For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

Why the fundamental data for some companies are missing?

AAN.N does issue annual reports but

the code above returns me an empty dataframe



Can someone please tell me where is wrong?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonfundamental-data
1619519023598.png (22.6 KiB)
1619519059035.png (6.3 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
23k 22 9 14

Hello @ryan.liu,

Somehow, as I try to test the same request, I get the same result, but also error "delimiter is unexpected in formula".

Try:

df, err = ek.get_data(
    instruments = ['AAN.N'],
    fields = ['TR.F.OriginalAnnouncementDate(SDate=0,EDate=-99)']
)
df

for me the result looks like:

Using Code Creator in Eikon can be very helpful:

Type CODECR into Eikon search bar, select instrument, field, and you can tune the parameters:

The code that is generated at the bottom panel can be copied to clipboard.




aann.gif (12.4 KiB)
aanncodecr.gif (260.6 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea