How do we use Eikon API or RDP to pull the ICE TTF forward curve for any given settlement date pleas
For example, it seemed like RDP is the easier option as it works if we use rd.get_history('0#.FTSE'), but if it is rd.get_history('0#TFMBM:') then I get error "No data to return"...
Asking on behalf of client, thanks.
Best Answer
-
It looks like the rd.get_history method is unable to expand this chain RIC (0#TFMBM:). We need to find a way to expand this RIC. If the client uses a desktop session, the client can use ek.get_data method to expand this chain RIC.
import refinitive.data.icon as ek
ek.set_app_key('<app key>')
df, err = ek.get_data(['0#TFMBM:'], ['DSPLY_NAME']);The output is:
Then, I removed '/' from RICs and sent the list to the rd.get_history method.
instrument_list = df["Instrument"]
instrument_list = map( lambda x: x if x[0]!='/' else x[1:], instrument_list)
instrument_list = list(instrument_list)
rd.get_history(universe=instrument_list)The output is:
0
Answers
-
Hi Jirapongse,
Thank you for your answer. Can you also help incorporate the function to include start/end date parameters so user can specify the date range himself?
Thank you again,
Candice
0 -
Hi Jirapongse,
Thank you for your answer. Can you also help incorporate the function to include start/end date parameters so user can specify the date range himself?
Thank you again,
Candice
0 -
The client can run help(rd.get_history) to see the available parameters of this method.
Parameters
----------
universe: str | list
instruments to request.
fields: str | list, optional
fields to request.
interval: str, optional
The consolidation interval. Supported intervals are:
tick, tas, taq, minute, 1min, 5min, 10min, 30min, 60min, hourly, 1h, daily,
1d, 1D, 7D, 7d, weekly, 1W, monthly, 1M, quarterly, 3M, 6M, yearly, 1Y
start: str or date or datetime or timedelta, optional
The start date and timestamp of the query in ISO8601 with UTC only
end: str or date or datetime or timedelta, optional
The end date and timestamp of the query in ISO8601 with UTC only
adjustments : str, optional
The adjustment
count : int, optional
The maximum number of data returned. Values range: 1 - 10000
use_field_names_in_headers : bool, optional
Return field name in headers instead of title
Returns
-------
pandas.DataFrame
Examples
--------
>>> get_history(universe="GOOG.O")
>>> get_history(universe="GOOG.O", fields="tr.Revenue", interval="1Y")
>>> get_history(
... universe="GOOG.O",
... fields=["BID", "ASK", "tr.Revenue"],
... interval="1Y",
... start="2015-01-01",
... end="2020-10-01",
... )To specify the date range, the client can use the start and end parameters. For example:
rd.get_history(universe=instrument_list, start="2022-06-01", end="2022-06-30")
The output is:
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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛