Macros

Macros can be created only if you set Type of output data as Value or Expert Value.

There are two types of macros: Global and Local.

Using Global Macros

1. Open AnalyzerXL Wizard.
2. Select function, for example Stochastic Oscillator.
3. Click Next button.
4. Choose Type of output data, for example Value.
5. Into field “High”, enter the cell reference for the range of High prices.
6. Into field “Low”, enter the cell reference for the range of Low prices.
7. Into field “Close”, enter the cell reference for the range of Close prices.
8. Into field “Output range”, enter the cell reference for the range of output data.
9. Enter period as 3.
10. Enter slowing as 2.
11. Click Macros button.
12. In the Type of Macro Dialog enter name for macro, as Stochastic_Oscillator and select type of macro, as Global. NOTE that name of macro must not contain spaces.
13. Click Ok button, Macros Manager Dialog will appear.
14. Click Add button.
15. Click Close button.
16. Global macros can be accessed through Macros Manager.

Using Local Macros

1. Open AnalyzerXL Wizard.
2. Select function, for example Stochastic Oscillator.
3. Click Next button.
4. Choose Type of output data, for example Value.
5. Into field “High”, enter the cell reference for the range of High prices.
6. Into field “Low”, enter the cell reference for the range of Low prices.
7. Into field “Close”, enter the cell reference for the range of Close prices.
8. Into field “Output range”, enter the cell reference for the range of output data.
9. Enter period as 3.
10. Enter slowing as 2.
11. Click Macros button.
12. In the Type of Macro Dialog enter name for macro, as Stochastic_Oscillator and select type of macro, as Local. NOTE that name of macro must not contain spaces.
13. Click Ok button.
14. Local macros can be accessed through Excel’s macros list by selecting command Macros… in the Tools|Macro menu, or by pressing Alt+F8.