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")


Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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

Answers