Technical Analysis is essentially the methods of predicting the price movement through the use of chart patterns and market indicators. BulkQuotesXL Pro Technical Analysis Functions Library allows you to produce your own trading system using all power of Microsoft Excel 2010 environment.

All functions are divided into the following groups:

The following notations are used in the description of the functions:

This section contains the syntax of the TA function call, for example: **AroonDown(“OutPutStartCell”,”Period”)** or
**AroonDown() **or** AroonDown.** If all or some of the function's parameters are omitted, their default
values are used in calculation.

This section contains the parameters of the TA function's formula. All of them are optional and, if omitted, their default values are used in calculations. Below is the list of all possible parameters:

**Deviation** - the number of standard deviations by which to shift the upper and lower bands

**Factor** - the double of values lagged

**MinAlert** – the minimal value for generating an alert

**MaxAlert** – the maximum value for generating an alert

**Method** - the moving average calculation methods:

MvAvg =
Simple Moving Average

ExpMvAvg = Exponential Moving Average

LinWgtMvAvg = Linear Weighted
Moving Average

**OutPutStartCell** - the
upper cell of the column where the formula results will be displayed.

**Percent** - the percentage to shift the upper and lower envelopes from the base moving average. For example, enter "10" to shift
the envelopes 10 percent above and below the base moving average.

**Period**
- the number of time periods used in calculation.

**Slowing** - the number of
time periods used in the internal smoothing of the %K value.

This section specifies which inputs are used in the formula calculation, i.e. 'Open', 'High', 'Low', 'Close' or 'Volume' values.

This section contains the examples of the TA
function call from **Autorun Macro** field of **BulkQuotesXL
Settings** worksheet . The parameters must be
separated by commas and may be (but not necessary) put in quotes or singled
out by gaps.

Copyright © 1998-2012 Franz AG

Visit website: http://www.analyzerxl.com

Send feedback: support@analyzerxl.com