question

Upvotes
Accepted
darryl.cantre01 avatar image
3 ●0 ●2 ●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.

Shadab Hussain avatar image   Shadab Hussain

Hi @darryl.cantre01,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.


Thanks,

AHS

2 Answers

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
17.1k ●80 ●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
umer.nalla avatar image
25.3k ●87 ●12 ●25

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.