Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / July 2004

Tip: Looking for answers? Try searching our database.

Yahoo  Finance Web Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al Eaton - 07 Jul 2004 05:32 GMT
I have created a web query in Excel to download "key statistics"for a stock
into my spreadsheet.
The url  and query is  http://finance.yahoo.com/q/ks?s=PFE
Selection=yfncsumtab,21,24,26,29,32,35,38,41,44
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

with the ticker being PFE.  I want to be able to reference a cell in the
spreadsheet with a ticker so I can easily change the stock I am requesting
data for.  Can you tell me how to do that?

Signature

Al Eaton
aleaton@bak.rr.com

sebastienm - 17 Jul 2004 02:26 GMT
Hi,

1. Adding a general Parameter.
 -Once you have run the query, right-click a cell in the returned data and choose EditQuery from the pop-up menu.
 -There, change the url
        http://finance.yahoo.com/q/ks?s=PFE
   to
       http://finance.yahoo.com/q/ks?s=["Stock1","Enter stock symbol."]      
  -click OK
  - You are now being prompted to enter a stock symbol

Note: if you had saved your query into a qry file, i am not sure it will update the file and you may loose any modification. In that case, rebuild your query without saving it into a qry file.

2. Change the Parameter type.
Now that you have built a general parameter (prompt box), when you right-click the query data, the 'Parameters' submenu in the pop-up menu is enabled.
There, you can change the type of the parameter to be linked to a cell.

I hope this helps,
Signature

Regards,
Sébastien

sebastienm - 17 Jul 2004 02:27 GMT
Signature

Regards,
Sébastien

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.