How to sort an ek.get_data request by instrument and fiscal period (absolute)?

Hello,

I am requesting the following data in Excel:

=TR("GOOGL.OQ";"TR.BSPeriodEndDate.fperiod;TR.BSPeriodEndDate;TR.ISPeriodEndDate;TR.EPSActValue;TR.EPSActValue.date";"Period=FQ0 Frq=FQ SDate=1982-01-01 EDate=2019-12-31 CH=Fd RH=IN";B2)

And I use the following code to do the exact same via API:

data,err = ek.get_data("GOOGL.OQ", ['TR.BSPeriodEndDate.fperiod', 'TR.BSPeriodEndDate', 'TR.ISPeriodEndDate', 'TR.EPSActValue', 'TR.EPSActValue.date'], {'SDate':'1982-01-01', 'EDate':'2019-12-31', 'Period' : 'FQ0', 'Frq' : 'FQ'})

The trouble I have can be seen in this picture:

There is a missmatch in "time" as the date of EPS-actual (last column), which is the earnings announcement date, does not possibly fit the fiscal quarter (third column) in the same row.

I know how to fix this in Excel:

... CH=Fd RH=IN;fperiod"...

However, I do not know how to fix it in terms of the API. As far as I am aware CH and RH parameters are disregarded in the eikon python package.

Still I need to find a way to match the data in the API correctly.

Can you help?

Additionally: Do I get it right that ek.get_timeseries is limited to HIGH, CLOSE, LOW, OPEN and VOLUME?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @MisterM

Please be advised that when you're mixing fields from different categories (see the illustration of TR.ISPeriodEndDate and TR.EPSActValue falling under different categories in Formula Builder wizard in Eikon Excel) the timeseries returned for these fields are not guaranteed to be aligned on the date.

All comments

chavalit-jintamalit

Hi @MisterM

MisterM

Thanks for the clue that this behavior is linked to the mix of different categories.

Yet, the occurence does not seem arbitrary to me at all, as it is evitable in Excel. From what I have read and understood, Excel and the API syntax should offer the same options, that is why I ask how to realize the described "sort-feature" in the Eikon API.

chavalit-jintamalit

Hi @MisterM

Additionally: Do I get it right that ek.get_timeseries is limited to HIGH, CLOSE, LOW, OPEN and VOLUME?

Please refer to this document for the fields parameter.

You can include fields='*' in your code to get every available field (from default view).

MisterM

Additionally, the same problem occurs within categories as well (ISperiodenddate, BSperiodenddate -> Reuters Fundamentals), which can also be seen from the snapshot I posted.

This would be the correct dates via Excel:

EXPLORE OUR SITES