Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by isanchez · Dec 28, 2020 at 11:10 PM · eikondataapipython eikon

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.

1609195575943.png (16.5 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
REFINITIV
Answer by Alex Putkov. · Dec 29, 2020 at 12:53 AM

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 )
Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
isanchez · Dec 29, 2020 at 07:55 PM 0
Share

Hi @Alex Putkov.

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.


1609271447063.png (201.5 KiB)
avatar image
REFINITIV
Alex Putkov. ♦♦ isanchez · Dec 30, 2020 at 12:04 AM 0
Share

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.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

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

ERROR:pyeikon:Error code 404 | Client Error: Not Found -

Gap in FX data via Eikon API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges