For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 0 2 2

Historical implied vol for LGOc1

Hi, I'd like to get the historical IV for the ATM option of the front-month LGO contract. I've found LGOATM+0c1 and the fields IMPLIED_VOLT/TR.IMPLIEDVOLATILITY, but none of them seem to work.

Thank you in advance!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonderivativesvolatilityenergy
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
3.8k 4 4 6

Hi @matthew.ang, we have also data items called implied volatility index for pre-defined periods.

Example syntax:

df,err = ek.get_data('LGOATMIV',['TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORCALLOPTIONS.date','TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORCALLOPTIONS'],,{"Sdate":'-10D', "Edate":'0D'})



ahs.jpg (35.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
39.2k 75 11 27

To get current implied vol for LGOATM+0c1 use field name IMP_VOLT. To get the history use RHistory function in Excel:
=RHistory("LGOATM+0c1","IMP_VOLT.Timestamp;IMP_VOLT.Value","START:10-Jan-2020 END:10-Feb-2020 INTERVAL:1D",,"CH:Fd")

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

What would be the Python function to do the same?

Click below to post an Idea Post Idea