Request different cut-off for FX pairs.

Hello,
If I wanted to request a time-series of AUD= MidPrice at 16 hours, I would do a request like this:
import eikon as ek
ek.set_app_key('xxxxxxxxxxxxxxxxxxxxx')
data = ek.get_data(["AUD16H="], "TR.MIDPRICE")
But what if I wanted to do so for 16.30 hours? Or 15.30 hours? Would something like that be possible?
Thanks in advance for any help you may provide.
Best Answer
-
The example RIC you provided is a snapshot of FX spot rate at 4pm GMT with daily timeseries available. Such snapshots are only available hourly. If you need to know FX spot rate at a given time on a given day, you can use intraday timeseries. E.g.
rdp.get_historical_price_summaries('AUD=',
interval='PT30M',
start='2021-04-07T15:30',
end='2021-04-07T15:30',
fields=['MID_PRICE'])The depth of history available for historical intraday summaries is 1 year. However, if you need daily timeseries of snapshots at say 15:30 GMT, constructing those from intraday timeseries would likely not be practical, as you would either need to request each datapoint separately or retrieve timeseries in say 30 min aggregation and discard all the datapoints you're not interested in.
0
Answers
-
Thank you @Alex Putkov.1
One question though, you're using a method I have not seen for the Python Eikon API (usually through get_data and get_timeseries functions).
Is rdp another type of service or is it still Eikon's?
0 -
You can use this command to install RDP Lib.
pip install refinitiv.dataplatform
Then you can import it to your Python code.
import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxxx')0 -
Thanks again for your help @chavalit-jintamalit! Also @Alex Putkov.1, history then for this type of frequency (Intraday) can only go back a year?
Would it be possible to request a daily time-series in which the only observation a day will have, is going to be on such cut-off? e.g. AUD at 16.30 hours?
Or necessarily I have to request the full minutely intraday time-series for each day?0 -
Yes, intraday price history available through Eikon only goes back one year for history in 1 minute aggregation and 90 days for full tick history. If you need longer intraday price history, you need Refinitiv Tick History product.
Using Eikon you cannot retrieve daily timeseries of snapshots of AUDUSD exchange rate taken at 4:30pm each day. The only way to obtain such series using Eikon is to construct them from intraday timeseries, which would require retrieving either full intraday history and discarding all data points except one for each day or retrieving a single point (the price at 4:30pm on a given day) separately for each day (i.e. sending one request per day) and then combining these points into timeseries.
For info about RDP Library, check out the article titled "Discover our Refinitiv Data Platform Library".0 -
Thank you guys so much for such clear answers @Alex Putkov.1 @chavalit-jintamalit
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
- 685 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
- 252 ETA
- 556 WebSocket API
- 38 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
- 652 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
- 917 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 中文论坛