How to retrieve stock data in Excel

Trader_Herry

Member
Messages
51
Likes
0
Hey, do you know whether there is a free Excel addon which can retrieve stock data from Yahoo Finance (or other sources)?

I would like to retrieve stock data of a specific date. For example, when I input this function "=getclose(MSFT, 2007-01-01)", it will get the closing price of MSFT on 2007 Jan 01.

Thanks a lot.
 
Trader,

There are quite a few, though I can't remeber specific names. Do a Google search for "Excel data downloader" (or "data retrieval").

However, rather than specific dates I think most download data at regular intervals (end of day, intra-day).

Grant.
 
Hey, do you know whether there is a free Excel addon which can retrieve stock data from Yahoo Finance (or other sources)?

I would like to retrieve stock data of a specific date. For example, when I input this function "=getclose(MSFT, 2007-01-01)", it will get the closing price of MSFT on 2007 Jan 01.

Thanks a lot.
Try

http://fransking.blogspot.com/2006/06/getting-stock-prices-into-excel.html

or just google

excel yahoo finance add in

to find loads more

Charlton
 
I googled but I can't find what I want. They won't allow me to specify what date of stock quote I want to retrieve.
For example I would like to get the closing price after the first month the stock goes public. But they can't do it.
 
Hey, do you know whether there is a free Excel addon which can retrieve stock data from Yahoo Finance (or other sources)?

I would like to retrieve stock data of a specific date. For example, when I input this function "=getclose(MSFT, 2007-01-01)", it will get the closing price of MSFT on 2007 Jan 01.

Thanks a lot.

Here are several VBA functions to pull financial information into Excel:

Current information from Yahoo
Philadelphia Reflections: Exchange Quotes from XML using Excel (Yahoo Finance)

Current information from Google
Philadelphia Reflections: Exchange Quotes from XML using Excel (Google Finance)

Historical information from Yahoo
Philadelphia Reflections: Get Historical Stock Data in Excel (single date; from Yahoo Finance)

Treasury Yields
Philadelphia Reflections: Treasury Yields from XML using Excel

Black Scholes Merton
Philadelphia Reflections: Black-Scholes-Merton in Excel
 
Try this plugin ... does exactly what you asked for...

Stock Quotes in Excel 2010 or any version | Google Translate for Excel, Time-saving plugins (Add-ins) for Microsoft® Excel®


Hey, do you know whether there is a free Excel addon which can retrieve stock data from Yahoo Finance (or other sources)?

I would like to retrieve stock data of a specific date. For example, when I input this function "=getclose(MSFT, 2007-01-01)", it will get the closing price of MSFT on 2007 Jan 01.

Thanks a lot.
 
Top