How to enforce the same time-period when downloading FX and forwards?
Hi,
I want to extract daily spot and forward FX data at the exact same time of the day. It seems that ek.get_timeseries is not using standardized time and I want to enforce that.
I am using the code:
ek.get_timeseries(RICs, fields, start_date, end_date, interval = "daily")
However, for a simple example of "EUR=" and "JPY=" we see different times for their CLOSE:
I have seen a similar question asked here however there is no accepted answer and people say this data is standardized but, as the above example shows, probably isn't. I have to get a lot of currencies, for the past 24 years. I also need to get the sport and the 1-month forwards, i.e. "EUR=" and "EUR1MV=". Therefore, I need to find a robust way of downloading this data.
Best Answer
-
Here's the resolution from the case, for reference,
I collaborated with our Account Specialist and made some comparisons in chart for Daily VS Hourly. Rest assure that close gets 5PM NY / 21:00 GMT Value:
Correct samples:
CAD= 1.3529 Mar 21 17:00 (5PM) NY Bid
CAD= 1.3529 Mar 21 21:00 GMT BidGBP= 1.2656 Mar 21 17:00 (5PM) NY Bid
GBP= 1.2656 Mar 21 21:00 GMT BidJPY= 151.61 Mar 21 17:00 (5PM) NY Bid
JPY= 151.61 Mar 21 21:00 GMT BidFor EUR, there were instances wherein values is rounded up to three decimals
Mar 21
EUR= 1.086 Mar 21 17:00 (5PM) NY Bid
EUR= 1.0858 Mar 21 21:00 GMT Bid (1.0858 rounded up to three decimals is 1.086)Tried other dates e.g. Mar 20
EUR= 1.0918 Mar 20 17:00 (5PM) NY Bid
EUR= 1.092 Mar 20 21:00 GMT Bid (1.0918 rounded up to three decimals is 1.092)Tried another one. Other dates for EUR are fine (screenshot is in the sub-comment)
0
Answers
-
Thank you for reaching out to us.
I found that you have submitted this question to the content support team and the support team has closed the case.
If you have any further questions regarding the summitted question, you can re-open the case by replying to that email. The content support team can answer this question.
Regarding APIs, as far as I know, you can't enforce time when getting the daily historical data. To get prices at specific times, you may need to use intraday data (hour or minute) instead.
0 -
here's the screenshot
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 中文论坛