ANALYTIC FUNCTIONS 
LAG 
Accesses data from a previous row in the same result set without the use of a selfjoin 


RUNNING VALUES 
RunningCOUNT 
Calculate the running count of records in a partition without the use of a selfjoin 
RunningSUM 
Calculate the running sum without the use of a selfjoin 
RunningAVG 
Calculate the running average without the use of a selfjoin 
RunningMAX 
Calculate the running maximum value without the use of a selfjoin 
RunningMIN 
Calculate the running minimum value without the use of a selfjoin 
RunningDEVSQ 
Calculate the running sum of squares of deviations without the use of a selfjoin 
RunningSTDEV 
Calculate the running standard deviation without the use of a selfjoin 
RunningSTDEVP 
Calculate the running population standard deviation without the use of a selfjoin 
RunningVAR 
Calculate the running simple variance without the use of a selfjoin 
RunningVARP 
Calculate the running population variance without the use of a selfjoin 
RunningCORREL 
Calculate the running Pearson product moment correlation coefficienwt without the use of a selfjoin 
RunningCOVAR 
Calculate the running covariance without the use of a selfjoin 
RunningFORECAST 
Calculate the running forecast value without the use of a selfjoin 
RunningINTERCEPT 
Calculate the running intercept without the use of a selfjoin 
RunningKURT_S 
Calculate running kurtosis values for a sample without the use of a selfjoin 
RunningKURT_P 
Calculate running kurtosis values for a population without the use of a selfjoin 
RunningPRODUCT new! 
Calculate running product without the use of a selfjoin 
RunningRSQ 
Calculate the running square of the Pearson product moment correlation coefficienwt without the use of a selfjoin 
RunningSKEW_S 
Calculate running skewness values for a sample without the use of a selfjoin 
RunningSKEW_P 
Calculate running skewness values for a population without the use of a selfjoin 
RunningSLOPE 
Calculate the running slope without the use of a selfjoin 
RunningSTEYX 
Calculate the running standard error in a regression without the use of a selfjoin 
RunningTTEST 
Calculate running TTEST values without the use of a selfjoin 
RunningVOLATILITY new! 
Calculate running volatility without the use of a selfjoin 


MOVING VALUES 
MovingCOUNT 
Count the number of moving rows without the use of a selfjoin 
MovingSUM 
Calculate the moving sum without the use of a selfjoin 
MovingAVG 
Calculate the moving average without the use of a selfjoin 
MovingMAX 
Calculate the moving maximum without the use of a selfjoin 
MovingMIN 
Calculate the moving minimum without the use of a selfjoin 
MovingPRODUCT new! 
Calculate the moving product without the use of a selfjoin 
MovingDEVSQ 
Calculate the moving sum of squares of deviations without the use of a selfjoin 
MovingSTDEV 
Calculate the moving sample standard deviation without the use of a selfjoin 
MovingSTDEVP 
Calculate the moving population standard deviation without the use of a selfjoin 
MovingVAR 
Calculate the moving sample variance without the use of a selfjoin 
MovingVARP 
Calculate the moving population variance without the use of a selfjoin 
MovingCORREL 
Calculate the moving Pearson product moment correlation coefficient without the use of a selfjoin 
MovingCOVAR 
Calculate the moving covariance without the use of a selfjoin 
MovingFORECAST 
Calculate the moving predicted value without the use of a selfjoin 
MovingINTERCEPT 
Calculate the moving intercept without the use of a selfjoin 
MovingKURT_S 
Calculate moving kurtosis values for a sample without the use of a selfjoin 
MovingKURT_P 
Calculate moving kurtosis values for a population without the use of a selfjoin 
MovingRSQ 
Calculate the moving square of the Pearson product moment correlation coefficient without the use of a selfjoin 
MovingSKEW_S 
Calculate moving skewness values for a sample without the use of a selfjoin 
MovingSKEW_P 
Calculate moving skewness values for a population without the use of a selfjoin 
MovingSLOPE 
Calculate the moving slope without the use of a selfjoin 
MovingSTEYX 
Calculate the moving standard error without the use of a selfjoin 
MovingTTEST 
Calculate moving TTEST values without the use of a selfjoin 
MovingVOLATILITY new! 
Calculate the moving volatility without the use of a selfjoin 


MOVING AVERAGES 
DEMA 
Calculate the daily exponential weighted moving average without the use of a selfjoin 
DWMA 
Calculate a daily weighted moving average without the use of a selfjoin 
RunningEWMA 
Calculate the running exponentially weighted moving average without the use of a selfjoin 
MovingEWMA 
Calculate the exponentially weighted moving average without the use of a selfjoin 


INVENTORY CALCULATIONS 
FIFO 
Calculate running FIFO (first in, first out) values without the use of a selfjoin 
LIFO 
Calculate running LIFO (last in, first out) values without the use of a selfjoin 
WAC 
Calculate running weighted average cost values without the use of a selfjoin 


CAPM  CAPITAL ASSET PRICING MODEL 
RunningSHARPE 
Calculate running SHARPE values without the use of a selfjoin 
RunningINFORATIO 
Calculate running INFORATIO values without the use of a selfjoin 
MovingSHARPE 
Calculate moving SHARPE values without the use of a selfjoin 
MovingINFORATIO 
Calculate moving INFORATIO values without the use of a selfjoin 


Misc. Functions 
XLDB_WINDOWING_VERSION 
Version Information 