Fundamental Data - Previous Quarters

Optuma Scripting
1

Hi,

I would like to create a watchlist that shows the current Earnings per Share (EPS) value as well as the previous 3 quarters.
However, I'm not quite sure how to go about getting the previous values.

The current value is easy enough:

DATAFIELD(FEED=FD, FIELD=EPS, LATESTONLY=False)

However, I have tried the following to look back 3 months and it does not appear to work as I intended it. (I just the figure corresponding to the current EPS):

DATAFIELD(Month(PERIODAMOUNT=1), FEED=FD, FIELD=EPS, LATESTONLY=False,OFFSET=-3)

Can anyone tell me where I am going wrong?

Thanks
Liam

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.

 

 

EPSExample.owb (26.1 KB)

3

Fantastic. That's exactly what I'm after.

This may be a dumb question, but why do I need to retrieve every 2nd value (Eg. Value[2], Value[4], etc.)?

Also, where does Optuma source it's fundamental data from?