Technical Analysis Functions Library

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:
Send feedback: