Using Data Import with URLs and Pointers

  • Thread starter Thread starter 2.7182818284590...
  • Start date Start date
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.
 
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 (e-mail address removed) with your file
 
Back
Top