Rabu, 20 April 2016

[smf_addin] Digest Number 3680

11 Messages

Digest #3680
1b
1e
2a
New files have been uploaded to the website by "Randy Harmelink" rharmelink
2b
Re: New files have been uploaded to the website by "Kermit W. Prather" kermitpra
2c
2d
Re: New files have been uploaded to the website by "Kermit W. Prather" kermitpra
3b
Re: Unable to get Sales from Zacks by "Randy Harmelink" rharmelink

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


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.
>
>
>
>

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

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

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?
>
>

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.

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.

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.
>
>

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.



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?








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 the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar