Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
cchen01 avatar image
11 ●5 ●7 ●10

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,

eikoneikon-data-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apiequitiesscreener
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @cchen01

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


Alex Putkov.1 avatar image   Alex Putkov.1

@cchen01

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

2 Answers

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
78.9k ●250 ●52 ●74

@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.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.