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.