Login     Register

        Contact Us     Search

XLeratorDB/windowing Documentation

Home


XLeratorDB/windowing

Use XLeratorDB/windowing for a wide variety of windowing analytical calculations. The feature-rich XLeratorDB function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

The XLeratorDB/windowing functions provide windowing features to SQL Server 2005 and later that are not otherwise available in all versions of SQL Server.

FUNCTION REFERENCE - WINDOWING FUNCTIONS
ANALYTIC FUNCTIONS
LAG Accesses data from a previous row in the same result set without the use of a self-join
   
RUNNING VALUES
RunningCOUNT Calculate the running count of records in a partition without the use of a self-join
RunningSUM Calculate the running sum without the use of a self-join
RunningAVG Calculate the running average without the use of a self-join
RunningMAX Calculate the running maximum value without the use of a self-join
RunningMIN Calculate the running minimum value without the use of a self-join
RunningDEVSQ Calculate the running sum of squares of deviations without the use of a self-join
RunningSTDEV Calculate the running standard deviation without the use of a self-join
RunningSTDEVP Calculate the running population standard deviation without the use of a self-join
RunningVAR Calculate the running simple variance without the use of a self-join
RunningVARP Calculate the running population variance without the use of a self-join
RunningCORREL Calculate the running Pearson product moment correlation coefficienwt without the use of a self-join
RunningCOVAR Calculate the running covariance without the use of a self-join
RunningFORECAST Calculate the running forecast value without the use of a self-join
RunningINTERCEPT Calculate the running intercept without the use of a self-join
RunningKURT_S Calculate running kurtosis values for a sample without the use of a self-join
RunningKURT_P Calculate running kurtosis values for a population without the use of a self-join
RunningPRODUCT    new! Calculate running product without the use of a self-join
RunningRSQ Calculate the running square of the Pearson product moment correlation coefficienwt without the use of a self-join
RunningSKEW_S Calculate running skewness values for a sample without the use of a self-join
RunningSKEW_P Calculate running skewness values for a population without the use of a self-join
RunningSLOPE Calculate the running slope without the use of a self-join
RunningSTEYX Calculate the running standard error in a regression without the use of a self-join
RunningTTEST Calculate running T-TEST values without the use of a self-join
RunningVOLATILITY    new! Calculate running volatility without the use of a self-join
   
MOVING VALUES
MovingCOUNT Count the number of moving rows without the use of a self-join
MovingSUM Calculate the moving sum without the use of a self-join
MovingAVG Calculate the moving average without the use of a self-join
MovingMAX Calculate the moving maximum without the use of a self-join
MovingMIN Calculate the moving minimum without the use of a self-join
MovingPRODUCT    new! Calculate the moving product without the use of a self-join
MovingDEVSQ Calculate the moving sum of squares of deviations without the use of a self-join
MovingSTDEV Calculate the moving sample standard deviation without the use of a self-join
MovingSTDEVP Calculate the moving population standard deviation without the use of a self-join
MovingVAR Calculate the moving sample variance without the use of a self-join
MovingVARP Calculate the moving population variance without the use of a self-join
MovingCORREL Calculate the moving Pearson product moment correlation coefficient without the use of a self-join
MovingCOVAR Calculate the moving covariance without the use of a self-join
MovingFORECAST Calculate the moving predicted value without the use of a self-join
MovingINTERCEPT Calculate the moving intercept without the use of a self-join
MovingKURT_S Calculate moving kurtosis values for a sample without the use of a self-join
MovingKURT_P Calculate moving kurtosis values for a population without the use of a self-join
MovingRSQ Calculate the moving square of the Pearson product moment correlation coefficient without the use of a self-join
MovingSKEW_S Calculate moving skewness values for a sample without the use of a self-join
MovingSKEW_P Calculate moving skewness values for a population without the use of a self-join
MovingSLOPE Calculate the moving slope without the use of a self-join
MovingSTEYX Calculate the moving standard error without the use of a self-join
MovingTTEST Calculate moving T-TEST values without the use of a self-join
MovingVOLATILITY    new! Calculate the moving volatility without the use of a self-join
   
MOVING AVERAGES
DEMA Calculate the daily exponential weighted moving average without the use of a self-join
DWMA Calculate a daily weighted moving average without the use of a self-join
RunningEWMA Calculate the running exponentially weighted moving average without the use of a self-join
MovingEWMA Calculate the exponentially weighted moving average without the use of a self-join
   
INVENTORY CALCULATIONS
FIFO Calculate running FIFO (first in, first out) values without the use of a self-join
LIFO Calculate running LIFO (last in, first out) values without the use of a self-join
WAC Calculate running weighted average cost values without the use of a self-join
   
CAPM - CAPITAL ASSET PRICING MODEL
RunningSHARPE Calculate running SHARPE values without the use of a self-join
RunningINFORATIO Calculate running INFORATIO values without the use of a self-join
MovingSHARPE Calculate moving SHARPE values without the use of a self-join
MovingINFORATIO Calculate moving INFORATIO values without the use of a self-join
   
Misc. Functions
XLDB_WINDOWING_VERSION Version Information

 



 |  View Topic History  |
Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service