question

Upvotes
Accepted
3 0 0 2

Equivalent of TR.RICS for equity

Hi all,

I'm using the Eikon Excel add-in to retrieve time series data for a number of instruments over a range of brokers/exchanges. For bonds, it is fairly easy to derive a set of appropriate RICs from a given ISIN using the TR.RICS parameter or a chain query. However, I have not been able to find a similar functionality for equity instruments, despite seeing up to 30 exchanges an instrument is traded on in its AQ window. Starting with an ISIN, is there a way to obtain a list of these RICs within Excel?

Thanks!

eikoneikon-com-apiexcel
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

You can use RSearch function to retrieve the list of RICs given an ISIN for an equity, e.g.

=RSearch("EQUITY","IssueISIN:US0378331005 RawContextFilter:'AssetState ne \'DC\''","NBROWS:100")
To familiarize yourself with the parameters of the function and to help you construct it follow the wizard behind the Search button under Thomson Reuters tab in Excel ribbon. Once you've selected your search criteria click the button with icon depicting a function symbol "f(x)" to insert RSearch function into the worksheet.
If you have any further questions about using Eikon Excel, please contact Refinitiv Helpdesk. This forum is dedicated to software developers using Eikon APIs. Refinitiv Helpdesk can be reached by using Contact Us capability in your Eikon application or by calling the Helpdesk number in your country.
icon clock
10 |1500

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

Click below to post an Idea Post Idea