Detailed profile at my About page

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.  Table Of Contents​ CDS Description Creating a slimmed-down CDS object in 13 secondsCreating a full-fledged CDS objectUnderstanding the main formulaBrowsing the contents of a created CDS objectUsing the CDS objectThe Price functionAddition...
Continue reading
  15292 Hits
  0 Comments
15292 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
  8468 Hits
  0 Comments
8468 Hits
0 Comments

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

cover
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 ...
Continue reading
  9514 Hits
  0 Comments
9514 Hits
0 Comments

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

Cover
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.  Table Of Contents​ The Primitives: Time and Money How did our prehistoric ancestors measure ...
Continue reading
  6966 Hits
  0 Comments
6966 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 articles Yield Curve Building in Excel using Bond Prices (QuantLibXL vs Deriscope and Bootstrapping in Excel a Yield Curve to perfectly fit Bl...
Continue reading
  53105 Hits
  0 Comments
53105 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 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
  14547 Hits
  0 Comments
14547 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
  7463 Hits
  0 Comments
7463 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
  19219 Hits
  0 Comments
19219 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
  7786 Hits
  0 Comments
7786 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 spectr...
Continue reading
  8837 Hits
  0 Comments
8837 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.  Table Of Contents​ Deposit Contract Description What is a Yield Curve?Why do we nee...
Continue reading
  13733 Hits
  0 Comments
13733 Hits
0 Comments

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

cover
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...
Continue reading
  6794 Hits
  0 Comments
6794 Hits
0 Comments

Beyond Black Scholes: American Options without Dividends

cover1
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.  Table Of Contents​ American Options: What are they?Creating an object of type Stock OptionGenerating the pricing formulasPricing Ou...
Continue reading
  6870 Hits
  0 Comments
6870 Hits
0 Comments

Beyond Black Scholes: European Options with Discrete Dividends

cover
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...
Continue reading
  5515 Hits
  0 Comments
5515 Hits
0 Comments

Introduction to Deriscope – Part 5: Live Feeds

cover
Overview Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.Deriscope enables you to receive in Excel live feeds from several different providers.These feeds include real time or almost real time prices of financia...
Continue reading
  22832 Hits
  0 Comments
22832 Hits
0 Comments

Introduction to Deriscope – Part 4: Spreadsheet

FormSplitRanges
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...
Continue reading
  4383 Hits
  0 Comments
4383 Hits
0 Comments

Introduction to Deriscope – Part 3: Pricing a Stock Option

SelectPriceScreenshot
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...
Continue reading
  3419 Hits
  0 Comments
3419 Hits
0 Comments

Introduction to Deriscope – Part 2: Creating a Stock Option

Initial
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...
Continue reading
  4284 Hits
  0 Comments
4284 Hits
0 Comments

Introduction to Deriscope – Part 1: Why Deriscope?

cover
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...
Continue reading
  5880 Hits
  0 Comments
5880 Hits
0 Comments

Beyond Black Scholes: European Options without Dividends

option-signs
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...
Continue reading
  3673 Hits
  0 Comments
3673 Hits
0 Comments

Using a Forex Trading Simulator in Excel

DsSimulatorFXOper
In my last post I showed you how to use the Deriscope Stock Trading Simulator Excel spreadsheet to place simulated BUY and SELL market orders on US stocks traded on IEX (the Investors Exchange)Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still...
Continue reading
  16971 Hits
  0 Comments
16971 Hits
0 Comments

Using a Stock Trading Simulator in Excel

DsSimulatorOper
As I promised you in my previous article I am back with a review of a Stock Trading Simulator that works in Excel and does not suffer from the mentioned drawbacks that hamper all other available free simulators.​Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the informat...
Continue reading
  10199 Hits
  0 Comments
10199 Hits
0 Comments

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

Investopedia-OrderStock
Have you ever thought of being a trader? Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.I mean trading things like stocks, currencies, options or anything else that you can buy and sell almost instantly - typic...
Continue reading
  2091 Hits
  0 Comments
2091 Hits
0 Comments

What is the fair price of one dollar?

cover
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...
Continue reading
  2114 Hits
  0 Comments
2114 Hits
0 Comments

Can Excel Spreadsheet Cells contain Objects directly?

Cover
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...
Continue reading
  2590 Hits
  0 Comments
2590 Hits
0 Comments