How can i import data (from a webpage) to Excel, and keep a history of the data(like a log)?

Question

I know how to link the webpage to excel (data/import external data/new web query) , but this particular data is timestamped, and i'd like to keep a history of it for graphing purposes. Thanks in advance.

[I know how to link the webpage to excel (data/import external data/new web query) , but this particular data is timestamped, and i'd like to keep a history of it for graphing purposes. Thanks in advance. ] this would be for intraday/real time price/volume data.

Answer 1

There are far too many details missing from your question to give a good answer. You don't indicate if you are talking daily, weekly, monthly, or intraday price/volume data. If so, why not just download the historical data itself rather than keeping your own history? Or whether you are possibly referring to fundamental data. The answers can depend a lot on just what you are doing with the data.

I'd suggest a visit to some Yahoo groups that deal with retrieving data from the Internet for use in EXCEL:

http://tech.groups.yahoo.com/group/xltraders/
http://finance.groups.yahoo.com/group/smf_addin/

Within the context of a discussion thread, where details like the above can be exchanged, you may get a better answer. Also, the files areas of the two groups contain a number of tools and examples of getting financial data off the web.

BTW -- the second group is one of mine.