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 igorg · Dec 12, 2018 at 03:21 PM · eikon data apitimeseries

Data values are different for 'tick' and 'minute' time-series requests

>>> dataFrame = ek.get_timeseries(rics=["AMXL.MX"], start_date="2018-12-11 21:00:00", end_date="2018-12-11 21:10:00", interval="tick", normalize=False)
>>> dataFrame
AMXL.MX                  VALUE     VOLUME
Date
2018-12-11 21:00:01.096    NaN   326400.0
2018-12-11 21:00:01.096    NaN   193800.0
2018-12-11 21:00:01.096    NaN   413800.0
2018-12-11 21:00:01.096    NaN      600.0
2018-12-11 21:00:01.096    NaN   934000.0
2018-12-11 21:00:01.096    NaN    65400.0
2018-12-11 21:00:01.096    NaN   855100.0
2018-12-11 21:00:01.096    NaN   855000.0
2018-12-11 21:00:01.096    NaN      100.0
2018-12-11 21:00:01.096    NaN   855000.0
2018-12-11 21:00:01.096    NaN   100500.0
2018-12-11 21:00:01.096    NaN   248144.0
2018-12-11 21:00:01.096    NaN    84700.0
2018-12-11 21:00:01.096    NaN   625356.0
2018-12-11 21:00:01.096    NaN  1054644.0
>>> dataFrame = ek.get_timeseries(rics=["AMXL.MX"], start_date="2018-12-11 21:00:00", end_date="2018-12-11 21:10:00", interval="minute", normalize=False)
>>> dataFrame
AMXL.MX               HIGH    LOW   OPEN  CLOSE  COUNT    VOLUME
Date
2018-12-11 21:00:00  13.85  13.81  13.83  13.82   83.0  299274.0
>>>

The sum of Volume field values for 'tick' request is 6612544. But in 'minute' it's 299274.

Shouldn't they be the same?

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. · Dec 12, 2018 at 08:33 PM

No, they shouldn't. The one minute interval timestamped at 21:00:00 is the minute that ends at 21:00:00, i.e. the 60 seconds between 20:59:00 and 21:00:00. The tick data in your example falls into the next one minute interval: the one that ends and is timestamped at 21:01:00. That latter one minute interval is not returned when you ask for 1 minute timeseries because it falls outside of the trading session. I'm not sure what the volume after 9pm GMT refers to. There's no price associated with it. Perhaps it's related to a closing auction? I'm afraid I'm not an expert on the trading rules for Bolsa Mexicana. If you need to find out how to interpret this data the best resource is Refinitiv Helpdesk.

Comment

People who like this

0 Show 3 · 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
igorg · Dec 12, 2018 at 09:04 PM 0
Share

I checked the ticks between 20:59:00 and 21:00:00.. The sum of Volume also does not match to 'minute' volume.

avatar image
REFINITIV
Alex Putkov. ♦♦ igorg · Dec 12, 2018 at 10:10 PM 0
Share

I just did the same and the sum of the volume for all ticks between 20:59:00 and 21:00:00 came to 299274, the same as the volume for 1 minute interval timestamped 21:00:00.

avatar image
igorg Alex Putkov. ♦♦ · Dec 13, 2018 at 09:08 AM 0
Share

I'm sorry, I did it for wrong date.

avatar image
Answer by igorg · Dec 12, 2018 at 08:51 PM

@Alex Putkov.

We contacted that exchange with the question how to collect Closing Auction volume. So they told us that all trades between 21:00:00 and 21:05:00 (I don't remember exact time). So we collect all the ticks and calculate the summary. So I decided to check what if I collect 'minute' intervals for that period. It will return less rows with the same result.. I thought. So why is the data not available with minutes/hours intervals? Refinitiv Helpdesk?

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. ♦♦ · Dec 12, 2018 at 10:13 PM 0
Share

Yes, if you need an explanation how the closing auction volume is represented in the timeseries and why it is not shown in 1 minute summarization, the best resource is Refinitiv 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 >
7 People are following this question.

Related Questions

Eikon Desktop Data API stopped working after changing to a new user on Eikon terminal

get_timeseries throws if cannot get info for 1 ticker

Why is get_timeseries using Eikon API not pulling the full price history?

how to "catch" statusCode == 'Error' with normalization = false flag

Hourly historical data for 5 years

  • 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