Problem retrieving data for a RIC with Python eikon API

Hello, when i run the blow code it returns NA

On the platform the ticker has the financials i am trying to download.

Any reason why?


df, err = ek.get_data(
instruments = ['TNB^E12'] ,
fields = ['TR.TotalCurrentAssets.Periodenddate',
'TR.TotalCurrentAssets',
'TR.TotalCurrLiabilities',
'TR.TotalLongTermDebt',
'TR.TotCashFromOperatingActivities',
'TR.CapitalExpenditures'],
parameters = {
'Period': 'FI0',
'SDate': '0',
'EDate': '-40Y',
'Frq': 'FI',
'ReportingState': 'Orig',
'ConsolBasis': 'Consolidated',
'Curn': 'Native'
}
)

Best Answer

  • @mihalis.panczyk Thanks for your question - so the following code works for me:

    df, err = ek.get_data(
        instruments = ['TNB^E12'] ,
        fields = ['TR.TotalCurrentAssets.Periodenddate',
                  'TR.TotalCurrentAssets', 
                  'TR.TotalCurrLiabilities',
                  'TR.TotalLongTermDebt',
                  'TR.TotCashFromOperatingActivities',
                  'TR.CapitalExpenditures'],
        parameters = {
            'Period': 'FQ0',
            'SDate': '0',
            'EDate': '-40',
            'Frq': 'FQ',
            'ReportingState': 'Orig',
            'ConsolBasis': 'Consolidated',
            'Curn': 'Native'
        }
    )
    df

    1665065101604.png

    I hope this can help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.