New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
ns3481 avatar image
17 ●5 ●7 ●13

Getting data for delisted RIC using reference data

Hi Refinitiv Support Team,

I am trying to download data from companies whose shares have been DELISTED from trading at an exchange in the past. In the following you find under:

  1. code that tries to download stock prices for YAHOO that was delisted in 2017. This code gives an error message and returns no data.
  2. Code that succeeds in downloading stock price data for IBM, that is a company that is still traded until today. This code returns valid output data.

Would you mind letting me know how to download stock price data for delisted companies?

Thanks a lot for your help!

1.

import refinitiv.data as rd
import pandas as pd
rd.open_session()
 
startDate="1997-19-19"
endDate="2017-06-16"
RIC_RD="YHOO"
 
dfRD=rd.get_history(universe=f"{RIC_RD}",start=f"{startDate}",end=f"{endDate}",
               fields=["HIGH_1","TRDPRC_1","LOW_1","OPEN_PRC","NUM_MOVES","ACVOL_UNS"],
               adjustments="unadjusted")

2.

import refinitiv.data as rd
import pandas as pd
rd.open_session()
 
startDate="1996-01-02"
endDate="2023-01-31"
RIC_RD="IBM"
 
dfRD=rd.get_history(universe=f"{RIC_RD}",start=f"{startDate}",end=f"{endDate}",
               fields=["HIGH_1","TRDPRC_1","LOW_1","OPEN_PRC","NUM_MOVES","ACVOL_UNS"],
               adjustments="unadjusted")


eikon-data-apipython apiprice-history
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.

1 Answer

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@ns3481

Thank you for reaching out to us.

I think the delisted RIC for Yahoo Inc is AOL^F15.

1701328618075.png

1701328654588.png

You can contact the content support team directly via MyRefinitiv to verify this RIC.


1701328618075.png (15.6 KiB)
1701328654588.png (49.7 KiB)
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.

ns3481 avatar image ns3481

@Jirapongse , thank you for the swift response.


1.Is there a way I can get the delisted RICs for all stocks, say all constituents of a major index (think S&P 500 or Russell 1000). We face this issue for hundreds of stocks.

2. From your query it appears as though the stock data starts from 2009, when it should start much earlier, from say 1997.

Thanks a lot for your help!

Jirapongse avatar image Jirapongse ns3481
@ns3481

Please contact the content support team to verify RICs and content.

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.