Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
rafael01 avatar image
50 ●1 ●1 ●4

How to get enddate and release date using Eikon API in python

Hello,


I would like to construct a time series on a quarterly basis (The last twelve months) of fundamentals for each company in Brazil. However, I have not succeeded. Below you can see the call in python:


df, err = ek.get_data(
    instruments = ['PETR4.SA'],
    fields = ['TR.F.EBIT(SDate=2020-01-01,EDate=0D,Period=LTM,Frq=FQ)',
              'TR.ISStatementLastUpdatedDate',
              'TR.ISPeriodEndDate']
)


The response is:


1659732152086.png

How can I get all rows correctly filled?


Thanks in advance


Rafael


eikon-data-apipythondate
1659732152086.png (31.4 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
nick.zincone avatar image
17.8k ●82 ●39 ●63

Hi @rafael01

For content-related questions, it is best to go through the helpdesk. You can access the "Get Help & Support" feature within the desktop via the help menu or by hit the F1 key.

That being said, I don't believe there is historical data available for the 2 date fields you requested - the helpdesk can confirm.

I did find this:

df, err = ek.get_data(
    instruments = ['PETR4.SA'],
    fields = ['TR.F.EBIT',
              'TR.F.EBIT.periodenddate',
              'TR.F.EBIT.calcdate'],
    parameters = 
    {
        'SDate': '2020-01-01',
        'EDate': '0D',
        'Period': 'LTM',
        'Frq': 'FQ'
    }
)

ahs.png


ahs.png (26.7 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.

rafael01 avatar image rafael01
Thanks nick......

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.