How can I get historical FX forward values in Python (Eikon data API, Codebook)?
Good afternoon!
I need to download historical daily FX 1-month forward values (open, high, low, close) for some liquid currencies (Canadian dollar against USD etc). I am also interested in downloading daily historical data for FX spot rates (open, high, low, close). I am currently working with Python Eikon data API in Codebook in Eikon web version.
How can I do that (wia ek.get_timeseries, ek.get_data or some other way)? I would be grateful for any help or suggestions.
Best Answer
-
Hello @lozovoy.hse ,
With get_timeseries call, available fields are the ones that you see in the example above, as without specifying the fields a parameter to get_timeseries, we get all the fields that are available.
With get_data, we can research the fields that are available for the instrument using Data Item Browser tool within Eikon desktop or Refinitiv Workspace desktop, for example:
Next, to see what is available via time series, we only leave time series checked, unchecking realtime and static fields:
Therefore, this field is not available as timeseries/history via get_data, only as realtime.
For more insight on content availability, the best approach is to refer the content questions directly to Refinitiv content experts, via Refinitiv Helpdesk Online -> Content -> Eikon, this forum will be more helpful to you with API usage questions.
As additional information that may be of interest, Refinitiv Tick History product includes this content, and offers the best coverage of tick history requirements. If you may need this, I would suggest to discuss your requirements in detail with your Refinitiv account team.
1
Answers
-
Hello @lozovoy.hse ,
I would try ek.get_timeseries, first.
Having examined the results, you can decide, if this is sufficient for your requirement, and if not, try get_data and parametrization per Eikon Data APIs for Python - Reference Guide.
For example:
import eikon as ek
ek.set_app_key('YOURVALIDKEYHERE')
ek.get_timeseries(['CAD1M=','CAD='],start_date='2020-05-04',end_date='2021-10-04')Results in:
Hope this information helps
1 -
@zoya faberov Thank you for quick response! Your answer is helpful. I have an additional question: is it possible to get data for daily bid and ask for the same tickers? For instance, close bid for 'CAD1M=' and close ask for 'CAD1M= '.
0 -
Good evening!
@zoya faberov Thank you so much for your detailed answer! Now I got all the information I needed, so I am closing the question.
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 中文论坛