Excel 2007 : Downloading Stock Prices in excel 2007

[sammalone]

I was using the MSN Money add-in in excel 03 to download stock prices into an excel sheet, but haven't been able to get the add-in for 07. Does anyone know of a free way to pull multiple stock prices into a workbook? Delayed quotes are fine and I don't mind having to manually update prices several times a day, I just want a group of prices to pull into a sheet at least one a day. Thanks

[yariv]

Hi,

You can use web import to do this: Use Data - Get external data from web.

A web query explorer screen opens inside Excel. select the page containing the data that you would like to download, when the page loads you will see yellow arrows on the page that represent tables on the page. Click the arrow of the table that you like to import. Once you select the table, the yellow arrow turn to green.
You can use the options button to change the import preferences.

When you click the Import button, the Import Data dialog is displayed. By default, the data will be imported at the current cell pointer location.

Click the OK button. Intitially, you will see a strange code in cell A1.

After a few seconds, the data from the web page loads into the worksheet.

You can use the options in order to refresh the data automaticly.

Hope thats helps,

Yariv