AnalyzerXL

Financial Analysis Solutions for Microsoft Excel

AnalyzerXL

Financial Analysis

Solutions for Excel

DownloaderXL

AnalyzerXL is a library of 146 technical analysis functions, indicators and experts in the form of Excel formulas. An indicator is used to determine the trend of a market, the strength of the market and the direction of the market. An expert is a stock market system such as Bill Williams Profitunity. All 146 formulas include wizards that make entering data easy.

146 technical analysis functions, indicators and experts are easily calculated in Microsoft Excel environment. AnalyzerXL's seamless integration with Excel provides opportunities for customization that are just not possible with competing software packages. With knowledge of VBA, traders can easily develop custom indicators and experts in a fraction of the time it would take with other software. Users can also create and name macros using the AnalyzerXL interface.

The AnalyzerXL Wizard makes it easy to implement a new function and simplifies the creation of trading systems. It is also easy to create charts from functions with numeric outputs - just click the Chart icon and select the type of chart you wish to create.

Types of Functions

An indicator is used to determine the trend of a market, the strength of the market and the direction of the market. An expert is a stock market system such as Bill Williams' Profitunity. Expert functions produce special outputs, such as Buy/Sell signals, trend directions and more.

Types of Outputs

All functions are categorized by the type of output they produce. There are two types of outputs: Formulas and Values. Formulas are automatically re-calculated when you change input data, whereas Values remain the same. With Formulas, you do not need to re-enter range references or function parameters when you update data.

Macros

For functions that output Values, AnalyzerXL provides a macro-building feature to improve the updating process. These macros can easily be called when you update your data. There are two types of macros: Local and Global. Local macros can only be called from the workbook in which they were created, whereas Global macros can be called from any workbook.