Includes articles relating to working with interest rates and their derivatives in Excel through Deriscope

USD Swaption Pricing in Excel using SABR Stochastic Volatility and Market Vol Cube from CME

cover
The pricing of exotic interest rate products cannot ignore the so called market volatility cube that is made daily available by several swaption brokers. Traders often use the SABR Stochastic volatility model in order to estimate vols off the provided grid. In this article I will show you how to price an out-of-the-money swaption by applying SABR c...
Continue reading
  1128 Hits
  0 Comments
1128 Hits
0 Comments

USD Swaption Pricing in Excel using the Bachelier Model and Market Normal Vols from CME

cover
The Chicago Mercantile Exchange ( CME ) clears European swaption trades on 3-month USD LIBOR since April 2016 and has thus become the first major exchange that lists Over-The-Counter (OTC) interest rate products with optionality. The standardized swaption contracts have 5 different expiries - 1M, 3M, 6M, 1Y, 2Y – and 7 underlying swap tenors - 1Y, ...
Continue reading
  1138 Hits
  0 Comments
1138 Hits
0 Comments

Swaption Pricing in Excel: 14 Free QuantLib Models plus Implied Volatility Surface and Cube

cover
Most people are unaware of the fact that free and open source QuantLib comes with a great variety of modelling approaches when it comes to pricing an interest rate European swaption in Excel that surpasses what is offered by expensive commercial products. In fact, 14 different modelling approaches are implemented, whereby the Black approach does no...
Continue reading
  2054 Hits
  0 Comments
2054 Hits
0 Comments

Excel Builder and Cash Flow Viewer for Non-Standard Interest Rates Swaps

cover
Building, pricing and analyzing even non-standard interest rate swaps in Excel becomes a simple exercise when the Deriscope interface to the open source QuantLib analytics library is employed. We have already encountered a simple interest rate swap contract in the Yield Curve Building in Excel using Swap Rates article, where vanilla swaps were used...
Continue reading
  926 Hits
  0 Comments
926 Hits
0 Comments

Time for a coffee break? Understanding Time and its implications on Interest Rates

Cover
With this article I want to give you an intuitive feeling of the concept of interest rate and also show you how to work with various types of interest rates – such as a compounded interest rate - in Excel as accurately as market professionals do. Contrary to the four-dimensional space-time of relativistic physics, financial stochastic processes evo...
Continue reading
  239 Hits
  0 Comments
239 Hits
0 Comments

Yield Curve Building in Excel using Deposits, Futures and Swaps

cover
With this article I want to show you how to create a yield curve in Excel using the open source QuantLib analytics library, when the input market data are a mixture of deposit rates, futures prices and swap rates. I have already written how you may build a yield curve using a single type of market instruments, such as deposits , futures  or sw...
Continue reading
  655 Hits
  0 Comments
655 Hits
0 Comments

Yield Curve Building in Excel using Swap Rates

cover
With this article I want to show you how to create a yield curve in Excel using the open source QuantLib analytics library, when the input market data are swap rates. I will also show you how to apply dual bootstrapping when an exogenous yield curve is present. For short term maturities – typically less than a year – the yield curve may be built ou...
Continue reading
  1535 Hits
  0 Comments
1535 Hits
0 Comments

Yield Curve Building in Excel using Futures

cover
With this article I want to show you how to create a yield curve in Excel using the open source QuantLib analytics library, when the input market data are futures prices. The futures convexity will be taken into account. I explained how you may build a yield curve in Excel out of forward rates in my previous article . In reality, forward rates are ...
Continue reading
  669 Hits
  0 Comments
669 Hits
0 Comments

Yield Curve Building in Excel using Forward Rates

cover
With this article I want to show you how to create a yield curve in Excel using the open source QuantLib analytics library, when the input market data are forward rates. My previous article  focused on building a yield curve in Excel out of deposit rates in general and Libor rates in particular. These rates cover the short range of the maturit...
Continue reading
  548 Hits
  0 Comments
548 Hits
0 Comments

Yield Curve Building in Excel using Deposit (LIBOR) Rates

cover
With this article I want to show you how to create a yield curve in Excel using the open source QuantLib analytics library, when the input market data are deposit rates – such as Libor rates -, which are a special type of interest rates called zero rates. As I describe in my article about interest rates , a deposit rate - effectively the interest r...
Continue reading
  931 Hits
  0 Comments
931 Hits
0 Comments