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.

Yield Curve

Articles relating to the various types of yield curves that may be built in Excel using Deriscope

Ioannis Rigopoulos

Yield Curve Building in Excel with Central Bank Meeting Dates and STIR OIS Trading Arbitrage Opportunities: The GBP Sonia case

cover
One of the central banks' duties is to ensure the cost of money (aka interest rates) is optimal for the economy. If a) the economy is overheated and needs to slow down to avoid a future burst or b) inflation rates are too high due to increased consumer demand, higher interest rates will a₁) have a cooling effect on the economy by raising the c...
Continue reading
  663 Hits
  0 Comments
663 Hits
0 Comments
Ioannis Rigopoulos

Bootstrapping in Excel a Yield Curve to perfectly fit Bloomberg Price/Yield Quotes of US Treasury Bills, Notes and Bonds

cover
I have already described the bootstrapping method for building a yield curve from various instrument types in the yield curve articles category. In particular, my post on Yield Curve Building in Excel using Bond Prices (QuantLibXL vs Deriscope) demonstrates how this is done in practice using a simplified theoretical setup consisting of three m...
Continue reading
  2631 Hits
  0 Comments
2631 Hits
0 Comments
Ioannis Rigopoulos

Turn-of-the-Month Effect in SOFR Curve built out of 1- & 3- Month Futures

cover
In my previous article about building a SOFR yield curve in Excel using QuantLib and Deriscope I was confronted with an unexpected result concerning the short term – less than two years – section of the curve.The following two charts were produced that show the continuously compounded zero rates for every calendar maturity for the next two-yea...
Continue reading
  3657 Hits
  0 Comments
3657 Hits
0 Comments
Ioannis Rigopoulos

How to build a SOFR Yield Curve in Excel using QuantLib and Deriscope

Cover
The markets expect that Libor will be gradually phased out as more investors and lenders prefer financial products tied to the Secured Overnight Financing Rate (SOFR) rather than the USD London Inter-bank Offered Rate (LIBOR).The main reason for this ongoing exodus is the expected cessation of the daily announcements of the interbank lending rates ...
Continue reading
  13216 Hits
  0 Comments
13216 Hits
0 Comments
Ioannis Rigopoulos

Dependence of USD Interest Rate Swaps Price & Risk on Modelling Assumptions affecting the Curve Building

cover
In my post about USD Interest Rate Swaps in Excel, I have explained in detail how to calculate the price and risk of a single USD interest rate swap using a multi-curve approach and actual market data from Bloomberg as of 22 May 2019.A comparative analysis between the single-curve and multi-curve approach has been laid out in my post focusing on sw...
Continue reading
  2489 Hits
  0 Comments
2489 Hits
0 Comments
Ioannis Rigopoulos

Pricing of Cross-Currency Collateralized Swaps using OIS vs non-OIS Discounting: The Mexican case.

cover
Last week I described the unique problem faced by interest rate swap traders when the collateral is kept in a currency different than the one where the swaps are denominated. You may want to visit that post for details on how the appropriate discounting (basis) curve in the Mexican case is constructed out of several market rates that include t...
Continue reading
  4979 Hits
  0 Comments
4979 Hits
0 Comments
Ioannis Rigopoulos

Building in Excel the Implied Risk-Free Discounting Curve when the Collateral is kept in another Currency. Example: Mexico, where no Local OIS Market exists.

cover
Before the 2007-08 financial crisis, all swap cash flows were discounted with the same yield curve used in "forecasting" the future Libor rates and thus the amounts of the floating cash flows.At any given time, this yield curve was constructed so that it reproduced the market prices of the swaps traded at that time.After its construction, the yield...
Continue reading
  5046 Hits
  0 Comments
5046 Hits
0 Comments
Ioannis Rigopoulos

Using Bloomberg Tenor Basis Swap Spreads in Excel to calculate 1M USD Libor Forward Rates

cover
Until the 2007-08 financial crisis, forward interest rates of any tenor had been calculated off one single yield curve. In the US, traders had been building one USD yield curve out of market-traded deposits, futures and fixed-to-3M-Libor swaps and used that curve for all purposes involving interest rate calculations, such as extracting discount fac...
Continue reading
  12296 Hits
  0 Comments
12296 Hits
0 Comments
Ioannis Rigopoulos

OIS Discounted USD Libor Curve Production in Excel for Front Office Trading

cover
I have already explained in my earlier yield curve building post how one can use the Excel Deriscope addin to derive the discount factors and zero rates implied by any given market rates of deposits, futures and swaps.At another post about dual bootstrapping, I calculated in Excel the price of an actual 50-year EUR collateralized swap held by ...
Continue reading
  12984 Hits
  0 Comments
12984 Hits
0 Comments
Ioannis Rigopoulos

Perfect Bloomberg Price Match of an Interest Rate Swap in Excel by using Dual Bootstrapping

cover
Up until the financial crisis of 2008, the price calculation of an interest rate swap involved only the so-called Libor curve. The latter was essentially the discount factors (or equivalently zero rates or forward rates) implied by market-traded instruments, such as deposits, futures, forwards and swaps. The Libor curve was used to derive everythin...
Continue reading
  17637 Hits
  0 Comments
17637 Hits
0 Comments
Ioannis Rigopoulos

Currency Swaps and Basis Curves in Excel

cover
​The basic concepts of spot fx rates, forward fx contracts, fx swaps and the construction of foreign yield curves out of fx forward rates have been described in detail in my previous fx rates article.While these instruments cover the short end of the maturity spectrum – typically about a year -, the tenor of so-called currency swaps (also know...
Continue reading
  14718 Hits
  0 Comments
14718 Hits
0 Comments
Ioannis Rigopoulos

FX Spots, Forwards, Swaps and Curves in Excel

cover
​Assume you possess Nd units of a currency DOM regarded as domestic currency. For example, you live in the US and hold 1,000 USD, ie. Nd = 1,000 and DOM = USD.For whatever reasons, you want to replace this money with their equivalent number of units Nf of another currency FOR regarded as foreign currency. For concreteness think of FOR like if it we...
Continue reading
  39424 Hits
  0 Comments
39424 Hits
0 Comments
Ioannis Rigopoulos

Risk free Yield Curve Building in Excel using Negative Overnight Index Swap (OIS) Rates

cover
Long are the dates when all-purpose risk free yield curves were produced out of deposits, futures and swaps. Since the credit crisis of 2007/08, banks realized they should use different curves for different purposes. In the intervening years, quants have proven mathematically that uncollateralized contingent flows should be discounted using a curve...
Continue reading
  7391 Hits
  0 Comments
7391 Hits
0 Comments
Ioannis Rigopoulos

Parametric Yield Curve Fitting to Bond Prices under constraints: The National Bank of Georgia case

cover
Both the Nelson Siegel method and its Svensson extension are very popular among central and other banks when the time spectrum of interest rates needs to be derived from market bond prices. If you are interested in non-parametric methods favored by relative value traders as they provide an exact fit to observed bond prices, these have been demonstr...
Continue reading
  5483 Hits
  0 Comments
5483 Hits
0 Comments
Ioannis Rigopoulos

Parametric Yield Curve Fitting to Bond Prices: The Nelson-Siegel-Svensson method

cover1
When it comes to building a yield curve out of bond prices, QuantLib can handle both non-parametric and parametric methods, both deliverable to Excel through Deriscope.The former have been demonstrated at my articles Yield Curve Building in Excel using Bond Prices (QuantLibXL vs Deriscope and  Bootstrapping in Excel a Yield Curve to ...
Continue reading
  45976 Hits
  0 Comments
45976 Hits
0 Comments
Ioannis Rigopoulos

Yield Curve Building in Excel using Bond Prices (QuantLibXL vs Deriscope)

cover
With this article I want to show you how to create a yield curve in Excel by bootstrapping bond prices, using the open source QuantLib analytics library. I will present both alternative spreadsheet interfaces to QuantLib, which are the QuantLibXL and Deriscope.For a production-ready setup using actual Bloomberg quotes of US Treasuries, look at Boot...
Continue reading
  11899 Hits
  0 Comments
11899 Hits
0 Comments
Ioannis Rigopoulos

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 swaps...
Continue reading
  6250 Hits
  0 Comments
6250 Hits
0 Comments
Ioannis Rigopoulos

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 out...
Continue reading
  16287 Hits
  0 Comments
16287 Hits
0 Comments
Ioannis Rigopoulos

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 sel...
Continue reading
  6717 Hits
  0 Comments
6717 Hits
0 Comments
Ioannis Rigopoulos

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 maturity s...
Continue reading
  7251 Hits
  0 Comments
7251 Hits
0 Comments
Ioannis Rigopoulos

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 ra...
Continue reading
  11596 Hits
  0 Comments
11596 Hits
0 Comments