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.


image

Best 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

  • 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

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


    Thank you

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.