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?
Best Answer
-
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)0
Answers
-
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.0 -
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!
0 -
When you say "loop for each name in list" do you mean that you call get_data on the names one at a time? That seemed to work for me. I also added some try excepts to catch HTTPErrors (which are usually returned when the request times out), and KeyErrors (which usually means that the request returned no result).
0 -
The easiest will probably be to use the =RSearch function in Excel. It doesn't accept a list of names, you can use only one name as a criteria per instance of the function. But the function can be easily multiplied by copying it down the column, and it's not subject to restrictions on the number of requests. Name search is inherently ambiguous and imprecise, but I'm sure you're well aware of this.
0 -
dshi, is it appropriate to ask you share your code? I am complete novice here and in python. Thanks!
0 -
Alexander, but the output will differ depending on the name in the request, should I write something like macros to resolve this issue? Unfortunately, I have only names, so such way of searching is only possible for me. Thanks!
0 -
Not sure If I'm allowed to share the whole thing, but this is how you might call the function for one company.
fields = ["TR.OrganizationID"]
'''where "search" would be the name of a company'''
exp = "SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.CommonName,%s), CURN=CAD)" %search
df, e = ek.get_data(exp, fields)0 -
I'm not sure I understand the issue. Yes, the output will differ depending on the input. There's no need for any macros. You can use cell referencing to read the inputs, e.g. assuming that the company names are in column A in cell B1 enter =RSearch("EQUITY","Search:'"&A1&"'",,"TRANSPOSE:YES"). Then you can copy the function down column B.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 629 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 84 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛
