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
Size:
Color:
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?
Size:
Color:
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.
Size:
Color:
Thanks Eugene...I have reached out to Fidelity. I have found issues with their fundamental data on several other stocks
Size:
Color:
You're welcome.
Size:
Color:
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.aspxDownload 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.
Size:
Color:
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
Size:
Color:
Size:
Color:
Ok thanks
Size:
Color: