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

raymund.pornasdoro1

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.

Jirapongse

@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.