question

Upvotes
Accepted
2 0 0 2

How to retrieve exchange-specific RIC from ISIN input

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!

ricssymbologyexchanges
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.

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...


Upvotes
Accepted
53.2k 138 44 63

@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:

1655107961132.png

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


1655107961132.png (21.5 KiB)
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.

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!


Upvote
53.2k 138 44 63

@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.

1655115669310.png

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')"

1655115669310.png (106.5 KiB)
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.

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!