Extracting List of Delisted Equities using Screener, RDP. or Eikon API

Hello,
I am looking for a way to pull a list of delisted equities using either Screener, the Eikon API, or RDP. The output can be in the form of a data structure in python or an Excel file.
Thanks,
Best Answer
-
Here's an example using RDP Library to access RDP Search service to retrieve stocks delisted from the US exchanges in 2021
rdp.search(view = rdp.SearchViews.EquityQuotes,
filter = "ListingStatus eq 'DEL' and ExchangeCountry eq 'USA' and RetireDate gt 2021-01-01",
select = "RIC, DocumentTitle, RetireDate",
top=10000)For details about RDP Search service see the article titled Building Search into your Application Workflow.
0
Answers
-
You can use the Screener application in Eikon Excel to create a formula and then apply the formula to the Eikon Data API. For more information, please refer to Find Your Right Companies with SCREENER | Eikon Data APIs(Python).
If you need help using the Screener application, please directly contact the Eikon support team via MyRefinitiv. They can provide you with the formula to retrieve the required information.
0
Categories
- All Categories
- 3 Polls
- 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
- 615 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
- 249 ETA
- 554 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
- 643 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
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛