Price data missing for several RIC's using ek.get_timeseries in python API
Historical Price data is missing for several TIC's using python data API:
ek.get_timeseries(ticker, start_date=date_start_1, end_date=date_end_1)
In which "ticker" is any of the below tic's, while dates are multiple combinations between 1988 and 2020.
AKS.N BGG.NCHK.NCTL.NDNR.NDO.NFTR.OQMNK.NNE.NUTX.NWLBAQ.PKALT.N^K99BOAT.O^D99CMY^L96COW.QAD^C95CSGA.QAD^C95CSP.QAD^C95ENE.N^A02FCXb.N^K95FLR_w.N^L00FSR.N^B01GITL.L^
H90GNN.MW^D93GRACq.L^A00GX.N^A02HIA.H^
C90LOCK.CD^
A98MCAc.AS^L90MHC.L^A92NCR.L^I91NOXL.QAD^
L00NRTO.PK^B02OMw.N^K97PINw.N^
J94PPW.BE^C02PZS.N^L99RAM.QAD^L89RTN.N^L97SOVN.QAD^C95SPC.L^D92SQB.F^C90SQD^L97TKA.QAD^L91USH.N^
F97WETT.SI^E01
Best
Filipe
Best Answer
-
The stock of Briggs & Stratton Corp was delisted from NYSE in July 2020, and the RIC BGG.N is no longer valid. Use delisted stock RIC BGG.N^G20:
ek.get_timeseries('BGG.N^G20', start_date='1988-08-31', end_date = '1999-12-31')
0
Answers
-
Editable list of tics without timeseries
AKS.N BGG.NCHK.NCTL.NDNR.NDO.NFTR.OQMNK.NNE.NUTX.NWLBAQ.PKALT.N^K99BOAT.O^D99CMY^L96COW.QAD^C95CSGA.QAD^C95CSP.QAD^C95ENE.N^A02FCXb.N^K95FLR_w.N^L00FSR.N^B01GITL.L^
H90GNN.MW^D93GRACq.L^A00GX.N^A02HIA.H^
C90LOCK.CD^
A98MCAc.AS^L90MHC.L^A92NCR.L^I91NOXL.QAD^
L00NRTO.PK^B02OMw.N^K97PINw.N^
J94PPW.BE^C02PZS.N^L99RAM.QAD^L89RTN.N^L97SOVN.QAD^C95SPC.L^D92SQB.F^C90SQD^L97TKA.QAD^L91USH.N^
F97WETT.SI^E010 -
Hi,
You didn't detail values for the range [start_date_1 , end_date_1] but I assume that you reached the limit of data point you can retrieve.
Check this note to get more information on limits : https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/documentation?content=49692&type=documentation_item
0 -
It would be very helpful to get a specific example of the date range where prices are missing for a specific RIC. I noticed that many (if not all) of the RICs you provided refer to delisted stocks. For delisted stocks you would only have price history up to the date when the stock was delisted. This is one reason you may have noticed "missing data". Another reason may be that your requests are hitting the 3K rows limit mentioned by @pierre.faurel. There may be other reasons. To tell you which one applies we'll need a specific example.
0 -
Hello Alex and Pierre.
I'm aware of the 3000 row limit. For each of those ticker I've requested multiple timeseries for different time periods, 1988 - 2000, 2000 - 2010 and 2010 - 2020. The values come empty for all of them using the ek.get_timeseries method.
Please try the BGG.N TIC as example. This stock has been around since 1988 and doesn't matter which time period request I do, the time-series comes empty.
date_start_1 = '1988-08-31'
date_end_1 = '1999-12-31'or
date_start_1 = '2000-01-01'
date_end_1 = '2010-12-31'or
date_start_1 = '2011-01-01'
date_end_1 = '2020-11-12'Moreover, using other methods such as ek.get_data() close princing values are provided for some dates. It seems it's an issue for these stocks on the timrseries method.
Regarding the stock being delisted, no matter when it was delisted, it should have provided values for at least one of the 3 time period requests I did.
Thank you in advance.
Best
Filipe
0 -
Hello Alex.
Thank you for your reply. Indeed, all the TIC's I mentioned that were supposed to be alive are now delisted as you mentioned.
However, the issue seems to persist on the already delisted tics mentioned about. Please consider the following two examples:
ek.get_timeseries('ALT.N^K99', start_date='1988-08-31', end_date = '1999-12-31')
ek.get_timeseries('ENE.N^A02', start_date='1988-08-31', end_date = '1999-12-31')
Thank you in advance.
Best
Filipe0 -
I believe we have previously discussed the case of stocks delisted long ago. See my comments here.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 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
- 370 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛