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.

Includes articles relating to pricing credit-linked financial instruments such as bonds, credit default swaps etc in Excel through Deriscope

Subcategories from this category:

Bonds, CDS

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

Floating Rate Notes (FRN) in Excel: Understanding Duration, Discount Margin and KRD

cover
Deriscope exports in Excel over 30 functions that deal with bonds, as I have described in an earlier document about bond risk management functions.In spite of the fact that the referred functions apply to all types of bonds, including interest rate and inflation linked bonds, one should be cautious when the referenced bond does not pay a fixed rate...
Continue reading
  14855 Hits
  0 Comments
14855 Hits
0 Comments

Bond Key Rate Duration (KRD) in Excel: Calculating and Understanding

cover
You are all familiar with the concept of bond Duration, which tells us how much a bond's price changes if its yield goes up or down by a small amount.While there exist several different Duration definitions that produce slightly different results, the one that is most closely related to the Key Rate Duration is the Modified Duration D, which may be...
Continue reading
  15020 Hits
  0 Comments
15020 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. 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
  4906 Hits
  0 Comments
4906 Hits
0 Comments

Credit Default Swap (CDS) Pricing in Excel using QuantLib

cover
Free and open source QuantLib supports the precise valuation of Credit Default Swaps (CDS) in Excel. A CDS contract specifies N payment times T1, T2, …, TN at which, counterparty A (the Protection Seller) receives a pre-agreed fixed amount from counterparty B (the Protection Buyer) provided that a pre-defined credit event – such as the default of s...
Continue reading
  11703 Hits
  0 Comments
11703 Hits
0 Comments

Over 30 Bond Risk Management Functions in Excel: Clean & Dirty Price, Yield, Duration, Convexity, BPS, DV01, Z-spread etc

cover
Free and open source QuantLib is capable of calculating several risk measures associated with the pricing of bonds and allows you to get in Excel quantities like clean and dirty price, duration, convexity, BPS, DO01, Z-spread etc.I have already showed you how to build a yield curve out of clean bond prices using either a parametric or non...
Continue reading
  6056 Hits
  0 Comments
6056 Hits
0 Comments