2. USAGE
2.1. Excel Behavior
The system comprise a tool set for quantitative and statistics metrics aplied at Financial Market.
Now will be detailed how to use each system functions.
Exists functions available to worksheets, functions for programming modules and run commands in menu or toolbar.
Functions available in worksheets are found in the category in the function assistant:
Category: Calculus
All functions available in the spread sheets have its names initiated with the following abbreviation contend 2 (two) letters and followed of a point of separation (form: XX.).
Abbreviation: CC. (from CalCulus)
To find a spread sheet function function_name, search for CC.function_name.
The way to include functions for the spread sheets is the same of other functions and it will not be detailed. All the functions of spread sheets will be described as functions only.
For functions on programming modules, its names always will follow a prefix given by the abbreviation with 2(two) letters and followed with a underlined character (i.e.: XX_).
Abbreviation: CC. (from CalCulus)
To use a module functions function_name, just search for XX_function_name
The way to include functions in programming modules its specific and will presented for each function. All programming modules functions will be described as macros only. The macros (functions on programming modules) must be declared inside of the modules where it will be called.
The run commands are functionalities available only in menu or toolbar and will be described as commands only.
2.1. Excel Behavior
After installing the product, will be included some characteristics in Microsoft Excel that will support it.
Will be included a function category in the function assistant:
Category: Calculus
This category will hold all CC.function_name functions.
A new menu will be included in the menu bar of Microsoft Excel:
Menu: Calculus
This menu gives access to the commands of the add-in and other information.
|
