Identifier conversion to RIC

eikon114

Hello,

I am trying to get the RIC of a list of banks I got through S&P Capital IQ. For each bank, I have their name, their primary industry, and sometimes their SNL, CIQ, CUSIP, ISIN and LEI identifiers. I converted the ISIN codes to RIC by using the code: ek.get_symbology( symbol = ISIN , from_symbol_type = "ISIN", to_symbol_type = "RIC"). However, I only have a limited number of ISIN identifiers available (only for one third of my sample). The problem is similar for the CUSIP identifier. I have much more SNL, CIQ and LEI identifiers, but they does not seem to be supported as inputs for the function ek.get_symbology. Do you know if there is a function where we could use either the CIQ, the LEI identifiers or even the name of the banks to get their RIC?

Thanks a lot in advance.

nick.zincone

Hi @eikon114

There is an RDP service (symbology) that will support the conversions you are after. For example, converting the following LEI to a RIC:

import refinitiv.data as rd
...

# Symbology
request_definition = rd.delivery.endpoint_request.Definition(
    method = rd.delivery.endpoint_request.RequestMethod.POST,
    url = 'https://api.refinitiv.com/discovery/symbology/v1/lookup',
    body_parameters = {         # Specify body parameters
        "from": [
            {
                "identifierTypes": ["LEI"],
                "values": ["549300561UZND4C7B569"]
            }
        ],
        "to": [
            {
                "identifierTypes": ["RIC"]
            }
        ],
        "path": [
            {
                "relationshipTypes": ["InverseIsPrimarySecurityOf"],
                "objectTypes": [
                    {
                        "from": "Organization",
                        "to": "AnyInstrument"
                    }
                ]
            },
            {
                "relationshipTypes": ["InverseIsValuationQuoteOf"],
                "objectTypes": [
                    {
                        "from": "AnyInstrument",
                        "to": "AnyQuote"
                    }
                ]
            }
        ],
        "reference": ["name","status","classification"],
        "type": "strict"
    }
)
response = request_definition.get_data()

# Dump the json response from the platform containing the results
response.data.raw

{'data': [
   {
      'input': [
      {
         'value': '549300561UZND4C7B569',     
         'identifierType': 'LEI'
      }],   
      'output': [
      {
         'value': 'TRI.TO',     
         'identifierType': 'RIC',     
         'name': 'THOMSON REUTERS ORD',     
         'status': 'Active',     
         'classification': 'Ordinary Shares'
      }]
   }], 
 'requestId': 'cae84148-61ce-4b1c-aac9-e2036035a519', 
 'effectiveAt': '2022-03-21T15:43:21.313Z', 
 'messages': []
}