Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by XeL Arjona · Jul 03, 2017 at 03:55 PM · pythonpython apisearchscreeningrsearch

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

ml11
veyrejulien

People who like this

2 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Jul 03, 2017 at 05:04 PM

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by vlscout · Jul 11, 2017 at 06:03 AM

@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.thomsonreuters.com/questions/11063/using-screener-queries-in-the-scripting-api.html

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

Comment
Christiaan Meihsl

People who like this

1 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Alex Putkov. ♦♦ · Jul 11, 2017 at 12:08 PM 0
Share
@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.
avatar image
blucap · Oct 13, 2017 at 12:39 AM 0
Share

Neat!

How would this work for

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

Many thanks!

avatar image
REFINITIV
Alex Putkov. ♦♦ blucap · Oct 17, 2017 at 10:13 AM 0
Share

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.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

Screening using name contains

Why does Eikon Python API return empty fields on certain names?

Is it possible to get macroeconomic indicators with an API?

Request CF_LAST in a particular currency.

What is the field COUNT and what does it mean when it is assigned with -1?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges