Download Historical Stock Prices in Excel with a Click

Download the Excel file that can get historical stock data with a click of a button.

Works in Excel 2007, Excel, 2010, and Excel 2013.

This nifty Excel file can download historical daily adjusted closing prices for a list of U.S. stock symbols within a specified date range.
The form that comes with the Excel file is very intuitive to use. Just enter a list of stock symbols, enter the start and end dates, select a frequency, and click download. In seconds, your pristine data is automatically downloaded and organized into a new sheet within the file.

More Free Excel Tools

Get Stock Quotes in Excel

Get Currency Exchange Rates in Excel

Get Historical Exchange Rates in Excel

[dayyoo]

Thanks for helping cut out a lot of tedium from my day. Keep the tools coming!

[xzadeh]

This is just a tool I needed! Thanks a ton for sharing it. Very useful.

[financialaccounting]

it works !!
and it will save me TIME !
thanks !

[niteshkalwar]

This is very useful, Yi. Thank you. 

Also, just an idea...is there a way to download companies historical sales revenue or EPS. These metrics will be at quarterly level published by companies. Thanks again for sharing your knowledge.

[markduffy]

Hi This is a great tool. I am intrested in more than US stocks. Is there any way i can get into the code so as to alter it a little to suite my needs. Not sure what the ethics are in asking such a question 

[aaronsiegel]

Hey, wonderful video. I have excel 14.5.1 for mac 2011 is there a reason it isn't working?

[sinanoezonar]

great vid...where can I download it? Cant find it anymore on the link.

[sinnylo]

This tools is useful but can it be available with HK stocks in google finance? please.

[Michael-urju]

This is really help.

However, I am wondering if I can update the stock price daily after I download it. Because I want to constantly keep track of the stock information.

[regardspratik]

Thanks Yi. I was looking at other excel macros you have. great work man. I was wondering if there is a way to combine all of these macros into one file? ie. having the stock quotes and historical stock prices, etc.

[natthananp]

I would like to thank you for your useful excel spreadsheet to get historical stock prices. However, it would be much appreciated if you can develop this in Mac version since I could not use it in the excel in my mac.

[TheHolyHandGrenade]

Thanks for your efforts! I will give this a try - it looks great. It there a way to populate the data in the "Stock Symbols" window on the Control sheet from cells instead of typing them in there directly? 

[NabilTX]

I am using Excel 2007 and when opening the file I get the following: MS Visual Basic,
Can't exit design mode because control "Control Frame" cannot be created.

Any suggestions?

Thanks!

[yasminsaira]

Hi    is there any site that has  historical stock price for de listed companies and how can we search/find the data?

[jerhrbst]

Hi Yi, Nice program.  But I need: Hi, Lo, Close  : data for each date   --  to use with my Excel Charts.  Could you either change the program to include the Hi & Lo's,   or write a new program to do that?

[haydensmith]

The site is no longer available, any other way to access the Excel sheet?

[lelandconn]

It won't let me use the tool. I keep opening it, and it says "To view the unsupported content in the file, you can open the workbook as read-only. However, if you change and then save the workbook, unsupported content will not be saved." And I can't use any of the stuff its just like a picture, i can only read it and move it around.

[BSelm]

Thanks, but I need to download historical data for crude oil from investing.com? How could I do this?

[ShanmuganathanGanapathy]

Hey Thanks for the great tool.
Wondering if I could change data download for stock market.
Like I wanna download for NSE India, is it possible?

[bryanceglarek]

Mr. Yi, If you only knew how much help this has inplied (haven't used yet)! When i am done doing my research i will repost... Be Back