How can I transcode from normal RIC to delisted RIC so that I can query the price?

Hi Team,

I am writing on behalf of Mr. Max Zhu. How can he transcode from normal RIC to delisted RIC so that he can query the price?

"For example, for PEUP.PA I need to transcode to PEUP.PA^A21. In order to do that, I need to query the delist date. Can you advise how to query the delist date? Is there an attribute I can use with get_data?"

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @pearl.techico

I think you can use TR.RetireDate field to get the delist date.

This forum is not the best place to ask about content questions.

For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
This forum is dedicated to things specific to the use of Eikon APIs.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

All comments

chavalit-jintamalit

Hi @pearl.techico

I think you can use TR.RetireDate field to get the delist date.

This forum is not the best place to ask about content questions.

chavalit-jintamalit

Hi @pearl.techico

I would like to add more information.

The suffix format is

^<month><year>

month is A, B, C, D, ... , L (Jan to Dec)

So PEUP.PA delisted in January 2021.

So the delist RIC is PEUP.PA^A21

Max.Zhu

This doesn't seem always work. eg, '000030.KS'

EXPLORE OUR SITES