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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
18 1 1 1

Historical implied volatility for US stocks

Hi guys,

I'm interested in pulling historical implied volatility for US stocks via Python API. Currently, after going through all questions regarding implied volatility, I still cannot find a way to pull historical implied volatility at the end of each day. Could you help me and tell me if there is a proven way to do so via Python API ?

If not via Python API, spreadsheet formulas would also be useful, I just need it to work.

I tried following https://community.developers.refinitiv.com/questions/24802/eod-implied-volatility-of-equity-stock-options.html , but there is no answer that fits my needs.

Any help would be appreciated.

Best regards,

Filip

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonhistorical
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
6.7k 8 6 7

@itsupport2 When you say US stocks - do you mean individual stocks or indicies. In any case implied volatility is calculated using options vols. We publish separate RICs for 30 day ATM IV for puts - these are available historically - here for TSLA:

df,e = ek.get_data('TSLAATMIV.U',['TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDE XFORPUTOPTIONS.Date','TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORPUTOPTIONS'],{'SDate':'20100903','EDate':'20180902','Frq':'D'}) 

df.sort_index(ascending=False, inplace=True) 
df

We publish these for most stocks where options are available I believe. So the trick here is to combine the RIC root you are interested in eg TSLA and then add ATMIV.U or other venue. eg TSLAATMIV.U and so forth.

I hope this can help.




1612970153644.png (458.0 KiB)
1612971315738.png (132.7 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.

Upvote
18 1 1 1

@jason.ramchandani This works !!! Thank you so much ! The problem in other posts was that it was suggested to pass RIC only (TSLA.O) instead of 'TSLAATMIV.U' as you suggested here. Hope this helps other people as well. Thanks !

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.

@itsupport2 glad it was helpful!

Click below to post an Idea Post Idea