Hyperlink Stock Ticker in Cell

[JavyD]

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
http://moneycentral.msn.com/investor/charts/charting.asp?Symbol=a

but on the Symbol=A, I want that A to actually be a cell say A1 where A will
be in that cell.

Is that possible.

 

[Ron Coderre]

Try something like this:

=HYPERLINK("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol="&A1,"MyStock")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[JavyD]

Not quite Ron, takes me to the web page but stays stuck on the symbol entry,
it's waiting for input, I need it to pick up the ticker in the cell and open
the page with the ticker already in it. You know what I mean.

 

[JavyD]

This is what I used

=HYPERLINK(CONCATENATE("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol=",A1),A1)

Thanks for your help. I can't beleive I answered my own questions. LOL