12 Messages
Digest #4242
Messages
Sat Nov 18, 2017 9:04 am (PST) . Posted by:
climbermel
I am using formulas such as =RCHGetElementNumber("BarChartMM", 1147) and getting not found for a response. I am using the 11.11 add-in and other formulas work.
In the sample sheet SMF-Template-Barchart-Market-Momentum.xls the top portion is
using: =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"NYSE","}"),"""advancingIssues"":""",""""))
for NYSE advancing issues, and apears to be working, the bottom uses the RCHGetElement above and has the problem.
I'll look for info on the smfConvertData, I haven't used that one in the past...
Thanks,
Mel
In the sample sheet SMF-Template-
using: =smfConvertData(
for NYSE advancing issues, and apears to be working, the bottom uses the RCHGetElement above and has the problem.
I'll look for info on the smfConvertData, I haven't used that one in the past...
Thanks,
Mel
Sat Nov 18, 2017 1:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Maybe a temporary Barchart glitch? It appears to be working fine here:
*Barchart Market Momentum, as shown on Sat, Nov 18th, 2017*
*NYSE* *NASDAQ* *AMEX* *OTC*
*Advancing Issues:* 1,224 1,434 142 7
*Declining Issues:* 736 928 72 7
*Unchanged Issues:* 75 125 19 4
*Advancing Issues (%):* 60.1 57.7 60.9 38.9
*Declining Issues (%):* 36.2 37.3 30.9 38.9
*Unchanged Issues (%):* 3.7 5.0 8.2 22.2
*Advancing Volume:* 2,079,900,000 1,096,950,000 55,980,000 1,040,000
*Declining Volume:* 1,078,560,000 731,560,000 24,990,000 20,000
*Unchanged Volume:* 43,300,000 41,030,000 3,700,000 40,000
*New 52-week Highs:* 90 97 3 0
*New 52-week Lows:* 19 29 4 0
*New Highs:* 88 93 1 1
*New Lows:* 14 14 1 0
smfConvertData() just converts a string into numeric data, as well as it
can. Otherwise, it just returns the initial string that was passed.
However, the "percentage of stocks" section does need to be redone, because
Barchart added a new column to their table.
On Sat, Nov 18, 2017 at 10:04 AM, climbermel@
...
wrote:
>
> I am using formulas such as =RCHGetElementNumber("BarChartMM", 1147) and
> getting not found for a response. I am using the 11.11 add-in and other
> formulas work.
>
> In the sample sheet SMF-Template-Barchart-Market-Momentum.xls the top
> portion is
> using: =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL)
> ,"NYSE","}"),"""advancingIssues"":""",""""))
> for NYSE advancing issues, and apears to be working, the bottom uses the
> RCHGetElement above and has the problem.
>
> I'll look for info on the smfConvertData, I haven't used that one in the
> past...
>
>
*Barchart Market Momentum, as shown on Sat, Nov 18th, 2017*
*NYSE* *NASDAQ* *AMEX* *OTC*
*Advancing Issues:* 1,224 1,434 142 7
*Declining Issues:* 736 928 72 7
*Unchanged Issues:* 75 125 19 4
*Advancing Issues (%):* 60.1 57.7 60.9 38.9
*Declining Issues (%):* 36.2 37.3 30.9 38.9
*Unchanged Issues (%):* 3.7 5.0 8.2 22.2
*Advancing Volume:* 2,079,900,000 1,096,950,000 55,980,000 1,040,000
*Declining Volume:* 1,078,560,000 731,560,000 24,990,000 20,000
*Unchanged Volume:* 43,300,000 41,030,000 3,700,000 40,000
*New 52-week Highs:* 90 97 3 0
*New 52-week Lows:* 19 29 4 0
*New Highs:* 88 93 1 1
*New Lows:* 14 14 1 0
smfConvertData(
can. Otherwise, it just returns the initial string that was passed.
However, the "percentage of stocks" section does need to be redone, because
Barchart added a new column to their table.
On Sat, Nov 18, 2017 at 10:04 AM, climbermel@
...
wrote:
>
> I am using formulas such as =RCHGetElementNumbe
> getting not found for a response. I am using the 11.11 add-in and other
> formulas work.
>
> In the sample sheet SMF-Template-
> portion is
> using: =smfConvertData(
> ,"NYSE"
> for NYSE advancing issues, and apears to be working, the bottom uses the
> RCHGetElement above and has the problem.
>
> I'll look for info on the smfConvertData, I haven't used that one in the
> past...
>
>
The DE in the caption stopped working. The 46xx series are from Morningstar the 4947 from Yahoo.
Any hints,
Thanks
Armando
Any hints,
Thanks
Armando
Sat Nov 18, 2017 1:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm getting a lot of timeouts on accessing the Morningstar web pages those
elements come from. It could be that Morningstar is unplugging them. They
are their old "print format" pages.
Re: Yahoo mutual fund elements -- see:
https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQAJ
On Sat, Nov 18, 2017 at 11:42 AM, armando@
...
wrote:
> The DE in the caption stopped working. The 46xx series are from
> Morningstar the 4947 from Yahoo.
>
> Any hints,
>
>
>
elements come from. It could be that Morningstar is unplugging them. They
are their old "print format" pages.
Re: Yahoo mutual fund elements -- see:
https://groups.google.com/d/msg/smf-addin/33cX75sYSlY/whTwlQmJCQAJ
On Sat, Nov 18, 2017 at 11:42 AM, armando@
...
wrote:
> The DE in the caption stopped working. The 46xx series are from
> Morningstar the 4947 from Yahoo.
>
> Any hints,
>
>
>
Sat Nov 18, 2017 10:57 am (PST) . Posted by:
ridgebacksexcel
I did some more investigating, going so far as to rebuild the stock charts tab again using your template that is working in Excel 2003 format. I use Excel 365, the most current version.
It seems after I save the workbook, Excel cuts off half of the first row of stock charts and all the other rows completely.
I noticed with edit comment, it points me to the minimized comment at the top of each of the cells. I can grab and expand them again, but when I save it does the same thing again.
I think this is a bug in the newest Excel update possibly.
Maybe you will experience the same thing since I think you have Excel 365 as well.
It seems after I save the workbook, Excel cuts off half of the first row of stock charts and all the other rows completely.
I noticed with edit comment, it points me to the minimized comment at the top of each of the cells. I can grab and expand them again, but when I save it does the same thing again.
I think this is a bug in the newest Excel update possibly.
Maybe you will experience the same thing since I think you have Excel 365 as well.
Sat Nov 18, 2017 1:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I am using EXCEL 365, but under Win10.
I did try loading the template from the Yahoo group, adding a number of
ticker symbols, and then saved it and reopened it. It all looked OK to me.
So I'm not sure what is going on there?
You could try attaching a copy of yours. Maybe when I open it, I might
discover something?
On Sat, Nov 18, 2017 at 11:56 AM, tmallen2@
...
wrote:
> I did some more investigating, going so far as to rebuild the stock charts
> tab again using your template that is working in Excel 2003 format. I use
> Excel 365, the most current version.
>
> It seems after I save the workbook, Excel cuts off half of the first row
> of stock charts and all the other rows completely.
>
> I noticed with edit comment, it points me to the minimized comment at the
> top of each of the cells. I can grab and expand them again, but when I save
> it does the same thing again.
>
> I think this is a bug in the newest Excel update possibly.
>
> Maybe you will experience the same thing since I think you have Excel 365
> as well.
>
>
>
I did try loading the template from the Yahoo group, adding a number of
ticker symbols, and then saved it and reopened it. It all looked OK to me.
So I'm not sure what is going on there?
You could try attaching a copy of yours. Maybe when I open it, I might
discover something?
On Sat, Nov 18, 2017 at 11:56 AM, tmallen2@
...
wrote:
> I did some more investigating, going so far as to rebuild the stock charts
> tab again using your template that is working in Excel 2003 format. I use
> Excel 365, the most current version.
>
> It seems after I save the workbook, Excel cuts off half of the first row
> of stock charts and all the other rows completely.
>
> I noticed with edit comment, it points me to the minimized comment at the
> top of each of the cells. I can grab and expand them again, but when I save
> it does the same thing again.
>
> I think this is a bug in the newest Excel update possibly.
>
> Maybe you will experience the same thing since I think you have Excel 365
> as well.
>
>
>
Sat Nov 18, 2017 2:16 pm (PST) . Posted by:
"George Toscano" gtoscano2005
Hi Randy,
RCH is no longer working as of October 28, 2017 on my desktop For example:
=RCHGetYahooQuotes(A4,$B$2) where A4 is stock ticker and B2 = n
gives a blank cell.
Running Windows 10 (piece of garbage)Using Microsoft Excel 2007was there a new update to the function? if so can you send e the link?
Kindly,
George Toscano
On Saturday, November 18, 2017 4:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I am using EXCEL 365, but under Win10.
I did try loading the template from the Yahoo group, adding a number of ticker symbols, and then saved it and reopened it. It all looked OK to me. So I'm not sure what is going on there?
You could try attaching a copy of yours. Maybe when I open it, I might discover something?
On Sat, Nov 18, 2017 at 11:56 AM, tmallen2@... wrote:
I did some more investigating, going so far as to rebuild the stock charts tab again using your template that is working in Excel 2003 format. I use Excel 365, the most current version.It seems after I save the workbook, Excel cuts off half of the first row of stock charts and all the other rows completely.
I noticed with edit comment, it points me to the minimized comment at the top of each of the cells. I can grab and expand them again, but when I save it does the same thing again.
I think this is a bug in the newest Excel update possibly.
Maybe you will experience the same thing since I think you have Excel 365 as well.
#yiv1634113493 #yiv1634113493 -- #yiv1634113493ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1634113493 #yiv1634113493ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1634113493 #yiv1634113493ygrp-mkp #yiv1634113493hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1634113493 #yiv1634113493ygrp-mkp #yiv1634113493ads {margin-bottom:10px;}#yiv1634113493 #yiv1634113493ygrp-mkp .yiv1634113493ad {padding:0 0;}#yiv1634113493 #yiv1634113493ygrp-mkp .yiv1634113493ad p {margin:0;}#yiv1634113493 #yiv1634113493ygrp-mkp .yiv1634113493ad a {color:#0000ff;text-decoration:none;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ygrp-lc {font-family:Arial;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ygrp-lc #yiv1634113493hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ygrp-lc .yiv1634113493ad {margin-bottom:10px;padding:0 0;}#yiv1634113493 #yiv1634113493actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1634113493 #yiv1634113493activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1634113493 #yiv1634113493activity span {font-weight:700;}#yiv1634113493 #yiv1634113493activity span:first-child {text-transform:uppercase;}#yiv1634113493 #yiv1634113493activity span a {color:#5085b6;text-decoration:none;}#yiv1634113493 #yiv1634113493activity span span {color:#ff7900;}#yiv1634113493 #yiv1634113493activity span .yiv1634113493underline {text-decoration:underline;}#yiv1634113493 .yiv1634113493attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1634113493 .yiv1634113493attach div a {text-decoration:none;}#yiv1634113493 .yiv1634113493attach img {border:none;padding-right:5px;}#yiv1634113493 .yiv1634113493attach label {display:block;margin-bottom:5px;}#yiv1634113493 .yiv1634113493attach label a {text-decoration:none;}#yiv1634113493 blockquote {margin:0 0 0 4px;}#yiv1634113493 .yiv1634113493bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1634113493 .yiv1634113493bold a {text-decoration:none;}#yiv1634113493 dd.yiv1634113493last p a {font-family:Verdana;font-weight:700;}#yiv1634113493 dd.yiv1634113493last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1634113493 dd.yiv1634113493last p span.yiv1634113493yshortcuts {margin-right:0;}#yiv1634113493 div.yiv1634113493attach-table div div a {text-decoration:none;}#yiv1634113493 div.yiv1634113493attach-table {width:400px;}#yiv1634113493 div.yiv1634113493file-title a, #yiv1634113493 div.yiv1634113493file-title a:active, #yiv1634113493 div.yiv1634113493file-title a:hover, #yiv1634113493 div.yiv1634113493file-title a:visited {text-decoration:none;}#yiv1634113493 div.yiv1634113493photo-title a, #yiv1634113493 div.yiv1634113493photo-title a:active, #yiv1634113493 div.yiv1634113493photo-title a:hover, #yiv1634113493 div.yiv1634113493photo-title a:visited {text-decoration:none;}#yiv1634113493 div#yiv1634113493ygrp-mlmsg #yiv1634113493ygrp-msg p a span.yiv1634113493yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1634113493 .yiv1634113493green {color:#628c2a;}#yiv1634113493 .yiv1634113493MsoNormal {margin:0 0 0 0;}#yiv1634113493 o {font-size:0;}#yiv1634113493 #yiv1634113493photos div {float:left;width:72px;}#yiv1634113493 #yiv1634113493photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1634113493 #yiv1634113493photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1634113493 #yiv1634113493reco-category {font-size:77%;}#yiv1634113493 #yiv1634113493reco-desc {font-size:77%;}#yiv1634113493 .yiv1634113493replbq {margin:4px;}#yiv1634113493 #yiv1634113493ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1634113493 #yiv1634113493ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1634113493 #yiv1634113493ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1634113493 #yiv1634113493ygrp-mlmsg select, #yiv1634113493 input, #yiv1634113493 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1634113493 #yiv1634113493ygrp-mlmsg pre, #yiv1634113493 code {font:115% monospace;}#yiv1634113493 #yiv1634113493ygrp-mlmsg * {line-height:1.22em;}#yiv1634113493 #yiv1634113493ygrp-mlmsg #yiv1634113493logo {padding-bottom:10px;}#yiv1634113493 #yiv1634113493ygrp-msg p a {font-family:Verdana;}#yiv1634113493 #yiv1634113493ygrp-msg p#yiv1634113493attach-count span {color:#1E66AE;font-weight:700;}#yiv1634113493 #yiv1634113493ygrp-reco #yiv1634113493reco-head {color:#ff7900;font-weight:700;}#yiv1634113493 #yiv1634113493ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ov li a {font-size:130%;text-decoration:none;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1634113493 #yiv1634113493ygrp-sponsor #yiv1634113493ov ul {margin:0;padding:0 0 0 8px;}#yiv1634113493 #yiv1634113493ygrp-text {font-family:Georgia;}#yiv1634113493 #yiv1634113493ygrp-text p {margin:0 0 1em 0;}#yiv1634113493 #yiv1634113493ygrp-text tt {font-size:120%;}#yiv1634113493 #yiv1634113493ygrp-vital ul li:last-child {border-right:none !important;}#yiv1634113493
RCH is no longer working as of October 28, 2017 on my desktop For example:
=RCHGetYahooQuotes(A4,$B$2) where A4 is stock ticker and B2 = n
gives a blank cell.
Running Windows 10 (piece of garbage)Using Microsoft Excel 2007was there a new update to the function? if so can you send e the link?
Kindly,
George Toscano
On Saturday, November 18, 2017 4:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I am using EXCEL 365, but under Win10.
I did try loading the template from the Yahoo group, adding a number of ticker symbols, and then saved it and reopened it. It all looked OK to me. So I'm not sure what is going on there?
You could try attaching a copy of yours. Maybe when I open it, I might discover something?
On Sat, Nov 18, 2017 at 11:56 AM, tmallen2@... wrote:
I did some more investigating, going so far as to rebuild the stock charts tab again using your template that is working in Excel 2003 format. I use Excel 365, the most current version.It seems after I save the workbook, Excel cuts off half of the first row of stock charts and all the other rows completely.
I noticed with edit comment, it points me to the minimized comment at the top of each of the cells. I can grab and expand them again, but when I save it does the same thing again.
I think this is a bug in the newest Excel update possibly.
Maybe you will experience the same thing since I think you have Excel 365 as well.
#yiv1634113493 #yiv1634113493 -- #yiv1634113493ygrp-
Sat Nov 18, 2017 2:34 pm (PST) . Posted by:
ridgebacksexcel
Here is a copy of the Stock Chart Sheet. I resized all the comments and saved it. No problems till I opened it a 2nd time. It did the same thing again.
This is what it looks like on my spreadsheet.
Half of the 1st row and none of the other rows. You can resize it but it does not stay that way as far as I can tell.
I get an error when I try and upload the file. Here is a link to my Public OneDrive folder to access it.
https://1drv.ms/x/s!Au0GJ3GwreeVipoJYhWW0Bsa7qXnAw https://1drv.ms/x/s!Au0GJ3GwreeVipoJYhWW0Bsa7qXnAw
This is what it looks like on my spreadsheet.
Half of the 1st row and none of the other rows. You can resize it but it does not stay that way as far as I can tell.
I get an error when I try and upload the file. Here is a link to my Public OneDrive folder to access it.
https://1drv.ms/x/s!Au0GJ3GwreeVipoJYhWW0Bsa7qXnAw https://1drv.ms/x/s!Au0GJ3GwreeVipoJYh
Sat Nov 18, 2017 3:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo unplugged their current quotes CSV on 10/31, so RCHGetYahooQuotes()
is now dead. See the announcements blog for details and alternatives:
https://smf-add-in.blogspot.com/
P.S. In the future, please start a new topic instead of hijacking a current
one.
On Sat, Nov 18, 2017 at 3:16 PM, George Toscano gtoscano2005@
...
wrote:
>
> RCH is no longer working as of October 28, 2017 on my desktop
> For example:
>
> =RCHGetYahooQuotes(A4,$B$2) where A4 is stock ticker and B2 = n
> gives a blank cell.
>
> Running Windows 10 (piece of garbage)
> Using Microsoft Excel 2007
> was there a new update to the function? if so can you send e the link?
>
>
is now dead. See the announcements blog for details and alternatives:
https://smf-add-in.blogspot.com/
P.S. In the future, please start a new topic instead of hijacking a current
one.
On Sat, Nov 18, 2017 at 3:16 PM, George Toscano gtoscano2005@
...
wrote:
>
> RCH is no longer working as of October 28, 2017 on my desktop
> For example:
>
> =RCHGetYahooQuotes(
> gives a blank cell.
>
> Running Windows 10 (piece of garbage)
> Using Microsoft Excel 2007
> was there a new update to the function? if so can you send e the link?
>
>
Sat Nov 18, 2017 3:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I see what you do using the browser version of EXCEL, but when I open it
externally, it's fine.
On Sat, Nov 18, 2017 at 3:34 PM, tmallen2@
...
wrote:
> Here is a copy of the Stock Chart Sheet. I resized all the comments and
> saved it. No problems till I opened it a 2nd time. It did the same thing
> again.
>
> This is what it looks like on my spreadsheet.
>
> Half of the 1st row and none of the other rows. You can resize it but it
> does not stay that way as far as I can tell.
>
> I get an error when I try and upload the file. Here is a link to my Public
> OneDrive folder to access it.
>
> https://1drv.ms/x/s!Au0GJ3GwreeVipoJYhWW0Bsa7qXnAw
>
>
>
externally, it's fine.
On Sat, Nov 18, 2017 at 3:34 PM, tmallen2@
...
wrote:
> Here is a copy of the Stock Chart Sheet. I resized all the comments and
> saved it. No problems till I opened it a 2nd time. It did the same thing
> again.
>
> This is what it looks like on my spreadsheet.
>
> Half of the 1st row and none of the other rows. You can resize it but it
> does not stay that way as far as I can tell.
>
> I get an error when I try and upload the file. Here is a link to my Public
> OneDrive folder to access it.
>
> https://1drv.ms/x/s!Au0GJ3GwreeVipoJYh
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar