question

Upvotes
Accepted
3 0 1 2

How to get the PrimaryRIC for a large list of ISINs?

I am trying to get the PrimaryRIC for a large list of ISINs. If I do it one by one I get the correct result (see below).


What I really want is to include multiple ISINs - "Filter": " IssueISIN in ( 'US02079K1079', US0378331005, US88160R1014 etc. ) " - and only show the top results for each ISIN, not the combined.


Endpoint: https://api.refinitiv.com/discovery/searchlight/v1/

REQUEST:

{

"View": "EquityQuotes",

"Filter": "IssueISIN in ('US02079K1079')",

"Select": "RIC, PrimaryRIC, ExchangeCode, IssuerShortName",

"Top": 1

}


RESPONSE:

{

"Total": 93,

"Hits": [

{

"RIC": "GOOG.O",

"PrimaryRIC": "GOOGL.O",

"ExchangeCode": "NSQ",

"IssuerShortName": "Alphabet"

}

]

}


Hope you could help me with this.

ricssearch
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
Accepted
13k 61 39 63

Hi @darryl.cantre01,

Using the endpoint: https://api.refinitiv.com/discovery/searchlight/v1/lookup

Try something like this:

{
  "View": "SearchAllLight",
  "Scope": "IssueISIN",
  "Terms": "GB00BH4HKS39,US0378331005,US4592001014,US5949181045",
  "Select": "DocumentTitle,RIC"
}

Will give you:

{
  "Matches": {
    "GB00BH4HKS39": {
      "DocumentTitle": "Vodafone Group PLC, Ordinary Share, London Stock Exchange",
      "RIC": "VOD.L"
    },
    "US0378331005": {
      "DocumentTitle": "Apple Inc, Ordinary Share, NASDAQ Global Select Consolidated",
      "RIC": "AAPL.O"
    },
    "US4592001014": {
      "DocumentTitle": "International Business Machines Corp, Ordinary Share, NYSE Consolidated",
      "RIC": "IBM"
    },
    "US5949181045": {
      "DocumentTitle": "Microsoft Corp, Ordinary Share, NASDAQ Global Select Consolidated",
      "RIC": "MSFT.O"
    }
  }
}
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
24.9k 86 10 22

Hi @darryl.cantre01

Do you have access to the Symbology API? If so, try the following example:

GitHub - Refinitiv-API-Samples/Example.RDPLibrary.Python.ConvertSymbology: Simple notebook to convert ISINs (or other Symbology) to RICs using the Refinitiv Data Platform Symbology API

It loads ISINs from a file and then tries to get PrimaryRIC for each, followed by non-primary for those that fail the first search.


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.