Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel.

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

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
  2941 Hits
  0 Comments
2941 Hits
0 Comments

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
  2365 Hits
  0 Comments
2365 Hits
0 Comments

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
  10162 Hits
  0 Comments
10162 Hits
0 Comments

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
  1544 Hits
  0 Comments
1544 Hits
0 Comments

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.As I have explained in my related article, QuantLib is capable of solving the respective parametric equations treating the model parameters as unknown.Due to the...
Continue reading
  1757 Hits
  0 Comments
1757 Hits
0 Comments

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 previous article.The latter impose a parametric form on some mathematical quantity implied by the produced yield curve.The following parametri...
Continue reading
  11905 Hits
  0 Comments
11905 Hits
0 Comments

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

cover
With this article I want to show you how to create a bond yield curve in Excel, i.e. a yield curve out of bond prices, using the open source QuantLib analytics library. I will present both alternative spreadsheet interfaces to QuantLib, which are the QuantLibXL and Deriscope.The main use of a yield curve is that it allows us to calculate the p...
Continue reading
  3323 Hits
  0 Comments
3323 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 swaps...
Continue reading
  2044 Hits
  0 Comments
2044 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 out...
Continue reading
  6125 Hits
  0 Comments
6125 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 sel...
Continue reading
  2570 Hits
  0 Comments
2570 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 maturity s...
Continue reading
  2288 Hits
  0 Comments
2288 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 ra...
Continue reading
  3928 Hits
  0 Comments
3928 Hits
0 Comments