How can I automatically store web query results in another Excel worksheet?

[stormspike]

I have a list of 20 securities on my Excel spreadsheet. My spreadsheet has been programmed to download the latest stock price from http://finance.yahoo.com

But I would also like to keep track of their performance over time, not just the spot price whenever I have the spreadsheet opened.

Example: I would like the current time stamp and and the current MSFT stock price to be automatically appended to the last row of Sheet 1. The current time stamp and the current GOOG stock price to be automatically appended to the last row of Sheet 2. The current time stamp and my overall portfolio valuation to be automatically calculated and appended to the last row on Sheet 3.

How can I do that in Excel?

[stormspike]

I have a list of 20 securities on my Excel spreadsheet. My spreadsheet has been programmed to download the latest stock price from http://finance.yahoo.com

But I would also like to keep track of their performance over time, not just the spot price whenever I have the spreadsheet opened.

Example: I would like the current time stamp and and the current MSFT stock price to be automatically appended to the last row of Sheet 1. The current time stamp and the current GOOG stock price to be automatically appended to the last row of Sheet 2. The current time stamp and my overall portfolio valuation to be automatically calculated and appended to the last row on Sheet 3.

How can I do that in Excel?

Nobody knows how to??