I am looking for Implied volatility data for the 100% moneyness symbols. The filed is "O6" for 6M...

... ATM IV.

For example the 100% moneyness symbol for AAPL.OQ is AAQ$MONEY100. I want data for this symbol through datastream API. Thanks

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @mehul.mathur

    You can use the DataStream Website to find instruments and fields. For example, these are valid fields of AAQ$MONEY100.

    image

    Then, you can use the DatastreamDSWS library to retrieve the data.

    For example, this is a sample python code:

    import DatastreamDSWS as DSWS
    ds = DSWS.Datastream(username = 'username', password = 'password')
    df = ds.get_data(tickers="AAQ$MONEY100",fields =["O6"], kind=0)
    df

    For time-series data:

    df = ds.get_data(tickers='AAQ$MONEY100', fields=["O6"], start="2011-01-01", end="2019-01-01", kind=1)
    df

Answers