Getting CUSIP/ISIN for stock RIC code

ns3481
ns3481 Newcomer

Hi Team,


I have a list of RIC codes and I'm trying to get the corresponding CUSIP/ISIN and the dates for which the mapping is valid using RTH Python. I use the following code, but the CUSIP field always returns a null value. Not sure about the corresponding field for the Bloomberg ticker.


instrument_list = [{'Identifier': '3412583.XD', 'IdentifierType': 'Ric'},
{'Identifier': 'A.N', 'IdentifierType': 'Ric'},
{'Identifier': 'AA.N', 'IdentifierType': 'Ric'},
{'Identifier': 'AAL.N', 'IdentifierType': 'Ric'},
{'Identifier': 'AAL.OQ', 'IdentifierType': 'Ric'}]
requestBody = {
'ExtractionRequest': {
'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest',
'ContentFieldNames': [ "Company Name", "Currency Code", "CUSIP", "ISIN", "Start date", "Change Date",],
'IdentifierList': {
'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList',
'InstrumentIdentifiers': instrument_list,
'ValidationOptions': {'AllowHistoricalInstruments': 'true', 'AllowInactiveInstruments' : 'true'},
"UseUserPreferencesForValidationOptions": 'false'
},
"Condition": {"ReportDateRangeType": "Range", "QueryStartDate": "2010-01-01", "QueryEndDate": "2015-09-09"}
}
}

requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes';

requestHeaders_extraction = {
'Prefer':'respond-async',
'Content-Type':'application/json',
'Authorization': 'token ' + auth_token
}

extraction_response = requests.post(requestUrl, json = requestBody, headers = requestHeaders_extraction)


can you please help me with the correct 'ContentFieldNames'/quert?

Thanks.

Best Answer

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.