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

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 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