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...
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: On...
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...
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...
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 ...
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 eq...
