15 Messages
Digest #4189
Messages
Wed Nov 1, 2017 1:44 pm (PDT) . Posted by:
"Bob Gerard" bobgerard28
Same thing I noticed. RCHGetYahooQuotes returns nothing .... Happened just a little while ago.
________________________________
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com> on behalf of codyklein@alum.drexel.edu [smf_addin] <smf_addin@yahoogroups.com>
Sent: November 1, 2017 1:30 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetYahooQuotes(B6:B50,C4:V4)
Is it me or did anyone else notice RCHGetYahooQuotes stopped working late this afternoon?
________________________________
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com> on behalf of codyklein@alum.drexel.edu [smf_addin] <smf_addin@yahoogroups.com>
Sent: November 1, 2017 1:30 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetYahooQuotes(
Is it me or did anyone else notice RCHGetYahooQuotes stopped working late this afternoon?
Wed Nov 1, 2017 1:45 pm (PDT) . Posted by:
midhenry1
Same here. No error message, just all cells in array are blank
=RCHGetElementNumber("Version") works fine.
=RCHGetElementNumbe
Wed Nov 1, 2017 1:45 pm (PDT) . Posted by:
midhenry1
Me too
---In smf_addin@yahoogroups.com, <codyklein@...> wrote :
Is it me or did anyone else notice RCHGetYahooQuotes stopped working late this afternoon?
---In smf_addin@yahoogroups.com, <codyklein@
Is it me or did anyone else notice RCHGetYahooQuotes stopped working late this afternoon?
Wed Nov 1, 2017 1:45 pm (PDT) . Posted by:
jaromir.dvorak
Me too, is there other function, to get current price?
Wed Nov 1, 2017 1:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Announced on the blog 25 minutes ago, when I ran into myself:
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
On Wed, Nov 1, 2017 at 1:30 PM, codyklein@
...
wrote:
> Is it me or did anyone else notice RCHGetYahooQuotes stopped working late
> this afternoon?
>
>
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
On Wed, Nov 1, 2017 at 1:30 PM, codyklein@
...
wrote:
> Is it me or did anyone else notice RCHGetYahooQuotes stopped working late
> this afternoon?
>
>
Wed Nov 1, 2017 2:11 pm (PDT) . Posted by:
john_hoel
Today all calls to the SMF add-in to download quotes return 'Error'. The same workbook calls FRED 2013 and several add-ins that I have written and they all work.
I tried a system restart and the problem persists.
I reinstalled the SMF add-in and the problem persists.
However, this function does work:
=RCHGetElementNumber("Version")
which returns:
Stock Market Functions add-in, Version 2.1.2016.09.02 (C:\SMF AddIn; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
Any suggestions?
I tried a system restart and the problem persists.
I reinstalled the SMF add-in and the problem persists.
However, this function does work:
=RCHGetElementNumbe
which returns:
Stock Market Functions add-in, Version 2.1.2016.09.
Any suggestions?
Wed Nov 1, 2017 2:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
On Wed, Nov 1, 2017 at 2:10 PM, john@
...
wrote:
>
> Today all calls to the SMF add-in to download quotes return 'Error'. The
> same workbook calls FRED 2013 and several add-ins that I have written and
> they all work.
>
> I tried a system restart and the problem persists.
>
> I reinstalled the SMF add-in and the problem persists.
>
> However, this function does work:
>
> =RCHGetElementNumber("Version")
>
> which returns:
>
> Stock Market Functions add-in, Version 2.1.2016.09.02 (C:\SMF AddIn;
> Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
> Any suggestions?
>
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
On Wed, Nov 1, 2017 at 2:10 PM, john@
...
wrote:
>
> Today all calls to the SMF add-in to download quotes return 'Error&#
> same workbook calls FRED 2013 and several add-ins that I have written and
> they all work.
>
> I tried a system restart and the problem persists.
>
> I reinstalled the SMF add-in and the problem persists.
>
> However, this function does work:
>
> =RCHGetElementNumbe
>
> which returns:
>
> Stock Market Functions add-in, Version 2.1.2016.09.
> Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
> Any suggestions?
>
Wed Nov 1, 2017 2:31 pm (PDT) . Posted by:
john_hoel
Aha! When I change these to call MarketWatch, they work.
Wed Nov 1, 2017 2:36 pm (PDT) . Posted by:
"Dennis Sesar" dennis@zis.com
I have been using the function in the subject field for a long time. Today
it returns blank, C79 contains the ticker symbol and I am trying to get the
closing price returned. Any Ideas?
Dennis Sesar
18757 Burbank Blvd., Ste 116
Tarzana, CA 91356
Tel: 310.826.8634/818.206.8634 Ext 114
dennis@zis.com <mailto:dennis@zis.com>
it returns blank, C79 contains the ticker symbol and I am trying to get the
closing price returned. Any Ideas?
Dennis Sesar
18757 Burbank Blvd., Ste 116
Tarzana, CA 91356
Tel: 310.826.8634/818.206.8634 Ext 114
dennis@zis.com <mailto:dennis@zis.com>
Wed Nov 1, 2017 2:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the announcements blog:
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171031.html
On Wed, Nov 1, 2017 at 2:36 PM, 'Dennis Sesar' dennis@zis.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> *I have been using the function in the subject field for a long time.
> Today it returns blank, C79 contains the ticker symbol and I am trying to
> get the closing price returned. Any Ideas? *
>
>
>
>
>
https://smf-add-in.blogspot.com/2017/11/alert-rchgetyahooquotes-problems.html
https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171031.html
On Wed, Nov 1, 2017 at 2:36 PM, 'Dennis Sesar' dennis@zis.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> *I have been using the function in the subject field for a long time.
> Today it returns blank, C79 contains the ticker symbol and I am trying to
> get the closing price returned. Any Ideas? *
>
>
>
>
>
Wed Nov 1, 2017 3:47 pm (PDT) . Posted by:
"Jonathan" jbr863
Oh. I don't have a Premium Membership so if they moved that metric behind the paywall then "yea", that's definitely what's happening.
On Wednesday, November 1, 2017, 10:40:42 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Based on your results, I'd say you weren't logged in (i.e. no security cookie for the IE object that EXCEL uses). That would allow the "TTM" for "Free Cash Flow" to be returned, but not return a value for "Enterprise Value".
To check, what do you get with:
=RCHGetWebData("https://www.gurufocus.com/new_index/","Premium Member until",75)
I get:
Premium Member until 2018-01-11) , which covers <b>USA</b>.. <a href=https:
On Wed, Nov 1, 2017 at 10:11 AM, Jonathan jbr863@... wrote:
I don't know why the image got removed in my last email but I have included it as an attachment.
Free Cash Flow works fine (Item # 137) - hopefully the image comes through this time. The last two formulae correctly return TTM FCF as $176.90.
When I change the bottom two formulae to call item #151(Enterprise Value), the bottom two formulae return TTM EV as "Error":
| =RCHGetElementNumber("Version" ) | Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 15.0; ; ; 1) |
| =smfGetGuruFocusItem("AGX",151 , "TTM",0) | Error |
| =smfConvertData(smfGetTagConte nt("https://www.gurufocus.com/ financials/AGX";, "div", -1, "id=""Rf""", "/term/ev/", "yesttm")) | Error |
#yiv4672646596 #yiv4672646596 -- #yiv4672646596ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4672646596 #yiv4672646596ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4672646596 #yiv4672646596ygrp-mkp #yiv4672646596hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4672646596 #yiv4672646596ygrp-mkp #yiv4672646596ads {margin-bottom:10px;}#yiv4672646596 #yiv4672646596ygrp-mkp .yiv4672646596ad {padding:0 0;}#yiv4672646596 #yiv4672646596ygrp-mkp .yiv4672646596ad p {margin:0;}#yiv4672646596 #yiv4672646596ygrp-mkp .yiv4672646596ad a {color:#0000ff;text-decoration:none;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ygrp-lc {font-family:Arial;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ygrp-lc #yiv4672646596hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ygrp-lc .yiv4672646596ad {margin-bottom:10px;padding:0 0;}#yiv4672646596 #yiv4672646596actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4672646596 #yiv4672646596activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4672646596 #yiv4672646596activity span {font-weight:700;}#yiv4672646596 #yiv4672646596activity span:first-child {text-transform:uppercase;}#yiv4672646596 #yiv4672646596activity span a {color:#5085b6;text-decoration:none;}#yiv4672646596 #yiv4672646596activity span span {color:#ff7900;}#yiv4672646596 #yiv4672646596activity span .yiv4672646596underline {text-decoration:underline;}#yiv4672646596 .yiv4672646596attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4672646596 .yiv4672646596attach div a {text-decoration:none;}#yiv4672646596 .yiv4672646596attach img {border:none;padding-right:5px;}#yiv4672646596 .yiv4672646596attach label {display:block;margin-bottom:5px;}#yiv4672646596 .yiv4672646596attach label a {text-decoration:none;}#yiv4672646596 blockquote {margin:0 0 0 4px;}#yiv4672646596 .yiv4672646596bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4672646596 .yiv4672646596bold a {text-decoration:none;}#yiv4672646596 dd.yiv4672646596last p a {font-family:Verdana;font-weight:700;}#yiv4672646596 dd.yiv4672646596last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4672646596 dd.yiv4672646596last p span.yiv4672646596yshortcuts {margin-right:0;}#yiv4672646596 div.yiv4672646596attach-table div div a {text-decoration:none;}#yiv4672646596 div.yiv4672646596attach-table {width:400px;}#yiv4672646596 div.yiv4672646596file-title a, #yiv4672646596 div.yiv4672646596file-title a:active, #yiv4672646596 div.yiv4672646596file-title a:hover, #yiv4672646596 div.yiv4672646596file-title a:visited {text-decoration:none;}#yiv4672646596 div.yiv4672646596photo-title a, #yiv4672646596 div.yiv4672646596photo-title a:active, #yiv4672646596 div.yiv4672646596photo-title a:hover, #yiv4672646596 div.yiv4672646596photo-title a:visited {text-decoration:none;}#yiv4672646596 div#yiv4672646596ygrp-mlmsg #yiv4672646596ygrp-msg p a span.yiv4672646596yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4672646596 .yiv4672646596green {color:#628c2a;}#yiv4672646596 .yiv4672646596MsoNormal {margin:0 0 0 0;}#yiv4672646596 o {font-size:0;}#yiv4672646596 #yiv4672646596photos div {float:left;width:72px;}#yiv4672646596 #yiv4672646596photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4672646596 #yiv4672646596photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4672646596 #yiv4672646596reco-category {font-size:77%;}#yiv4672646596 #yiv4672646596reco-desc {font-size:77%;}#yiv4672646596 .yiv4672646596replbq {margin:4px;}#yiv4672646596 #yiv4672646596ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4672646596 #yiv4672646596ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4672646596 #yiv4672646596ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4672646596 #yiv4672646596ygrp-mlmsg select, #yiv4672646596 input, #yiv4672646596 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4672646596 #yiv4672646596ygrp-mlmsg pre, #yiv4672646596 code {font:115% monospace;}#yiv4672646596 #yiv4672646596ygrp-mlmsg * {line-height:1.22em;}#yiv4672646596 #yiv4672646596ygrp-mlmsg #yiv4672646596logo {padding-bottom:10px;}#yiv4672646596 #yiv4672646596ygrp-msg p a {font-family:Verdana;}#yiv4672646596 #yiv4672646596ygrp-msg p#yiv4672646596attach-count span {color:#1E66AE;font-weight:700;}#yiv4672646596 #yiv4672646596ygrp-reco #yiv4672646596reco-head {color:#ff7900;font-weight:700;}#yiv4672646596 #yiv4672646596ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ov li a {font-size:130%;text-decoration:none;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4672646596 #yiv4672646596ygrp-sponsor #yiv4672646596ov ul {margin:0;padding:0 0 0 8px;}#yiv4672646596 #yiv4672646596ygrp-text {font-family:Georgia;}#yiv4672646596 #yiv4672646596ygrp-text p {margin:0 0 1em 0;}#yiv4672646596 #yiv4672646596ygrp-text tt {font-size:120%;}#yiv4672646596 #yiv4672646596ygrp-vital ul li:last-child {border-right:none !important;}#yiv4672646596
On Wednesday, November 1, 2017, 10:40:42 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Based on your results, I'd say you weren't logged in (i.e. no security cookie for the IE object that EXCEL uses). That would allow the "TTM" for "Free Cash Flow" to be returned, but not return a value for "Enterprise Value".
To check, what do you get with:
=RCHGetWebData("https://www.gurufocus.com/new_index/","Premium Member until",75)
I get:
Premium Member until 2018-01-11) , which covers <b>USA</b>.. <a href=https:
On Wed, Nov 1, 2017 at 10:11 AM, Jonathan jbr863@... wrote:
I don't know why the image got removed in my last email but I have included it as an attachment.
Free Cash Flow works fine (Item # 137) - hopefully the image comes through this time. The last two formulae correctly return TTM FCF as $176.90.
When I change the bottom two formulae to call item #151(Enterprise Value), the bottom two formulae return TTM EV as "Error":
| =RCHGetElementNumber("Version" ) | Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 15.0; ; ; 1) |
| =smfGetGuruFocusItem("AGX",151 , "TTM",0) | Error |
| =smfConvertData(smfGetTagConte nt("https://www.gurufocus.com/ financials/AGX"
#yiv4672646596 #yiv4672646596 -- #yiv4672646596ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar