Python Eikon API get_timeseries() Time Interval

Hello,
I am using the get_timeseries() method to retrieve rates by the minute, though I am noticing that not all the hours of the day are included and that not all minutes in the hour are there.
For example, if I call:
get_timeseries('CNYUSD=R', start_date='2017-10-27T00:00:00',end_date='2017-10-27T23:00:00',interval='minute')
I only get the 1st - 15th hour of the day. For hour 4, I am only seeing 15 values (when I would expect 60, one for each minute). Is it possible with the Python Eikon API to get values for every minute, or ideally every second, of the day?
Best Answer
-
What you see is expected. The backend only summarizes price history data into a bar for a standard interval such as one minute if there's a price update within that interval. For less liquid instruments such as this exchange rate the only way you can create the timeseries you're looking for is by constructing it in your code from the timeseries you retrieve from Eikon (by repeating the price from previous interval for every interval without a price).
0
Answers
-
Okay, thanks Alex. So, just to be clear-- if there is data returned for 14:47:00 and then 15:01:00, the rates in between will be the price for 14:47:00, right?
If there was no data for after the 15th hour of every day, there was no price movement at all until the next day...?
Lastly, just wanted to confirm that these timestamps are UTC.0 -
The answer is yes on all points. If there is data returned for 14:47:00 and then 15:01:00, the best indicator of the rates in between is the price update for 14:47:00. If there was no data for after the 15th hour of every day, there were no price updates at all until the next day. And yes, the timestamps are in UTC. Please also note that these exchange rates are indicative. They are not firm quotes and they do not reflect any actual trades happening in the FX market.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 250 ETA
- 555 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛