Kamis, 07 Agustus 2014

[smf_addin] Digest Number 3143[2 Attachments]

15 Messages

Digest #3143
1a
problem with Calculated - Piotroski by "Folonari Darilo" folonari05
1d
Re: problem with Calculated - Piotroski by "Folonari Darilo" folonari05
1e
Re: problem with Calculated - Piotroski by "Randy Harmelink" rharmelink
1f
Re: problem with Calculated - Piotroski by "Folonari Darilo" folonari05
1h
Re: problem with Calculated - Piotroski by "Randy Harmelink" rharmelink
2b
Re: Newbie trying to get from ADVFN by "Randy Harmelink" rharmelink
2g

Messages

Thu Aug 7, 2014 4:28 am (PDT) . Posted by:

"Folonari Darilo" folonari05

hi
I've some problem with this data. See attachement. Grazie
Attachment(s) from Folonari Darilo
1 of 1 File(s)

Thu Aug 7, 2014 4:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Without ticker symbols, I can't investigate anything. Try it on ticker
symbol MMM.

All I need is specific formulas that you are using.

On Thu, Aug 7, 2014 at 4:27 AM, Folonari Darilo folonari05@... wrote:

>
> I've some problem with this data. See attachement. Grazie
>

Thu Aug 7, 2014 6:12 am (PDT) . Posted by:

Hi Randy,
Just as an information: I've had trouble with Piotroski data
element with all symbols I've tried. I did not go further with
it for sheer lack of time.
Best regards,
Armando

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 7, 2014 8:59 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] problem with Calculated - Piotroski



Without ticker symbols, I can't investigate anything. Try it on
ticker symbol MMM.

All I need is specific formulas that you are using.

On Thu, Aug 7, 2014 at 4:27 AM, Folonari Darilo folonari05@...
wrote:

I've some problem with this data. See attachement. Grazie






Thu Aug 7, 2014 6:19 am (PDT) . Posted by:

"Folonari Darilo" folonari05


--------------------------------------------
Gio 7/8/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> ha scritto:

Oggetto: Re: [smf_addin] problem with Calculated - Piotroski
A: smf_addin@yahoogroups.com
Data: Giovedì 7 agosto 2014, 13:59


 

When i use RCHGetElementNumber(mmm;15001) or 15003 or 15007 the formula returns me value 1 , for all symbol i use.(?)
In all other cases as RCHGetElementNumber(mmm;15002) or RCHGetElementNumber(mmm;15004) or 15005 or 15006 the formula retuns "error".

I've also some problem (we discuss it in another post) with mornigstarT with function RCHGetElementNumber from 885 to 891 except with data 885. is it Normal? I have not a premium registration but i don't understand why function 885 returns the exact value and the others not work.
Grazie e sorry for my english.







Without ticker symbols, I
can't investigate anything. Try it on ticker symbol
MMM.

All I need is
specific formulas that you are using.


On Thu, Aug 7, 2014 at 4:27 AM, Folonari Darilo
folonari05@... wrote:




I've some problem with this data. See attachement.
Grazie












#yiv1439946714 #yiv1439946714 --
#yiv1439946714ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv1439946714 #yiv1439946714ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1439946714 #yiv1439946714ygrp-mkp #yiv1439946714hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1439946714 #yiv1439946714ygrp-mkp #yiv1439946714ads {
margin-bottom:10px;}

#yiv1439946714 #yiv1439946714ygrp-mkp .yiv1439946714ad {
padding:0 0;}

#yiv1439946714 #yiv1439946714ygrp-mkp .yiv1439946714ad p {
margin:0;}

#yiv1439946714 #yiv1439946714ygrp-mkp .yiv1439946714ad a {
color:#0000ff;text-decoration:none;}
#yiv1439946714 #yiv1439946714ygrp-sponsor
#yiv1439946714ygrp-lc {
font-family:Arial;}

#yiv1439946714 #yiv1439946714ygrp-sponsor
#yiv1439946714ygrp-lc #yiv1439946714hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1439946714 #yiv1439946714ygrp-sponsor
#yiv1439946714ygrp-lc .yiv1439946714ad {
margin-bottom:10px;padding:0 0;}

#yiv1439946714 #yiv1439946714actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv1439946714 #yiv1439946714activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv1439946714 #yiv1439946714activity span {
font-weight:700;}

#yiv1439946714 #yiv1439946714activity span:first-child {
text-transform:uppercase;}

#yiv1439946714 #yiv1439946714activity span a {
color:#5085b6;text-decoration:none;}

#yiv1439946714 #yiv1439946714activity span span {
color:#ff7900;}

#yiv1439946714 #yiv1439946714activity span
.yiv1439946714underline {
text-decoration:underline;}

#yiv1439946714 .yiv1439946714attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv1439946714 .yiv1439946714attach div a {
text-decoration:none;}

#yiv1439946714 .yiv1439946714attach img {
border:none;padding-right:5px;}

#yiv1439946714 .yiv1439946714attach label {
display:block;margin-bottom:5px;}

#yiv1439946714 .yiv1439946714attach label a {
text-decoration:none;}

#yiv1439946714 blockquote {
margin:0 0 0 4px;}

#yiv1439946714 .yiv1439946714bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1439946714 .yiv1439946714bold a {
text-decoration:none;}

#yiv1439946714 dd.yiv1439946714last p a {
font-family:Verdana;font-weight:700;}

#yiv1439946714 dd.yiv1439946714last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv1439946714 dd.yiv1439946714last p
span.yiv1439946714yshortcuts {
margin-right:0;}

#yiv1439946714 div.yiv1439946714attach-table div div a {
text-decoration:none;}

#yiv1439946714 div.yiv1439946714attach-table {
width:400px;}

#yiv1439946714 div.yiv1439946714file-title a, #yiv1439946714
div.yiv1439946714file-title a:active, #yiv1439946714
div.yiv1439946714file-title a:hover, #yiv1439946714
div.yiv1439946714file-title a:visited {
text-decoration:none;}

#yiv1439946714 div.yiv1439946714photo-title a,
#yiv1439946714 div.yiv1439946714photo-title a:active,
#yiv1439946714 div.yiv1439946714photo-title a:hover,
#yiv1439946714 div.yiv1439946714photo-title a:visited {
text-decoration:none;}

#yiv1439946714 div#yiv1439946714ygrp-mlmsg
#yiv1439946714ygrp-msg p a span.yiv1439946714yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1439946714 .yiv1439946714green {
color:#628c2a;}

#yiv1439946714 .yiv1439946714MsoNormal {
margin:0 0 0 0;}

#yiv1439946714 o {
font-size:0;}

#yiv1439946714 #yiv1439946714photos div {
float:left;width:72px;}

#yiv1439946714 #yiv1439946714photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv1439946714 #yiv1439946714photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv1439946714 #yiv1439946714reco-category {
font-size:77%;}

#yiv1439946714 #yiv1439946714reco-desc {
font-size:77%;}

#yiv1439946714 .yiv1439946714replbq {
margin:4px;}

#yiv1439946714 #yiv1439946714ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg select,
#yiv1439946714 input, #yiv1439946714 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg pre, #yiv1439946714
code {
font:115% monospace;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg * {
line-height:1.22em;}

#yiv1439946714 #yiv1439946714ygrp-mlmsg #yiv1439946714logo {
padding-bottom:10px;}


#yiv1439946714 #yiv1439946714ygrp-msg p a {
font-family:Verdana;}

#yiv1439946714 #yiv1439946714ygrp-msg
p#yiv1439946714attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1439946714 #yiv1439946714ygrp-reco
#yiv1439946714reco-head {
color:#ff7900;font-weight:700;}

#yiv1439946714 #yiv1439946714ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1439946714 #yiv1439946714ygrp-sponsor #yiv1439946714ov
li a {
font-size:130%;text-decoration:none;}

#yiv1439946714 #yiv1439946714ygrp-sponsor #yiv1439946714ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1439946714 #yiv1439946714ygrp-sponsor #yiv1439946714ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1439946714 #yiv1439946714ygrp-text {
font-family:Georgia;}

#yiv1439946714 #yiv1439946714ygrp-text p {
margin:0 0 1em 0;}

#yiv1439946714 #yiv1439946714ygrp-text tt {
font-size:120%;}

#yiv1439946714 #yiv1439946714ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1439946714


Thu Aug 7, 2014 6:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried elements #15001 thru #15014 with ticker symbol MMM and they
work fine for me.

Didn't you have troubles accessing AdvFN data? Most of the Piotroski items
are calculated using elements from AdvFN. For example, these three items
are needed to calculate the 2nd Piotroski factor:

=RCHGetElementNumber("MMM",11326)
=RCHGetElementNumber("MMM",11330)
=RCHGetElementNumber("MMM",6856)

What do you get for them? There are two possible things you need to do to
access AdvFN data. See the "Tips and FAQs" web page for more information.

Element #885 from MorningStar is not a proprietary item, so it doesn't
require the IE security cookie.

On Thu, Aug 7, 2014 at 6:12 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Just as an information: I've had trouble with Piotroski data element with
> all symbols I've tried. I did not go further with it for sheer lack of
> time.
>
>
On Thu, Aug 7, 2014 at 6:19 AM, Folonari Darilo folonari05@... wrote:

>
> When i use RCHGetElementNumber(mmm;15001) or 15003 or 15007 the formula
> returns me value 1 , for all symbol i use.(?)
> In all other cases as RCHGetElementNumber(mmm;15002) or
> RCHGetElementNumber(mmm;15004) or 15005 or 15006 the formula retuns "error".
>
> I've also some problem (we discuss it in another post) with mornigstarT
> with function RCHGetElementNumber from 885 to 891 except with data 885. is
> it Normal? I have not a premium registration but i don't understand why
> function 885 returns the exact value and the others not work.
>
>
>

Thu Aug 7, 2014 6:42 am (PDT) . Posted by:

"Folonari Darilo" folonari05


--------------------------------------------
Gio 7/8/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> ha scritto:

Oggetto: Re: [smf_addin] problem with Calculated - Piotroski
A: smf_addin@yahoogroups.com
Data: Giovedì 7 agosto 2014, 15:29


 
Didn't you have troubles accessing
AdvFN data?
YES because i'm from Italy and AdvFN not works well. You told me this a few days ago. is not it?








I just tried
elements #15001 thru #15014 with ticker symbol MMM and they
work fine for me.

Didn't you have troubles accessing
AdvFN data? Most of the Piotroski items are calculated using
elements from AdvFN. For example, these three items are
needed to calculate the 2nd Piotroski factor:


=RCHGetElementNumber("MMM",11326)
=RCHGetElementNumber("MMM",11330)
=RCHGetElementNumber("MMM",6856)

What do you get
for them? There are two possible things you need to do to
access AdvFN data. See the "Tips and FAQs" web
page for more information.


Element #885 from MorningStar is not
a proprietary item, so it doesn't require the IE
security cookie.

On Thu, Aug 7, 2014 at 6:12
AM, armando@pipeline.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:















Just
as an information: I've had trouble with Piotroski data
element with
all symbols I've tried.  I did not go further with it
for sheer lack of
time.

On Thu, Aug 7, 2014 at 6:19
AM, Folonari Darilo folonari05@... wrote:



When i use RCHGetElementNumber(mmm;15001) or 15003 or 15007
the formula returns me value 1 , for all symbol i use.(?)

In all other cases as RCHGetElementNumber(mmm;15002) or
RCHGetElementNumber(mmm;15004) or 15005 or 15006 the formula
retuns "error".



I've also some problem (we discuss it in another post)
with mornigstarT with function RCHGetElementNumber  from
885 to 891 except with data 885. is it Normal? I have not a
premium registration but i don't understand why function
885 returns the exact value and the others not work.


















#yiv2290327026 #yiv2290327026 --
#yiv2290327026ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv2290327026 #yiv2290327026ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2290327026 #yiv2290327026ygrp-mkp #yiv2290327026hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv2290327026 #yiv2290327026ygrp-mkp #yiv2290327026ads {
margin-bottom:10px;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad {
padding:0 0;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad p {
margin:0;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad a {
color:#0000ff;text-decoration:none;}
#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc {
font-family:Arial;}

#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc #yiv2290327026hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc .yiv2290327026ad {
margin-bottom:10px;padding:0 0;}

#yiv2290327026 #yiv2290327026actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv2290327026 #yiv2290327026activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv2290327026 #yiv2290327026activity span {
font-weight:700;}

#yiv2290327026 #yiv2290327026activity span:first-child {
text-transform:uppercase;}

#yiv2290327026 #yiv2290327026activity span a {
color:#5085b6;text-decoration:none;}

#yiv2290327026 #yiv2290327026activity span span {
color:#ff7900;}

#yiv2290327026 #yiv2290327026activity span
.yiv2290327026underline {
text-decoration:underline;}

#yiv2290327026 .yiv2290327026attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv2290327026 .yiv2290327026attach div a {
text-decoration:none;}

#yiv2290327026 .yiv2290327026attach img {
border:none;padding-right:5px;}

#yiv2290327026 .yiv2290327026attach label {
display:block;margin-bottom:5px;}

#yiv2290327026 .yiv2290327026attach label a {
text-decoration:none;}

#yiv2290327026 blockquote {
margin:0 0 0 4px;}

#yiv2290327026 .yiv2290327026bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2290327026 .yiv2290327026bold a {
text-decoration:none;}

#yiv2290327026 dd.yiv2290327026last p a {
font-family:Verdana;font-weight:700;}

#yiv2290327026 dd.yiv2290327026last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv2290327026 dd.yiv2290327026last p
span.yiv2290327026yshortcuts {
margin-right:0;}

#yiv2290327026 div.yiv2290327026attach-table div div a {
text-decoration:none;}

#yiv2290327026 div.yiv2290327026attach-table {
width:400px;}

#yiv2290327026 div.yiv2290327026file-title a, #yiv2290327026
div.yiv2290327026file-title a:active, #yiv2290327026
div.yiv2290327026file-title a:hover, #yiv2290327026
div.yiv2290327026file-title a:visited {
text-decoration:none;}

#yiv2290327026 div.yiv2290327026photo-title a,
#yiv2290327026 div.yiv2290327026photo-title a:active,
#yiv2290327026 div.yiv2290327026photo-title a:hover,
#yiv2290327026 div.yiv2290327026photo-title a:visited {
text-decoration:none;}

#yiv2290327026 div#yiv2290327026ygrp-mlmsg
#yiv2290327026ygrp-msg p a span.yiv2290327026yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2290327026 .yiv2290327026green {
color:#628c2a;}

#yiv2290327026 .yiv2290327026MsoNormal {
margin:0 0 0 0;}

#yiv2290327026 o {
font-size:0;}

#yiv2290327026 #yiv2290327026photos div {
float:left;width:72px;}

#yiv2290327026 #yiv2290327026photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv2290327026 #yiv2290327026photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv2290327026 #yiv2290327026reco-category {
font-size:77%;}

#yiv2290327026 #yiv2290327026reco-desc {
font-size:77%;}

#yiv2290327026 .yiv2290327026replbq {
margin:4px;}

#yiv2290327026 #yiv2290327026ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg select,
#yiv2290327026 input, #yiv2290327026 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg pre, #yiv2290327026
code {
font:115% monospace;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg * {
line-height:1.22em;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg #yiv2290327026logo {
padding-bottom:10px;}


#yiv2290327026 #yiv2290327026ygrp-msg p a {
font-family:Verdana;}

#yiv2290327026 #yiv2290327026ygrp-msg
p#yiv2290327026attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2290327026 #yiv2290327026ygrp-reco
#yiv2290327026reco-head {
color:#ff7900;font-weight:700;}

#yiv2290327026 #yiv2290327026ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
li a {
font-size:130%;text-decoration:none;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2290327026 #yiv2290327026ygrp-text {
font-family:Georgia;}

#yiv2290327026 #yiv2290327026ygrp-text p {
margin:0 0 1em 0;}

#yiv2290327026 #yiv2290327026ygrp-text tt {
font-size:120%;}

#yiv2290327026 #yiv2290327026ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2290327026


Thu Aug 7, 2014 7:04 am (PDT) . Posted by:

As I mentioned, I was not successful using Piotrosky data element
either. My initial interpretation of the problem was this:
(1) The calculated Piotrosky number depends on 9 other data
elements.(2) If any one of those elements are missing for any
reason, then the resulting calculation would give an "Error" on
the cell.
I've not not verify whether that theory is correct. Perhaps
Randy can attest to it.
That was my guess when I first tried it. Perhaps for blue chip
tickers like MMM all data elements are there.


-----Original Message-----
From: "Folonari Darilo folonari05@yahoo.it [smf_addin]"
Sent: Aug 7, 2014 10:42 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] problem with Calculated - Piotroski



--------------------------------------------
Gio 7/8/14, Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> ha scritto:

Oggetto: Re: [smf_addin] problem with Calculated - Piotroski
A: smf_addin@yahoogroups.com
Data: Giovedì 7 agosto 2014, 15:29



Didn't you have troubles accessing
AdvFN data?
YES because i'm from Italy and AdvFN not works well. You told me
this a few days ago. is not it?








I just tried
elements #15001 thru #15014 with ticker symbol MMM and they
work fine for me.

Didn't you have troubles accessing
AdvFN data? Most of the Piotroski items are calculated using
elements from AdvFN. For example, these three items are
needed to calculate the 2nd Piotroski factor:


=RCHGetElementNumber("MMM",11326)
=RCHGetElementNumber("MMM",11330)
=RCHGetElementNumber("MMM",6856)

What do you get
for them? There are two possible things you need to do to
access AdvFN data. See the "Tips and FAQs" web
page for more information.


Element #885 from MorningStar is not
a proprietary item, so it doesn't require the IE
security cookie.

On Thu, Aug 7, 2014 at 6:12
AM, armando@pipeline.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:















Just
as an information: I've had trouble with Piotroski data
element with
all symbols I've tried. I did not go further with it
for sheer lack of
time.

On Thu, Aug 7, 2014 at 6:19
AM, Folonari Darilo folonari05@... wrote:



When i use RCHGetElementNumber(mmm;15001) or 15003 or 15007
the formula returns me value 1 , for all symbol i use.(?)

In all other cases as RCHGetElementNumber(mmm;15002) or
RCHGetElementNumber(mmm;15004) or 15005 or 15006 the formula
retuns "error".



I've also some problem (we discuss it in another post)
with mornigstarT with function RCHGetElementNumber from
885 to 891 except with data 885. is it Normal? I have not a
premium registration but i don't understand why function
885 returns the exact value and the others not work.


















#yiv2290327026 #yiv2290327026 --
#yiv2290327026ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv2290327026 #yiv2290327026ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2290327026 #yiv2290327026ygrp-mkp #yiv2290327026hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;marg&#92;
in:10px
0;}

#yiv2290327026 #yiv2290327026ygrp-mkp #yiv2290327026ads {
margin-bottom:10px;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad {
padding:0 0;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad p {
margin:0;}

#yiv2290327026 #yiv2290327026ygrp-mkp .yiv2290327026ad a {
color:#0000ff;text-decoration:none;}
#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc {
font-family:Arial;}

#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc #yiv2290327026hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2290327026 #yiv2290327026ygrp-sponsor
#yiv2290327026ygrp-lc .yiv2290327026ad {
margin-bottom:10px;padding:0 0;}

#yiv2290327026 #yiv2290327026actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv2290327026 #yiv2290327026activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size&#92;
:10px;padding:10px;}

#yiv2290327026 #yiv2290327026activity span {
font-weight:700;}

#yiv2290327026 #yiv2290327026activity span:first-child {
text-transform:uppercase;}

#yiv2290327026 #yiv2290327026activity span a {
color:#5085b6;text-decoration:none;}

#yiv2290327026 #yiv2290327026activity span span {
color:#ff7900;}

#yiv2290327026 #yiv2290327026activity span
.yiv2290327026underline {
text-decoration:underline;}

#yiv2290327026 .yiv2290327026attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding&#92;
:10px
0;width:400px;}

#yiv2290327026 .yiv2290327026attach div a {
text-decoration:none;}

#yiv2290327026 .yiv2290327026attach img {
border:none;padding-right:5px;}

#yiv2290327026 .yiv2290327026attach label {
display:block;margin-bottom:5px;}

#yiv2290327026 .yiv2290327026attach label a {
text-decoration:none;}

#yiv2290327026 blockquote {
margin:0 0 0 4px;}

#yiv2290327026 .yiv2290327026bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2290327026 .yiv2290327026bold a {
text-decoration:none;}

#yiv2290327026 dd.yiv2290327026last p a {
font-family:Verdana;font-weight:700;}

#yiv2290327026 dd.yiv2290327026last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv2290327026 dd.yiv2290327026last p
span.yiv2290327026yshortcuts {
margin-right:0;}

#yiv2290327026 div.yiv2290327026attach-table div div a {
text-decoration:none;}

#yiv2290327026 div.yiv2290327026attach-table {
width:400px;}

#yiv2290327026 div.yiv2290327026file-title a, #yiv2290327026
div.yiv2290327026file-title a:active, #yiv2290327026
div.yiv2290327026file-title a:hover, #yiv2290327026
div.yiv2290327026file-title a:visited {
text-decoration:none;}

#yiv2290327026 div.yiv2290327026photo-title a,
#yiv2290327026 div.yiv2290327026photo-title a:active,
#yiv2290327026 div.yiv2290327026photo-title a:hover,
#yiv2290327026 div.yiv2290327026photo-title a:visited {
text-decoration:none;}

#yiv2290327026 div#yiv2290327026ygrp-mlmsg
#yiv2290327026ygrp-msg p a span.yiv2290327026yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2290327026 .yiv2290327026green {
color:#628c2a;}

#yiv2290327026 .yiv2290327026MsoNormal {
margin:0 0 0 0;}

#yiv2290327026 o {
font-size:0;}

#yiv2290327026 #yiv2290327026photos div {
float:left;width:72px;}

#yiv2290327026 #yiv2290327026photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv2290327026 #yiv2290327026photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;wh\
ite-space:nowrap;width:64px;}

#yiv2290327026 #yiv2290327026reco-category {
font-size:77%;}

#yiv2290327026 #yiv2290327026reco-desc {
font-size:77%;}

#yiv2290327026 .yiv2290327026replbq {
margin:4px;}

#yiv2290327026 #yiv2290327026ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg select,
#yiv2290327026 input, #yiv2290327026 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg pre, #yiv2290327026
code {
font:115% monospace;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg * {
line-height:1.22em;}

#yiv2290327026 #yiv2290327026ygrp-mlmsg #yiv2290327026logo {
padding-bottom:10px;}


#yiv2290327026 #yiv2290327026ygrp-msg p a {
font-family:Verdana;}

#yiv2290327026 #yiv2290327026ygrp-msg
p#yiv2290327026attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2290327026 #yiv2290327026ygrp-reco
#yiv2290327026reco-head {
color:#ff7900;font-weight:700;}

#yiv2290327026 #yiv2290327026ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
li a {
font-size:130%;text-decoration:none;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2290327026 #yiv2290327026ygrp-sponsor #yiv2290327026ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2290327026 #yiv2290327026ygrp-text {
font-family:Georgia;}

#yiv2290327026 #yiv2290327026ygrp-text p {
margin:0 0 1em 0;}

#yiv2290327026 #yiv2290327026ygrp-text tt {
font-size:120%;}

#yiv2290327026 #yiv2290327026ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2290327026





Thu Aug 7, 2014 8:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Actually, there are probably 50 to 60 data elements used. And most are
AdvFN items. So if Italy has problems with AdvFN items, Piotroski won't be
available either.

It appears the Italy issue is that they don't follow the URL format used by
other countries.

On Thu, Aug 7, 2014 at 7:04 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> As I mentioned, I was not successful using Piotrosky data element either.
> My initial interpretation of the problem was this:
>
> (1) The calculated Piotrosky number depends on 9 other data elements.
> (2) If any one of those elements are missing for any reason, then the
> resulting calculation would give an "Error" on the cell.
>
> I've not not verify whether that theory is correct. Perhaps Randy can
> attest to it.
>
> That was my guess when I first tried it. Perhaps for blue chip tickers
> like MMM all data elements are there.
>

Thu Aug 7, 2014 6:41 am (PDT) . Posted by:

ace9941

I am trying to use the template smfGetAdvFNElement-Template-All-Line-Items.xls http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls. I live in Canada so I changed the link to http://ca.advfn.com/ http://ca.advfn.com/


Ticker Symbol NYSE/MMM
Quarterly Data (Q)


The number of periods come back correctly (81)


However all other fields display "--"


I am using Windows 7 and EXCEL 2010


I tried registering with ADVFN for a free account then logging in but didn't make a difference.


Other Info: I successfully used the template RCHGetHTMLTable-Template-MSN-Annual-Financials.xls


Does the ADVFN template work correctly? Am I doing something wrong?


Thanks in advance for any guidance.
Steve





Thu Aug 7, 2014 8:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What link did you change? If the number of quarters came back OK, the
smfGetAdvFNElement() function is working OK. So it must be column C that is
not calculating problem. It's what gets all the line item labels for
smfGetAdvFNElement() to use. What URL value did you end up with in cell B5?

On Thu, Aug 7, 2014 at 6:32 AM, sauger@rogers.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I am trying to use the template
> smfGetAdvFNElement-Template-All-Line-Items.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls>.
> I live in Canada so I changed the link to http://ca.advfn.com/
>
> Ticker Symbol NYSE/MMM
>
> Quarterly Data (Q)
>
> The number of periods come back correctly (81)
>
> However all other fields display "--"
>
> I am using Windows 7 and EXCEL 2010
>
> I tried registering with ADVFN for a free account then logging in but
> didn't make a difference.
>
> Other Info: I successfully used the
> template RCHGetHTMLTable-Template-MSN-Annual-Financials.xls
>
> Does the ADVFN template work correctly? Am I doing something wrong?
>

Thu Aug 7, 2014 9:04 am (PDT) . Posted by:

ace9941

I edited B5 directly and ended up with

="http://ca.advfn.com/exchanges/"&RCH_Stock_Market_Functions.xla!smfstrExtr(RCHGetWebData("http://www.advfn.com/p.php?pid=financials&symbol="&Ticker,"canonical",150),"/exchanges/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"





I've now changed B5 back to "http://www.advfn.com/...." and I still get the same result. 81 quarters but no information is displayed anywhere else, only "--". (No text or numbers)


Steve


Thu Aug 7, 2014 9:10 am (PDT) . Posted by:

ace9941

Cell C7 has formula =IF(UPPER(Ticker)="NONE";,"--",RCHGetTableCell(rURL,1,"Indicators",,,,ROWS($7:7),"</TABLE",,"--"))

The =IF(UPPER(Ticker)="NONE"; appears to work OK so it has to be the RCHGetTableCell(...) that isn't operating correctly.


Steve

Thu Aug 7, 2014 9:27 am (PDT) . Posted by:

ace9941

I got it working by going back to the original and starting over. I'm not sure what was wrong but I adjusted some settings for both EXCEL and IE options.

Thanks for the help Randy
Steve

Thu Aug 7, 2014 9:42 am (PDT) . Posted by:

ace9941

OK - a new problem. I did a few spot tests with different stock symbols. I'm finding that there is a problem occurring in 2013 when looking at quarterly data. Most of the time 1, 2 or 3 quarters are skipped. Some times a quarter is skipped but the subsequent quarter is duplicated. For example, stock is GC. For quarter ended 2013/09 and 2013/06 the same data is duplicated all the way down the column. If I look at the quarterly indicator starting with 2014/03 I see 1 4 3 3 1 4 3 2 1 4 3 2 1 ... In other words the second quarter was skipped and the third quarter was repeated twice.

Is this data that has been scraped directly from the site? It looks like the results saved after someone periodically scraped the site at irregular intervals.


Steve

Attachment(s) from
1 of 1 Photo(s)

Thu Aug 7, 2014 11:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't even see financial statements available for GC, so I'm not sure
what you're looking at.

However, I do recall complaints about the data in the past. I think one
complaint was that some of the quarterly numbers were YTD instead of for
the quarter. That is, YTD in one column, but quarterly in the next.

On Thu, Aug 7, 2014 at 9:42 AM, sauger@rogers.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> OK - a new problem. I did a few spot tests with different stock symbols.
> I'm finding that there is a problem occurring in 2013 when looking at
> quarterly data. Most of the time 1, 2 or 3 quarters are skipped. Some
> times a quarter is skipped but the subsequent quarter is duplicated. For
> example, stock is GC. For quarter ended 2013/09 and 2013/06 the same data
> is duplicated all the way down the column. If I look at the quarterly
> indicator starting with 2014/03 I see 1 4 3 3 1 4 3 2 1 4 3 2
> 1 ... In other words the second quarter was skipped and the third quarter
> was repeated twice.
>
> Is this data that has been scraped directly from the site? It looks like
> the results saved after someone periodically scraped the site at irregular
> intervals.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 11.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)