5 Messages
Digest #3086
Messages
Thu Jun 5, 2014 5:12 am (PDT) . Posted by:
"Jim Ranum" amt2100
Sorry to be a pain on this. I know it's probably simple, but I've always had trouble with this. Usually just give up after a while.
I copied and pasted what you show here and now the link does open up the main website page: www.gurufocus.com but does not go to the stock page with the ticker: www.gurufocus.com/stock/ticker
Did yours go to a ticker page?
Thanks very much,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 04, 2014 11:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
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/ <http://www.gurufocus.com/&F43> &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?
I copied and pasted what you show here and now the link does open up the main website page: www.gurufocus.com but does not go to the stock page with the ticker: www.gurufocus.com/stock/ticker
Did yours go to a ticker page?
Thanks very much,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 04, 2014 11:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
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/ <http://www.gurufocus.com/&F43> &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?
Thu Jun 5, 2014 5:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yup. It goes to the web page of the ticker symbol that was in cell F43.
If there's nothing in cell F43, then that formula would end up sending you
to the home page of the website.
On Thu, Jun 5, 2014 at 5:12 AM, 'Jim Ranum' amt2100@...wrote:
>
> Sorry to be a pain on this. I know it's probably simple, but I've always
> had trouble with this. Usually just give up after a while.
>
> I copied and pasted what you show here and now the link does open up the
> main website page: www.gurufocus.com but does not go to the stock page
> with the ticker: www.gurufocus.com/stock/ticker
>
> Did yours go to a ticker page?
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Wednesday, June 04, 2014 11:59 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
>
>
>
>
>
> 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")
>
>
>
If there's nothing in cell F43, then that formula would end up sending you
to the home page of the website.
On Thu, Jun 5, 2014 at 5:12 AM, 'Jim Ranum' amt2100@...wrote:
>
> Sorry to be a pain on this. I know it's probably simple, but I've always
> had trouble with this. Usually just give up after a while.
>
> I copied and pasted what you show here and now the link does open up the
> main website page: www.gurufocus.com but does not go to the stock page
> with the ticker: www.gurufocus.com/stock/ticker
>
> Did yours go to a ticker page?
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Wednesday, June 04, 2014 11:59 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
>
>
>
>
>
> 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"
>
>
>
Thu Jun 5, 2014 7:39 am (PDT) . Posted by:
"Jim Ranum" amt2100
That's weird then.
Can you please verify the "spaces" in the instruction you gave here? I'll retype it with underscores for the spaces that I'm seeing.
=HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,F43_&_"_GuruFocus")
I've also tried taking all the spaces out. Makes no difference, just goes to the main page. I have "mmm" in F43 for practice.
Now what appears in the cell on the spreadsheet changed to: mmmGuruFocus
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 05, 2014 8:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
Yup. It goes to the web page of the ticker symbol that was in cell F43.
If there's nothing in cell F43, then that formula would end up sending you to the home page of the website.
On Thu, Jun 5, 2014 at 5:12 AM, 'Jim Ranum' amt2100@...wrote:
Sorry to be a pain on this. I know it's probably simple, but I've always had trouble with this. Usually just give up after a while.
I copied and pasted what you show here and now the link does open up the main website page: www.gurufocus.com but does not go to the stock page with the ticker: www.gurufocus.com/stock/ticker
Did yours go to a ticker page?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 04, 2014 11:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
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")
Can you please verify the "spaces" in the instruction you gave here? I'll retype it with underscores for the spaces that I'm seeing.
=HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,F43_&_"_GuruFocus")
I've also tried taking all the spaces out. Makes no difference, just goes to the main page. I have "mmm" in F43 for practice.
Now what appears in the cell on the spreadsheet changed to: mmmGuruFocus
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 05, 2014 8:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
Yup. It goes to the web page of the ticker symbol that was in cell F43.
If there's nothing in cell F43, then that formula would end up sending you to the home page of the website.
On Thu, Jun 5, 2014 at 5:12 AM, 'Jim Ranum' amt2100@...wrote:
Sorry to be a pain on this. I know it's probably simple, but I've always had trouble with this. Usually just give up after a while.
I copied and pasted what you show here and now the link does open up the main website page: www.gurufocus.com but does not go to the stock page with the ticker: www.gurufocus.com/stock/ticker
Did yours go to a ticker page?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 04, 2014 11:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
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"
Thu Jun 5, 2014 8:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The spaces shouldn't make any difference, except the last one, which puts a
space in the label it shows you. Which is why you see it as "mmmGuruFocus"
instead of "mmm GuruFocus".
HOWEVER, if you previously ASSIGNED a hyperlink to the cell, the
HYPERLINK() function will NOT override that.
When you put your mouse over the cell, what URL does it tell you is the
hyperlink?
If you still have problems, try a single example in a new worksheet and
check if it works. If not, attach it so I can look at it.
On Thu, Jun 5, 2014 at 7:38 AM, 'Jim Ranum' amt2100@... wrote:
>
> That's weird then.
>
>
>
> Can you please verify the "spaces" in the instruction you gave here? I'll
> retype it with underscores for the spaces that I'm seeing.
>
>
>
> =HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,F43_&_"_GuruFocus")
>
> I've also tried taking all the spaces out. Makes no difference, just goes
> to the main page. I have "mmm" in F43 for practice.
>
> Now what appears in the cell on the spreadsheet changed to:
> *mmmGuruFocus*
>
space in the label it shows you. Which is why you see it as "mmmGuruFocus"
instead of "mmm GuruFocus".
HOWEVER, if you previously ASSIGNED a hyperlink to the cell, the
HYPERLINK() function will NOT override that.
When you put your mouse over the cell, what URL does it tell you is the
hyperlink?
If you still have problems, try a single example in a new worksheet and
check if it works. If not, attach it so I can look at it.
On Thu, Jun 5, 2014 at 7:38 AM, 'Jim Ranum' amt2100@... wrote:
>
> That's weird then.
>
>
>
> Can you please verify the "spaces" in the instruction you gave here? I'll
> retype it with underscores for the spaces that I'm seeing.
>
>
>
> =HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,
>
> I've also tried taking all the spaces out. Makes no difference, just goes
> to the main page. I have "mmm" in F43 for practice.
>
> Now what appears in the cell on the spreadsheet changed to:
> *mmmGuruFocus*
>
Thu Jun 5, 2014 8:19 am (PDT) . Posted by:
"Jim Ranum" amt2100
Well that fixed it. I did delete the contents of the cell before I put your new formula in there, but I guess it was still holding on to it.
Working now.
Really great, as usual.
Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 05, 2014 11:11 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
The spaces shouldn't make any difference, except the last one, which puts a space in the label it shows you. Which is why you see it as "mmmGuruFocus" instead of "mmm GuruFocus".
HOWEVER, if you previously ASSIGNED a hyperlink to the cell, the HYPERLINK() function will NOT override that.
When you put your mouse over the cell, what URL does it tell you is the hyperlink?
If you still have problems, try a single example in a new worksheet and check if it works. If not, attach it so I can look at it.
On Thu, Jun 5, 2014 at 7:38 AM, 'Jim Ranum' amt2100@... wrote:
That's weird then.
Can you please verify the "spaces" in the instruction you gave here? I'll retype it with underscores for the spaces that I'm seeing.
=HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,F43_&_"_GuruFocus")
I've also tried taking all the spaces out. Makes no difference, just goes to the main page. I have "mmm" in F43 for practice.
Now what appears in the cell on the spreadsheet changed to: mmmGuruFocus
Working now.
Really great, as usual.
Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, June 05, 2014 11:11 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Manually Calculating Spreadsheet Process Slow
The spaces shouldn't make any difference, except the last one, which puts a space in the label it shows you. Which is why you see it as "mmmGuruFocus" instead of "mmm GuruFocus".
HOWEVER, if you previously ASSIGNED a hyperlink to the cell, the HYPERLINK() function will NOT override that.
When you put your mouse over the cell, what URL does it tell you is the hyperlink?
If you still have problems, try a single example in a new worksheet and check if it works. If not, attach it so I can look at it.
On Thu, Jun 5, 2014 at 7:38 AM, 'Jim Ranum' amt2100@... wrote:
That's weird then.
Can you please verify the "spaces" in the instruction you gave here? I'll retype it with underscores for the spaces that I'm seeing.
=HYPERLINK("http://www.gurufocus.com/stock/"_&_F43,
I've also tried taking all the spaces out. Makes no difference, just goes to the main page. I have "mmm" in F43 for practice.
Now what appears in the cell on the spreadsheet changed to: mmmGuruFocus
Tidak ada komentar:
Posting Komentar