AnalyzerXL

Compatibility: MS Excel 2000, 2003, 2007, 2010 (32-bit only)
Current version: 6.1.38 (December 2011)
Available in: AnalyzerXL and TraderXL Pro packages (compare)

AnalyzerXL is a library of 165 technical analysis functions, indicators and experts in the form of Excel formulas. 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.

Key features summary:

165 technical analysis functions, indicators, and experts
Built-in charts for more accurate analysis
Macro creation and management