Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by f.janeiro · Nov 15, 2020 at 01:31 PM · python apipython api eikoneikondataapipython eikon

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Nov 16, 2020 at 12:02 AM

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

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by f.janeiro · Nov 15, 2020 at 01:34 PM

missing data RICS.pdf


missing-data-rics.pdf (208.7 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by pierre.faurel · Nov 15, 2020 at 09:53 PM

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


Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Alex Putkov. · Nov 15, 2020 at 11:29 PM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by f.janeiro · Nov 15, 2020 at 11:51 PM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by f.janeiro · Nov 16, 2020 at 09:19 AM

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
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Alex Putkov. ♦♦ · Nov 16, 2020 at 07:29 PM 0
Share

@f.janeiro

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
13 People are following this question.

Related Questions

Gap in FX data via Eikon API

How do I retrieve a price for US92204A7028 Vanguard Information Technology Etf traded at NYSE ARCA?

Request CF_LAST in a particular currency.

Python Standarized balance Sheet, Income Statement and CashFlow

Unpopulated TR.ExchangeCountry vs. populated TR.HeadquartersCountry

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges