ANALYTIC FUNCTIONS 
LAG 
Obtain access to multiple rows within a resultant table, without the need for a selfjoin. 

RUNNING VALUES 
RunningCOUNT 
Show how many rows are included in an ordered resultant table or within a partition in the resultant table, without having to do a selfjoin. 
RunningSUM 
Calculate the sum of column values in an ordered resultant table, without the need for a selfjoin. 
RunningAVG 
Calculate the average of column values in an ordered resultant table, without having to do a selfjoin. 
RunningMAX 
Calculate the maximum of column values in an ordered resultant table, without the need for a selfjoin. 
RunningMIN 
Calculate the minimum of column values in an ordered resultant table, without the need for a selfjoin. 
RunningDEVSQ 
Calculate the sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin. 
RunningSTDEV 
Calculate the sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin. 
RunningSTDEVP 
Calculate the population standard deviation of column values in an ordered resultant table, without the need for a selfjoin. 
RunningVAR 
Calculate the sample variance of column values in an ordered resultant table, without the need for a selfjoin. 
RunningVARP 
Calculate the population variance of column values in an ordered resultant table, without the need for a selfjoin. 
RunningCORREL 
Calculate the Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
RunningCOVAR 
Calculate the covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
RunningFORECAST 
Calculate the predicted value of y for a specific value of x for a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
RunningINTERCEPT 
Calculate the intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
RunningKURT_S 
Calculate the sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin. 
RunningKURT_P 
Calculate the population kurtosis of column values in an ordered resultant table, without the need for a selfjoin. 
RunningPRODUCT *!* 
Calculate the product of column values in an ordered resultant table, without the need for a selfjoin. 
RunningRSQ 
Calculate the square of the Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
RunningSKEW_S 
Calculate the samples skewness of column values in an ordered resultant table, without the need for a selfjoin. 
RunningSKEW_P 
Calculate the population skewness of column values in an ordered resultant table, without the need for a selfjoin. 
RunningSLOPE 
Calculate the slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
RunningSTEYX 
Calculate the standard error of the predicted yvalue for each x in a regression within a resultant table or partition, without the need for a selfjoin. 
RunningTTEST 
Calculate the Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin. 
RunningVOLATILITY *!* 
Calculate the historical volatility based upon price or valuation data from column values in an ordered resultant table, without the need for a selfjoin. 

MOVING VALUES 
MovingCOUNT 
Show how many rows are included in an ordered resultant table or within a partition in the resultant table, without having to do a selfjoin. 
MovingSUM 
Calculate the sum of column values in an ordered resultant table, without the need for a selfjoin. 
MovingAVG 
Calculate the moving average of column values in an ordered resultant table, without having to do a selfjoin. 
MovingMAX 
Calculate the maximum of column values in an ordered resultant table, without the need for a selfjoin. 
MovingMIN 
Calculate the minimum of column values in an ordered resultant table, without the need for a selfjoin. 
MovingPRODUCT *!* 
Calculate the product of column values in an ordered resultant table, without the need for a selfjoin. 
MovingDEVSQ 
Calculate the sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin. 
MovingSTDEV 
Calculate the sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin. 
MovingSTDEVP 
Calculate the population standard deviation of column values in an ordered resultant table, without the need for a selfjoin. 
MovingVAR 
Calculate the sample variance of column values in an ordered resultant table, without the need for a selfjoin. 
MovingVARP 
Calculate the population variance of column values in an ordered resultant table, without the need for a selfjoin. 
MovingCORREL 
Calculate the Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
MovingCOVAR 
Calculate the covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
MovingFORECAST 
Calculate the predicted value of y for a specific value of x for a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
MovingINTERCEPT 
Calculate the intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
MovingKURT_S 
Calculate the sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin. 
MovingKURT_P 
Calculate the population kurtosis of column values in an ordered resultant table, without the need for a selfjoin. 
MovingRSQ 
Calculate the square of the Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin. 
MovingSKEW_S 
Calculate the sample skewness of column values in an ordered resultant table, without the need for a selfjoin. 
MovingSKEW_P 
Calculate the population skewness of column values in an ordered resultant table, without the need for a selfjoin. 
MovingSLOPE 
Calculate the slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin. 
MovingSTEYX 
Calculate the standard error of the predicted yvalue for each x in a regression within a resultant table or partition, without the need for a selfjoin. 
MovingTTEST 
Calculate the Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin. 
MovingVOLATILITY *!* 
Calculate the historical volatility based upon price or valuation data from column values in an ordered resultant table, without the need for a selfjoin. 

MOVING AVERAGES 
DEMA 
Calculate the daily exponential weighted moving average of column values in an ordered resultant table, without the need for a selfjoin. 
DWMA 
Calculate a daily weighted moving average across multiple rows within a resultant table, without the need for a selfjoin. 
RunningEWMA 
Calculate the exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin. 
MovingEWMA 
Calculate the exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin. 

INVENTORY CALCULATIONS 
FIFO 
Calculate FIFO (first in, first out) values in an ordered resultant table. 
LIFO 
Calculate LIFO (last in, first out) values in an ordered resultant table. 
WAC 
Calculate running weighted average cost in an ordered resultant table. 

CAPM  CAPITAL ASSET PRICING MODEL 
RunningSHARPE 
Calculate the Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin. 
RunningINFORATIO 
Calculate the information ratio from column values in an ordered resultant table without the need of a selfjoin. 
MovingSHARPE 
Calculate the Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin. 
MovingINFORATIO 
Calculate the information ratio from column values in an ordered resultant table without the need for a selfjoin. 

OTHER 
XLDB_WINDOWING_VERSION 
Return XLeratorDB / windowing version information. 
