Reply To: Fundamental Data – Previous Quarters

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

#45371
MA7
  • 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.

 

 

Pin It on Pinterest