Documentation
Standard
Mean (Simple Average)
The Average function computes the mean (or simple average) of a set of input values.
Bollinger Bands
The Bollinger Bands functions are based on methods developed by John Bollinger. They compute a pair of data values based on the moving average of the input value series.
Moving Average Envelopes
The Moving Average Envelopes functions compute a pair of data bands that envelop a moving average of the input data values.
Trend and Forecasting
The Trend and Forecasting function calculates a regression line or line of best fit. When applied to a time series, it can forecast future values.
Cumulative Total
The Cumulative Total function computes the cumulative total (or running sum) of a set of input values.
Exponential Moving Average
The Exponential Moving Average function computes the average of a set of input values over a specified number of time periods.
Historical Volatility
The Historical Volatility function calculates the volatility of a set of input data values, such as stock prices over a period of time.
Median
The Median function computes the median (e.g. middle) value from a set of input values.
Mode
The Mode function finds the value (or values) repeated more often than any other in a value series.
Moving Average
The Moving Average function computes the average of a set of input values over a specified number of time periods. The smaller the number of time periods, the faster the moving average responds to changes in the input values.
Totals (Sum)
The Sum function calculates the sum total for a set of input values.
Weighted Moving Average
The Weighted Moving Average function computes the average of a set of input values over a specified number of time periods.
Percent of Total
The Percent of Total functions return the percentage of each value in the input series out of the total sum of the values in the input series.
Rank Value
The Rank Value function returns the value found at the specified position, either starting from the highest or the lowest value.
K-Means Clustering
The Clustering function uses the K-Means algorithm to split data points into clusters based on similarity of the measures provided.
Distance
The Distance function computes the as-the-crow-flies distance between a source and destination identified by latitude and longitude.
Rank Function
The Rank function calculates the rank for each value in a set of input values.
Data Outliers
The Data Outlier functions identify the outliers in a set of input values.