View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JavyD
 
Posts: n/a
Default 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.