Using Data Import with URLs and Pointers

[2.7182818284590...]

Would it be possible for me to generate a URL with a pointer, and then
importing data from that URL which was just created from using
pointers?

For example, in column A, I'd like stock symbols. In column B, I'd
like the website address to be a function of what's in column A.
Column C should be a data import of data from that website.

A Stock Symbol B URL
Address
C Revenue
AAPL =concatenate("http://finance.yahoo.com/q/
is?s=",a2,"+Income+Statement&annual") $65,225,000

MSFT =concatenate("http://finance.yahoo.com/q/
is?s=",a3,"+Income+Statement&annual") $69,943,000


Basically, my ambition is to create a column A with all 500 companies
on the S&P 500.
Column B is the web address of this stock.
Column C has the revenues of that company.

 

[swp]

go look at: http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l--#

expand the "Download Index Data" area by clicking on the "+"

click on the "Index Earnings" link (it also has revenue)

swp

 

[Don Guillett]

Would it be possible for me to generate a URL with a pointer, and then
importing data from that URL which was just created from using
pointers?

For example, in column A, I'd like stock symbols.  In column B, I'd
like the website address to be a function of what's in column A.
Column C should be a data import of data from that website.

A Stock Symbol          B URL
Address
C Revenue
AAPL                         =concatenate("http://finance.yahoo.com/q/
is?s=",a2,"+Income+Statement&annual")     $65,225,000

MSFT                        =concatenate("http://finance.yahoo.com/q/
is?s=",a3,"+Income+Statement&annual")      $69,943,000

Basically, my ambition is to create a column A with all 500 companies
on the S&P 500.
Column B is the web address of this stock.
Column C has the revenues of that company.

Contact me privately at (e-mail address removed) with your file