How to retrieve stock data in Excel

[Trader_Herry]

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.

 

[grantx]

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.

 

[Charlton]

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

 

[Trader_Herry]

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]

Edgeseeker will do the trick for you:

www.edgeseeker.com

 

[Spreadsheets]

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.

 

[kuzelamacro]

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

 

[George Fisher]

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

 

[newtraderuk]

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.