For example the 100% moneyness symbol for AAPL.OQ is AAQ$MONEY100. I want data for this symbol through datastream API. Thanks
1
●1 ●1 ●2
I am looking for Implied volatility data for the 100% moneyness symbols. The filed is "O6" for 6M ATM IV.
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
78.8k
●250 ●52 ●74
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
78.8k
●250 ●52 ●74
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.
