[Python API] How to fuzzy search for companies by name ?

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!

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

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.

All comments

kiriger

This question is similar, but the answers do not cover fuzzy matching and constraints:

https://community.developers.refinitiv.com/questions/37096/screening-using-name-contains.html?redirectedFrom=37019

Alex Putkov.1

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)

kiriger

Thanks, Alex. Are there boolean operators that can be used in conjunction with Contains?

Imagine there is a complex names with multiple words which may be in different forms including abbreviations. One way to search for such an entry would be to split it into words or ngrams, potentially, at character level, and use AND and OR to build up query expression.

For example:

OR(
  AND(
    Contains(..., "that-co"),
    Contains(..., "inc")
  ),
  AND(
    Contains(..., "that"),
    Contains(..., "company"),
    Contains("incorporated")
  )
)

EXPLORE OUR SITES