Hi, thanks for taking a look. See subj.
Ideally, search would retrieve top N entries.
Even better, it would let me constrain the search scope to companies that are registered in a given country (precise match by code), operate in a given industry sector (either precise match by a symbology or a fuzzy one given keywords or a precise match against a list of options ("contains")) and / or have turnover (or other financials) in a given range -- and still return top N of those satisfying the constraints.
How can that be achieved using the Python API ?
Thanks in advance!
Fuzzy search is not available in Eikon. You can however combine exact string match name search with other criteria in Eikon Screener. Here's an example returning public companies containing the word "resources" in the company name, headquartered in the US and falling under Financials sector according to Thomson Reuters Business Classification scheme (TRBC).
name = '"resources"' exp = ('SCREEN(U(IN(Equity(active,public,primary))),' + ' Contains(TR.CommonName,%s),' %name + 'IN(TR.HQCountryCode,"US"),' + 'IN(TR.TRBCEconSectorCode,"55"))') fields = ['TR.CompanyName'] ek.get_data(exp, fields)To construct Screener expression follow the wizard behind Screener button under Thomson Reuters tab in Excel ribbon. You may also want to watch a series of short video tutorials titled "Working with the Screener" available from the main Eikon menu - Help - Tutorials and Training. Type in "Screener" in the search bar a click on "Working with the Screener" in the results.
This question is similar, but the answers do not cover fuzzy matching and constraints: