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.

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

Continue reading
  7275 Hits

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

Continue reading
  9806 Hits

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
  4685 Hits

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

Continue reading
  5752 Hits