Series of web queries: Autofill?
 

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


--
Gent
------------------------------------------------------------------------
Gent's Profile: http://www.excelforum.com/member.php...o&userid=32423
View this thread: http://www.excelforum.com/showthread...hreadid=521915

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