Trying to retrieve S&P500 Index options,
Hello,
I am currently using a MacOS System, PyCharm, and the Thomson Reuters API Proxy.
I am having some issues retrieving the following data for options on the S&P500 Index over different maturities and moneynesses.
- Price Call
- Price Put
- Implied Volality (or better, Implied Variance)
- Time To Maturity
- Strike
- Current Stock Price
Before posting here, I tried to solve the issue on my own, attempting to e.g. this video:
As, mentioned I am interested in the S&P500 Index options, I further would like to know how one can retrieve the above listed data. I looked into the Data Item Browser and did not find exact matches to the DAX example.
Question 1: How can I find this information?
The below command gives me the result of my screenshot of replicating the DAX example from the video.
dax = ek.get_data('0#GDAX*.EX', fields = ['PUTCALLIND', 'STRIKE_PRC', 'CF_CLOSE', 'IMP_VOLT'])[0]
For Example in row 2611: What I can see is that the string is:
- unknown, starting with a "/"
- the instrument "GDAX",
- then the strike price 15200 with one additional decimal "152000"
- unknown, possibly referring to maturity (?) "L4"
- unknown, ".EX"
Question 2: What exactly is the meaning of the values inside of the 'Instrument' column? Especially, what is the meaning of the for me unknown parts of the string? How can I map this?
Thanks a lot and best regards!
Hi @s_suha01
For Q2.
The instrument is actually a RIC (an identifier uses in Refinitiv)
For example, IBM.N is a RIC code for IBM equity
.SPX is a RIC code for S&P 500 INDEX
.GDAX is a RIC code for XETRA DAX PF
Sometime your account may not entitle to "realtime" data so the "/" in front of RIC code indicates that it is a delayed data
For example, VOD.L vs /VOD.L
If you want to know more detail about RIC rule.
You can open Eikon Desktop and type in "RIC RULES" to open a help page.
Or you can try "Options RICs and Expiry Codes" (I cannot attach more pictures)
Lastly, this is the question on the content, if you still need further content clarification, you can contact Refinitiv Content Helpdesk at https://my.refinitiv.com/
They will be able to explain the content or RIC guideline to you in much more detail.
Hello @chavalit.jintamalit, thanks for your reply. Your sample code helped a lot.
However, two issues remain unsolved:
- The sample code you supplied yields 4348 rows, corresponding to 4348 unique instruments (options) w.r.t. the underlying. However, there are only 12 unique values for "Expiry Date". How can I verify if the sample code has fetched *all* instruments for any possible expiration date?
- Referring to the instrument "SPXx16224900.U": On the Thomson Reuters Desktop App (via Browser), I could verify that the Exercise Style is "P-EU", which is most likely for "European Put". How can I verify the Exercise Style via a request using the API?
Thanks,
s_suha01
How can I verify if the sample code has fetched *all* instruments for any possible expiration date?
The 0#SPX*.U is the chain RIC for all the options so it supposes to return all the available options.
How can I verify the Exercise Style via a request using the API?
You can add "PUT_CALL" field to your API call.
