Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
isanchez avatar image
16 ●4 ●9 ●10

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1602686501661.png (108.4 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.

chavalit-jintamalit avatar image   chavalit-jintamalit

Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the appropriate reply.
This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

3 Answers

· Write an Answer
Upvote
Accepted
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

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


screenshot-2020-10-16-at-095531.png (222.0 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.

Upvote
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
isanchez avatar image
16 ●4 ●9 ●10

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