What would be the best endpoint to use to grab all the RIC, ISIN, SEDOL etc. codes for a universe...

What would be the best endpoint to use to grab all the RIC, ISIN, SEDOL etc. codes for a universe of US stocks. Ideally using RDP.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @raymund.pornasdoro1

    You can use the RDP Search API to search for all codes in US stocks.

    The endpoint is https://api.refinitiv.com/discovery/search/v1/.

    The request is:

    {
      "View": "EquityQuotes",
      "Filter": "ExchangeCountry eq 'USA' and AssetType eq 'EQUITY' and AssetStateName eq 'Active'",
      "Select": "ExchangeCountry,RIC,CUSIP,SEDOL,AssetType,AssetStateName",
      "Top": 1000
    }

    The output is:

    {
      "Total": 230942,
      "Hits": [
        {
          "ExchangeCountry": "USA",
          "RIC": "TSLA.O",
          "CUSIP": "88160R101",
          "AssetType": [
            "EQUITY"
          ],
          "AssetStateName": "Active"
        },
        {
          "ExchangeCountry": "USA",
          "RIC": "AAPL.O",
          "CUSIP": "037833100",
          "AssetType": [
            "EQUITY"
          ],
    ...

    For more information, please refer to the API documentation or the Building Search into your Application Workflow article.