Hyperlink Stock Ticker in Cell
 

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
http://moneycentral.msn.com/investor...g.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.

Hyperlink Stock Ticker in Cell
 

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" wrote:

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
http://moneycentral.msn.com/investor...g.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.

Hyperlink Stock Ticker in Cell
 

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.

"Ron Coderre" wrote:

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" wrote:

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
http://moneycentral.msn.com/investor...g.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.

Hyperlink Stock Ticker in Cell
 

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

"Ron Coderre" wrote:

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" wrote:

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
http://moneycentral.msn.com/investor...g.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.