question

Upvotes
Accepted
9 1 0 4

Getting Realized & Implied volatilities for different time horizon for STOXX50E and SPX (.SP500) indices from Datastream in series format.

I can pull realized data for multiple time horizon for a single date using Eikon API but I need series of data. Below is an example for .STOXX50E pulled using EIKON API.

However this is for one data point i.e, only latest value. I need series of data, example like data series for last 6 months or 1 year or 5 years for every business day for different time horizon.

Also, I do not see implied volatility field for each time horizon in code creator app. I also require this in data series like above for realized volatility.

Can you please help how can I pull the data using Datastream API?

  1. import refinitiv.data.eikon as ek

  2. ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

  3. df, err = ek.get_data(
  4. instruments = ['.STOXX50E'],
  5. fields = [
  6. 'TR.Volatility10D',
  7. 'TR.Volatility30D'
  8. ]
  9. )

  10. display(df)
#contentdatastream-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.

1 Answer

· Write an Answer
Upvotes
Accepted
73k 226 49 71

@Wasim Akram

Thank you for reaching out to us.

This forum is aimed at answering "how to" types of questions about using Refinitiv APIs and the moderators are not Content/Data specialists. For content availability type questions, I recommend you raise a ticket at Product Support | MyRefinitiv for the product concerned.

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.