Downloading stock prices automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I download stock prices automatically (say from Yahoo) into Excel
2002? Thanks.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Calculate profits on stock sales on FIFO basis 5
Excel doesn't recognize stock symbol and won't update price 5
download info from a web site to Excel 3
How do I make a web query file to download stock data? 1
Sonos at Costco? 4
Auto replace between Excel and Word 1
Getting stock market prices 8
web query 3

Back
Top