Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel.

Includes articles describing fundamental aspects of Derivatives Pricing in Excel through Deriscope.

Introduction to Deriscope – Part 5: Live Feeds

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

Introduction to Deriscope – Part 4: Spreadsheet

FormSplitRanges
In this article I show you how to manipulate the formulas created by the wizard in order to build functional Excel spreadsheets.  Deriscope Formula Syntax Rules​The main spreadsheet formula that Deriscope exposes to Excel is ds(r1, r2, …) where r1, r2, … are ranges containing primarily key-value pairs.Also available are the dsi and dsv variati...
Continue reading
  2037 Hits
  0 Comments
2037 Hits
0 Comments

Introduction to Deriscope – Part 3: Pricing a Stock Option

SelectPriceScreenshot
In my previous article 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 YouTube Stock Option Pricing video...
Continue reading
  1500 Hits
  0 Comments
1500 Hits
0 Comments

Introduction to Deriscope – Part 2: Creating a Stock Option

Initial
In my previous article I listed the main reasons for using Deriscope.Now I will show you how to use Deriscope to create a Stock Option object. Rather than typing the formula by hand, I will ask the wizard to create the formula for me. After I start Excel and press on the Enable and Show Wizard button inside the Deriscope ribbon tab, the Deriscope t...
Continue reading
  2033 Hits
  0 Comments
2033 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
  3334 Hits
  0 Comments
3334 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
  905 Hits
  0 Comments
905 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
  1191 Hits
  0 Comments
1191 Hits
0 Comments