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!
Unpopulated TR.ExchangeCountry vs. populated TR.HeadquartersCountry
Price data missing for several RIC's using ek.get_timeseries in python API
Server Error: code 500 by downloading the data from eikon
How do I retrieve a price for US92204A7028 Vanguard Information Technology Etf traded at NYSE ARCA?