how can i retieve stock data in an excel worksheet?

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

Guest

How can i retrieve stock data from yahoo finance in an excell worksheet and
have it update dynamically?
 
You can make a macro which uses the web query feature or do it
manually. Make a new web query: DATA > IMPORT EXTERNAL DATA > NEW
WEBQUERY > 'Enter an URL'
Use a made existing web query: DATA > REFRESH DATA
Pleas take a look in Excel or VBA help for more info.
Hope this helps!

- Bas
 
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

download info from a web site to Excel 3
VBA userform Vlookup Excel 1
Web site plus excell 1
Getting stock market prices 8
Calculating a worksheet 3
Help!! 2
Pull stock price from web, format in Excel 2000 1
[VBA] Dynamic target stock 7

Back
Top