Documentation
Formulas
Weighted Moving Average
The Weighted Moving Average function computes the average of a set of input values over a specified number of time periods.
Exponential Smoothing
The Forecasting and Exponential Smoothing functions use exponential smoothing models to predict future values based on an analysis of historical time series data.
Correlation Matrix
The Correlation Matrix function calculates the strength of the relationships between possible pairings of the specified data series.
Correlation
The Correlation function calculates the strength of the relationship between two input data series.
Normal Distribution
The Normal Distribution function calculates the standard normal cumulative distribution for an input data series.
Percentile
The Percentile function returns a scalar value below which the specified percentage of input data values fall.
Histogram
The Histogram function assigns numeric values to bins and returns the counts.
Percent Rank
The Percent Rank function calculates the percent rank for each value in a set of input values.
Sample Standard Deviation
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.
Population Standard Deviation
The Population Standard Deviation function measures volatility as the difference between values and their average. A larger difference implies a larger standard deviation value.
Variance
The Variance function calculates the volatility of a set of input data values, such as stock prices over a period of time.
Minimum Subset
The Minimum Subset function returns the smallest or bottom value(s) in an input data series.
First Subset
The First Subset function returns the value(s) appearing first in an input data series.
Last Subset
The Last Subset function returns the value(s) appearing last in an input data series.
Middle Subset
The Middle Subset function returns the middle value(s) in an input data series.
Maximum Subset
The Maximum Subset function returns the largest or top value(s) in an input data series.
Zig Zag Subset
The Zig Zag Subset function returns the input data values that show movement greater than the specified sensitivity percentage value.
Accumulation Distribution
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.
Aroon Oscillator
The Aroon Oscillator function is calculated as the difference between the Aroon Up and Aroon Down indicators, with resulting values ranging from -100 to 100.
Average Directional Index
The Average Directional Index was developed by J. Welles Wilder. It combines two other indicators, the Positive Directional Indicator and the Negative Directional Indicator, which were also developed by Wilder.