Retrieve list of instruments for all stocks on an exchange

armandnaude

Greetings

I wish to perform breadth analysis on an exchange. How would I go about getting a list of all issues/stocks on an exchange that I need to query?

Regards, and thank you

Zhenya Kovalyov

You can do so by using on of the COM APIs RSearch (here is the tutorial and the related download). Your asset class in this case will be "EQUITY", and the search criteria look like this (for example, London Stock Exchange):

"ExchangeCode: 'LSE' IsPrimaryQuote:Yes"

The result will be the full list of shares traded on LSE.

jayhtchan

any .net sample code for this? thanks

Zhenya Kovalyov

https://community.developers.refinitiv.com/discussion/comment/8911#Comment_8911

comapiusageexamplesyncsearchapi.zip

Here you are. Make sure you reference Interop.Rsearch.dll from the correct location, so it compiles.

%PROGRAMFILES(X86)%\Thomson Reuters\Eikon\<X, Y or Z folder>\Bin\Apps\TR.OFFICE.CORE\0.0.0.0\Bin\Interop.RSearch.dll

To see your active version of Eikon and determine with folder (X, Y or Z) to use, you can open

%PROGRAMFILES(X86)%\Thomson Reuters\Eikon\Eikon.exe.xml and read the BinFolder tag.

Muzammil.Sharief

Hi,

Trkd api is a demand based product and is not meant for bulk download. The maximum no. of results one can fetch is 4020 therefore you need to apply filters to refine the result.

You need to apply filters like exchange code = LSE, asset catergory = ORD and GICS code = 10102010 to get the results.

Thanks

Muzammil

Zhenya Kovalyov

https://community.developers.refinitiv.com/discussion/comment/8900#Comment_8900

Thanks for your post Muzammil. This is very insightful information about the bandwidth limits designed for TRKD API usage. However I believe @armandnaude is looking for a solution within Eikon, by posting in the Eikon COM forum. This can be confusing as both Eikon COM and TRKD host a function called RSearch

armandnaude

https://community.developers.refinitiv.com/discussion/comment/8895#Comment_8895

Greetigns Zhenya
Is it possible to do this type of query at a point in time (specific day) in the past?
Thank you kindly for all your help!

Zhenya Kovalyov

https://community.developers.refinitiv.com/discussion/comment/9180#Comment_9180

Hi @armandnaude! I could not find a search criteria like that, so looks like no.

h24cui

When I use the RSearch function, I can only retrieve up to 2000 instrument at a time. Is there any way to handle this issue? Thanks.

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/12953#Comment_12953

Generally no. For some searches you may be able to order the results by some criteria and use the result of the previous query as a criteria for the next one, thus retrieving the next batch of 2K instruments. E.g. if you're searching for all stocks listed on an exchange you can order the result by market cap descending. Then use the lowest of the market cap for stocks in the result set as an additional criteria for the next query, e.g. "ExchangeCode:'FRA' MktCapCompanyUsd:<..." and so on. But this is only possible for some searches.

a01531951

I see that the repository is not available anymore, is there an easier way to do it now days?