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:
- code that tries to download stock prices for YAHOO that was delisted in 2017. This code gives an error message and returns no data.
- 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
-
Thank you for reaching out to us.
I think the delisted RIC for Yahoo Inc is AOL^F15.
You can contact the content support team directly via MyRefinitiv to verify this RIC.
1
Answers
-
@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!
0 -
@ns3481
Please contact the content support team to verify RICs and content.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛