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.
ds
dsi
dsv
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.
dsMergeH
dsMergeV
dsPipe
dsReplace
dsSort
dsSubRange
dsTrimCols
dsTrimRows
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.
dsGet
dsLive
dsLivev