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...
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...
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 unde...
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 "embed...
