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
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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.
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
