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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aminhushen avatar image
3 ●0 ●0 ●2

Collected implied volatility using Eiklon Python package

I am trying to collect AUDCAD 1 month implied volatility using pyton's Eikon package.

ek.get_data('AUDCAD1MO=R', 'IMP_VOLT')

Here is the error returned.

( Instrument IMP_VOLT 0 AUDCAD1MO=R NaN, [{'code': 251658244, 'col': 1, 'message': "Error: Field 'IMP_VOLT' was not found in response for the instrument 'AUDCAD1MO=R'", 'row': 0}])

I am able to collect its implied volatility from excel function. What is the correct way to fetch the data?

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apihistoricalvolatility
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.

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.3k ●77 ●11 ●27

You say you can retrieve what you need into Excel. What is the call you use in Excel?
Field IMP_VOLT does not exist for RIC AUDCAD1MO=R. RIC AUDCAD1MO=R provides several implied volatilities: bid volatility can be found in field "BID", ask volatility can be found in field "ASK", mid volatility can be found in field "PRIMACT_1".

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.

aminhushen avatar image aminhushen

The script returns implied volatility by using ek.get_data('AUDCAD1MO=R', 'BID'). Thanks Alex!