Python Standarized Data Response
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.
Best Answer
-
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.
1
Answers
-
I'm not sure I quite understand the use case here, but it sounds to me like you're looking for a standardized balance sheet instead of "as reported" one, i.e. a balance sheet with standardized line items. If this is what you're looking for, create a list of the line items you're interested in and use them in the fields argument of get_data method, e.g.
df, err = ek.get_data(['MS.LM'],
['TR.F.BVExclOthEq',
'TR.F.SecHeldUnderCollat',
'TR.F.PeriodEndDate'],
parameters = p )0 -
ok, sound good, but is there a way to consult the line items group by section. Ej.
getting all the list item what belong to ASSETS Section or Liabilities section, because the main query at begining of the ticket
df, err = ek.get_data(['MS.LM'], ['TR.F.BalanceSheet.fieldName','TR.F.BalanceSheet.fielddescription', 'TR.F.BalanceSheet.date','TR.F.BalanceSheet'], parameters = p )
cannot find the way to separate by section.
thanks.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 370 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛