The Excel Derivatives Periscope

With a Wizard-Guided User Interface
Access the full QuantLib's Analytics Library
Price exotic options and derivatives
Access live stock prices and fx quotes around the world
  • True Real Time Quotes on Forex and over 8,000 US Stocks and ETFs
  • Forex and Stock Trading Simulator Spreadsheets
  • Global Real Time & Historical Prices from Yahoo Finance, IEX and Alpha Vantage
  • US Company Financial data on last four quarters from IEX
  • 50+ Technical Indicators on Global Equities
  • 165 Fiat Currencies and 392 Cryptocurrencies
All in one downloadable Excel addin

Deriscope™ is an Excel Add-In specializing in financial derivatives valuation. Its main innovative feature is an integrated wizard - the first of its kind in the financial industry - that helps you create spreadsheets with real time data (stock, ETF, forex, cryptocurrency, futures, option and commodity live quotes and historical data) that deal with the pricing and risk management of diverse types of derivatives such as options, interest rate swaps, swaptions, credit default swaps, inflation swaps, basket options etc.

j Visit my blog articles for details on how Dericope may be used

j Visit my youtube videos for tutorials with narration


Deriscope draws on QuantLib's analytical power to calculate the price, risk and various other properties of all the financial instruments listed under Products. It also makes use of a QuantLib extension called ORE, sponsored by Quaternion Risk Management for pricing instruments not available in QuantLib and calculating portfolio analytics such as VaR and XVA.
Deriscope facilitates data input by supplying instrument definitions filled with typical values that you may replace with your own custom data. It also supplies certain live market data, such as stock tickers and current prices.
Deriscope also significantly simplifies the process of spreadsheet construction through an included spreadsheet generation tool.
Deriscope makes no attempt to sanitize the output of QuantLib algorithms. This is so by design so that Deriscope may be also used as a QuantLib test tool. For example the QuantLib "AnalyticBarrier" pricing method calculates option prices as if the rebate were zero, even if a non-zero rebate is supplied by the user. Deriscope outputs the price as calculated by QuantLib but it also warns you that the rebate input is ignored. Generally you must supply the input data expected by the applicable QuantLib model.
You may start using Deriscope right now. Simply go to Download page to get the latest available version.

j Go to the Download Page For both 32 & 64 bit Excel



The following are some of Deriscope's advantages that distinguish it from other similar products in the market:

Live Feeds

Live feeds, historical prices and statistical indicators on various security types are displayed in the spreadsheet from several different providers as described in detail in this blog article.
Disclaimer: All feeds are sent to the client's device directly from the referred provider. Deriscope does not transmit, distribute, publish or otherwise disseminate such feeds and therefore cannot guarantee the accuracy or the timely update of the displayed data.
For those who are interested in analyzing the time series directly in Excel, offers a thorough, state of the art statistical analysis package for free.

Excel Integration

Deriscope is fully integrated with Excel.
All Excel versions - both 32 and 64 bit - from 2000 to the latest 2016, including the Office 365, are supported.
It does not litter Excel's existing menu (or ribbon in the latest versions) with its own items. It only displays a dedicated task pane that acts as both information board and workplace in real-time interaction with the spreadsheet contents.

Analytics Reliability - QuantLib

Rather than relying on proprietary analytics, Deriscope delegates the option pricing job to the QuantLib software library, which has been in existence since the year 2000 and is actually used by thousands of professionals worldwide. In a sense Deriscope acts as the Excel interface to the QuantLib pricing library. This fact bestows Deriscope with the reliability sought by the average user with regard to number accuracy.
This fact also makes Deriscope an excellent way to get acquainted with QuantLib and test its several features and models directly in Excel without the need to use a programming language.
More related info at the Technology page.

User Friendly Interface

Deriscope is designed in such a way that it can be used immediately to build and price complex derivative instruments without the need of prior training.
The dedicated task pane allows you to browse through all available instruments and functions.
After you have made your function selection, you may browse and edit the respective input parameters and finally generate a regular spreadsheet formula that may be inserted in any cell.
You can then manipulate this formula directly in the spreadsheet just like any other Excel formula without the need of the dedicated task pane.

Information Everywhere

You will never need to consult a manual in order to understand the meaning of the hundreds of functions and their input parameters that are accessible through Deriscope.
Context based information is dynamically generated in real time and displayed in the dedicated task pane.
You may even enquire the actual steps undertaken by the pricing algorithm to better diagnose potential data entry errors.

Deriscope in action

Pricing a Stock Option

Video tutorials available here