CUSIP querying failures

mjg

hello, because querying using TickerSymbol trying to get RIC isn't bulletproof, i thought i might try relying on CUSIP.

it turns out that is not bulletproof either.

here is a list of CUSIPs that fail using this code:

'G96629103', 'G9892K100', 'N94209108', '81807M205', 'M98068105', 'M9T951109', 'N3144W105', 'M97628107', 'G98239109', 'G9525W109', 'Y95308105', 'N30577105', 'G48833118'

    response = symbol_conversion.Definition(symbols=cusips,
                                            from_symbol_type=symbol_conversion.SymbolTypes.CUSIP
                                            ).get_data()

some of these CUSIPs do come up in Data Item Browser if you punch the associated Ticker Symbol in, example:

G96629103 ticker WTW

some of these CUSIPS don't come up in Data Item Browser, but shuold. example:

81807M205 ticker YQ

----

i am looking for some way, any way, to reliably be able to take EITHER a U.S. Ticker Symbol (still struggling with that despite some good help from @marcin.bunkowski here):

https://community.developers.refinitiv.com/questions/112362/some-nyse-rics-returning-without-suffix-why.html

OR, i can use a CUSIP instead if that makes this a more bulletproof join/query method. but i am shocked that CUSIP seems to be just as difficult as Ticker Symbol.

---

In the end I want to make queries for attributes like Market Cap, Dividend Record Date, Fund Inception Date, and so on, but to get the data back I Expect to get back for the security I am entering. If Ticker dodesn't work, and CUSIP doesn't work, what will?

m.bunkowski

Hi @mjg

I have tried to run your example several times and indeed, intermittently I was getting the same error message that was coming from the backend service that can be overloaded. I have observed that it was less frequent, when you request one field 'TR.RIC'. That can be later on successfully used in your further calls.

Alternatively, you can reduce the number of instruments in a single call.

You can also do a try-except block to catch errors and retry like below

max_steps = 3
step = 0
while step < max_steps:
    try:
        df = rd.get_data(cusips, ['TR.TickerSymbol', 'TR.RIC', 'TR.CusipExtended','TR.OrganizationID'])
        print(df)
        break

    except rd.errors.RDError as e: 
        print("RDError code :", e.code) 
        print("RDError message:", e.message)
        step +=1 
        continue