Screening using name contains

exp =  "SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,CA), CURN=CAD)"


exp = "SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.CommonName,%s), CURN=CAD)" %name


fields = ["TR.CompanyName"]


df,e = ek.get_data(exp, fields)

The first exp works, but the second one does not. How is the "Contains" argument supposed to be used?

Find more posts tagged with

eikon

workspace

eikon-data-api

workspace-data-api

refinitiv-data-platform-eikon

Accepted answers

Jirapongse

@dshi

The name should in double quotes. I have tried this one and it works.

name = '"Business"'
exp = 'SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.CommonName,%s), CURN=CAD)' %name
fields = ["TR.CompanyName"]
df,e = ek.get_data(exp, fields)
print (df)

All comments

Jirapongse

@dshi

The name should in double quotes. I have tried this one and it works.

name = '"Business"'
exp = 'SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.CommonName,%s), CURN=CAD)' %name
fields = ["TR.CompanyName"]
df,e = ek.get_data(exp, fields)
print (df)

dshi

Thanks!
Also wanted to say that for some reason,

exp = 'SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.CommonName,\"%s\"), CURN=CAD)' %name

Doesn't work.

i-sergeeich

Dear dshi,

Could you say whether it is possible to send list of names and receive all result? I have around 3k company names, where ISIN or similar is not available, so I can search only by names. If i try loop for each name in list than there will be an error indicating too much requests. So is there any way to send list of names and get rics using python or excel maybe (if put all names in a column). Here I am looking for something like get_symbology, where one can send list of ISINs and receive list of RICs.

Thank you very much!

EXPLORE OUR SITES