Eikon Side by Side Interoperability API and EIkon API Intraday FX Rates Enquiry
Dear Refinitiv API team,
I have a Refinitiv Workspace license. I am working on a project with IT where I need to extract:
Main Global Majors FX Rates (e.g. GBP / EUR, GBP / USD etc.) Bid / Ask / Close prices for 10+ currencies at specific times of day: For example at:
- 9am, 3pm and 6pm (Note: I understand the FX end of day close price is settled at 4pm.)
IT have requested this data call would be run once a day or at the fixed times of day (stated above). The data needs to be stored in SQL Server Integration Services SSIS (SSIS). Environment is Windows.
IT preference for ongoing maintenance is to use the Eikon Side by Side Interoperability API.
- Would it be best to use an intraday API data call to store bid / ask / close prices at these fixed times?
- The FX rates bid / ask / close data calls may also need to be checked dynamically live. Therefore would it be best to pull in live bid / ask FX rates in memory and store those data points by writing a script or is there an alternative better solution? Note I have live FX rates on my license.
Therefore:
- I would like to know can these intraday data calls be done directly using the Eikon Side by Side Interoperability API instead using GET / POST requests (IT preference for ongoing maintenance) and have an example guidance / code to run so It can test.
- I would like to know the code in Python main Eikon API to extract FX rates at specific intraday time intervals (as stated above).
- I would like to know the code in Python main Eikon API to extract FX rates live and store these from memory to SQL.
- How to extract all major codes automatically in Python and Eikon Side by Side Interoperability API code for all countries instead of manually stating?
- What are limits on intraday historical data?
Please kindly advise.
Thanks
Best Answer
-
Thanks for reaching out to us.
As I know, you can't retrieve data with Eikon Side by Side Interoperability API. The API is used to:
- Launch an Eikon app
- Create a communication channel with Eikon apps to send and receive context
- Send and receive underlying Metadata: Pass portfolios and Trade Tickets as well as instrument identifiers
To retrieve data, you need to use Eikon Data API or Refintiv Data Library for Python.
This is an output from Refintiv Data Libary for Python when requesting intraday data.
This is an output from Eikon Data API when requesting intraday data.
The Intraday time series database only stores up to 1 year of history.
0
Answers
-
Thanks you for your kind response. Good to know the correct API to use.
1. Could you advise how to extract intraday data at a specific time of day only using either the Eikon or Refinitiv Data Library?
2. Can we extract FX rates live and store these from memory to SQL ideally using SSIS web requests?
3. Could you kindly confirm that we can connect via a web request? Ideally SSIS but PowerShell would work as well.
4. How to extract all major FX codes automatically in Python and Eikon Side by Side Interoperability API code for all countries instead of manually stating? If we can't do, we can manually set FX codes in a Python list.
Thanks
Tomasz
0 -
You can specify the date and time in the date parameters, as shown below.
rd.get_history(universe="JPY=", interval="minute", start="2022-11-01T03:50:00", end="2022-11-01T04:00:00")
I don't know about SSIS web requests. It should be fine if the SSIS web requests support Python, dot net, typescript, or REST API.
If it supports Python, dot net, or typescript, you can use our provided libraries.
If it supports REST API, you can use Refinitiv Data Platform APIs.
Typically, to extract data, you need to specify instrument codes, such as RICs. Yes, you need to specify FX codes in a list.
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
- 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛