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

mjg
mjg
in Refinitiv Data Platform Libraries

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?

Tagged:

Answers

  • nick.zincone
    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:

    1720705358231.png

  • mjg
    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
    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
    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.

Categories