14 Messages
Digest #4450
Messages
Thu Dec 27, 2018 9:21 am (PST) . Posted by:
ridgebacksexcel
Randy,
I am getting an error from all my RCHCreateComment Function formulas.
Is StockCharts.com behind a pay wall now and no longer functioning?
Is there a work around or another site we could use to display stock charts?
I really love this function and would like to get it working again.
I am getting an error from all my RCHCreateComment Function formulas.
Is StockCharts.
Is there a work around or another site we could use to display stock charts?
I really love this function and would like to get it working again.
Thu Dec 27, 2018 11:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Without an example of what's not working, I can't help much.
But a change at your source may be the issue.
On Thu, Dec 27, 2018 at 10:22 AM tmallen2@... wrote:
> I am getting an error from all my RCHCreateComment Function formulas.
>
> Is StockCharts.com behind a pay wall now and no longer functioning?
>
> Is there a work around or another site we could use to display stock
> charts?
>
> I really love this function and would like to get it working again.
>
>
But a change at your source may be the issue.
On Thu, Dec 27, 2018 at 10:22 AM tmallen2@... wrote:
> I am getting an error from all my RCHCreateComment Function formulas.
>
> Is StockCharts.
>
> Is there a work around or another site we could use to display stock
> charts?
>
> I really love this function and would like to get it working again.
>
>
Thu Dec 27, 2018 1:40 pm (PST) . Posted by:
ridgebacksexcel
This is the formula I have always used and was working fine until a few days ago.
=RCHCreateComment("AAPL",INT(3+RAND()),,,1)
"APPL" is referred to by another cell such as B1
So in my spreadsheet it is: =RCHCreateComment(B1,INT(3+RAND()),,,1)
I just get a Value error and a blank comment with my name in it.
Office 365 recently did an update. Maybe it messed something up.
=RCHCreateComment(
"APPL" is referred to by another cell such as B1
So in my spreadsheet it is: =RCHCreateComment(
I just get a Value error and a blank comment with my name in it.
Office 365 recently did an update. Maybe it messed something up.
Thu Dec 27, 2018 1:49 pm (PST) . Posted by:
ridgebacksexcel
Even a simple version such as this will not work:
=RCHCreateComment("APPL",1)
=RCHCreateComment(
Thu Dec 27, 2018 2:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Is this the chart you used to get?
https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
If so, it looks like they just changed the URL. This one that the add-in
has hard-coded no longer works:
http://stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
On Thu, Dec 27, 2018 at 2:40 PM tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> This is the formula I have always used and was working fine until a few
> days ago.
>
> =RCHCreateComment("AAPL",INT(3+RAND()),,,1)
>
> "APPL" is referred to by another cell such as B1
>
> So in my spreadsheet it is: =RCHCreateComment(B1,INT(3+RAND()),,,1)
>
> I just get a Value error and a blank comment with my name in it.
>
> Office 365 recently did an update. Maybe it messed something up.
>
>
https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
If so, it looks like they just changed the URL. This one that the add-in
has hard-coded no longer works:
http://stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
On Thu, Dec 27, 2018 at 2:40 PM tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> This is the formula I have always used and was working fine until a few
> days ago.
>
> =RCHCreateComment(
>
> "APPL" is referred to by another cell such as B1
>
> So in my spreadsheet it is: =RCHCreateComment(
>
> I just get a Value error and a blank comment with my name in it.
>
> Office 365 recently did an update. Maybe it messed something up.
>
>
Thu Dec 27, 2018 3:00 pm (PST) . Posted by:
ridgebacksexcel
Yes that was the chart I used to get.
Is there a workaround link or do you need to recode the URL in the function?
I can see the chart with this URL: https://c.stockcharts.com/c-sc/sc?chart=AAPL https://c.stockcharts.com/c-sc/sc?chart=AAPL
Can this work? It does not seem to work yet but getting closer here.
=RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=AAPL",1)
Is there a workaround link or do you need to recode the URL in the function?
I can see the chart with this URL: https://c.stockcharts.com/c-sc/sc?chart=AAPL https://c.stockcharts.com/c-sc/sc?chart=AAPL
Can this work? It does not seem to work yet but getting closer here.
=RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=AAPL",1)
Thu Dec 27, 2018 3:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Coding it all yourself would be:
=RCHCreateComment("
https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
",99,229,132,1)
I have changed the add-in code for the problem, but with other things "in
the hopper", it's not a good time to re-release the code I have.
On Thu, Dec 27, 2018 at 4:00 PM tmallen2@... wrote:
> Yes that was the chart I used to get.
>
> Is there a workaround link or do you need to recode the URL in the
> function?
>
> I can see the chart with this URL:
> https://c.stockcharts.com/c-sc/sc?chart=AAPL
>
> Can this work? It does not seem to work yet but getting closer here.
>
> =RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=AAPL",1)
>
>
>
=RCHCreateComment("
https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
",99,229,132,1)
I have changed the add-in code for the problem, but with other things "in
the hopper", it's not a good time to re-release the code I have.
On Thu, Dec 27, 2018 at 4:00 PM tmallen2@... wrote:
> Yes that was the chart I used to get.
>
> Is there a workaround link or do you need to recode the URL in the
> function?
>
> I can see the chart with this URL:
> https://c.stockcharts.com/c-sc/sc?chart=AAPL
>
> Can this work? It does not seem to work yet but getting closer here.
>
> =RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=AAPL",1)
>
>
>
Thu Dec 27, 2018 4:38 pm (PST) . Posted by:
ridgebacksexcel
Ok just to be clear so I understand, typing this formula exactly as below will only work after you release the new add-in with the coding change?
=RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]",99,229,132,1)
I still get a Value#! message with this exact coding.
If this code should work now, I'll keep investigating.
Excel had a big update that may have messed up something else too.
I used to be able the right click the formula cell and select edit comment. That is not there now in the newer version of Excel.
I only get a Yellow Comment with My Name: and colon at the top left of the comment box.
=RCHCreateComment("https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[
I still get a Value#! message with this exact coding.
If this code should work now, I'll keep investigating.
Excel had a big update that may have messed up something else too.
I used to be able the right click the formula cell and select edit comment. That is not there now in the newer version of Excel.
I only get a Yellow Comment with My Name: and colon at the top left of the comment box.
Thu Dec 27, 2018 4:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The new formula I gave you shouldn't need any of the new code. The second
parameter of "99" says you are going to provide all the necessary
parameters. Other values give various default values for those parameters.
I just cut and pasted it and it worked fine here.
The yellow comment box with "Name:" in it has been the standard for a new
comment as long as I can remember.
Can you insert that image, using that URL, directly into your worksheet:
> Insert > Pictures
On Thu, Dec 27, 2018 at 5:47 PM tmallen2@... wrote:
> Ok just to be clear so I understand, typing this formula exactly as below
> will only work after you release the new add-in with the coding change?
>
> =RCHCreateComment("
> https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[pb20!b50][dc]
> ",99,229,132,1)
>
> I still get a Value#! message with this exact coding.
>
> If this code should work now, I'll keep investigating.
>
> Excel had a big update that may have messed up something else too.
>
> I used to be able the right click the formula cell and select edit
> comment. That is not there now in the newer version of Excel.
>
> I only get a Yellow Comment with My Name: and colon at the top left of the
> comment box.
>
>
parameter of "99" says you are going to provide all the necessary
parameters. Other values give various default values for those parameters.
I just cut and pasted it and it worked fine here.
The yellow comment box with "Name:" in it has been the standard for a new
comment as long as I can remember.
Can you insert that image, using that URL, directly into your worksheet:
> Insert > Pictures
On Thu, Dec 27, 2018 at 5:47 PM tmallen2@... wrote:
> Ok just to be clear so I understand, typing this formula exactly as below
> will only work after you release the new add-in with the coding change?
>
> =RCHCreateComment("
> https://c.stockcharts.com/c-sc/sc?chart=MMM,uu[305,a]dacayaci[
> ",99,229,
>
> I still get a Value#! message with this exact coding.
>
> If this code should work now, I'll keep investigating.
>
> Excel had a big update that may have messed up something else too.
>
> I used to be able the right click the formula cell and select edit
> comment. That is not there now in the newer version of Excel.
>
> I only get a Yellow Comment with My Name: and colon at the top left of the
> comment box.
>
>
Thu Dec 27, 2018 5:28 pm (PST) . Posted by:
ridgebacksexcel
No it does not work in my new version of Excel. I am using the exact same formula as you are. It just pulls up a new comment box and Value#! error code.
I'll keep playing with it since I know it works on an older version of Excel. It must be blocking the image somehow.
I'll get back to you in a few days when I have more time to play with it.
Thanks.
I'll keep playing with it since I know it works on an older version of Excel. It must be blocking the image somehow.
I'll get back to you in a few days when I have more time to play with it.
Thanks.
Thu Dec 27, 2018 5:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There is a possibility that EXCEL finally fixed the error that allows this
to happen.
A function is only supposed to be able to return a value to the cell it was
given access to. That doesn't include manipulating the cell attributes, for
things like format, color, font, OR COMMENT. This was an "undocumented
feature". I'm surprised Microsoft hasn't fixed it by now. It's been around
for a long time.
On Thu, Dec 27, 2018 at 6:35 PM tmallen2@... wrote:
> No it does not work in my new version of Excel. I am using the exact same
> formula as you are. It just pulls up a new comment box and Value#! error
> code.
>
> I'll keep playing with it since I know it works on an older version of
> Excel. It must be blocking the image somehow.
>
> I'll get back to you in a few days when I have more time to play with it.
>
>
>
to happen.
A function is only supposed to be able to return a value to the cell it was
given access to. That doesn't include manipulating the cell attributes, for
things like format, color, font, OR COMMENT. This was an "undocumented
feature"
for a long time.
On Thu, Dec 27, 2018 at 6:35 PM tmallen2@... wrote:
> No it does not work in my new version of Excel. I am using the exact same
> formula as you are. It just pulls up a new comment box and Value#! error
> code.
>
> I'll keep playing with it since I know it works on an older version of
> Excel. It must be blocking the image somehow.
>
> I'll get back to you in a few days when I have more time to play with it.
>
>
>
Thu Dec 27, 2018 6:08 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I dug up an old "dynamic chart" workbook I created when I was first
fiddling around with inserting charts. I had to change the URL for
StockCharts images, but it still seems to work here once that was done.
It does nothing until something is change in the "Tickers" range (yellow
shaded cells). Then, the EXCEL change event is triggered and it insert an
image to the cell immediately to the right of the entered ticker symbol.
It's a very short VBA routine. If RCHCreateComment() is no longer working,
maybe something like that could work for what you need?
On Thu, Dec 27, 2018 at 6:35 PM tmallen2@... wrote:
> No it does not work in my new version of Excel. I am using the exact same
> formula as you are. It just pulls up a new comment box and Value#! error
> code.
>
> I'll keep playing with it since I know it works on an older version of
> Excel. It must be blocking the image somehow.
>
> I'll get back to you in a few days when I have more time to play with it.
>
fiddling around with inserting charts. I had to change the URL for
StockCharts images, but it still seems to work here once that was done.
It does nothing until something is change in the "Tickers" range (yellow
shaded cells). Then, the EXCEL change event is triggered and it insert an
image to the cell immediately to the right of the entered ticker symbol.
It's a very short VBA routine. If RCHCreateComment(
maybe something like that could work for what you need?
On Thu, Dec 27, 2018 at 6:35 PM tmallen2@... wrote:
> No it does not work in my new version of Excel. I am using the exact same
> formula as you are. It just pulls up a new comment box and Value#! error
> code.
>
> I'll keep playing with it since I know it works on an older version of
> Excel. It must be blocking the image somehow.
>
> I'll get back to you in a few days when I have more time to play with it.
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
Thu Dec 27, 2018 11:31 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Without a specific example of what you're doing, it's hard to diagnose.
But they started to unplug Google Finance 2 or 3 years ago, so any pricing
API would probably go away as well.
Did you check the URL in your browser?
On Thu, Dec 27, 2018 at 12:02 PM picsound@... wrote:
>
> http://www.google.com/finance/getprices?q=.... not work more?
>
But they started to unplug Google Finance 2 or 3 years ago, so any pricing
API would probably go away as well.
Did you check the URL in your browser?
On Thu, Dec 27, 2018 at 12:02 PM picsound@... wrote:
>
> http://www.google.com/finance/getprices?q=.... not work more?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar