market cap in refinitiv data api where gui app has the right answer

mjg

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?

nick.zincone

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:

mjg

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

mjg

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'
    ]
)

nick.zincone

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.