Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel. If you choose a category from the list on the left and click on the appearing envelope icon, you will be notified by email when a new article is posted in that category.

Fully Functional Excel Spreadsheet for SOFR Swaption Trading with Lognormal, Normal and Shifted Lognormal SABR Vol Calibration

cover

Setting up an interest rate swaption trading desk is a complex endeavor. First, the type of the underlying interest rate should be defined, and it can be either a still existing ibor rate such as EURIBOR or JPY TIBOR or – in the case of LIBOR that has been discontinued as of June 30, 2023 - an equivalent ARR (Alternative Reference Rate) s...

Continue reading
  6973 Hits

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
  20751 Hits

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
  24263 Hits

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, 2Y...

Continue reading
  30533 Hits