2
2.7182818284590...
I have created a table in Excel. In one column are hyperlinks to the
balance sheet of a company in the S&P 500. Let's assume that this
column is in A. A1 is titled "Name of Company", and A2 reads "AAPL",
which is the symbol for Apple. When you click on A2, the browser
would have you on http://finance.yahoo.com/q/bs?s=AAPL+Balance+Sheet&annual
..
Now, suppose that I want to parse some very specific data from this
site. Specifically, I'd like to parse the Total Stockholder Equity,
which happens to be 47,791,000.
How do I go about doing this?
Regarding doing this for all 500 of the companies, I've got ideas on
how to solve this:
1. Have all the symbols in Column A.
2. The formula for Column B would be: =concatenate("http://
finance.yahoo.com/q/bs?s=",A2,"+Balance+Sheet&annual")
3. Convert Column B from a text string into a hyperlink
4. YOUR Data Import which you will show me to extract this data for
each stock.
Thanks in advance.
balance sheet of a company in the S&P 500. Let's assume that this
column is in A. A1 is titled "Name of Company", and A2 reads "AAPL",
which is the symbol for Apple. When you click on A2, the browser
would have you on http://finance.yahoo.com/q/bs?s=AAPL+Balance+Sheet&annual
..
Now, suppose that I want to parse some very specific data from this
site. Specifically, I'd like to parse the Total Stockholder Equity,
which happens to be 47,791,000.
How do I go about doing this?
Regarding doing this for all 500 of the companies, I've got ideas on
how to solve this:
1. Have all the symbols in Column A.
2. The formula for Column B would be: =concatenate("http://
finance.yahoo.com/q/bs?s=",A2,"+Balance+Sheet&annual")
3. Convert Column B from a text string into a hyperlink
4. YOUR Data Import which you will show me to extract this data for
each stock.
Thanks in advance.