Python Standarized balance Sheet, Income Statement and CashFlow

isanchez
isanchez Explorer
in Eikon Data APIs

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.


image

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @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

    image

    This is a new capability - pretty neat!

Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    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.

    image

  • isanchez
    isanchez Explorer

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


    Thank you

Categories