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.

Articles relating to equity related products that may be built in Excel using Deriscope

Monte Carlo Pricing of any European Structured Product in Excel: Revisiting the Morgan Stanley Trigger Plus 2024 Note

cover
In my previous article I showed how one can use Deriscope in Excel to calculate the price of a particular type of a structured product that pays the minimum of two equity indices observed at some specified future terminal time. As example was used the Trigger Plus note issued by Morgan Stanley on April 1, 2019, which is based on the value of t...
Continue reading
  5734 Hits
  0 Comments
5734 Hits
0 Comments

Pricing Structured Products in Excel: The Morgan Stanley Trigger Plus 2024 Note

cover
Various structured products can be precisely priced in Excel using Deriscope and its underlying QuantLib analytics. In this article I will focus on the Trigger Plus product issued by Morgan Stanley on April 1, 2019. It is based on the value of the worst performing of the Dow Jones Industrial Average and the Russel 2000 Index due April 4, 2024. It o...
Continue reading
  10001 Hits
  0 Comments
10001 Hits
0 Comments

Pricing of Risk Scaling Options in Excel

cover
You are all familiar with simple European call options that are securities promising to pay their holders at some agreed future time T the difference S(T) – K between the price S(T) realized by a monitored underlying S at time T and a fixed amount K, under the condition that S(T) is greater than K. The last long sentence may be compressed to t...
Continue reading
  3604 Hits
  0 Comments
3604 Hits
0 Comments

Using Quantos to gain exposure on Foreign Assets without the Currency Risk: Yes, but be careful!

cover
A common usage of quanto call options is to benefit from the price appreciation of a foreign asset and on the same time stay immune on exchange rate variations.A European style quanto call option on a foreign asset S with strike K is always cash settled and pays its holder on expiry time T the amount max{S(T) – K, 0} converted into domestic currenc...
Continue reading
  7921 Hits
  0 Comments
7921 Hits
0 Comments

Accessing and Manipulating Historical Data from Yahoo Finance in Excel

cover
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.Yahoo Finance displays historical data for stock prices, indices, bond yields, fx rates, commodity prices etc on their website and allow anyone to download a text file ...
Continue reading
  14546 Hits
  0 Comments
14546 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
  6292 Hits
  0 Comments
6292 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.America has been traditionally touted as the "land of choice" and American Options honor their name by granting their holders an additional cho...
Continue reading
  6347 Hits
  0 Comments
6347 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
  5238 Hits
  0 Comments
5238 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
  22291 Hits
  0 Comments
22291 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
  3217 Hits
  0 Comments
3217 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
  3986 Hits
  0 Comments
3986 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
  3395 Hits
  0 Comments
3395 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
  9301 Hits
  0 Comments
9301 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
  1939 Hits
  0 Comments
1939 Hits
0 Comments