11 Messages
Digest #3680
Messages
Tue Apr 19, 2016 10:36 am (PDT) . Posted by:
lscottedgar
Hi,
Looks like the changes at GuruFocus may have changed the GetGuruFocusItem for the Annual Fiscal Period. The Annual Period are offset by 1 year. i.e. the most recent year for MMM shows as Dec14 rather than Dec15. There seems to be a column for "Trend" that may have changed the layout. The rest of the data is in the correct column. Just the Annual Fiscal Period is off.
= smfGetGuruFocusItem("MMM",0,"A",0) should be "Dec15" not Dec14.
Scott
Looks like the changes at GuruFocus may have changed the GetGuruFocusItem for the Annual Fiscal Period. The Annual Period are offset by 1 year. i.e. the most recent year for MMM shows as Dec14 rather than Dec15. There seems to be a column for "Trend" that may have changed the layout. The rest of the data is in the correct column. Just the Annual Fiscal Period is off.
= smfGetGuruFocusItem
Scott
Tue Apr 19, 2016 11:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads-up. I just updated the add-in code and uploaded a new
ZIP archive to the front page of the website.
On Tue, Apr 19, 2016 at 10:36 AM, scottedgar@prodigy.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Looks like the changes at GuruFocus may have changed the GetGuruFocusItem
> for the Annual Fiscal Period. The Annual Period are offset by 1 year. i.e.
> the most recent year for MMM shows as Dec14 rather than Dec15. There seems
> to be a column for "Trend" that may have changed the layout. The rest of
> the data is in the correct column. Just the Annual Fiscal Period is off.
>
> = smfGetGuruFocusItem("MMM",0,"A",0) should be "Dec15" not Dec14.
>
>
>
>
ZIP archive to the front page of the website.
On Tue, Apr 19, 2016 at 10:36 AM, scottedgar@prodigy.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Looks like the changes at GuruFocus may have changed the GetGuruFocusItem
> for the Annual Fiscal Period. The Annual Period are offset by 1 year. i.e.
> the most recent year for MMM shows as Dec14 rather than Dec15. There seems
> to be a column for "Trend" that may have changed the layout. The rest of
> the data is in the correct column. Just the Annual Fiscal Period is off.
>
> = smfGetGuruFocusItem
>
>
>
>
Tue Apr 19, 2016 11:15 am (PDT) . Posted by:
lscottedgar
Randy,
Wonderful. Thank you for the very quick response. All looks good now.
Scott
Wonderful. Thank you for the very quick response. All looks good now.
Scott
Tue Apr 19, 2016 5:40 pm (PDT) . Posted by:
"Bryce Goehring" brigity10
Is it possible to pull Fair value and Margin of Safety from the below page http://www.gurufocus.com/dcf/UNP on the DCF tab and/or Financial strength and Profitability & growth from the summary tab?
ThanksBG
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 19, 2016 1:04 PM
Subject: Re: [smf_addin] smfGetGuruFocusItem Fiscal Period (Annual) off
Thanks for the heads-up. I just updated the add-in code and uploaded a new ZIP archive to the front page of the website.
On Tue, Apr 19, 2016 at 10:36 AM, scottedgar@prodigy.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
Looks like the changes at GuruFocus may have changed theGetGuruFocusItem for the Annual Fiscal Period. The Annual Period are offset by1 year. i.e. the most recent year for MMM shows as Dec14 rather than Dec15. Thereseems to be a column for "Trend" that may have changed the layout. The rest ofthe data is in the correct column. Just the Annual Fiscal Period is off.= smfGetGuruFocusItem("MMM",0,"A",0) shouldbe "Dec15" not Dec14.
#yiv4592234127 #yiv4592234127 -- #yiv4592234127ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4592234127 #yiv4592234127ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4592234127 #yiv4592234127ygrp-mkp #yiv4592234127hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4592234127 #yiv4592234127ygrp-mkp #yiv4592234127ads {margin-bottom:10px;}#yiv4592234127 #yiv4592234127ygrp-mkp .yiv4592234127ad {padding:0 0;}#yiv4592234127 #yiv4592234127ygrp-mkp .yiv4592234127ad p {margin:0;}#yiv4592234127 #yiv4592234127ygrp-mkp .yiv4592234127ad a {color:#0000ff;text-decoration:none;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ygrp-lc {font-family:Arial;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ygrp-lc #yiv4592234127hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ygrp-lc .yiv4592234127ad {margin-bottom:10px;padding:0 0;}#yiv4592234127 #yiv4592234127actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4592234127 #yiv4592234127activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4592234127 #yiv4592234127activity span {font-weight:700;}#yiv4592234127 #yiv4592234127activity span:first-child {text-transform:uppercase;}#yiv4592234127 #yiv4592234127activity span a {color:#5085b6;text-decoration:none;}#yiv4592234127 #yiv4592234127activity span span {color:#ff7900;}#yiv4592234127 #yiv4592234127activity span .yiv4592234127underline {text-decoration:underline;}#yiv4592234127 .yiv4592234127attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4592234127 .yiv4592234127attach div a {text-decoration:none;}#yiv4592234127 .yiv4592234127attach img {border:none;padding-right:5px;}#yiv4592234127 .yiv4592234127attach label {display:block;margin-bottom:5px;}#yiv4592234127 .yiv4592234127attach label a {text-decoration:none;}#yiv4592234127 blockquote {margin:0 0 0 4px;}#yiv4592234127 .yiv4592234127bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4592234127 .yiv4592234127bold a {text-decoration:none;}#yiv4592234127 dd.yiv4592234127last p a {font-family:Verdana;font-weight:700;}#yiv4592234127 dd.yiv4592234127last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4592234127 dd.yiv4592234127last p span.yiv4592234127yshortcuts {margin-right:0;}#yiv4592234127 div.yiv4592234127attach-table div div a {text-decoration:none;}#yiv4592234127 div.yiv4592234127attach-table {width:400px;}#yiv4592234127 div.yiv4592234127file-title a, #yiv4592234127 div.yiv4592234127file-title a:active, #yiv4592234127 div.yiv4592234127file-title a:hover, #yiv4592234127 div.yiv4592234127file-title a:visited {text-decoration:none;}#yiv4592234127 div.yiv4592234127photo-title a, #yiv4592234127 div.yiv4592234127photo-title a:active, #yiv4592234127 div.yiv4592234127photo-title a:hover, #yiv4592234127 div.yiv4592234127photo-title a:visited {text-decoration:none;}#yiv4592234127 div#yiv4592234127ygrp-mlmsg #yiv4592234127ygrp-msg p a span.yiv4592234127yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4592234127 .yiv4592234127green {color:#628c2a;}#yiv4592234127 .yiv4592234127MsoNormal {margin:0 0 0 0;}#yiv4592234127 o {font-size:0;}#yiv4592234127 #yiv4592234127photos div {float:left;width:72px;}#yiv4592234127 #yiv4592234127photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4592234127 #yiv4592234127photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4592234127 #yiv4592234127reco-category {font-size:77%;}#yiv4592234127 #yiv4592234127reco-desc {font-size:77%;}#yiv4592234127 .yiv4592234127replbq {margin:4px;}#yiv4592234127 #yiv4592234127ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4592234127 #yiv4592234127ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4592234127 #yiv4592234127ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4592234127 #yiv4592234127ygrp-mlmsg select, #yiv4592234127 input, #yiv4592234127 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4592234127 #yiv4592234127ygrp-mlmsg pre, #yiv4592234127 code {font:115% monospace;}#yiv4592234127 #yiv4592234127ygrp-mlmsg * {line-height:1.22em;}#yiv4592234127 #yiv4592234127ygrp-mlmsg #yiv4592234127logo {padding-bottom:10px;}#yiv4592234127 #yiv4592234127ygrp-msg p a {font-family:Verdana;}#yiv4592234127 #yiv4592234127ygrp-msg p#yiv4592234127attach-count span {color:#1E66AE;font-weight:700;}#yiv4592234127 #yiv4592234127ygrp-reco #yiv4592234127reco-head {color:#ff7900;font-weight:700;}#yiv4592234127 #yiv4592234127ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ov li a {font-size:130%;text-decoration:none;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4592234127 #yiv4592234127ygrp-sponsor #yiv4592234127ov ul {margin:0;padding:0 0 0 8px;}#yiv4592234127 #yiv4592234127ygrp-text {font-family:Georgia;}#yiv4592234127 #yiv4592234127ygrp-text p {margin:0 0 1em 0;}#yiv4592234127 #yiv4592234127ygrp-text tt {font-size:120%;}#yiv4592234127 #yiv4592234127ygrp-vital ul li:last-child {border-right:none !important;}#yiv4592234127
ThanksBG
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 19, 2016 1:04 PM
Subject: Re: [smf_addin] smfGetGuruFocusItem Fiscal Period (Annual) off
Thanks for the heads-up. I just updated the add-in code and uploaded a new ZIP archive to the front page of the website.
On Tue, Apr 19, 2016 at 10:36 AM, scottedgar@prodigy.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
Looks like the changes at GuruFocus may have changed theGetGuruFocusItem for the Annual Fiscal Period. The Annual Period are offset by1 year. i.e. the most recent year for MMM shows as Dec14 rather than Dec15. Thereseems to be a column for "Trend" that may have changed the layout. The rest ofthe data is in the correct column. Just the Annual Fiscal Period is off.= smfGetGuruFocusItem
#yiv4592234127 #yiv4592234127 -- #yiv4592234127ygrp-
Tue Apr 19, 2016 7:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just compute the DCF page's Fair Value and Margin of Safety yourself. See
this thread, which even has an attachment that does the calculations:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/27867
For the other two items:
=smfGetTagContent("http://www.gurufocus.com/stock/UNP","a",1,">Financial
Strength",,,,1)
=smfGetTagContent("http://www.gurufocus.com/stock/UNP","a",1,">Profitability
& Growth",,,,1)
On Tue, Apr 19, 2016 at 5:40 PM, Bryce Goehring brigity10@
...wrote:
>
> Is it possible to pull Fair value and Margin of Safety from the below page
> http://www.gurufocus.com/dcf/UNP on the DCF tab and/or Financial strength
> and Profitability & growth from the summary tab?
>
>
this thread, which even has an attachment that does the calculations:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/27867
For the other two items:
=smfGetTagContent("http://www.gurufocus.com/stock/UNP","a",1,">Financial
Strength",,,,1)
=smfGetTagContent("http://www.gurufocus.com/stock/UNP","a",1,">Profitability
& Growth",,,,1)
On Tue, Apr 19, 2016 at 5:40 PM, Bryce Goehring brigity10@
...wrote:
>
> Is it possible to pull Fair value and Margin of Safety from the below page
> http://www.gurufocus.com/dcf/UNP on the DCF tab and/or Financial strength
> and Profitability & growth from the summary tab?
>
>
Tue Apr 19, 2016 11:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
A new ZIP archives has been uploaded to the website:
RCH_Stock_Market_Functions-2.1.2016.04.19.zip
<http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes
they've made to their web page.
RCH_Stock_Market_Functions-2.1.2016.04.19.zip
<http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes
they've made to their web page.
Tue Apr 19, 2016 12:59 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, when I attempted to open the zip file I got this message.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 2:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New files have been uploaded to the website
A new ZIP archives has been uploaded to the website:
RCH_Stock_Market_Functions-2.1.2016.04.19.zip <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes they've made to their web page.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 2:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New files have been uploaded to the website
A new ZIP archives has been uploaded to the website:
RCH_Stock_Market_Functions-2.1.2016.04.19.zip <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes they've made to their web page.
Tue Apr 19, 2016 1:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It opens fine from the website, or the link in the message below, for me...
Perhaps it got corrupted during the download?
On Tue, Apr 19, 2016 at 12:59 PM, 'Kermit W. Prather' kermitp@...wrote:
>
> Randy, when I attempted to open the zip file I got this message.
>
>
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Tuesday, April 19, 2016 2:10 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] New files have been uploaded to the website
>
>
>
>
>
>
> A new ZIP archives has been uploaded to the website:
>
> RCH_Stock_Market_Functions-2.1.2016.04.19.zip
> <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
>
> This fixes the annual period extraction from GufuFocus, because of changes
> they've made to their web page.
>
>
Perhaps it got corrupted during the download?
On Tue, Apr 19, 2016 at 12:59 PM, 'Kermit W. Prather' kermitp@...wrote:
>
> Randy, when I attempted to open the zip file I got this message.
>
>
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Tuesday, April 19, 2016 2:10 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] New files have been uploaded to the website
>
>
>
>
>
>
> A new ZIP archives has been uploaded to the website:
>
> RCH_Stock_Market_Functions-2.1.2016.04.19.zip
> <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
>
> This fixes the annual period extraction from GufuFocus, because of changes
> they've made to their web page.
>
>
Tue Apr 19, 2016 1:25 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Yep, my bad.
Works now, been so long since I updated I had to re-educate myself on the process.
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 4:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] New files have been uploaded to the website
It opens fine from the website, or the link in the message below, for me...
Perhaps it got corrupted during the download?
On Tue, Apr 19, 2016 at 12:59 PM, 'Kermit W. Prather' kermitp@...wrote:
Randy, when I attempted to open the zip file I got this message.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 2:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New files have been uploaded to the website
A new ZIP archives has been uploaded to the website:
RCH_Stock_Market_Functions-2.1.2016.04.19.zip <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes they've made to their web page.
Works now, been so long since I updated I had to re-educate myself on the process.
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 4:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] New files have been uploaded to the website
It opens fine from the website, or the link in the message below, for me...
Perhaps it got corrupted during the download?
On Tue, Apr 19, 2016 at 12:59 PM, 'Kermit W. Prather' kermitp@...wrote:
Randy, when I attempted to open the zip file I got this message.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 19, 2016 2:10 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New files have been uploaded to the website
A new ZIP archives has been uploaded to the website:
RCH_Stock_Market_Functions-2.1.2016.04.19.zip <http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip>
This fixes the annual period extraction from GufuFocus, because of changes they've made to their web page.
Tue Apr 19, 2016 5:47 pm (PDT) . Posted by:
tzewei_79
HI Randy,
Wow that fixed it thanks. Could you also recommend a book for me to read up on this coding manipulation?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
This is an example of why I say ordinary words are not good search terms. They can pop up before the table in a different context. Here's what a search on "Sales" is finding:
...provides a comprehensive overview of the company business drivers, complete with earnings and sales charts;...
So not the "Sales" you want from the table. In most cases, depending on how the web page is coded, a simple ">" prefix in front of the search term can fix the problem -- the ">" is the end of the HTML tag before the word "Sales", so that the simple term in a sentence would not satisfy the search.
This works fine for me:
=RCHGetTableCell("http://www.zacks.com/stock/quote/ http://www.zacks.com/stock/quote/"&A44&"/income-statement",1,">Sales")
On Mon, Apr 18, 2016 at 10:47 PM, tzewei_79@... wrote:
I was using this code for years and suddenly it becomes a string of "Value".
=RCHGetTableCell("http://www.zacks.com/stock/quote/ http://www.zacks.com/stock/quote/"&A44&"/income-statement",1,"Sales";)
I went to Zacks to check the table and it seems to be unchange. Anyone encounter this and has a solution?
Wow that fixed it thanks. Could you also recommend a book for me to read up on this coding manipulation?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
This is an example of why I say ordinary words are not good search terms. They can pop up before the table in a different context. Here's what a search on "Sales" is finding:
...provides a comprehensive overview of the company business drivers, complete with earnings and sales charts;...
So not the "Sales" you want from the table. In most cases, depending on how the web page is coded, a simple ">" prefix in front of the search term can fix the problem -- the ">" is the end of the HTML tag before the word "Sales", so that the simple term in a sentence would not satisfy the search.
This works fine for me:
=RCHGetTableCell("http://www.zacks.com/stock/quote/ http://www.zacks.com/stock/quote/"&A44&"/income-statement",1,">Sales")
On Mon, Apr 18, 2016 at 10:47 PM, tzewei_79@... wrote:
I was using this code for years and suddenly it becomes a string of "Value".
=RCHGetTableCell("http://www.zacks.com/stock/quote/ http://www.zacks.com/stock/quote/"&A44&"
I went to Zacks to check the table and it seems to be unchange. Anyone encounter this and has a solution?
Tue Apr 19, 2016 7:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry. No books.
For me, it's usually a 3-step process:
1. View the source code of the web page
2. Find the data I'm interested
3. Look for unique ways to identify getting to that data, usually in the
code just preceding it
The SMF-Quick-Webpage-Examination.xls template can also be very handy in
searching for items or patterns.
On Tue, Apr 19, 2016 at 5:47 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Wow that fixed it thanks. Could you also recommend a book for me to read
> up on this coding manipulation?
>
>
For me, it's usually a 3-step process:
1. View the source code of the web page
2. Find the data I'm interested
3. Look for unique ways to identify getting to that data, usually in the
code just preceding it
The SMF-Quick-Webpage-Examination.xls template can also be very handy in
searching for items or patterns.
On Tue, Apr 19, 2016 at 5:47 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Wow that fixed it thanks. Could you also recommend a book for me to read
> up on this coding manipulation?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar