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 Wizard
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 Excel Deriscope Ribbon, which - when clicked upon - expands to:
Live Feeds Functions (3)
These are functions specializing in the acquisition of live feeds.
All functions may fail if they are fed with incorrect input, in which case they return an object of type Error that contains diagnostic information, which can be displayed in the Wizard by selecting the source spreadsheet cell.
Look at Handling Excel Errors for tips on how to resolve various types of errors.