15 Messages
Digest #3994
Messages
Tue May 2, 2017 7:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. Uploading revised element definitions now. They
modified a variable name in the JavaScript code, which I was using to
position myself on the data for extraction.
On Tue, May 2, 2017 at 6:43 PM, cawley1647@
...wrote:
> I was wondering if Zacks has changed something? The earnings announcements
> has stopped working for me. Maybe it was something that I did, but I don't
> think so as it has stopped on two of my computers.
>
> I use the top line only to get the most recent earnings date.
>
> like this: =RCHGetElementNumber(Ticker,1290), but I change the word
> ticker to A1 or A2 etc. where I have the ticker for each of my holdings.
> Suddenly I get and "error" return instead of the date.
>
>
modified a variable name in the JavaScript code, which I was using to
position myself on the data for extraction.
On Tue, May 2, 2017 at 6:43 PM, cawley1647@
...wrote:
> I was wondering if Zacks has changed something? The earnings announcements
> has stopped working for me. Maybe it was something that I did, but I don't
> think so as it has stopped on two of my computers.
>
> I use the top line only to get the most recent earnings date.
>
> like this: =RCHGetElementNumbe
> ticker to A1 or A2 etc. where I have the ticker for each of my holdings.
> Suddenly I get and "error" return instead of the date.
>
>
Wed May 3, 2017 12:33 pm (PDT) . Posted by:
e_bartsch
Randy:
Is Element 1290 (earnings announcement date) working, now? I'm still getting an error message. I saw an earlier message and swapped out the definitions, but still getting the Error message. Should I, instead, re-install the entire Add-in? (I have the May 1 version running now).
Thanks.
Eric
Is Element 1290 (earnings announcement date) working, now? I'm still getting an error message. I saw an earlier message and swapped out the definitions, but still getting the Error message. Should I, instead, re-install the entire Add-in? (I have the May 1 version running now).
Thanks.
Eric
Wed May 3, 2017 1:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This is returning " 4/25/2017" for me:
=RCHGetElementNumber("MMM",1290)
After updating the smf-elements-8.txt file, you need to either exit and
restart EXCEL, or run the smfForceRecalculation macro, to load the new
definitions. You can check the definition of the element with:
=RCHGetElementNumber("Definition",1290)
I currently get:
ZacksEA;Quarterly Earnings -- Reported Date --
1;=SUBSTITUTE(smfWord(smfWord(smfStrExtr(RCHGetWebData("
https://www.zacks.com/stock/research/~~~~~/earnings-announcements","document.obj_data
= {"),": ",":"),3,"["),1,","),"""","")
The "document.obj_data" string is the change I made to the definition.
The element definition files are maintained independently of the XLA file,
so they can have updates later than the add-in itself. In fact, if you
update with the current ZIP file, you'd actually get the previous element
definitions. I don't typically update the ZIP file when I update definition
files.
On Wed, May 3, 2017 at 12:33 PM, eabartsch@
...wrote:
> Is Element 1290 (earnings announcement date) working, now? I'm still
> getting an error message. I saw an earlier message and swapped out the
> definitions, but still getting the Error message. Should I, instead,
> re-install the entire Add-in? (I have the May 1 version running now).
>
>
=RCHGetElementNumber("MMM",1290)
After updating the smf-elements-8.txt file, you need to either exit and
restart EXCEL, or run the smfForceRecalculation macro, to load the new
definitions. You can check the definition of the element with:
=RCHGetElementNumber("Definition",1290)
I currently get:
ZacksEA;Quarterly Earnings -- Reported Date --
1;=SUBSTITUTE(smfWord(smfWord(smfStrExtr(RCHGetWebData("
https://www.zacks.com/stock/research/~~~~~/earnings-announcements","
= {"),"
The "document.
The element definition files are maintained independently of the XLA file,
so they can have updates later than the add-in itself. In fact, if you
update with the current ZIP file, you'd actually get the previous element
definitions. I don't typically update the ZIP file when I update definition
files.
On Wed, May 3, 2017 at 12:33 PM, eabartsch@
...wrote:
> Is Element 1290 (earnings announcement date) working, now? I'm still
> getting an error message. I saw an earlier message and swapped out the
> definitions, but still getting the Error message. Should I, instead,
> re-install the entire Add-in? (I have the May 1 version running now).
>
>
Wed May 3, 2017 6:38 pm (PDT) . Posted by:
cawley1647@rogers.com
Randy you are a genius! Changing to "document.obj_data" in the definition file worked a treat. Thank you.
Tue May 2, 2017 7:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check these website pages for updates
to Zacks "Earnings Announcements" element definitions
:
-- http://ogres-crypt.com/SMF/Elements/
Updated files:
-- RCHGetElementNumber-Element-Definitions.xls
-- smf-elements-8.txt
Best practice is to close EXCEL before updating file
s
in the SMF folder.
>
to Zacks "Earnings Announcements" element definitions
:
-- http://ogres-crypt.com/SMF/Elements/
Updated files:
-- RCHGetElementNumber
-- smf-elements-
Best practice is to close EXCEL before updating file
s
in the SMF folder.
>
Wed May 3, 2017 7:01 am (PDT) . Posted by:
"Archie Roa" bleushin19
Hi Randy,
Had it working again, thanks for the links. Making some minor fix on the web addresses to get the values. Thank you so much.
On Wednesday, May 3, 2017 10:22 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Check these website pages for updates to Zacks "Earnings Announcements" element definitions:
-- http://ogres-crypt.com/SMF/Elements/
Updated files:
-- RCHGetElementNumber-Element-Definitions.xls
-- smf-elements-8.txt
Best practice is to close EXCEL before updating files in the SMF folder.
#yiv1682720495 #yiv1682720495 -- #yiv1682720495ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1682720495 #yiv1682720495ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1682720495 #yiv1682720495ygrp-mkp #yiv1682720495hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1682720495 #yiv1682720495ygrp-mkp #yiv1682720495ads {margin-bottom:10px;}#yiv1682720495 #yiv1682720495ygrp-mkp .yiv1682720495ad {padding:0 0;}#yiv1682720495 #yiv1682720495ygrp-mkp .yiv1682720495ad p {margin:0;}#yiv1682720495 #yiv1682720495ygrp-mkp .yiv1682720495ad a {color:#0000ff;text-decoration:none;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ygrp-lc {font-family:Arial;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ygrp-lc #yiv1682720495hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ygrp-lc .yiv1682720495ad {margin-bottom:10px;padding:0 0;}#yiv1682720495 #yiv1682720495actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1682720495 #yiv1682720495activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1682720495 #yiv1682720495activity span {font-weight:700;}#yiv1682720495 #yiv1682720495activity span:first-child {text-transform:uppercase;}#yiv1682720495 #yiv1682720495activity span a {color:#5085b6;text-decoration:none;}#yiv1682720495 #yiv1682720495activity span span {color:#ff7900;}#yiv1682720495 #yiv1682720495activity span .yiv1682720495underline {text-decoration:underline;}#yiv1682720495 .yiv1682720495attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1682720495 .yiv1682720495attach div a {text-decoration:none;}#yiv1682720495 .yiv1682720495attach img {border:none;padding-right:5px;}#yiv1682720495 .yiv1682720495attach label {display:block;margin-bottom:5px;}#yiv1682720495 .yiv1682720495attach label a {text-decoration:none;}#yiv1682720495 blockquote {margin:0 0 0 4px;}#yiv1682720495 .yiv1682720495bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1682720495 .yiv1682720495bold a {text-decoration:none;}#yiv1682720495 dd.yiv1682720495last p a {font-family:Verdana;font-weight:700;}#yiv1682720495 dd.yiv1682720495last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1682720495 dd.yiv1682720495last p span.yiv1682720495yshortcuts {margin-right:0;}#yiv1682720495 div.yiv1682720495attach-table div div a {text-decoration:none;}#yiv1682720495 div.yiv1682720495attach-table {width:400px;}#yiv1682720495 div.yiv1682720495file-title a, #yiv1682720495 div.yiv1682720495file-title a:active, #yiv1682720495 div.yiv1682720495file-title a:hover, #yiv1682720495 div.yiv1682720495file-title a:visited {text-decoration:none;}#yiv1682720495 div.yiv1682720495photo-title a, #yiv1682720495 div.yiv1682720495photo-title a:active, #yiv1682720495 div.yiv1682720495photo-title a:hover, #yiv1682720495 div.yiv1682720495photo-title a:visited {text-decoration:none;}#yiv1682720495 div#yiv1682720495ygrp-mlmsg #yiv1682720495ygrp-msg p a span.yiv1682720495yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1682720495 .yiv1682720495green {color:#628c2a;}#yiv1682720495 .yiv1682720495MsoNormal {margin:0 0 0 0;}#yiv1682720495 o {font-size:0;}#yiv1682720495 #yiv1682720495photos div {float:left;width:72px;}#yiv1682720495 #yiv1682720495photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1682720495 #yiv1682720495photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1682720495 #yiv1682720495reco-category {font-size:77%;}#yiv1682720495 #yiv1682720495reco-desc {font-size:77%;}#yiv1682720495 .yiv1682720495replbq {margin:4px;}#yiv1682720495 #yiv1682720495ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1682720495 #yiv1682720495ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1682720495 #yiv1682720495ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1682720495 #yiv1682720495ygrp-mlmsg select, #yiv1682720495 input, #yiv1682720495 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1682720495 #yiv1682720495ygrp-mlmsg pre, #yiv1682720495 code {font:115% monospace;}#yiv1682720495 #yiv1682720495ygrp-mlmsg * {line-height:1.22em;}#yiv1682720495 #yiv1682720495ygrp-mlmsg #yiv1682720495logo {padding-bottom:10px;}#yiv1682720495 #yiv1682720495ygrp-msg p a {font-family:Verdana;}#yiv1682720495 #yiv1682720495ygrp-msg p#yiv1682720495attach-count span {color:#1E66AE;font-weight:700;}#yiv1682720495 #yiv1682720495ygrp-reco #yiv1682720495reco-head {color:#ff7900;font-weight:700;}#yiv1682720495 #yiv1682720495ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ov li a {font-size:130%;text-decoration:none;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1682720495 #yiv1682720495ygrp-sponsor #yiv1682720495ov ul {margin:0;padding:0 0 0 8px;}#yiv1682720495 #yiv1682720495ygrp-text {font-family:Georgia;}#yiv1682720495 #yiv1682720495ygrp-text p {margin:0 0 1em 0;}#yiv1682720495 #yiv1682720495ygrp-text tt {font-size:120%;}#yiv1682720495 #yiv1682720495ygrp-vital ul li:last-child {border-right:none !important;}#yiv1682720495
Had it working again, thanks for the links. Making some minor fix on the web addresses to get the values. Thank you so much.
On Wednesday, May 3, 2017 10:22 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Check these website pages for updates to Zacks "Earnings Announcements" element definitions:
-- http://ogres-crypt.com/SMF/Elements/
Updated files:
-- RCHGetElementNumber
-- smf-elements-
Best practice is to close EXCEL before updating files in the SMF folder.
#yiv1682720495 #yiv1682720495 -- #yiv1682720495ygrp-
Wed May 3, 2017 3:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sigh. More changes. This time for Gurufocus and the smfGetGuruFocusItem()
function:
*Date* *Routine* *Description*
2017-05-03 smfGetGuruFocusItem Updated all GuruFocus usage of protocol
"http://" to "https://" in the XLA file.
2017-05-02 RCHGetElementNumber Update elements #1286 thr #1400 (Zacks
Earnings History) on smf-elements-8.txt, due to website changes
Changes can be found here:
-- http://ogres-crypt.com/SMF/
-- http://ogres-crypt.com/SMF/Documentation/
Updated files:
-- RCH_Stock_Market_Functions-2.1.2017.05.03.zip
-- Change-Log.html
You'll need to close EXCEL before updating file
s
in the SMF folder.
function:
*Date* *Routine* *Description*
2017-05-03 smfGetGuruFocusItem Updated all GuruFocus usage of protocol
"http://" to "https://" in the XLA file.
2017-05-02 RCHGetElementNumber Update elements #1286 thr #1400 (Zacks
Earnings History) on smf-elements-8.txt, due to website changes
Changes can be found here:
-- http://ogres-crypt.com/SMF/
-- http://ogres-crypt.com/SMF/Documentation/
Updated files:
-- RCH_Stock_Market_
-- Change-Log.html
You'll need to close EXCEL before updating file
s
in the SMF folder.
Wed May 3, 2017 2:04 pm (PDT) . Posted by:
bushpilote
Hi Randy,
I'd appreciate you help in understanding why the following two functions have stopped working
in new version of smf in excel 2007 on windows 10 (ie worked perfectly yesterday on new version of smf in Excel 2007 on Windows Vista):
1) RCHgetwebdata:
=IF($J$3="No"," ",smfConvertData(smfStrExtr(RCHGetWebData("http://www.bloomberg.com/quote/"&$A10,"itemprop=""priceChangePercent""",100),"content=""",""""))/100)
A10 = BCOM:IND
2) =RCHGetTableCell($H$3,1,">"&TEXT(A8008,"mmm dd, yyyy")&"<",1)
H3 = http://www.investing.com/commodities/crude-oil-historical-data http://www.investing.com/commodities/crude-oil-historical-data
A8008 = 26-4-2017 formatted as Apr 26,2017
Thanks.
I'd appreciate you help in understanding why the following two functions have stopped working
in new version of smf in excel 2007 on windows 10 (ie worked perfectly yesterday on new version of smf in Excel 2007 on Windows Vista):
1) RCHgetwebdata:
=IF($J$3="No"," ",smfConvertData(smfStrExtr(RCHGetWebData("http://www.bloomberg.com/quote/"&$A10,"itemprop=""priceChangePercent""",100),"content=""",""""))/100)
A10 = BCOM:IND
2) =RCHGetTableCell($H$3,1,">"&TEXT(A8008,"mmm dd, yyyy")&"<",1)
H3 = http://www.investing.com/commodities/crude-oil-historical-data http://www.investing.com/commodities/crude-oil-historical-data
A8008 = 26-4-2017 formatted as Apr 26,2017
Thanks.
Wed May 3, 2017 2:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All I had to do was change both of your URLs to "https://" instead of
"http://". In both cases, the original URL was redirected to the new URL in
my browser.
On Wed, May 3, 2017 at 2:04 PM, bushpilote@
...wrote:
>
> I'd appreciate you help in understanding why the following two functions
> have stopped working
> in new version of smf in excel 2007 on windows 10 (ie worked perfectly
> yesterday on new version of smf in Excel 2007 on Windows Vista):
>
> 1) RCHgetwebdata:
>
> =IF($J$3="No"," ",smfConvertData(smfStrExtr(RCHGetWebData("http://www.
> bloomberg.com/quote/"&$A10,"itemprop=""priceChangePercent"
> "",100),"content=""",""""))/100)
>
> A10 = BCOM:IND
>
> 2) =RCHGetTableCell($H$3,1,">"&TEXT(A8008,"mmm dd, yyyy")&"<",1)
>
> H3 = http://www.investing.com/commodities/crude-oil-historical-data
> A8008 = 26-4-2017 formatted as Apr 26,2017
>
>
"http://". In both cases, the original URL was redirected to the new URL in
my browser.
On Wed, May 3, 2017 at 2:04 PM, bushpilote@
...wrote:
>
> I'd appreciate you help in understanding why the following two functions
> have stopped working
> in new version of smf in excel 2007 on windows 10 (ie worked perfectly
> yesterday on new version of smf in Excel 2007 on Windows Vista):
>
> 1) RCHgetwebdata:
>
> =IF($J$3="No"," ",smfConvertData(smfStrExtr(RCHGetWebData("http://www.
> bloomberg.com/quote/"&$A10,"itemprop=""priceChangePercent"
> "",100),"content=""",""""))/100)
>
> A10 = BCOM:IND
>
> 2) =RCHGetTableCell($H$3,1,">"&TEXT(A8008,"mmm dd, yyyy")&"<",1)
>
> H3 = http://www.investing.com/commodities/crude-oil-historical-data
> A8008 = 26-4-2017 formatted as Apr 26,2017
>
>
Wed May 3, 2017 2:40 pm (PDT) . Posted by:
marksballard
Would GuruFocus changing from an http site to an https site negatively impact the ability of this function to operate correctly?
I have a premium membership to Gurufocus and always login prior to opening excel. It has always worked perfectly until today when I get a warning box pop up saying that I am being transferred to the https site - I've never seen that until today.
My bookmark in internet explorer is the http site so that is what I have historically opened.
Thanks for any insight from this group.
I have a premium membership to Gurufocus and always login prior to opening excel. It has always worked perfectly until today when I get a warning box pop up saying that I am being transferred to the https site - I've never seen that until today.
My bookmark in internet explorer is the http site so that is what I have historically opened.
Thanks for any insight from this group.
Wed May 3, 2017 3:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. I did indeed have to update some URLs. Just
uploaded a *new* version of the add-in. Maybe we can get through a week
without some website changing something? :(
On Wed, May 3, 2017 at 2:29 PM, marksballard@
...wrote:
>
> Would GuruFocus changing from an http site to an https site negatively
> impact the ability of this function to operate correctly?
>
> I have a premium membership to Gurufocus and always login prior to opening
> excel. It has always worked perfectly until today when I get a warning box
> pop up saying that I am being transferred to the https site - I've never
> seen that until today.
>
> My bookmark in internet explorer is the http site so that is what I have
> historically opened.
>
> Thanks for any insight from this group.
>
uploaded a *new* version of the add-in. Maybe we can get through a week
without some website changing something? :(
On Wed, May 3, 2017 at 2:29 PM, marksballard@
...wrote:
>
> Would GuruFocus changing from an http site to an https site negatively
> impact the ability of this function to operate correctly?
>
> I have a premium membership to Gurufocus and always login prior to opening
> excel. It has always worked perfectly until today when I get a warning box
> pop up saying that I am being transferred to the https site - I've never
> seen that until today.
>
> My bookmark in internet explorer is the http site so that is what I have
> historically opened.
>
> Thanks for any insight from this group.
>
Wed May 3, 2017 3:33 pm (PDT) . Posted by:
hsadvisor1
=RCHGetElementNumber("VFINX",4717) I get un-defined
The only function that works is this one - =RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX http://portfolios.morningstar.com/fund/summary?t=VFINX",1,">Asset Allocation",,,">US Stock|>Stock")
Is there some way that this function can reference a cell containing the ticker symbol rather than have to change the ticker symbol in the formula?
The only function that works is this one - =RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX http://portfolios.morningstar.com/fund/summary?t=VFINX",1,"
Is there some way that this function can reference a cell containing the ticker symbol rather than have to change the ticker symbol in the formula?
Wed May 3, 2017 3:41 pm (PDT) . Posted by:
hsadvisor1
I meant to ask
Is there some way that this function can reference the text in
a cell containing the ticker symbol rather than have to change the ticker symbol in the formula?
Is there some way that this function can reference the text in
a cell containing the ticker symbol rather than have to change the ticker symbol in the formula?
Wed May 3, 2017 4:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
"Undefined" means you didn't put all of the ZIP contents into the add-in
folder. The smf-elements-*.txt files contain the element definitions. They
get loaded when you use an element number the first time. If the files
aren't there, then no definitions exist and all elements are "undefined".
Just use a cell reference in place of the ticker symbol. That's normal
EXCEL processing. Nothing to do with the add-in. In this case, you
concatenate the cell to the rest of the URL, as in:
="http://portfolios.morningstar.com/fund/summary?t="&A1
On Wed, May 3, 2017 at 3:33 PM, hsadvisor1@
...wrote:
> =RCHGetElementNumber("VFINX",4717) *I get un-defined*
>
> The only function that works is this one - =RCHGetTableCell("
> *http://portfolios.morningstar.com/fund/summary?t=VFINX*
> <http://portfolios.morningstar.com/fund/summary?t=VFINX>",1,">Asset
> Allocation",,,">US Stock|>Stock")
>
> Is there some way that this function can reference a cell containing the
> ticker symbol rather than have to change the ticker symbol in the formula?
>
>
folder. The smf-elements-*.txt files contain the element definitions. They
get loaded when you use an element number the first time. If the files
aren't there, then no definitions exist and all elements are "undefined".
Just use a cell reference in place of the ticker symbol. That's normal
EXCEL processing. Nothing to do with the add-in. In this case, you
concatenate the cell to the rest of the URL, as in:
="http://portfolios.morningstar.com/fund/summary?t="&A1
On Wed, May 3, 2017 at 3:33 PM, hsadvisor1@
...wrote:
> =RCHGetElementNumber("VFINX",4717) *I get un-defined*
>
> The only function that works is this one - =RCHGetTableCell("
> *http://portfolios.morningstar.com/fund/summary?t=VFINX*
> <http://portfolios.morningstar.com/fund/summary?t=VFINX>",1,
> Allocation"
>
> Is there some way that this function can reference a cell containing the
> ticker symbol rather than have to change the ticker symbol in the formula?
>
>
Wed May 3, 2017 5:05 pm (PDT) . Posted by:
hsadvisor1
I bow down to your expertise and am in awe of your endless energy as you answer all these questions without hesitation. Thanks Randy. I'll await your Yahoo fix. I still don't know how you do it.
Harry
Harry
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar