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

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

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

All comments

f.janeiro

missing data RICS.pdf

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

Alex Putkov.1

@f.janeiro

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.

f.janeiro

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'

date_start_1 = '2000-01-01'
date_end_1 = '2010-12-31'

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

Alex Putkov.1

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

f.janeiro

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

Filipe

Alex Putkov.1

@f.janeiro

I believe we have previously discussed the case of stocks delisted long ago. See my comments here.

EXPLORE OUR SITES