Search API filter
Hi everybody! I am currently utilizing the Search API for my project, which involves gathering data on delisted companies. I have successfully collected the required data, but I am now facing a challenge in filtering this dataset to include only companies based in the United States. Despite trying various values, I have not been able to retrieve any relevant data.
Could anyone guide how to adjust my code to effectively filter for U.S. companies that were also delisted in the past two years?
Thank you in advance for your assistance.
def search_delisted_companies():
response = rd.discovery.search(
view = "Organisations
filter = "OrganisationStatus xeq 'Delisted'",
select ="DocumentTitle, DelistedDate, OrganisationStatus, ReasonDelisted
top = 100
)
return response
Best Answer
-
Hi @vitali ,
I have the impression that `OrganisationStatus` is only `Unlisted` or `Listed`. Have you tried:
rd.discovery.search(
view = "Organisations",
filter ="OrganisationStatus xeq 'Unlisted'",
select ="DocumentTitle, DelistedDate, OrganisationStatus, ReasonDelisted, IsExchangeListed",
top = 100
)1
Answers
-
Hi, @jonathan.legrand. I'm able to retrieve the Delisted companies. My current objective is to refine this dataset by applying a filter that will allow me to exclusively obtain information on companies based in the United States, focusing specifically on those delisted within the last two years.
0 -
Hi @vitali, TO find US companies, please try:
rd.discovery.search(
view = "Organisations",
filter ="OrganisationStatus xeq 'Unlisted' and RCSCountryHeadquartersLeaf eq 'United States'",
select ="DocumentTitle, DelistedDate, OrganisationStatus, ReasonDelisted, IsExchangeListed, RCSCountryHeadquartersLeaf",
# "RCSCountryHeadquartersName, RCSCountryHeadquarters, RCSCountryName" +
# "RCSCountryHeadquarters, RCSCountryHeadquartersGenealogy, RCSCountryHeadquartersLeaf, " +
# RCSCountryHeadquartersLeafML, RCSCountryHeadquartersName, RCSCountryHeadquartersNameML, " +
# RCSCountryLeaf, RCSCountryLeafML, RCSCountryName, RCSCountryNameML",
top = 100,
# order_by="DelistedDate"
)When it comes to the `DelistedDate` field not working, I'm afraid that we are straying too far into a content question. For such questions, please reach out to my.refinitiv.com. Have you tried raising a ticket there? You may have to specify that you are inquiring about the content field indicative of "company's listing status" that is filterable.
1 -
Thank you very much for your assistance; I truly appreciate it.
I plan to contact my.refinitiv.com for further information regarding the DelistedDate.
Thank you once again for your support.
0 -
Hi @vitali
Try with the code below:
rd.discovery.search(
view=rd.discovery.Views.EQUITY_QUOTES,
filter="OrganisationStatus eq 'Delisted' and RCSIssuerCountryLeaf eq 'United States' and RetireDate ge 2024-02-01",
top=1000,
select="RIC, CommonName, RetireDate, OrganisationStatus"
)0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛