New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
dimitrakopoulos01 avatar image
3 ●0 ●0 ●2

Obtain matching RIC for passed ISIN + MIC + Currency combination

I have a list of securities (ISIN + MIC + Currency which allows to uniquely identify them) for which I am looking to obtain the matching RIC using datascope select.

For example:

  • US88160R1014, XNAS, USD
  • US0378331005, XNAS, USD
  • US6516391066, XNYS, USD

I scoured the different questions on the Q&A portal but none provides a concrete answer. Is there a straight-forward way to achieve this?

p.s. I can think of work-arounds (e.g. get all securities listed under a given MIC, match vs. the ISIN etc.) but this would entail numerous API calls (therefore sub-optimal)

#technologydatascope-select
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.

1 Answer

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
25.1k ●68 ●15 ●21

Hello @dimitrakopoulos01,

Please take a look at these articles which talk a bit about the symbology conversion from ISIN and other security identifiers:

Symbology (ISIN/CUSIP/SEDOL) conversion to RIC using DataScope

ISIN to RIC conversion with the DSS (DataScope Select) REST API


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.

dimitrakopoulos01 avatar image dimitrakopoulos01

Thanks a lot for the feedback @Gurpreet - after reading all the material you posted (thank you #1) and consulting @alejandro.lesaga (thank you #2), concluded there is no need to go over the TermsAndConditionsReportTemplate. Opted for the simpler / lighter approach of using the EndOfDayPricingExtractionRequest and creating a mapping table between the Refinitiv exchanges and the MICs (as per ISO-20022) - this allows me to:

  1. Pass a list of identifiers: ISIN + MIC + CurrencyCode
  2. Convert the MIC into a Refinitiv Exchange (as per the mapping mentioned above)
  3. Place the request with the ISIN + Source combination
  4. Fetch the response and match for the CurrencyCode I need from [1]
  5. Extract the matching RIC (to be used later on for the needed data extractions)
1731077938949.png

1731077938949.png (194.8 KiB)

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.