April 16, 2021

Where to Download Historical Stock Data

Where to Download Historical Stock Data

Click here to get a PDF of this post

Here is a list of websites that allow traders to download historical stock data for the U.S. stock market. 

Yahoo Finance allows download data manually from its website:

One of the best places to get free historical end of day price data going back over 60 years is still  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. 

Where to Download Historical Stock Data

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

Where 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. 

Where 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. 

AlphaVantage is another leading provider of free APIs for historical and real time data on stocks, physical and crypto currencies,.
All you have to do is register to get your free API then take a look at their documentation here. 
To export historical daily quotes, you need this URL requested here.

QuantShare allows download of real time historical and intraday data:
Intraday Historical Data 
Daily Historical Data

Tiingo is another data provider that allows download of historical daily data with their API here for free. 
API call format to retrieve EOD data here. 

The Nasdaq website allows the download of  U.S. stock market data. To download data for APAM, click this URL then click on the download link at the bottom.

Stooq is a Poland based company its databases can be found here through this link. You can download data in CSV or Metastock format for many markets including U.S stocks, U.K stocks, bonds, commodities, currencies, indices, and more. Data is available here in daily, hourly and 5 minutes format.

Where to Download Historical Stock Data

Photo by Vitaly Vlasov from Pexels