• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Historical stock quotes in excel

sak

Joined
8/16/09
Messages
84
Points
18
I have two columns. Column 1 is all tickers and column 2 are various dates from 2009, 2010, 2011, etc. and I have a 1000 rows of them

Is there a way I can grab the prices using some excel function in column 3 for corresponding ticker and dates. So, a function something like: =price(ticker,date)

I tried using google finance but the way they output the quotes makes it harder to do for 1000 rows.
 
Here you go.

I made this spreadsheet a few years back and if I recall correctly I got a good portion of the VBA code from online so props to the original creator.

Enjoy.
 

Attachments

  • Market_Data_Stats_Oct_Latest.zip
    38.9 KB · Views: 66
There is a new provider of historical data since last August called Alpha Vantage.
I have managed to create an Excel Addin called Deriscope that retrieves data from that provider into Excel.
It is completely free. You can download it from Free Download Deriscope
and watch a video tutorial at
 
Back
Top