I am trying to write a script for calculating earnings per share (EPS) growth to use in a watchlist, however I have some uncertainty as to if I am getting the previous period EPS and if I am using the script caching  function correctly.
It is my understanding that the “Earnings per Share – Fiscal Period” fundamental data in Optuma is for the fiscal 12 month period, the fiscal period can not be overridden, and is updated every six months as companies report. That is, the EPS data is for the trailing 12 month period and the data updates every 6 months.
On this understanding, I am using the following script to calculate EPS growth % for a one year period.
// Earnings per Share – Fiscal Period as updated every 6 month period EPS=DATAFIELD(Month(PERIODAMOUNT=6), FEED=FD, FIELD=EPS);
// to calculate the most recent period EPS EPS1=EPS;
// to calculate the EPS for the pervious 12 month period i.e.  is current period,  would be previous data update 6 months ago,  is 12 months ago EPS3=EPS;
// to calculate EPS (Earnings per share) growth 1 yr (%) EPSgrowth1yr%=(( (EPS1-EPS3)/EPS3)*100); EPSgrowth1yr%
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.