Having a reliable source of free data is extremely handy for the independent trader. It allows you to move fast and look into your ideas quickly.
Yahoo Finance recently changed how you can access their historical stock data. No more simple downloads from the website and programmatic access now requires a different approach.
For the R and Python folks: The maintainers of quantmod and yfinance have already updated their packages to work with the new Yahoo setup.
And Excel users? We’ve got you covered.
We’ve created a dead-simple Excel spreadsheet that pulls historical price and volume data for any ticker you want. No coding required.
Here’s how to use it:
- Download the spreadsheet by filling out the form below. The download link will be emailed to you.
- This will subscribe you to our newsletter, and you’ll get email updates about our upcoming Excel Edge Lab course.
- Open the spreadsheet and click “Enable editing”
- Enter your ticker in cell C2
- Set your start date in cell C3 (the end date in cell C4 defaults to today)
- Go to the “Data” tab and click “Refresh all”
- If prompted about Privacy Level, just check the box and click OK
That’s it. The sheet will fetch your data in seconds.
Fill out the form below to get the spreadsheet:
