Re: Newby Question

Posted by animesh on
URL: http://quantlib.414.s1.nabble.com/Newby-Question-tp7349p7350.html

There is a sample given in StandaloneExamples/InterestRateDerivatives.xls file.

Although I am assuming you already have used that file. So regarding calculation of probability I think one of the ways is to model different term-structures, and find the swap values. Calculating the probability then is just a simple division!
In the sheets "Swaps" (Swap value is calculated using the rates in term structures sheet) and "TermStructures", this has been done.
It's been done for a flat forward rate, so a simple solution might be to use a nice macro to change it, and calculate swap values. For more complex term structures you can change this qlFlatForward function and use a different term structure.

Hope this helps.


On 8/2/10 1:00 PM, Sutcliffe, Anthony wrote:

Hello all.

I'm trying to do the following:

To calculate the probability of the value of a swap falling below a given level using the quantlib xl addin. The choice of interest rate model is not that important, as this is just proof of concept, although a term-structure matching version is preferred. I'd also like to be able to display the envelope in which the yield curve will move at a given confidence interval.

I've downloaded the addin and it appears to work, but I'm not sure how to proceed from here. Can anyone give me any pointers?

Thanks very much.

Anthony Sutcliffe
Assistant Vice President
Investment Risk Management
State Street Global Advisors Limited
20 Churchill Place, London E14 5HJ
[phone] (Direct Line)

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users