Documentation

Formulas

The Percent Rank function calculates the percent rank for each value in a set of input values.

The Sample Standard Deviation function measures volatility as the difference between values and their moving average. A larger difference implies a larger standard deviation value.

The Population Standard Deviation function measures volatility as the difference between values and their average. A larger difference implies a larger standard deviation value.

The Variance function calculates the volatility of a set of input data values, such as stock prices over a period of time.

The Histogram function assigns numeric values to bins and returns the counts.

The Correlation Matrix calculates the strength of the relationships between possible pairings of the specified data series.

The Exponential Smoothing functions apply an exponentially-decreasing weight to historical data in order to forecast future values based on emerging trends.

The Minimum Subset function returns the smallest value(s) in an input data series.

The First Subset function returns the value(s) appearing first in an input data series.

The Last Subset function returns the value(s) appearing last in an input data series.

The Middle Subset function returns the middle value(s) in an input data series.

The Maximum Subset function returns the largest value(s) in an input data series.

The Zig Zag Subset function returns the input data values that show movement greater than the specified sensitivity percentage value.

The Williams %R (or Percent Range) function was developed by Larry Williams. It is similar to the Stochastic Oscillator function in that it relates the close price of a stock to its price range (high-low) over a specified number of time periods.

The Accumulation Distribution function is a technical indicator that considers both stock price and volume. Accumulation Distribution can be used to detect divergences between stock price movement and volume movement.

The Average True Range function computes an average of the True Range, which represents the range in price of a stock or commodity over the course of one day, or from one day to the next. Average True Range is used to indicate price volatility.

The Chaikin Money Flow function was developed by Marc Chaikin. It computes the sum of the Accumulation Distribution line values for a stock over a specified number of time periods, and divides this by the total stock volume over the same duration.

The Chaikin Oscillator function was developed by Marc Chaikin. It is calculated by subtracting the 10-day exponential moving average from the 3-day exponential moving average of the Accumulation Distribution line.

The Commodity Channel Index function was developed by Donald Lambert. It compares a stock price to its average over a specified number of time periods.

The Momentum function is a is a trend-following indicator that measures the speed of price movements by comparing the current stock price against its value from a specified number of time periods in the past.

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri