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 hardik.madhu · Jul 17, 2020 at 02:17 PM · pythoneikon apieikoneikon data apieikon python api

Eikon Python API Empty Response for Private Company Financial Data - e.g. TR.Revenue, TR.GrossProfit

Hello Everyone,

I tried looking for a similar problem on the forum, but couldn't really find anything that exactly matches. So here's the description of the issue we're facing.

I'm trying to query Financial Data for multiple Instruments in a single call. Our query looks like this:

df, err = get_data(instrument_id_list, financial_fields, 
                   parameters = {'SDate': 0, 'EDate': -9})

where

financial_fields = [
     'TR.CommonName',
     'TR.Revenue',
     'TR.GrossProfit',
     'TR.EBITDA',
     'TR.EBIT',
     'TR.NetIncomeAfterTaxes',
     'TR.TotalAssetsReported',
     'TR.TotalLiabilities',
     'TR.CashandEquivalents',
     'TR.IsBSCompleteStatement',
     'TR.IsISCompleteStatement',
     'TR.OrganizationID',
     'TR.TotalCurrLiabilities',
     'TR.TotalCurrentAssets'
]

and instrument_id_list is a list of 25 or 50 Instruments.


Our issue could be described with the following points.

  • While executing this query for Public Companies, we receive all of the available data, without any issues. Even if the instrument_id_list doesn't exclusively include Public Company Instruments, the data is retrieved without any problems.
  • BUT, this is not the case for Private Companies. For most of the Private Companies we query for, the returned data is completely empty.
  • This is especially concerning, since the data is available and visible on the Eikon Web Interface for the same private companies.
  • One such example is, Company Common Name: Industrias Alzuaran SL, Instrument: 5044749664. For this company, if we query data using the described get_data setup, the returned results are empty. But, we can see the financial data available on the Eikon Web Interface.
  • Additionally, if we query for different data fields, for the same company / companies (including Industrias Alzuaran SL, Instrument: 5044749664), as following, the returned results are not empty, and we get the available data points, without any issues.
overview_fields = [
     'TR.CommonName', 
     'TR.BusinessSummary', 
     'TR.HeadquartersCountry', 
     'TR.OrganizationWebsite',
     'TR.PrivateEquityBacked',
     'TR.PCFullTimeEmployee(Period=FY0)',
     'TR.PCTotRevenueFromBizActv(Period=FY0)'
]

df, err = get_data(instrument_ids_list, overview_fields)
  • Interesting things to note here is that, we also receive, TR.PCTotRevenueFromBizActv, which is essentially a financial field.

Any hint on why we're not able to retrieve financial data for private companies, would be immensely helpful.


Best,

Hardik


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
Best Answer
Answer by Gurpreet · Jul 17, 2020 at 03:06 PM

Hi @hardik.madhu, The data fields for private companies might be different from those of public companies. I used Data Item Browser (DIB) in Eikon and see lot of available financial fields for your instrument.

It is best to contact Refinitiv Helpdesk at my.refinitiv.com and raise a content query to clarify your questions.


1594998298902.png (86.1 KiB)
Comment

People who like this

0 Show 0 · 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.

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 >
12 People are following this question.

Related Questions

Number or RICs returned from screener seems too high

Extracting all historical companies listed on the ASX using the Python API?

[Python Eikon API]How retrieve net change data?

How can I pull information via the EIKON API without the use of a monitor?

Constituent list and weight for .SPX using Python 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