Sometimes, however, data for just one company isn’t enough – you need to compare the relative performance of several companies. This data can be used for correlation analysis, technical analysis with RSI and ATR, historical back-testing, portfolio optimization and much more.Ī previous spreadsheet let you download data for a single ticker symbol. As a workaround, I’ve posted a new version of the spreadsheet that uses Google Finance. Update on 20th May 2017: Yahoo Finance have discontinued their free historical data API. Download the new version at the bottom of this article. Update on 6th July 2017: I’ve uploaded a new version of the Yahoo spreadsheet that now works again. Update on 11th July 2017: You can now sort the historical data in ascending or descending date order Update on 14th April 2018: Yahoo changed a few things, so I’ve updated the downloader to work again Just enter a series of ticker symbols, two dates, and click a button.
This Excel spreadsheet downloads multiple historical stock quotes into Excel.
