Reply To: Fundamental Data – Previous Quarters

Optuma Forums Optuma Scripting Fundamental Data – Previous Quarters Reply To: Fundamental Data – Previous Quarters

#45371
AvatarMA7
  • Topics: 0
  • Replies: 2
  • Posts: 2

Hi Liam,

For the previous value you can use a script like this:

Value = DATAFIELD(Month(PERIODAMOUNT=3), FEED=FD, FIELD=EPS);

Value[2]

You can then modify the last line to Value[4] and Value [6] to grab the two EPS values before that.

I’ve attached a workbook example with the columns setup.

 

 

Attachments:

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