Historical Strike Price for constant maturity option

steffen.fuchs
steffen.fuchs Explorer
in Eikon Data APIs

Hi,

I'm trying to pull historical strike prices for constant maturity oprions:

data = ek.get_timeseries('SPX24MO=R',fields = 'STRIKE_PRC',start_date='2019-09-30', end_date='2019-10-22')

which returns:

SPX24MO=R   STRIKE_PRC
Date                  
2019-09-30         NaN
2019-10-01         NaN
2019-10-02         NaN
2019-10-03         NaN
2019-10-04         NaN
2019-10-07         NaN
2019-10-08         NaN
2019-10-09         NaN
2019-10-10         NaN
2019-10-11         NaN
2019-10-14         NaN
2019-10-15         NaN
2019-10-16         NaN
2019-10-17         NaN
2019-10-18         NaN
2019-10-21         NaN
2019-10-22         NaN

however, using Excel formula builder with following formula "=RHistory("SPX2WO=R","STRIKE_PRC.Timestamp;STRIKE_PRC.Value","INTERVAL:1D",,"TSREPEAT:NO CH:Fd",B2)"

returns the data I'm looking for:

image

is there a way to pull the historical strikes to python?


Thanks,

Steffen

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @steffen.fuchs

    According to my lookup via Data Item Browser (Eikon search -> Data Item Browser),

    Implied Volatility is not populated for this instrument


    image


    However, the moderators of this forum are developers.

    For in-depth content expertise, it is best to either refer to Refinitiv Helpdesk online or call your local Refinitiv Helpdesk, and to have your question be answered by a Refinitiv content expert.

Answers

Categories