For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
enakach avatar image
1 ●0 ●0 ●1

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.

search.png

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.

dss-rest-api#contentricssearch
search.png (53.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
24.4k ●62 ●15 ●21

@enakach,

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Gurpreet avatar image
24.4k ●62 ●15 ●21

Hi @enakach,

This DSS article on ISIN to RIC conversion describes the process in quite detail. Does it solve your issue?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
enakach avatar image
1 ●0 ●0 ●1

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."]

}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.