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 sdittmar · Jul 25, 2020 at 09:19 AM · eikonpython apiget_timeseriesdata

Significance of negative count data in get_timeseries request results?

When I request intraday historical data using the `get_timeseries` function, I occasionally receive entries with NaN prices, a count of -1 and some positive volume figure throughout the entire trading day. What is the practical significance of these data entries?

You can replicate it using the following code examples (Note: time is UTC!):

df = ek.get_timeseries('CRM', start_date='2020-07-24T20:00:00', end_date='2020-07-24T21:50:00', interval='minute')
df.head()

Or:

df = ek.get_timeseries('CREE.O', start_date='2020-07-24T15:40:00', end_date='2020-07-24T15:50:00', interval='minute')
df.head()

Unfortunately, I could not find any explanation on this forum as to what these rows represent.

crm.png (16.9 KiB)
cree.png (14.9 KiB)

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Jul 25, 2020 at 11:58 PM

@sdittmar
The value of -1 returned for the COUNT field, or the equivalent "#N/A" value returned by RHistory function in Excel for TRDPRC_1.Count field, signifies that there were no trades within the time interval that satisfy the criteria to be included into open, high, low, close summarization. For US stock exchanges the rules that govern which trades, times and condition codes affect open, high, low and close prices are published by Consolidated Tape Association. The types of trades that are excluded from open, high, low and close include odd-lots, average price trades and cash trades. You can find the complete rules here: https://www.ctaplan.com/tech-specs under CTS Binary Output Specifications. In your example for CREE.O on 2020-07-24 between 15:40 and 15:41 there was one trade, which was excluded from open, high, low, close summarization because it was an average price trade.

Comment
sdittmar

People who like this

1 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
sdittmar · Jul 27, 2020 at 08:44 AM 0
Share

Thank you Alex, your answers on this forum are always very helpful and appreciated!

avatar image
REFINITIV
Answer by chavalit.jintamalit · Jul 25, 2020 at 06:11 PM

Hi @sdittmar

This forum is not the best place to ask about content questions. For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
This forum is dedicated to things specific to the use of Eikon APIs.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

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
sdittmar · Jul 25, 2020 at 06:38 PM 0
Share

Getting some content people involved could greatly improve the usefulness of this forum... This way other users could benefit from the answers and Refinitiv would save resources for answering duplicate questions on the helpdesk.

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 >
11 People are following this question.

Related Questions

List of parameters for a given TR field.

Python API returns NaN for revenue of Australian banks

get_timeseries on RIC 'EURFVMc2' does not return any data

Retrieve the constituents of a yield curve at a specific value date using Eikon Data API (Python)

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