Python Standarized Data Response

isanchez

Hello,

Is there anyway to consult the complete periods for standarized balance sheet, Income and cashflow. I have the followings lines.

p = {

'Period': 'FY0'

, 'reportingState':'Rsdt'

, 'curn': currency

, 'Scale':'6'

, 'SORTA':'LISeq'

, 'CH':'Fd'

, 'IncludeOldYE' :'No'

, 'ReportType':'Latest'

, 'Edate' : '-5FY'

, 'FRQ':'FY'

, 'transpose':'y'

, 'Sdate' : '0FY'

, 'FXRate' : 'PeriodEnd'

, 'NULL' : 'blank'

}

df, err = ek.get_data(['MS.LM'], ['TR.F.BalanceSheet.fieldName','TR.F.BalanceSheet.fielddescription', 'TR.F.BalanceSheet.date','TR.F.BalanceSheet'], parameters = p )

I'm trying to get the last 5 years for each field that belongs to BalanceSheet, In some fields the data is ok for example:

and in the same query another field we got

How can I modify my current script or parameters to get the same periods even if the data does not exists I wondering if it is possible to get the following response:

InstrumentNameDateSTD Balance Sheet All534MS.LMTR.F.SecHeldUnderCollat2015-12-31T00:00:00Z11225666MS.LMTR.F.SecHeldUnderCollat2014-12-31T00:00:00Z213161007MS.LMTR.F.SecHeldUnderCollat2011-12-31T00:00:00Z421461115MS.LMTR.F.SecHeldUnderCollat2010-12-31T00:00:00Z46186

fieldperiodSTD Balance Sheet AllMS.LMTR.F.SecHeldUnderCollat2019-12-31T00:00:00Z

MS.LMTR.F.SecHeldUnderCollat2018-12-31T00:00:00Z

MS.LMTR.F.SecHeldUnderCollat2017-12-31T00:00:00Z

MS.LMTR.F.SecHeldUnderCollat2016-12-31T00:00:00Z

MS.LMTR.F.SecHeldUnderCollat2015-12-31T00:00:00Z11225

Thanks.

Alex Putkov.1

In a standardized balance sheet every standard line item is named, i.e. it is retrieved using a specific field name. The example in my previous response uses field names TR.F.BVExclOthEq and TR.F.SecHeldUnderCollat. You can group these fields (and all other named fields you'd like to retrieve) any way you like. E.g. you could use one get_data call to retrieve all fields that fall under assets and another call to retrieve all fields that fall under liabilities. Or you could create the list of fields where the first X fields fall under assets and the rest fall under liabilities.

The best way to explore the metadata for use with Eikon Data APIs is through CodeCreator app, which among other things allows you to search for field names or browse fields by category, see what parameters are applicable to selected field etc. And at the end it produces a code snippet, which you can copy & paste into whatever IDE you're using.