hello
when i query refintiiv data for the market cap
TR.CompanyMarketCap
for cusip:
117043109
i get back <NA>
in refinitiv workspace DIB i see a real number here
what is giong on?
Hi @mjg
I don't believe the API to get the data directly accepts a Cusip - you will need a step to convert. For example:
cusips are my typical argument to the call i make, i pass thousands of them and get the right data back for all but a few
this is the call i make, i have never noticed a problem with cusips as an input to universe, it is the standard way i use the api. i only noticed a few missing market caps of the 5,000 or so cusips i query for today bc i happened to fail a unit test for a random symbol i was checking valid output for.
rd.get_data( universe=cusips, fields=[ 'TR.CompanyMarketCap', 'TR.PE', 'TR.PriceToSalesPerShare', 'TR.GICSIndustry', 'TR.GICSSubIndustry', 'TR.SICIndustryGroup', 'TR.TotalDebtOutstanding', 'TR.ShortInterestPct', 'TR.CompanyName', 'TR.F.CashSTInvst', 'TR.PriceTargetMedian', 'TR.PriceTargetNumIncEstimates', 'TR.RevenueSmartEstF12MtoT12MGrowth', 'TR.EpsRepSmartEstF12MtoT12MGrowth', 'TR.PriceToBVPerShare', 'TR.FwdPEG' ])
There may be a logical explanation or possible issue why specific codes work and others do not. I would recommend you reach out to the Desktop Helpdesk F1 - Get Help & Support, and they can bring in a specialist who can confirm why some Cusips do not work. They may have you try, or provide to you, an API within Excel as part of the investigation.
