Deriscope Excel Functions
Deriscope exports to Excel 14 spreadsheet functions through an Excel Add-in named DeriscopeXLL that is listed in the screen attainable through Excel Options, as shown below:
These 14 functions can be browsed through the ragular Insert Function native Excel browser under the category Deriscope, as shown below:
They can be divided into three groups:
Analytics Functions (3)
These are functions specializing in the valuation of price and risk of financial instruments.
The function ds is best generated and pasted in the spreadsheet with the help of the
Every ds function can be converted to the corresponding dsi or dsv by simply changing the name ds by adding to it the letter i or v respectively.
Auxiliary Functions (8)
These are functions that play a non-critical, auxiliary role in data manipulation.
These functions are best generated and pasted in the spreadsheet through the specialized Insert Function button of the , which - when clicked upon - expands to:
Live Feeds Functions (3)
These are functions specializing in the acquisition of live feeds.