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
