Data not aligned

f.canta
f.canta
in Eikon Data APIs

I have a couple of issues regarding data downloads via APIs on Eikon and in particular:

1) "Period / Data not aligned
(A.N RIC is just an example, we have the same issue with several equities.)

E.g.: equity A.N

Python extraction:
1668766755261.png


Data shown in Eikon (it seems that these are correct):


1668766755303.png


As you can see the value 3,017 corresponds to 2000Q4 in Eikon and to 2000Q3 via Python.

How can I solve this?

Thank you.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse admin
    Answer ✓

    @f.canta

    Sorry about the issue that you are facing.

    The TR.F.TOTREVBIZACTIV field has its own fperiod field (TR.F.TOTREVBIZACTIV.fperiod) so you need to use this field instead for the financial period of "Revenue from Business Activities - Total".

    df, err = ek.get_data(
        ['A.N'],
        ['TR.ISSOURCE.DATE','TR.ISSOURCE.fperiod','TR.ISSOURCE.pefiodenddate', 'TR.ISSOURCE', 
         'TR.F.NETCASHFLOWOP','TR.F.TOTREVBIZACTIV.fperiod','TR.F.TOTREVBIZACTIV'],
        {'SDate': "1980-01-01", 'EDate': "2022-12-31",'Frq': 'FQ','Period': 'FQ0','ReportingState': 'ALL'},
    )

    The output is:

    1669251563126.png

    I hope that this information is of help

Categories