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
mdziel avatar image
7 ●2 ●2 ●3

Eikon codes for delisted companies

I'm trying to write a script to download data of delisted companies from Eikon. I have tickers of these companies, so the first step would to create the RIC, which in the case of delisting also includes a suffix of the type ^B19 (where 19 would be the year of the delisting). I have delisting dates, so the digit part is not a problem but the letter seems to be a bit random, e.g. for a company delisted in 2018 it was ^H18...

Does anyone know if there is any logic to this and if it's possible to reconstruct the "delisted RIC" from ticker and delisting date?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apidatarics
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.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @mdziel

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

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

Hello @mdziel,

The letter signifies the month of the delisting (A = January, B=February …)

Please see How are delisted codes indicated in Datascope for the explanation of the approach, you will need to login with your my.refinitiv customer account.

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.