Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
jacopo.rennenkampff avatar image
1 ●0 ●0 ●0

How to retrieve historical swaption volatilities in Excel?

I need to get swaption volatility surfaces for a time lenght of at least 10 years. It is for my master thesis.

I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("USD3MFSR";"BID.TIMESTAMP;BID.CLOSE";"NBROWS:1500 INTERVAL:1D";"CH:IN;Fd STREPEAT:N";B3)

Unfortunately it's not working. It says that CH it's not a valid refresh parameter. What can I do?screenshot-2024-07-17-151212.png

workspace#technologytime-seriesexcelswaps
screenshot-2024-07-17-151212.png (13.2 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.

1 Answer

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
7k ●18 ●2 ●8

Hi @jacopo.rennenkampff ,

This forum is dedicated to API related questions. For content and/or Excel related questions, please raise a query via Helpdesk either from Help&Support section on Workspace or via my.refinitiv.com.

Best regards,

Haykaz

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.