Commodity Options data (Option Price)
Hi,
Using the API, is there a way to retrieve options data (mainly option prices) for commodities (e.g., 0#NG+, 0#CL+) from a past date? For example, I need the values of some Natural Gas and Crude options as of 12/29/2023. Is it possible to get option prices for those options on that specific day?
Currently, I use the following method (see image) to get the implied volatility in terms of moneyness. Can I adjust the approach below to achieve what I need? I have also used 'historical_pricing.summaries.Definition' and 'get_data' with the 'chain' function to retrieve the option chain. However, the issue with this approach is that it does not return expired RICs.
Answers
-
Hi @anurag.rathore ,
The best way of getting prices is to use get_history or get_data functions as you mentioned above, which will return prices for expired contract. See some examples below:
1. get_history with no fields specified will return all available pricing fields for a given instrument
rd.get_history("NGG24^2", start = "2023-12-20", end = "2024-02-01")
2. get_data with no fields specified will return all available pricing fields as of current date, however the paramaters param is not supported for historcial pricing fields. So to ask for a price in past you may need to use TR fields instead. See below:
rd.get_data("NGG24^2", fields =[ "TR.ClosePrice", "TR.ClosePrice.date"], parameters={"SDate": "2023-12-29"})
Hope this helps and let me know if I misunderstood your question.
Best regards,
Haykaz
0 -
Hi
@aramyan.hThis is the futures data, I am looking for the option price data for these futures contracts.
Thanks0 -
Hi @anurag.rathore ,
do you have the rics? you can replace the rics in my code with your rics. Or there is somthing else your trying to achieve?
0 -
Hi, please read my original post. It refers to an option chain, and the part in question is getting the RICs. Your code retrieves historical prices for futures contracts, not options. Options and futures are two different things.
0 -
your original question was around getting the prices and to get the historical prices you need to use the function I included in my answer by passing the RICs you are interested in. I am not a content expert and any content related question (e.g what are the RICs for certain options/futures) please raise a query with helpdesk via my.refinitiv.com. You may also want to checkout this thread which provides examples on chain expansion for option on futures - Proper queries for options on futures using Python and Eikon API - Forum | Refinitiv Developer Community
Best regards,
Haykaz
1 -
Thanks, Haykaz0
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 中文论坛