Earnings per Share Growth

Optuma Forums Optuma Scripting Earnings per Share Growth

This topic contains 1 reply, has 2 voices, and was last updated by Matthew Matthew 3 weeks, 4 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #48787

    Daniel
    • Topics: 1
    • Replies: 0
    • Posts: 1

    Hi Optuma,

    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[1];

    // to calculate the EPS for the pervious 12 month period i.e. [1] is current period, [2] would be previous data update 6 months ago, [3] is 12 months ago
    EPS3=EPS[3];

    // to calculate EPS (Earnings per share) growth 1 yr (%)
    EPSgrowth1yr%=(( (EPS1-EPS3)/EPS3)*100);
    EPSgrowth1yr%

     

    Appreciate any comments or corrections.

    Kind regards,

    Daniel

     

     

     

    #48791
    Matthew
    Matthew
    • Topics: 3
    • Replies: 80
    • Posts: 83

    Hi Daniel,

    The following script should provide the results you’re trying to produce:

    There are some comments in the script describing each step.

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

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.

Close