September 18, 2021

How to Download Historical Stock Data

How to Download Historical Stock Data

Click here to get a PDF of this post

One of the best places to get free historical price data going back over 60 years is finance.yahoo.com.

Yahoo Finance provides historical price data that can be easily downloaded into Microsoft Excel and then used through the spreadsheet to backtest and study by creating formulas and filters. 

Here are the steps to download the historical stock data.

Step 1 go to finance.yahoo.com.

Step 2 is to key in a search for the ticker symbol you want to download data on. 

Step 3 is to click on the ‘historical data’ tab on the page for the ticker symbol you want. 

How to Download Historical Stock Data

Step 4 filter time period for the length of price data you want to download. 

How to Download Historical Stock Data

Step 5 open a Microsoft excel document on your computer and ensure you access to this software spreadsheet. 

Step 6 click download to send the selected time period of price data to your Microsoft Excel spreadsheet. 

How to Download Historical Stock Data

Step 7 The price data will appear in your Microsoft Excel Spreadsheet but you will need to adjust colum width in Excel for full visiabilty of all the information. 

Step 8 You can use the price data for backtesting or research by creating formulas in Excel. 

This is the quickest and easiest way I know of to download historical stock data for free online if you already have access to Microsoft Excel.