Microsoft Excel had been changed from previous versions.
If the issue persists for a few days, possibly due to a permanent change in the API's web address, please come back to this page and download the latest file.Monitor and analyze your stock portfolio right from this Excel spreadsheet.This spreadsheet provides you the formulas and a template with graphs and charts to get stock quotes from Yahoo finance.Start with the base URL: to your base URL followed by the stock symbols you want to download. As there are multiple exchanges around the world, you must specify which exchange your code relates to by adding a suffix. The Macros are not password protected so you are free to view and manipulate all code anyway you like. Don’t forget to add the correct suffix or prefix as detailed above. Tags for the information you want to download into cell C2.To download multiple companies at once, simply use the “ ” sign in between the company codes. s= How to Find the Correct Stock Code All listed companies have a stock ticker between 1 and 4 characters. • Australian listed companies require the suffix “. The Spreadsheet is in XLS so it’s backwards compatible to MS Excel 97. A few caveats: • Dow Jones data will not import due to licensing restrictions. dividends, ratios and target prices) are often only available for US listed companies. The data will be displayed in the order you specify in the Yahoo! You will need to rename the column headers to match the order of the tags you specified in C2.