question

Upvotes
Accepted
1 1 1 2

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

datastream-apidsws-apiderivativesvolatility
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.

Upvote
Accepted
80.3k 259 52 75

@mehul.mathur

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

1596537714092.png (89.6 KiB)
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.

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

Upvotes
80.3k 259 52 75

@mehul.mathur

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.

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.