Trying to retrieve S&P500 Index options,

Options
s_suha01
s_suha01 Newcomer
in Eikon Data APIs

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:

https://developers.refinitiv.com/content/eikon-data-api-python-quants-tutorial-9-derivative-analytics-i-data-chains-options


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]

imageFor 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!

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @s_suha01

    You can try this sample code:

    image


    You can use "Data Item Browser" to file more fields you are interested in on the instrument such as SPXx16224900.U

Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    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

    image


    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)

    image


    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.

  • s_suha01
    s_suha01 Newcomer

    Hello @chavalit-jintamalitchavalit.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

  • chavalit-jintamalit
    chavalit-jintamalit admin
    https://community.developers.refinitiv.com/discussion/comment/60663#Comment_60663

    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.

    image

Categories