Historical stock quotes in excel

[sak]

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.

 

[Darou]

You can try FinAnSu: an Excel addin for real-time data and historical data. Basically it is possible to do what you want with it, but it might be very slow...

 

[Sim Con]

You could write the VBA to do this easily by modifying the code in this spreadsheet: http://investexcel.net/218/importing-historical-stock-prices-from-yahoo-into-excel/

Let me know if you need some help

 

[ExSan]

You might consider consider coding this problem in C/C++ , it would be quite simple

 

[Harrison Delfino]

I use MarketXLS for this and it works great for me.
Live Stock Quotes in Excel with Excel Formulas

 

[ExSan]

check out interactive brokers API

 

[Daniel Duffy]

If you use C# (or C++) you can use

DDE
Excel RTServer

About Dynamic Data Exchange (Windows)
etc.

 

[MRoss]

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.

 

[Yannis]

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