Downloading stock prices automatically

C

crossfool

How can I download stock prices automatically (say from Yahoo) into Excel
2002? Thanks.
 
M

Mike H

Hi,

Select a cell where you want the table to start and then

Data|Import external data|New web query.

Paste the address of the Yahoo site into the window that's appeared and
click GO.
Select the table you want to import and click Import.

Back on the worksheet right-click the table to set up the refresh frequency.

Mike
 
Top