[smf_addin] Digest Number 3085

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3085

1a

Re: Manually Calculating Spreadsheet Process Slow by "Jim Ranum" amt2100

1b

Re: Manually Calculating Spreadsheet Process Slow by "Randy Randall" randyr_cds

1c

Re: Manually Calculating Spreadsheet Process Slouw by champy765

1d

Re: Manually Calculating Spreadsheet Process Slow by amt2100

1e

Re: Manually Calculating Spreadsheet Process Slow by "Randy Harmelink" rharmelink

Messages

1a

Re: Manually Calculating Spreadsheet Process Slow

Wed Jun 4, 2014 12:23 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy or anyone,

I'm trying to put a hyperlink to gurufocus in Excel that I can just click on it and it takes me to the specific ticker on gurufocus.

I have a hyperlink to the website I've been using, but then have to waste time inputting the ticker. (I know, I'm lazy)

I have the ticker symbol in cell F43 and the existing hyperlink in F47. I have tried modifying the hyperlink to use the customary "&F43 and not knowing what I'm doing, just &F43, as in

www.gurufocus.com/" <http://www.gurufocus.com/"&F43> &F43, but Excel doesn't like either one of those.

Can someone set me straight?

Thanks, I use this tool everyday.

Jim

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

1b

Re: Manually Calculating Spreadsheet Process Slow

Wed Jun 4, 2014 12:29 pm (PDT) . Posted by:

"Randy Randall" randyr_cds

Try something like:

=HYPERLINK("http://www.gurufocus.com/stock/" & F43,F43 & " GuruFocus")

On Wed, Jun 4, 2014 at 3:22 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy or anyone,
>
>
>
> I'm trying to put a hyperlink to gurufocus in Excel that I can just click
> on it and it takes me to the specific ticker on gurufocus.
>
> I have a hyperlink to the website I've been using, but then have to waste
> time inputting the ticker. (I know, I'm lazy)
>
>
>
> I have the ticker symbol in cell F43 and the existing hyperlink in F47. I
> have tried modifying the hyperlink to use the customary "&F43 and not
> knowing what I'm doing, just &F43, as in
>
> www.gurufocus.com/"&F43, but Excel doesn't like either one of those.
>
>
>
> Can someone set me straight?
>
>
>
> Thanks, I use this tool everyday.
>
> Jim
>
>
>
>
>

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

1c

Re: Manually Calculating Spreadsheet Process Slouw

Wed Jun 4, 2014 4:13 pm (PDT) . Posted by:

champy765

From: Randy Randall positive.theta@gmail.com [smf_addin]Sent:
Wednesday, June 4, 2014 15:29To: smf_addin@yahoogroups.comReply
To: smf_addin@yahoogroups.comSubject: Re: [smf_addin] Manually
Calculating Spreadsheet Process Slow


Try something like:

=HYPERLINK("http://www.gurufocus.com/stock/
<http://www.gurufocus.com/stock/> " & F43,F43 & " GuruFocus")


On Wed, Jun 4, 2014 at 3:22 PM, 'Jim Ranum' amt2100@gmail.com
<mailto:amt2100@gmail.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:



Hi Randy or anyone,



I'm trying to put a hyperlink to gurufocus in Excel that I
can just click on it and it takes me to the specific ticker on
gurufocus.

I have a hyperlink to the website I've been using, but
then have to waste time inputting the ticker. (I know, I'm
lazy)



I have the ticker symbol in cell F43 and the existing hyperlink
in F47. I have tried modifying the hyperlink to use the
customary "&F43 and not knowing what I'm doing,
just &F43, as in

www.gurufocus.com/"&F43
<http://www.gurufocus.com/"&F43> , but Excel
doesn't like either one of those.



Can someone set me straight?



Thanks, I use this tool everyday.

Jim

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

1d

Re: Manually Calculating Spreadsheet Process Slow

Wed Jun 4, 2014 8:54 pm (PDT) . Posted by:

amt2100

Thanks, but didn't work. I get an error message
Unable to open http://www.gurufocus.com/&F43 http://www.gurufocus.com/&F43 The Internet site reports that the item you requested could not be found.


So it's looking for a stock named &F43 instead of the ticker in F43. Same problem I had.
Any other ideas on this?


Thanks again,
Jim

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

1e

Re: Manually Calculating Spreadsheet Process Slow

Wed Jun 4, 2014 8:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you made &F43 part of your string literal instead of
concatenating it to the string literal. You didn't say which version you
tried, but copying this from an earlier message in the thread worked fine
for me:

=HYPERLINK("http://www.gurufocus.com/stock/" & F43,F43 & " GuruFocus")

On Wed, Jun 4, 2014 at 8:54 PM, amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, but didn't work.
> I get an error message
> Unable to open http://www.gurufocus.com/&F43 The Internet site reports
> that the item you requested could not be found.
>
> So it's looking for a stock named &F43 instead of the ticker in F43. Same
> problem I had.
> Any other ideas on this?
>
>

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

Visit Your Group

• New Members 37

• Privacy • Unsubscribe • Terms of Use