2 Messages
Digest #4639
Messages
Wed Oct 30, 2019 6:43 am (PDT) . Posted by:
sdkli6s74riwydpnmq2gtjfye62jlz2eu35n4ipf
I've received the "#VALUE" error for each of the following along with a comment insert that is a standard excel comment box containing only my username
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart") where $B$6 is the ticker SPY
rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart")
rchcreatecomment("SPY",99,550,450,1,1,1,1,"","Chart")
Before Monday of this week, I had been using this same sheet for more than 3 years without any issues. I am using the latest version of the plugin as well.
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart") where $B$6 is the ticker SPY
rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473",99,550,
rchcreatecomment(
Before Monday of this week, I had been using this same sheet for more than 3 years without any issues. I am using the latest version of the plugin as well.
Wed Oct 30, 2019 2:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You last one won't work, because you're giving it a ticker symbol instead
of a URL. The other two are working fine for me right now.
However, when I first tried this link in my browser:
https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473
....I got a message about not having authority to access that chart. But
every access after that first try is working fine. So maybe you're running
into some version of that security check? Try the above link in the IE
object of EXCEL and see if it shows you the chart. If you do get a chart,
try doing RCHCreateComment() with that URL again and see if it works.
I'm not sure how their chart security is working, but once I tried it,
every instance after that appears to be working fine? But I'm not sure
what's going on... :(
On Wed, Oct 30, 2019 at 1:40 PM nate.propes@... wrote:
>
> I've received the "#VALUE" error for each of the following along with a
> comment insert that is a standard excel comment box containing only my
> username
>
> =rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart")
> where $B$6 is the ticker SPY
>
> rchcreatecomment("
> https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473
> ",99,550,450,1,1,1,1,"","Chart")
>
> rchcreatecomment("SPY",99,550,450,1,1,1,1,"","Chart")
>
> Before Monday of this week, I had been using this same sheet for more than
> 3 years without any issues. I am using the latest version of the plugin as
> well.
>
>
of a URL. The other two are working fine for me right now.
However, when I first tried this link in my browser:
https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473
....I got a message about not having authority to access that chart. But
every access after that first try is working fine. So maybe you're running
into some version of that security check? Try the above link in the IE
object of EXCEL and see if it shows you the chart. If you do get a chart,
try doing RCHCreateComment() with that URL again and see if it works.
I'm not sure how their chart security is working, but once I tried it,
every instance after that appears to be working fine? But I'm not sure
what's going on... :(
On Wed, Oct 30, 2019 at 1:40 PM nate.propes@... wrote:
>
> I've received the "#VALUE" error for each of the following along with a
> comment insert that is a standard excel comment box containing only my
> username
>
> =rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart")
> where $B$6 is the ticker SPY
>
> rchcreatecomment("
> https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473
> ",99,550,
>
> rchcreatecomment(
>
> Before Monday of this week, I had been using this same sheet for more than
> 3 years without any issues. I am using the latest version of the plugin as
> well.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar