For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
31 1 1 3

Get Instruments by exchange or country?

For Python API:

I read at Q&A there is a way to retrieve (limited to 2k) list of instruments by the RSearch COM API.

Is there a current way (beta) or any future plans to do it programmatically by the wonderful Python API..? Screening is one of the main advantages of moving from desktop frameworks to Scripting API's, and if we can't have availability of total universe to start filtering from other fields (MktCap,SecotrIndustryCODE,Type,etc)...so...?! :D

Thanks in Advance!

XeL

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-apiscreeningsearch
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.

Upvotes
Accepted
39.2k 75 11 27

There's no definitive timeframe for it yet, but yes, there's a plan to add equity screener capability (similar to the equity screener in Eikon application and in Eikon Excel) to Eikon Python API. There's currently no plan to introduce criteria search capability for other asset classes.

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.

Upvote
38 0 2 4

@XeL Ariona @Alex Putkov.

Screening in the python API already works as long as you know the screening string. To get that, you first build your screen in Eikon application, then click "export as formula", and look at the formula in Excel.

For example, the following gets you 1161 french RICs:

screener_exp = 'SCREEN(U(IN(Equity(active,public,primary))),IN(TR.ExchangeCountryCode,"FR"), CURN=USD)'

companies_data, err = ek.get_data(instruments=[screener_exp], fields=['TR.RIC'])

print(companies_data)

Look at this as well

https://community.developers.refinitiv.com/questions/11063/using-screener-queries-in-the-scripting-api.html

Maybe Alex meant development of a stand alone screening GUI in the Proxy?

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.

@vlscout
I was actually referring to the very capability you discovered. And what I meant is that, while the capability is accessible, it is purposely not documented yet because it's still in development and is not yet supported.

Neat!

How would this work for

  1. a sector, say banks?
  2. other instruments, e.g. contingent convertible bonds?

Many thanks!

The best way to explore this capability is through the GUI in Eikon Excel add-in. Click on the Screener button in Thomson Reuters ribbon in Excel.

Click below to post an Idea Post Idea