Historical Strike Price for constant maturity option

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

Welcome!

It looks like you're new here. Sign in or register to get started.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.