question

Upvotes
Accepted
1 1 1 3

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'
    }
)
pythonpython apifinancial-statements
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
11k 22 6 9

@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.


1665065101604.png (381.1 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.

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.