I have already used the historical search on REST API. But the issue is that it is for a single I...

Options
Manigandan.R
Manigandan.R LSEG
in TRTH
I have already used the historical search on REST API. But the issue is that it is for a single Isin or a single Sedol. We need an API which will help us to get the Ric codes for a list of Isins/Sedols/Cusips. Is there a way?
Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @Manigandan.R, it is not quite clear what you are trying to achieve, there seem to be 2 different queries here.

    In the title you ask: "We need an API which will help us to get the Ric codes for a list of Isins/Sedols/Cusips. Is there a way?".

    Answer 1: you can use a Historical Reference extraction request, which takes as input a list of instruments (you can mix ISIN, CUSIP, SEDOL etc.) and return the corresponding RICs. In other words, this will do a bulk conversion of ISINs/SEDOLs/CUSIPs into RICs. As there will be several RICs per input instrument, you can also request the currency and/or exchange code in order to filter the results.

    Note that this can be done easily in the API with an On Demand request, which does not require a instrument list to be present on the server. Instead the instrument list is passed as a parameter.

    This is described in REST API tutorial 10 (which was recently changed to illustrate an HR (Historical Reference) call instead of a T&C (Terms & Conditions) call, because T&C will not return historical results whereas HR will). The corresponding Postman HTTP requests are available in the latest downloadable Postman collection, under the downloads tab.

    Then I see a different query: "how do I import a LIST of ISINs or CUSIP or SEDOL or RICs at a time". Is this related to the above query, or is it unrelated ?

    Answer 2: if it related, then the answer is that it is not necessary to load the list of ISINs, CUSIPs and SEDOLs in the server to be able to retrieve the equivalent RICs, as explained in Answer 1.

    Answer 3: if it is not related, am I right in guessing you just want to create a list of instruments on the server, for later usage in scheduled queries ? If yes, then you can easily create a list, and add instruments, using the API. That is described in detail in steps 3 and 4 of the REST API Tutorial 12.

    Maybe I have misinterpreted your query ? If yes, then please provide more details on what you are trying to achieve.

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    You can use On Demand Term and Conditions extraction. The request contains the list of identifiers with different types and the list of required content fields.

    {
      "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
         "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code"
        ],
        "IdentifierList": {
          "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
          "InstrumentIdentifiers": [
            {
              "Identifier": "00209tab1",
              "IdentifierType": "Cusip"
            },
            {
              "Identifier": "IBM.N",
              "IdentifierType": "Ric"
            },
            {
              "Identifier": "US4592001014",
              "IdentifierType": "Isin"
            },
            {
              "Identifier": "B1YW440",
              "IdentifierType": "Sedol"
            }
          ]
        }
      }
    }

    The response will contains the requested content fields.

    {
      "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
      "value": [
        {
          "IdentifierType": "Cusip",
          "Identifier": "00209TAB1",
          "RIC": "00209TAB1=RRPS",
          "CUSIP": "00209TAB1",
          "ISIN": "US00209TAB17",
          "SEDOL": "2166502",
          "Issuer OrgID": "172642",
          "Currency Code": "USD"
        },
        {
          "IdentifierType": "Ric",
          "Identifier": "IBM.N",
          "RIC": "IBM.N",
          "CUSIP": "459200101",
          "ISIN": "US4592001014",
          "SEDOL": "2005973",
          "Issuer OrgID": "18228",
          "Currency Code": "USD"
        },
        {
          "IdentifierType": "Isin",
          "Identifier": "US4592001014",
          "RIC": "IBM.N",
          "CUSIP": "459200101",
          "ISIN": "US4592001014",
          "SEDOL": "2005973",
          "Issuer OrgID": "18228",
          "Currency Code": "USD"
        },
        {
          "IdentifierType": "Sedol",
          "Identifier": "B1YW440",
          "RIC": "LP71000002",
          "CUSIP": null,
          "ISIN": "GB00B1YW4409",
          "SEDOL": "B1YW440",
          "Issuer OrgID": "100691344",
          "Currency Code": "GBp"
        }
      ]
    }

    For more information, please refer to REST API Tutorial 10: On Demand T&C extraction.

  • Manigandan.R
    Manigandan.R LSEG

    cusersu6031025documentsisin.txtThank you for the response. If I may clarify the question -

    jirapongse.phuriphanvichai

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/13819#Comment_13819

    @Manigandan.R

    Refer to the REST API Reference Tree in Search section, I couldn't find a function that is equivalent to Bulk Search. However, you can use the TermsAndConditionsExtractionRequest mentioned in the first answer or HistoricalReferenceExtractionRequest to retrieve the required data.

Categories