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?
1
●1 ●5 ●9
market cap in refinitiv data api where gui app has the right answer
18.9k
●85 ●39 ●63
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:
1
●1 ●5 ●9
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
1
●1 ●5 ●9
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'
]
)
18.9k
●85 ●39 ●63
Hi
@mjg
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.
