AnalyzerXL

Trade station, stock quotes, options, investment portfolio in Microsoft Excel AnalyzerXL is a library of 146 technical analysis functions, indicators and experts in the form of Excel formulas. AnalyzerXL is a useful microsoft excel utility that allows you to implement functions.

The AnalyzerXL Wizard makes it easy to implement a new function and simplifies the creation of trading systems.

AnalyzerXL 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.

Here are some key features of "AnalyzerXL":