symbol_conversion wont convert CUSIPS that begin with a letter?

jgarden

I run the following code which works for ALL CUSIPS except those that begin with a letter

---

response = symbol_conversion.Definition(
    symbols=["G1151C101", "G5494J103", "56585A102", "22822V101"],
    from_symbol_type=symbol_conversion.SymbolTypes.CUSIP,
    to_symbol_types=[
        symbol_conversion.SymbolTypes.RIC,
    ],
).get_data()

response.data.df

any ideas?

thanks

Jeff

umer.nalla

hI @jgarden

Please try using CinsNumber as the identifierType for international CUSIPs.

symbologylookup_url = 'https://api.refinitiv.com/discovery/symbology/v1/lookup';

request_body={
  "from": [
    {
      "identifierTypes": [
        "CinsNumber"
      ],
      "values": [
        "G1151C101", "G5494J103"
      ]
    }
  ],
  "to": [
    {
      "identifierTypes": [
        "RIC"
      ]
    }
  ],
  "reference": [
    "name",
    "status",
    "classification"
  ],
  "filter": {
    "status": "active"
  },
  "type": "auto"
}


request_definition = rd.delivery.endpoint_request.Definition(
    method = rd.delivery.endpoint_request.RequestMethod.POST,
    url = symbologylookup_url,
    body_parameters = request_body
)
response = request_definition.get_data()
# Extract the data from the response
mydata = response.data.raw['data']

Unfortunately, the higher level symbol_conversion function does not yet support CinsNumber.

jgarden

Found a solution by using the eikon get_symbology method, not ideal but it works

---

df = ek.get_symbology(symbol=["G1151C101", "G5494J103", "56585A102", "22822V101"], from_symbol_type='CUSIP', to_symbol_type='RIC', best_match=False)

df['best'] = [i[0] for i in df['RICs']]

this will create a column in the DF using the first RIC in the list of RICs provided by the get_symbology method.

If there is a solution using the refinintiv data I would still love to see it.

Thanks

Jeff

jgarden

https://community.developers.refinitiv.com/discussion/comment/95011#Comment_95011

umer.nalla

Jun 24, 2022

hI @jgarden

Please try using CinsNumber as the identifierType for international CUSIPs.

symbologylookup_url = 'https://api.refinitiv.com/discovery/symbology/v1/lookup';

request_body={
  "from": [
    {
      "identifierTypes": [
        "CinsNumber"
      ],
      "values": [
        "G1151C101", "G5494J103"
      ]
    }
  ],
  "to": [
    {
      "identifierTypes": [
        "RIC"
      ]
    }
  ],
  "reference": [
    "name",
    "status",
    "classification"
  ],
  "filter": {
    "status": "active"
  },
  "type": "auto"
}


request_definition = rd.delivery.endpoint_request.Definition(
    method = rd.delivery.endpoint_request.RequestMethod.POST,
    url = symbologylookup_url,
    body_parameters = request_body
)
response = request_definition.get_data()
# Extract the data from the response
mydata = response.data.raw['data']

Unfortunately, the higher level symbol_conversion function does not yet support CinsNumber.

Thanks for your response though I found another solution using eikon's get data as well