For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 2 3 5

Python Standarized balance Sheet, Income Statement and CashFlow

Is there anyway to consult the standarized balance sheet, the income statement and the cashflow with python? I have this lines to consult them "As reported"

=TR("AMXL.MX ","TR.F.ASRIncomeStatement","period=#4 RH=LIName SORTA=LISeq CH=Fd;FPA;ped Null=Blank reportingState=#1 curn=#2 scale=#3",,"Rsdt","NATIVE",6,"FY0")

I tried taking out the "ASR" but it didnt work.


This is the script in python

ek.get_data(['ALICORC1.LM'],

['TR.F.IncomeStatement.LINAME','TR.F.IncomeStatement'],

parameters = {'Period': 'FY0','reportingState':'Rsdt', 'curn':'Native', 'Scale':'6','SORTA':'LISeq'}

)

ek.get_data(['ALICORC1.LM'],

['TR.F.BalanceSheet.LINAME','TR.F.BalanceSheet'],

parameters = {'Period': 'FY0','reportingState':'Rsdt', 'curn':'Native', 'Scale':'6','SORTA':'LISeq'}

)

ek.get_data(['ALICORC1.LM'],

['TR.F.CashFlowStatement.LINAME','TR.F.CashFlowStatement'],

parameters = {'Period': 'FY0','reportingState':'Rsdt', 'curn':'Native', 'Scale':'6','SORTA':'LISeq'}

)

And we got the following result.


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
1602686501661.png (108.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
6.7k 8 6 7

@isanchez I think this is what you are looking for:

df, err =ek.get_data(['VOD.L'],['TR.F.BalanceSheet.fieldname','TR.F.BalanceSheet.fielddescription','TR.F.BalanceSheet'],parameters = {'Period': 'FY0','reportingState':'Rsdt', 'curn':'Native', 'Scale':'6','SORTA':'LISeq'})
df

This is a new capability - pretty neat!


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
18k 21 12 20

Hi @isanchez

I tested all your 3 API calls.

It seems that the TR.F.XXXX.LINAME field is invalid and it makes the API call failed.


ahs.png (67.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
16 2 3 5

Hello jason.ramchandani why applied those changes to our script and the result was the information what we need.


Thank you

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea