Problem retrieving data for a RIC with Python eikon API

mihalis.panczyk
mihalis.panczyk
in Eikon Data APIs

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

Best Answer

  • jason.ramchandani01
    jason.ramchandani01
    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.

Categories