Query about EPSMean and associated parameters

jakub.straka
jakub.straka
in Eikon Data APIs

Hello,

The output of my below code is a little confusing. I have the following questions:

- Is the PeriodEndDate the end of the Fiscal Year?

- If so, in the output image below, at index 225, both the CalcDate and Date values for FY1 are after the PeriodEndDate. Is that possible?


Code:

instruments = ['AAPL.O']
fields = [
'TR.EPSMean(Period=FY1)',
'TR.EPSMean(Period=FY1).PeriodEndDate',
'TR.EPSMean(Period=FY1).CalcDate',
'TR.EPSMean(Period=FY1).Date',
'TR.EPSLow(Period=FY1)',
'TR.EPSHigh(Period=FY1)',
]
parameters = {'SDate':'20000101', 'EDate':'20190901', 'FRQ':'M'}
df1, err = ek.get_data(instruments, fields, parameters)


Output attached:

Capture.PNG

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @jakub.straka

    I use Eikon Excel to confirm the datapoint and it seems that API retrieve the same data point as from Eikon Excel.

    image

    From API perspective, it retrieves the data correctly and successfully.

    So now the question is why the date is as shown on the screenshot.

    This forum is moderated by developer.

    For content question, please contact Refinitiv Helpdesk at https://my.refinitiv.com/

    They will be able to address and give you an authoritative answer on content question.

Categories