Retrieve RIC codes from ISIN and Exchange in instrument search
I am currently working on retrieving RICs for instruments using the Refinitiv API, given an ISIN and exchange. I am using the endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch.
My goal is to obtain the specific RIC for a given exchange and ISIN from the search results.
For example, I am querying for an instrument with the ISIN: US912828H458 and exchange: New York Stock Exchange. However, in the response, I receive multiple identifiers and sources, but I cannot locate the exchange code for the New York Stock Exchange (NYS).
Here is a sample of the response I am receiving:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Content.ValidatedInstrument)",
"value": [
{
"Identifier": "912828H45",
"IdentifierType": "Cusip",
"Source": "U81",
"Key": "VjF8MHgwMDA0MDUxYzkwYzYxOTUyfDB4MDAwNDA1MWM5MGM2MTk1MnxVODF8R0NRVXxHT1ZUfEdCTkR8R3xOfHw",
"Description": "UST 0.250 01/15/25",
"InstrumentType": "GovCorpQuote",
"Status": "Valid"
},
{
"Identifier": "912828H45=RRPS",
"IdentifierType": "Ric",
"Source": "EJV",
"Key": "VjF8MHgwMDA0MDUxYzkwYzYxOTUyfDB4MDAwNDA1MWM5MjllNjQ3NXxEM058R0NCRHxHT1ZUfEdCTkR8R3xOfFVTOTEyODI4SDQ1PVBYfA",
"Description": "UST 0.250 01/15/25",
"InstrumentType": "GovCorpBond",
"Status": "Valid"
}
..
],
"@odata.nextlink": "https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch?$skiptoken='MTA'"
}
I have attempted to filter by source, but I am still unable to find the corresponding exchange code.
Best Answer
-
You are using an incorrect exchange. This instrument is not on LSE but on EJV.
{ "Identifier": "GB00BNNGP551", "IdentifierType": "Isin", "Source": "EJV" },
Response:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [{
"IdentifierType": "Isin",
"Identifier": "GB00BNNGP551",
"RIC": "GBIL0E31=RRPS",
"ISIN": "GB00BNNGP551",
"Currency Code": "GBP",
"Exchange Code": "EJV",
"Exchange Code List": null
}
],
"Notes": [For any content related clarifications please raise a support ticket at LSEG myaccount - LSEG MyAccount
0
Answers
-
Hi @enakach,
This DSS article on ISIN to RIC conversion describes the process in quite detail. Does it solve your issue?
0 -
Thank you for your answer; it was helpful.
I have used the extract with notes endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes as suggested in the article to retrieve the RIC codes. However, I am encountering issues with the responses. Out of 1143 instruments, only 81 returned rics codes successfully. For the majority, I received the following response:
example of isins I was looking for:
ISIN: "GB00BNNGP551", exchange code: LSE
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "ISIN", "Currency Code", "Exchange Code", "Exchange Code List"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "GB00BNNGP551", "IdentifierType": "Isin", "Source": "LSE" },
],
"ValidationOptions": {
"AllowHistoricalInstruments": true,
"AllowInactiveInstruments": true,
"AllowOpenAccessInstruments": false
},
"UseUserPreferencesForValidationOptions": false
}
}
}and this is the reponse I am getting (similar response for all 1062 instruments)
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [{
"IdentifierType": "Isin",
"Identifier": "GB00BNNGP551",
"Error": "Not found"
}],
"Notes": ["All identifiers were invalid. No extraction performed."]
}0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛