Web Query problem

A

Al Eaton

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?
 

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

Series of web queries: Autofill? 1
How to use symbol=["Ticker" "Enter ticker"] with Microsoft Excel 2 1
Convert to a Parameter Query 3
Web Query, Help! 1
Run .IQY within VBA 0
Web Query question 7
Paste string on a cell to New Web Query URL 1
Exrtacting text from a string 2

Top