G
Gent
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
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