How to retrieve exchange-specific RIC from ISIN input

tom.derwort01

Hi , I am aware this question was asked before, but since the advanced time since it was asked in 2017 I was wondering if there was a more elegant and proper way to retrieve the RIC for an instrument at a specific exchange now? Hope there is since the existing solution are not very satisfying. And if there is no direct way, is there a way through the refinitiv library? (Trying to avoid eikon library if possible)

Thanks for the help in advance!

Jirapongse

@tom.derwort01

You can use the RDP /discovery/search/v1/explore endpoint with the Refinitiv Data Python Library.

The code looks like this:

response = search.Definition(
    view=search.SearchViews.SEARCH_ALL,
    select="ExchangeCode, RIC, IssueISIN", 
    filter="(IssueISIN eq 'LU0100938306' and ExchangeCode eq 'STU')"
).get_data()
response.data.df

The output is:

I used the EX-2.06.01-Search.ipynb example on GitHub.

tom.derwort01

This would be the request I want to do in Python:

=@RSearch("FUND","Search:LU0100938306,ExchangeCode:STU,NBROWS:1")

As an example, obviously then for a whole list of ISIN's...

tom.derwort

Awesome thank you! That helps a lot. I saw the example too but couldnt really figure out how to search for what I wanted. Im still pretty new to python. How/Where did u find the necessary syntax to the search function?

Can I use this example in combination for a whole row of ISINs of a dataframe by combining the row instead of the ISIN in the search or would I need to change it?

Thanks again for all the help so far!

Jirapongse

@tom.derwort

You can find more information regarding the RDP /discovery/search/v1/explore endpoint in the API Playground. Search for the RDP /discovery/search/v1 endpoint and then go to the Reference page of the /explore endpoint.

For multiple ISINs, you can try the following fiters:

• "(IssueISIN eq 'LU0100938306' and ExchangeCode eq 'STU') or (IssueISIN eq '<ISIN>' and ExchangeCode eq '<Exchange Code') or ..."
• "(IssueISIN in ('LU0100938306' '<ISIN_1>' '<ISIN_2>') and ExchangeCode eq 'STU')"

tom.derwort

Awesome thank you so much! I actually never cheked the playground cause I thought it was something else. But thanks so much I think that'll help a lot!