|
Posted to microsoft.public.excel.misc
|
|
|
Series of web queries: Autofill?
Gent wrote:
Hello,
I am trying to run a series of web queries in a single worksheet. I
have a list of about 500 stock tickers. I wrote a web query that that
will return the industry and sector of a SINGLE ticker in question
from finance.yahoo.com. Is there anyway I can drag/auto fill this
query as I would for a normal excel function? When I copy and paste
the query the cell reference in the parameter doesn't change as it
would if I was copying an excel formula. Please let me know if you
have any recommendations.
Below is the query I am using:
WEB
1
http://finance.yahoo.com/q/in?s=["keyword","Enter the Search Term:"]
Selection=18
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
Does this help?
http://www.vertex42.com/News/excel-web-query.html
|