# 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.

## Excel Builder and Cash Flow Viewer for Non-Standard Interest Rates Swaps

Building, pricing and analyzing even non-standard interest rate swaps in Excel becomes a simple exercise when the Deriscope interface to the open source QuantLib analytics library is employed.We have already encountered a simple interest rate swap contract in the Yield Curve Building in Excel using Swap Rates article, where vanilla swaps were used ...
8265 Hits
8265 Hits

## Time for a coffee break? Understanding Time and its implications on Interest Rates

With this article I want to give you an intuitive feeling of the concept of interest rate and also show you how to work with various types of interest rates – such as a compounded interest rate - in Excel as accurately as market professionals do.Contrary to the four-dimensional space-time of relativistic physics, financial stochastic processes evol...
6153 Hits
6153 Hits

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

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 ...
45972 Hits
45972 Hits

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

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...
11899 Hits
11899 Hits

## Yield Curve Building in Excel using Deposits, Futures and Swaps

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...
6250 Hits
6250 Hits

## Yield Curve Building in Excel using Swap Rates

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...
16287 Hits
16287 Hits

## Yield Curve Building in Excel using Futures

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...
6717 Hits
6717 Hits

## Yield Curve Building in Excel using Forward Rates

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...
7251 Hits
7251 Hits

## Yield Curve Building in Excel using Deposit (LIBOR) Rates

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...
11595 Hits
11595 Hits

## Beyond Black Scholes: American Option Price Dependence on Dividend Payment Time

With this article I want to show you how to create and price American options on an underlying that pays dividends – such as American stock options expiring after the ex-dividend date - in Excel using the open source QuantLib analytics library.In my previous article I showed you how to calculate the fair price of an American option on an under...
5856 Hits
5856 Hits

## Beyond Black Scholes: American Options without Dividends

With this article I want to show you how to create and price American options on a non-dividend-paying underlying – such as American stock options - in Excel using the open source QuantLib analytics library.America has been traditionally touted as the "land of choice" and American Options honor their name by granting their holders an additional cho...
5704 Hits
5704 Hits

## Beyond Black Scholes: European Options with Discrete Dividends

With this article I want to show you how to create and price European options on an underlying that pays discrete dividends – such as European stock options - in Excel using the open source QuantLib analytics library.In my previous article I presented an overview of the QuantLib models that can be used in Excel towards pricing the simplest non-line...
4896 Hits
4896 Hits

## Introduction to Deriscope – Part 5: Live Feeds

Overview Deriscope enables you to receive in Excel live feeds from several different providers.These feeds include real time or almost real time prices of financial securities (stocks, ETFs, indices, currencies, cryptocurrencies, futures and options), bid/offer quotes and sizes, time series of historical prices and statistical indicators, comp...
21330 Hits
21330 Hits

## Introduction to Deriscope – Part 4: Spreadsheet

In my Introduction to Deriscope – Part 3 I showed you the most basic features of the Deriscope wizard by using it to create the pricing formula of a Stock Option.Now, I show you several advanced Deriscope features that help you build efficient Excel spreadsheets.Table of Contents Deriscope Formula Syntax RulesColor RulesSyntax Rule: One i...
3672 Hits
3672 Hits

## Introduction to Deriscope – Part 3: Pricing a Stock Option

In my Introduction to Deriscope – Part 2 I showed you how to create a Stock Option object in Excel and how to access the list of functions that apply to that object. Now I will show you how to use the most important of these functions, the Price, which calculates the fair price of the calling object. Alternatively, you may watch my YouTub...
2959 Hits
2959 Hits

## Introduction to Deriscope – Part 2: Creating a Stock Option

In Introduction to Deriscope – Part 1 I listed the main reasons for using Deriscope. Now I will show you the main features of Deriscope using as example the creation of a Stock Option object.Table of Contents The Deriscope TaskpaneThe Input AreaThe Type SelectorThe Function SelectorThe Browse AreaThe Go ButtonThe Created ObjectTrivial Obj...
3624 Hits
3624 Hits

## Introduction to Deriscope – Part 1: Why Deriscope?

Deriscope is described by … Wikipedia at https://en.wikipedia.org/wiki/fascinatingnewproducts/bestever/deriscope as a "wizard-guided Excel Add-In dedicated to the pricing of Financial Derivatives". Well, it is a bit early for such a Wikipedia entry given Deriscope's recent birth date of August 2017. But the above description still applies and makes...
5106 Hits
5106 Hits

## Beyond Black Scholes: European Options without Dividends

Options are the simplest non-trivial financial derivatives around.They are part of the curriculum of every university course on Finance for a good reason: They are everywhere! They are traded on regulated exchanges around the world, change hands over the counter between … consenting adults, enhance or "infect" all sorts of contracts as "embedd...
3148 Hits
3148 Hits

14195 Hits
14195 Hits

8294 Hits
8294 Hits

## Should I use a Trading Simulator to learn how to trade?

Have you ever thought of being a trader? I mean trading things like stocks, currencies, options or anything else that you can buy and sell almost instantly - typically online - by pressing a button and not illiquid assets, such as houses or antique furniture. Wouldn't it be great to get some sense of what real world trading looks like before s...
1796 Hits
1796 Hits

## What is the fair price of one dollar?

Understanding the concept of "TRADABLE" will reveal a surprising answer to this question! A few years ago, when I was still working as a quant for a big bank in London, my typical good morning question waiting for me in the office would be an abstruse sentence such as:What is the fair price of a custom-made inflation bond convertible into equi...
1805 Hits
1805 Hits

## Can Excel Spreadsheet Cells contain Objects directly?

Could Deriscope pace the way for the new generation Excel beast — Object-Oriented UDFs — and what would that mean for the financial industry in particular?Most of financial analysis software libraries used by major banks are written in so-called "Object-Oriented" programming languages, such as C++.In the past, before the Object-Oriented paradigm be...
2208 Hits
2208 Hits