I tried to get the EPS data a year ago and the current EPS data, then calculate the percent increase. However, the percent increase seems to be wrong for the first couple of symbols.
The result of the run is as follows:
eps eps_change Equity(40531 [FXCM]) 0.0500 277.200000 Equity(4415 [LEG]) 0.0034 197.058824 Equity(12200 [LGND]) 0.0600 174.333333 Equity(23096 [UNTD]) 0.0100 169.000000 Equity(3766 [IBM]) 0.0200 150.500000
For symbol FXCM, the increase is 277.2X. But from NYSE, it seems the value should really be 27.72X:
A bit further digging of the data seems to show the EPS a year ago is wrong. It shows up as 0.05 from the algorithm, but from NYSE, it is actually 0.50.
For symbol LEG, the increase is 197X, but from NYSE, it seems the increase should be 1.97X:
Seems to be the same issue, the EPS a year ago shows up as 0.0034, but from NYSE, it should be 0.34.
I don't know whether other values are correct or not.
I'm not sure whether the incorrect data is from morning star or not. NYSE also use morning star data. Or is it just my algorithm gets the wrong data point?
|Returns||1 Month||3 Month||6 Month||12 Month|
|Alpha||1 Month||3 Month||6 Month||12 Month|
|Beta||1 Month||3 Month||6 Month||12 Month|
|Sharpe||1 Month||3 Month||6 Month||12 Month|
|Sortino||1 Month||3 Month||6 Month||12 Month|
|Volatility||1 Month||3 Month||6 Month||12 Month|
|Max Drawdown||1 Month||3 Month||6 Month||12 Month|