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!
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.
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.
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?
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?