Start by entering a start and end date, your desired quote frequency (d for daily, m for monthly, y for yearly), and your desired sorting (oldest data first or newest data first). That’s when you need this free, user-friendly spreadsheet for bulk data download. 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 Update on 2nd May 2022: Fixed to work past some Yahoo changes. Just enter a series of ticker symbols, two dates, and click a button. This Excel spreadsheet downloads multiple historical stock quotes into Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |