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: Metrixus
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: MX. (from MetriXus)
To find a spread sheet function function_name, search for MX.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: MX_ (from MetriXus)
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: Metrixus
This category will hold all MX.function_name functions.
A new menu will be included in the menu bar of Microsoft Excel:
Menu: Metrixus
This menu gives access to the commands of the add-in and other information.
A new toolbar will be included in Microsof Excel:
Toolbar: Metrixus
This bar will contain shortcuts for some commands of the menu. Its behavior will be the same of others toolbars.
Exists the option to show/hide he toolbar through the menu option:
- Menu - Metrixus | Show Metrixus bar
|