Yield Curve
https://blog.deriscope.com/index.php/en/categories/yield-curve
Sun, 20 Jan 2019 09:25:14 +0000Joomla! - Open Source Content Managementen-gbRisk free Yield Curve Building in Excel using Negative Overnight Index Swap (OIS) Rates
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-ois
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-oisLong 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...]]>AllMon, 03 Dec 2018 18:01:06 +0000Parametric Yield Curve Fitting to Bond Prices under constraints: The National Bank of Georgia case
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-nelson-siegel-const-param
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-nelson-siegel-const-paramBoth 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 ...]]>Yield CurveWed, 04 Apr 2018 13:18:59 +0000Parametric Yield Curve Fitting to Bond Prices: The Nelson-Siegel-Svensson method
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-nelson-siegel-svensson
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-nelson-siegel-svenssonWhen 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 param...]]>Yield CurveSun, 04 Mar 2018 17:05:32 +0000Yield Curve Building in Excel using Bond Prices (QuantLibXL vs Deriscope)
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-bond
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-bondWith 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 ...]]>Yield CurveFri, 02 Mar 2018 16:39:07 +0000Yield Curve Building in Excel using Deposits, Futures and Swaps
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-deposit-futures-swap
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-deposit-futures-swapWith 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...]]>Yield CurveThu, 01 Mar 2018 15:00:18 +0000Yield Curve Building in Excel using Swap Rates
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-swap
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-swapWith 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...]]>Yield CurveWed, 28 Feb 2018 09:21:48 +0000Yield Curve Building in Excel using Futures
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-futures
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-futuresWith 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 ...]]>Yield CurveMon, 26 Feb 2018 21:44:37 +0000Yield Curve Building in Excel using Forward Rates
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-forward
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-forwardWith 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...]]>Yield CurveMon, 26 Feb 2018 10:36:31 +0000Yield Curve Building in Excel using Deposit (LIBOR) Rates
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-deposit
https://blog.deriscope.com/index.php/en/yield-curve-excel-quantlib-depositWith 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...]]>Yield CurveFri, 23 Feb 2018 08:57:15 +0000