Retrieve historical data from financial websites

[WmWaster]

Retrieve historical data from financial websites

Hi.
How can I tell MS Excel to retrieve historical data automatically from financial websites, like Yahoo, MSN.

I need historical data of Us and Hong Kong stocks.

The data I would like to have is:
- open, low, high, close [most important!]
- 1-week open, low, high, close [preferred]
- 52-week high & low [preferred]

Thank you!

 

[cashmoney69]

go to

http://finance.yahoo.com/q/hp?s=INTC

scroll to the bottom, there is a "download to spread sheet" option

- nathan

 

[originalskunk]

There are many samples in the files section of this group

http://groups.yahoo.com/group/xltraders/

 

[rosy]

i use perl to grab data off several sites and store it in a database. PM me for details

 

[Bob111]

http://www.gummy-stuff.org/Yahoo-data.htm

 

[rocky_te]

You can get a free downloader at http://www.trendengines.com/Pages/Downloader Descr-1.htm

Rocky

 

[WmWaster]

Quote from cashmoney69:

go to

http://finance.yahoo.com/q/hp?s=INTC

scroll to the bottom, there is a "download to spread sheet" option

- nathan

Sorry, not that.

I would like to retrieve infomration directly from the server.

Eg: I would like to get everyday close for my portfolio. Previously I may need to manually update this data. I would like to find a way which can do this routine automatically.

 

[QQQShort]

MLDownloader could be an option for you.

http://www.trading-tools.com/mld.htm

I haven't used it recently. As I remember, it was a little cumbersome to use. It still might be a reasonably priced choice for your needs.

 

[WmWaster]

Quote from Bob111:

http://www.gummy-stuff.org/Yahoo-data.htm

Thanks.

1)
Go to:
http://finance.yahoo.com/d/quotes.csv?s=goog&f=f6

The URL is to retrieve "Float Shares".
But there're 3 unknown numbers in the quote. What do these 3 numbers mean?

http://finance.yahoo.com/d/quotes.csv?s=yhoo&f=f6

Sometimes it has 4 numbers.



2)
Does anyone know how I can get the stock quote of a specific time in Excel, eg adj. close on 24 Apr 06?

 

[WmWaster]

Just wonder.

It seems all people are getting quotes from Yahoo only. Is it just Yahoo being the only source for Excel in this planet?