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

Find more posts tagged with

python

python api

financial-statements

Accepted answers

jason.ramchandani01

@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

I hope this can help.

All comments

jason.ramchandani01

@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

I hope this can help.

EXPLORE OUR SITES