Obtain matching RIC for passed ISIN + MIC + Currency combination

dimitrakopoulos01

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)

Gurpreet

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

dimitrakopoulos01

https://community.developers.refinitiv.com/discussion/comment/122635#Comment_122635

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)