How to retrieve Swaption Volatility in Excel API, e.g. http://emea1.apps.cp.thomsonreuters.com/Explorer/GuideDefault.aspx?s=GFI40+AL+3&st=Menu+G+C&context=OV

Question

question

romerson.gadil

3 ●2 ●2 ●1

Raising the query on an external client's behalf:

Client is seeking assistance on how to pull the Swaption Volatility as seen in this page Home > Fixed Income > Interest Rate Derivatives > Swaptions
Eikon link: http://emea1.apps.cp.thomsonreuters.com/Explorer/GuideDefault.aspx?s=GFI40+AL+3&st=Menu+G+C&context=OV

using Excel API.

Sep 17, 2020 at 09:38 AM

10 |1500

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

Answer 1 · 2020-09-28T03:47:54Z

Jirapongse

55.8k ●145 ●45 ●65

I assume that the client is using Eikon Excel. Please directly contact the Eikon support team via MyRefinitiv for an answer.

1601264793290.png (16.2 KiB)

Sep 28, 2020 at 03:47 AM

10 |1500

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

Answer 2 · 2020-09-17T11:36:04Z

romerson.gadil

3 ●2 ●2 ●1

screenshot-17.png (201.7 KiB)

Sep 17, 2020 at 11:36 AM

10 |1500

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

romerson.gadil Sep 17, 2020 at 11:36 AM

Screenshot for reference.

romerson.gadil Sep 17, 2020 at 02:20 PM

I also got a word from the client that he would like to pass in a date and get the time-series of this swaption volatility surface.

I hope you can take a look into this request. Thank you.

Answer 3 · 2020-09-18T11:31:05Z

romerson.gadil

3 ●2 ●2 ●1

Hi Team, anyone who can help in checking this? Thank you.

Sep 18, 2020 at 11:31 AM

10 |1500

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