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?
Best Answer
-
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.
0
Answers
-
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?
0 -
I checked the ticks between 20:59:00 and 21:00:00.. The sum of Volume also does not match to 'minute' volume.
0 -
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.
0 -
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.
0 -
I'm sorry, I did it for wrong date.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 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 中文论坛