Historical Stock Prices in Excel
Simple spreadsheet with form to download historical stock prices right into Excel.
This nifty little spreadsheet can download historical daily adjusted closing prices for a list of stock symbols within a specified date range. With a click of a button, your pristine data is neatly organized in a new worksheet, waiting to be analyzed.
How to Use the Spreadsheet
The form is very intuitive to use. Just enter a list of stock symbols, enter the start and end dates, select a frequency, and click download. Your data will be downloaded into a new worksheet within the same file.
A Note About the Data Source
The historical stock price data is downloaded from Quandl.com, a free search engine for numerical data, through its API. As of 1/15/2015, Quandl limits anonymous data downloading to 50 API calls per day, which is equivalent to downloading data for 50 stocks per day. If you sign up for a free Quandl account, Quandl provides you with an authentication token under your account settings which lifts your download limits to 2,000 API calls per 10 minutes and 50,000 API calls per day. Limits are subject to change. Please refer to Quandl's API page for the current limits.
Quandl.com offers not only historical stock price data but also a slew of key financial data on publicly traded companies such as dividends, net income, PE ratio, and much more. Custom Excel templates, forms, or add-ins can be built to take advantage of the open data source, helping you streamline your financial analysis.
I really enjoy putting together simple yet practical spreadsheet tools - from coding the core functionalities to designing an intuitive template - that people would actually use regularly. Any feedback or suggestion to help improve this spreadsheet is sincerely appreciated.