If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yahoo Finance Web Query
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? -- Al Eaton |
#2
|
|||
|
|||
Yahoo Finance Web Query
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, -- Regards, Sébastien |
#3
|
|||
|
|||
Yahoo Finance Web Query
-- Regards, Sébastien |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
query wizard error | Christen | General Discussion | 12 | August 13th, 2004 08:37 PM |
SELECT function in Query | alexparks | Running & Setting Up Queries | 9 | July 5th, 2004 11:31 AM |
Update another table with a Max record query | Ngan | Running & Setting Up Queries | 2 | June 22nd, 2004 05:01 PM |
query field reference help | -dch | Running & Setting Up Queries | 4 | June 2nd, 2004 07:30 PM |
Query By Form | Craig | Running & Setting Up Queries | 2 | June 1st, 2004 01:10 AM |