question

Upvotes
Accepted
f.canta avatar image
1 ●0 ●0 ●0

Data not aligned

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.

eikon-data-apiapi#content
1668766755261.png (46.1 KiB)
1668766755303.png (32.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.7k ●294 ●53 ●79

@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


1669251563126.png (7.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.