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).
1
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
- 6 AHS
- 37 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
- 367 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛