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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top