B
Brablo
Suppose that I have 100 stocks which update every day, or so. I can
easily (using manual methods, which I don't mind) cut and paste the
symbols of these 100 stocks every week.
Example:
SHLM
IOSP
LFUS
ASEI
KAMN
GIFI
However, I'm also interested in tabulating their Analyst's Ratings from
the following website:
http://finance.yahoo.com/q/ao?s=SHLM for the first stock with
symbol SHLM.
How do I automate the process of parsing information from websites
like:
http://finance.yahoo.com/q/ao?s=IOSP
http://finance.yahoo.com/q/ao?s=SHLM
http://finance.yahoo.com/q/ao?s=LFUS
http://finance.yahoo.com/q/ao?s=ASEI ?
I know how to parse the desired information by importing data, but the
downfall with this is that I have to create a new query for every stock
symbol. I don't want to do it this way, because I always put in
~100-200 new stock symbols every other day.
I think that the better way to do this is to concatenate the website
addresses as: http://finance.yahoo.com/q/ao?s= (which is found in Cell
$a$99) + "STOCK SYMBOL" (which is found in cell A2). On that
particular website, parse the needed information in the dialog box,
which happens to be 3.0 for IOSP.
easily (using manual methods, which I don't mind) cut and paste the
symbols of these 100 stocks every week.
Example:
SHLM
IOSP
LFUS
ASEI
KAMN
GIFI
However, I'm also interested in tabulating their Analyst's Ratings from
the following website:
http://finance.yahoo.com/q/ao?s=SHLM for the first stock with
symbol SHLM.
How do I automate the process of parsing information from websites
like:
http://finance.yahoo.com/q/ao?s=IOSP
http://finance.yahoo.com/q/ao?s=SHLM
http://finance.yahoo.com/q/ao?s=LFUS
http://finance.yahoo.com/q/ao?s=ASEI ?
I know how to parse the desired information by importing data, but the
downfall with this is that I have to create a new query for every stock
symbol. I don't want to do it this way, because I always put in
~100-200 new stock symbols every other day.
I think that the better way to do this is to concatenate the website
addresses as: http://finance.yahoo.com/q/ao?s= (which is found in Cell
$a$99) + "STOCK SYMBOL" (which is found in cell A2). On that
particular website, parse the needed information in the dialog box,
which happens to be 3.0 for IOSP.