[smf_addin] Digest Number 3015

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3015

1a

How do I get the exact webpage link created in a cell? by "Kermit W. Prather" kermitpra

1b

Re: How do I get the exact webpage link created in a cell? by mikemcq802

1c

Re: How do I get the exact webpage link created in a cell? by "Kermit W. Prather" kermitpra

1d

Re: How do I get the exact webpage link created in a cell? by mikemcq802

Messages

1a

How do I get the exact webpage link created in a cell?

Sat Mar 22, 2014 9:07 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I have in a spreadsheet the following

1. Stock Symbol is in cell A1 such as FTR
2. I want this link http://getsplithistory.com/ to get the symbol
from cell A1

This link should open the webpage in a browser
http://getsplithistory.com/FTR

I can key the complete link in a cell, click on it and it opens the desired
page.
But when I try to have it use the symbol in a cell it does not work.
I tried concatenate but it would not treat the result as a link.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: How do I get the exact webpage link created in a cell?

Sat Mar 22, 2014 9:15 am (PDT) . Posted by:

mikemcq802

Use the HYPERLINK function such as:

=HYPERLINK("http://getsplithistory.com/"&A1)

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1c

Re: How do I get the exact webpage link created in a cell?

Sat Mar 22, 2014 1:06 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, Mike

I paste your hyperlink formula into cell b2 and it shows the link with the stock symbol on the end


AB


Getsplithistroy
<http://getsplithistory.com/> http://getsplithistory.com/AB


But when I click on the link it opens this link
http://getsplithistory.com/
The stock symbol is missing. I tried several symbols and they were always missing.

I had played with the hyperlink before I posted but could not get it to work.

I get the same result if I use a link to yahoo. No stock symbol include in link.
<http://finance.yahoo.com/q/bc?s=> http://finance.yahoo.com/q/bc?s= is in Cell B10 and symbol is in Cell A1
=HYPERLINK(B10,A1)
The resulting link is http://finance.yahoo.com/q/bc?s=
With an error message on the webpage saying Error: Please enter a ticker symbol.

I even tried using a clean workbook same results. Next I'll try starting from scratch on another machine.

I'm still open to suggestions.

Thank again for the suggestion.
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of mikemcq802@yahoo.com
Sent: Saturday, March 22, 2014 12:15 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: How do I get the exact webpage link created in a cell?


Use the HYPERLINK function such as:

=HYPERLINK("http://getsplithistory.com/"&A1)

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1d

Re: How do I get the exact webpage link created in a cell?

Sat Mar 22, 2014 2:58 pm (PDT) . Posted by:

mikemcq802

Your second example =HYPERLINK(B10,A1) is wrong. It should be B10&A1 (concatenation, no comma). Using a comma supplies 2 parameters. The second parameter to hyperlink is a "Friendly name".

The example I provided worked for me. Are you sure you used it correctly?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

Visit Your Group

• New Members 15

• Privacy • Unsubscribe • Terms of Use