Python Standarized balance Sheet, Income Statement and CashFlow

isanchez

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.

jason.ramchandani01

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