AnalyzerXL

AnalyzerXL is a library of 146 technical analysis functions, indicators and experts for Microsoft Excel. It is furnished with a Wizard that greatly enhances the convenience of using AnalyzerXL and improves the speed of building of trading systems. All functions are categorized by type of output.
AnalyzerXL can automatically build charts for functions with numeric outputs and it is very easy to use - just click the chart icon and select chart type.

AnalyzerXL has two types of output: Formulas (Expert Formulas) and Values (Expert Values). The difference between these two types is that, Formulas will be automatically recalculated if you will change initial input data, but Values will remain the same. In other words, if you use Formulas you will not need to re-enter range references and function parameters when you update data. Most of AnalyzerXL functions have Formulas, but some of functions have only Values (functions that use previous values of themselves). For these functions AnalyzerXL equipped with macro building feature, which enables you to build macros and easily call them when you update your data. You can build two types of macros: Local and Global. Local macros can be called only from the workbook were they have been created (macros are saved in this workbook). Global macros can be called from any workbook (macros are saved in AnalyzerXL special module).

AnalyzerXL has several expert functions, which produce special outputs, such as Buy/Sell signals, trend directions and more. These functions have two types of outputs: Expert Formulas and Expert Values - as well as other functions (see paragraph above).