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

rafael01

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:

How can I get all rows correctly filled?

Thanks in advance

Rafael

nick.zincone

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'
    }
)

rafael01

Thanks nick......