question

Upvotes
Accepted
5 4 4 3

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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apiderivativesvolatilityenergy
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.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 512.0 KiB each and 1.0 MiB total.

Upvotes
39.4k 78 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 512.0 KiB each and 1.0 MiB total.

What would be the Python function to do the same?

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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