Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting live stock quotes
- Thread starter Thorny
- Start date
In Excel, click on DATA-GET EXTERNAL DATA-RUN WEB QUERY
It should pop up a window with existing (standard queries). There, you should see a queries for getting stock quotes. If not, then create a file (call it stock.iqy (the "iqy" is a standard extension for a web query)) and put the following lines in the file:
WEB
1
["TICKER","Enter your stock symbol for a detailed quote."]
Once you have done that, follow the prompts.
There are then 2 ways in which you can update the quote. Either by clicking on DATA-REFRESH DATA, or by click on DATA-GET EXTERNAL DATA-DATA RANGE PROPERTIES and then selecting the check box which says "Refresh data on file open".
It should pop up a window with existing (standard queries). There, you should see a queries for getting stock quotes. If not, then create a file (call it stock.iqy (the "iqy" is a standard extension for a web query)) and put the following lines in the file:
WEB
1
["TICKER","Enter your stock symbol for a detailed quote."]
Once you have done that, follow the prompts.
There are then 2 ways in which you can update the quote. Either by clicking on DATA-REFRESH DATA, or by click on DATA-GET EXTERNAL DATA-DATA RANGE PROPERTIES and then selecting the check box which says "Refresh data on file open".
- Status
Similar threads
- Locked
- Question
- Locked
- Question