I am trying to figure out which EPS number is lifted from the Income Statement by the EPS%ChgPYQ parameter.
I think it might be ItemQ(sdbf,0) vs ItemQ(sdbf,4).
It seems EPSPExclXorQ may also equal ItemQ(sdbf,0).
I got 7 symbols in the s&p that met the criteria (493 passed equality):
EPSPExclXorQ != ItemQ(sdbf,0) so I am confused.
Can you shed some light?
I had to put ItemQ(sdbf,0) in a Custom funtion to use it. It would be nice to use the ItemQ elements directly in screens and reports.
Hi,
Once again I am trying to figure out which Income statement item is used to determine EPS%ChgPYQ since there are several - diluted vs basic, gaap vs non-gaap, and including or excluding extraordinary items
I think it is Itemq - SDAI so I made the following custom
formula and compared the result to the value reported by
EPS%ChgPYQ.
((itemq(sdai,0) - itemq(sdai,4)) / (abs(itemq(sdai,4)))) * 100.0
For most of the stocks in the s%p 500 the 2 values were within .01% (324 out of 500), but the others were off and in some cases they were off by a factor of 10.
Can you shed any light on the how EPS%ChgPYQ is determined.
It seems like EPS%ChgPYQ is unreliable if the denominator is a very small value e.g. .001
For example, for the stock AMT the EPS numbers are 0.21 vs negative 0.01, but the earnings increase, EPS%ChgPYQ, is a whooping 15,688.72%. Using my custom formula the increase is 1,659.16%
Thanks,
Mark
Hi,
No one seems to know the answer to my question. I’ll try asking again.
What is the formula behind the EPS%ChgPYQ parameter?
Thank you,
Mark
You are correct. SDBF is the key line item code.
EPSPExclXorQ = ItemQ(SDBF,0)
The growth rate has one little subtelty:
EPS%ChgPYQ = (ItemQ(SDBF,0)-ItemQ(SDBF,4))/Abs(ItemQ(SDBF,4))
This formula is much more effective at handling negative numbers, or more particularly, formulations where one number is positive and the other is negative.
I’m not sure why you would find 7 mismtches in the EPSPExclXorQ item. Could you tell us what those ocmpanies were?
Hi,
I just revisted this topic.
I want to verify that
EPSPExclXorQ = ItemQ(SDBF,0)
is true, so I did a screen with the following rule and created a report
showing the difference between the 2 items. My rule:
abs( ItemQ(SDBF,0) - EPSPExclXorQ ) > 0.01
With the universe set to russel3000 I see 35 stocks which pass. Examining the list I see most are outside the US so I suspect the diffence is due to
currency translation at the time the 2 items were entered
in the database.
However, I got some large differences between ItemQ(SDBF,0) and EPSPExclXorQ shown below ($aaa is ItemQ(SDBF,0) and $abb is the difference. As you can see for the difference for IMOS is a whopping $4.94/share. Can you shed any light on what is going on?
Thanks,
Mark
No Ticker Name Last $aaa EPSPExclXorQ $abbb
1
IMOS[5d][1y]
ChipMOS Technologies (Bermuda) Ltd 8.0600 5.1104 0.1706 4.9398
2
QXM[5d][1y]
Qiao Xing Mobile Communication Co., 1.1600 1.9951 -0.4147 2.4098
3
BORN[5d][1y]
China New Borun Corp 4.5000 2.6226 0.4141 2.2085
4
IGLD[5d][1y]
Internet Gold Golden Lines Ltd. 10.8910 -2.8200 -0.7469 2.0731
5
XING[5d][1y]
Qiao Xing Universal Resources, Inc. 0.7600 1.4945 -0.0287 1.5232
6
CEL[5d][1y]
Cellcom Israel Ltd. 15.9600 2.0000 0.5297 1.4703
7
CYD[5d][1y]
China Yuchai International Limited 16.0900 1.7230 0.2721 1.4509
I did some more investigation after I realized that NA’s might be the problem.
So I set the screen setting to Keep NA’s. i idon’t think NA’s are the problem.
The rule
EPSPExclXorQ = NA and ItemQ(SDBF,0) != NA
has one hit, REPYY. Surpisingly, in this case EPSPExclXorQ is NA and
is valid.
I still see the problems as noted in previous message. If you want to take a look I have made the screen, EPS diffs , public as well as the Report, aaa,
and custom functions public.
I made the screen and 2 custome functions, $aaa and $abbb, public, but I
guess there’s no way to make a Report public