How to retrieve stock data in 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.

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.

Try

http://fransking.blogspot.com/2006/0...nto-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.

Edgeseeker will do the trick for you:

www.edgeseeker.com

This spreadsheet will help you download stock quotes from Yahoo into Excel

There is a free and open source VBA solution that can download multiple security data for long time periods with the ability to set the data range. The solution can be downloaded from the page to download stock data to Excel.

You can try this:

stock excel macro | Free software downloads at SourceForge.net

It allows you to download datas from the Stock Exchange into the Excel file with one click. Required just insert a symbol (YHOO, MSFT, AAPL, etc..)

Contains this informations (for last 4Q):
- financial statement
- balance sheet
- cash flow
- price history
- daily summary