Step 8 You can use the price data for backtesting or research by creating formulas in Excel. 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 6 click download to send the selected time period of price data to your Microsoft Excel spreadsheet. Step 5 open a Microsoft excel document on your computer and ensure you access to this software spreadsheet. Step 4 filter time period for the length of price data you want to download. Step 3 is to click on the ‘historical data’ tab on the page for the ticker symbol you want. Step 2 is to key in a search for the ticker symbol you want to download data on.

Here are the steps to download the historical stock data.

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. One of the best places to get free historical end of day price data going back over 60 years is still. Yahoo Finance allows download data manually from its website: Here is a list of websites that allow traders to download historical stock data for the U.S.

Download yahoo finance live