DSS Rest api: How to search for a ISIN given a ticker and maturity year

sumit
sumit Explorer
edited January 17 in DSS

Hi,

I am trying to understand how I can query the DSS Rest api and get back the ISIN for a bond given simply a ticker (i.e. Issuer) and a maturity year. Ex:- ticker=KMI and maturity_year = 2045.

This should give me back the ISIN: US49456BAH42

Any example code would be very helpful

Thanks

Sumit

Tagged:

Best Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @sumit

    Thank you for reaching out to us.

    It could be the GovCorpSearch and you can use it with the HTTP POST method. The endpoint is:

    https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/GovCorpSearch

    The request message is:

    {
    
    "SearchRequest": {
    
        "Ticker": "KMI",
    
        "PreferredIdentifierType": "Isin",
    
        "MaturityDate": {
    
            "@odata.type": "#DataScope.Select.Api.Search.DateRangeComparison",
    
            "From": "2045-01-01T00:00:00.000Z",
    
            "To": "2045-12-31T00:00:00.000Z"
    
        }
    
    }
    
}

    The output is:

    image.png

    For other parameters, please refer to the REST API Reference Tree.

  • sumit
    sumit Explorer
    Answer ✓
    https://community.developers.refinitiv.com/discussion/comment/123544#Comment_123544

    What is the Source ? I get 37 values back where the Source is different

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/123566#Comment_123566

    It should be an exchange. However, please contact the Datascope Select support team directly via MyAccount to confirm it.

  • sumit
    sumit Explorer
    https://community.developers.refinitiv.com/discussion/comment/123570#Comment_123570

    Thanks a lot. One final question, in the request object, how can I specify both active & inactive bonds? Here's an example that I wish to retrieve….
    So essentially, ticker = TEVA and maturity_date_from: 01/02/2021 to 31/12/2021

    bond_search_inactive.png
  • Jirapongse
    Jirapongse ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/123585#Comment_123585

    @sumit

    I tested it on the DSS Web UI and couldn't find a way to do it.

    However, please contact the DSS support team directly via MyAccount to verify if the DSS searches support this kind of usage.

    If we can do it via the DSS Web UI, it could be possible in the DSS REST API.

  • sumit
    sumit Explorer

    Just for people who are after a similar solution, here's the response i received from support team…

    =======================================

    https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalSearchHi Sumit, Since these ISINs are matured you should use historical instrument search instead. That being said, the search options on DataScope are quite limited. Below is an example code:{
        "Request": {
            "RicPattern": "=",
            "BondTypeCodes": [],
            "ContributorIds": null,
            "CountryCodes": null,
            "CurrencyCodes": ["840"],
            "DomainCodes": null,
            "ExchangeCodes":[],
            "InstrumentTypeCodes": null,
            "CouponRate": null,
            "StrikePrice": null,
            "MaturityDate": {
                 "Start": "2021-11-10T00:00:00.000Z",
                "End": "2021-11-10T00:00:00.000Z"},
            "Range": {
                "Start": "2021-11-10T00:00:00.000Z",
                "End": "2021-11-10T00:00:00.000Z"
            },
            "ResultsBy": "Ric"
        }
        }Since there's no ticker or name field, it would give a lot of results. Instead I suggest to use:  {
            "Request": {
        "IdentifierType": "Isin",
        "Identifier": "US88166JAA16",
        "Range": {
            "Start": "2021-01-01T00:00:00.000Z",
            "End": "2021-12-31T00:00:00.000Z"
        },
        "ResultsBy": "Ric",
        "DomainCodes": []
            }    
    }and just search for the instrument using ISIN. https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalCriteriaSearch

Categories