Different EPS outputs FundamentalDataSeriesAnnual vs FundamentalDataSeries #2
Author: superticker
Creation Date: 9/17/2020 3:36 AM
profile picture

superticker

#1
Could some kind soul please explain why line 1 and line 2 come up with different numbers? My own manual calculations agree with line 2, but not line 1. Is the line 1 calculation performing some subtle undocumented manipulation the rest of us don't expect?

CODE:
Please log in to see this code.
profile picture

Eugene

#2
Sure, since this question was raised before in another topic:

Different EPS outputs FundamentalDataSeriesAnnual vs FundamentalDataSeries
profile picture

superticker

#3
I changed the above code as suggested in the Post# 2 link to:

CODE:
Please log in to see this code.

But that didn't help.

Really, that line above agrees with my manual calculations--it's right. It's the FundamentalDataSeriesAnnual() that's in question. And the link in Post# 2 is suggesting the data is to blame, but that's not the case here because the exact same provider with the exact same stock is being employed for both calls here.

So what's really going on here? How do I get both calls to give me the same numbers? And the FundamentalDataSeries() agrees with my manual calculations, so it's the FundamentalDataSeriesAnnual() call that's in question. How is that latter call forming its solution? The documentation isn't saying.
profile picture

Eugene

#4
Have you read Cone's post #6 and below?
profile picture

superticker

#5
I converted the Post# 6 code to YCharts data below. I made some changes, but it's basically the same code.

CODE:
Please log in to see this code.


And we get the following Debug result below.



So the annual and "summed aggregate" numbers are different with the same input data as pointed out in Post# 1. I'm asking why are they different? Are you suggesting that the FundamentalDataSeriesAnnual() function call only applies to Fidelity data (as shown in Post# 6 of the above link) and is irrelevant to WL Developer data? Is that the "hidden" point of Post# 6?

---
I just had a thought the fiscal year might be involved for the FundamentalDataSeriesAnnual() function call so ...

2020: 1.91+0.04-2.22 ........ = -2.22 != 5.43
2019: 1.10+0.62+1.25+2.43 = 5.43 == 5.43

So that's the deal. The FundamentalDataSeriesAnnual() function call is returning the annual earnings for the previous fiscal year, 2019; whereas, the FundamentalDataSeries() returns the earnings for the trailing-twelve-months (TTM). Sounds good; I won't use that annual call because I don't want data that old. Question resolved.
profile picture

Eugene

#6
QUOTE:
The FundamentalDataSeriesAnnual() function call is returning the annual earnings for the previous fiscal year, 2019; whereas, the FundamentalDataSeries() returns the earnings for the trailing-twelve-months (TTM).

Right, and that's the point of Robert's post #6 in cited topic:

<<The aggregate difference is due to comparing Fiscal Year Annual (Command 1) to the TTM (trailing 12 months) annual (Command 2),>>
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).