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

MisterM

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?

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.

MisterM

https://community.developers.refinitiv.com/discussion/comment/56182#Comment_56182

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

https://community.developers.refinitiv.com/discussion/comment/56198#Comment_56198

Hi @MisterM

I understand your concern.

You can give your feedback by contacting Refinitiv Helpdesk at https://my.refinitiv.com

So your feedback will be raised to an appropriate technical support team.

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

https://community.developers.refinitiv.com/discussion/comment/56182#Comment_56182

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:

chavalit-jintamalit

https://community.developers.refinitiv.com/discussion/comment/56406#Comment_56406

Hi @MisterM

They are from different categories

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