Using Data Import with URLs and Pointers

2

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.
 
D

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.
Click to expand...

Contact me privately at [email protected] with your file
 
Top