Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Overnight Indexed Swap (OIS) #463

Closed
RogKle opened this issue May 3, 2018 · 9 comments
Closed

Overnight Indexed Swap (OIS) #463

RogKle opened this issue May 3, 2018 · 9 comments

Comments

@RogKle
Copy link

RogKle commented May 3, 2018

The valuation of Switzerland's OIS vs. SARON needs the following new features:

  1. There is a "Pay Lag". That means that a payment happens not on the "Accrual End Date" but - in case of Switzerland - two business days later. Therefore in the schedule for the fixed and floating leg a "Pay Lag" should be defined. Similarly, a "Pay Lag" has to be implemented in qlOISRateHelper.
  2. The index SARON has an offset of zero and the OIS rates have a spot date of T+2. As a consequence for the valuation there are no fixings (neither historical nor forward) for T and T+1. Therefore the missing fixings should be interpolated between T-1 (last added fixing using qlIndexAddFixings) and T+2 (first forward start fixing calculated out of the OIS rates).
@lballabio
Copy link
Owner

As for the first point, the OISRateHelper class does provide a parameter to enter the payment lag, at least in the latest release (see here) but from the function names you're using I'm guessing that you're trying to access it from the Excel addin. You can give a heads-up to the addin maintainer at https://github.com/eehlers/QuantLibXL so he can update the thing.

For the second point: what you can do at this time is to use the correct spot date of T+2 for the OIS helpers, but a spot date of T for the curve you're bootstrapping. This will enable the curve to give you rates at T and T+1 by extrapolating the T+2 rate backwards. If the common practice is to interpolate, though, this will need some code added for the SARON index.

@RogKle RogKle closed this as completed Jun 15, 2018
@RogKle RogKle reopened this Jun 15, 2018
@RogKle
Copy link
Author

RogKle commented Jun 20, 2018

#1: I opened a corresponding new issue at https://github.com/eehlers/QuantLibXL
#2: Your proposed solution works, although the resulting NPV is slightly incorrect. Will the code for the SARON index be enhanced to enable interpolation?

Thank you very much for your support!

@lballabio
Copy link
Owner

I'll keep the issue open and see if someone has a go at the code.

@RogKle
Copy link
Author

RogKle commented Aug 16, 2018

Two month ago, I opened an issue at https://github.com/eehlers/QuantLibXL, but I've never received any answer. Is this still the correct addin maintainer ?

@lballabio
Copy link
Owner

It is. Eric is probably busy with his day job.

@RogKle
Copy link
Author

RogKle commented Nov 20, 2018

I'm sorry, but I'm still waiting for any answer from Eric.

@lballabio
Copy link
Owner

I'd try commenting again on that issue.

@stale
Copy link

stale bot commented Sep 5, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the stale label Sep 5, 2019
@stale
Copy link

stale bot commented Oct 5, 2019

This issue has been automatically closed as stale.

@stale stale bot closed this as completed Oct 5, 2019
@lballabio lballabio removed the stale label Aug 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants