Different EPS outputs FundamentalDataSeriesAnnual vs FundamentalDataSeries
Author: Partha
Creation Date: 9/1/2019 12:36 AM
profile picture

Partha

#1
I am getting different outputs for ticker SO (Southern Company) using these two commands

CODE:
Please log in to see this code.


//Output
2.19

CODE:
Please log in to see this code.


//Output
4.27

Can you please guide me what is the issue here? Thanks in advance
profile picture

Eugene

#2
QUOTE:
//Output
2.19

Did you make a typo? The number should be more like 2.91 rather than 2.19 according to stock's earnings history. The last 4 quarterly numbers are: 0.8, 0.7, 0.25, 1.14.

Please rerun your code with a little modification to the aggregate overload for FundamentalDataSeries:

CODE:
Please log in to see this code.


1. Does it make any difference?

2. If not, do you now see discrepancy in the results for FundamentalDataSeries on other symbols?
profile picture

Eugene

#3
Since I don't have access to the Fidelity data I was able to reproduce it using data by the StockPup provider: 2.41 vs 4.27. The 4.27 number is a result of summing up the 4 raw numbers: 1.14, 0.26, 2.01 (incorrect) and 0.86. Using the Zacks Adjusted Earnings (EPS) provider I get the correct annualized number 2.89. (FYI, it's recommended to Wealth-Lab Developer users as a trustworthy source.)

The difference in the raw data explains it for me. Disregard my previous reply and peek inside the quarterly numbers for SO in your Fidelity data. According to company's website (investor relations), the numbers must be 1.14, 0.25, 0.7 and 0.8. See the QuickRef example for FundamentalDataItems on how to output them. If they're different the quarterly data is wrong - hence GIGO.

April 2020: StockPup fundamental provider decommissioned, feed taken offline.
profile picture

Partha

#4
Thanks Eugene...I have reached out to Fidelity. I have found issues with their fundamental data on several other stocks
profile picture

Eugene

#5
You're welcome.
profile picture

Cone

#6
Re: 2.01 (incorrect)
It's not incorrect. It's a different source.

Look at the 10-K.
https://investor.southerncompany.com/information-for-investors/investor-information/quarterly-results/default.aspx

Download First Quarter 2019 and see page 5. Both numbers appear.

Basic Earnings Per Share1 is $2.01
Basic Earnings Per Share–Excluding Items is $0.70

@Partha
The aggregate difference is due to comparing Fiscal Year Annual (Command 1) to the TTM (trailing 12 months) annual (Command 2),

Maybe this script and output will help you see where the numbers are coming from (modified FundamentalDataItems QuickRef example). In short, if you add up the quarters from FY 2018, you'll get $2.19.

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

Partha

#7
Thanks Cone. I will use the script you provided.

I did some data check between Fidelity WL Pro data and Fidelity Website data. I noticed that EPS data in WL Pro is not same as Fidelity website data. I have reached out to fidelity data regarding this. In the mean time do you have some code I can to use the modify the "adjustment factor" in the fidelity data set so that I can get the same values as Fidelity Website (assume this is good data)

See attached data dump for DOW30 stocks, the EPS is not same. In S&P 500 some have very high differences

profile picture

Cone

#8
The feed to Wealth-Lab Pro simply does not include the adjusted earnings data, hence it's not available to WL Pro using the Fidelity Fundamental Provider.

The solutiion is to use the Zacks Adjusted Earnings (EPS) provider to obtain the adjusted earnings. To get it, install the free MS123 Extra Fundamental/News Providers.
profile picture

Partha

#9
Ok thanks
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).