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,

Find more posts tagged with

eikon

screener

workspace

equities

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

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.

All comments

Jirapongse

@cchen01

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.

Alex Putkov.1

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.

EXPLORE OUR SITES