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
You can use the DataStream Website to find instruments and fields. For example, these are valid fields of AAQ$MONEY100.
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
Thank you very much Jirapongse Phuriphanvichai. It worked. Could you please help me on How we can get these "100% moneyness" symbols in API. For example AAQ$MONEY100 for AAPL.OQ.
Many Thanks
The API supports "DS.SYMBOLLOOKUP" to lookup symbols.
df = ds.get_data(tickers="APPLE", fields=["DS.SYMBOLLOOKUP(Count=20)"], kind=0)
However, it is unable to look up those "100% moneyness" symbols. Therefore, you may not be able to get those "100% moneyness" symbols in API.