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.
@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!
Hello jason.ramchandani why applied those changes to our script and the result was the information what we need.
Thank you