Login
Register
Contact Us
Search
Menu
Home
Products
XLeratorDB
function packages
for SQL Server
financial
view documentation
pricing
statistics
view documentation
pricing
math
view documentation
pricing
engineering
view documentation
pricing
strings
view documentation
pricing
financialoptions
view documentation
pricing
windowing
view documentation
pricing
XLeratorDB
Compilation packages
for SQL Server
Suite
incl:
financial
,
statistics
,
math
,
engineering
&
strings
pricing
Suite (Developer)
requires SQL Server Developer Edition
pricing
Suite (Subscription)
Oneyear nonrecurring license
pricing
SuitePLUS
incl: all Suite packages PLUS
financialoptions
pricing
SuitePLUS (Developer)
requires SQL Server Developer Edition, also incl:
financialoptions
pricing
SuitePLUS (Subscription)
Oneyear nonrecurring license, also incl:
financialoptions
pricing
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
view documentation
pricing
SQL Server not required
View All Product Pricing ...
Download Free 15 Day Trial ...
Purchase
XLeratorDB
function packages for
SQL Server (2008 & later)
financial
statistics
math
engineering
strings
financialoptions
windowing
XLeratorDB
Compilation packages for
SQL Server (2008 & later)
Suite
Suite (Developer)
Suite (Subscription)
SuitePLUS
SuitePLUS (Developer)
SuitePLUS (Subscription)
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
Legacy XLeratorDB Packages for
SQL Server 2005
financial
for SQL Server 2005 only
statistics
for SQL Server 2005 only
math
for SQL Server 2005 only
Suite
for SQL Server 2005 only
Suite (Developer)
for SQL Server 2005 only
SuitePLUS
for SQL Server 2005 only
SuitePLUS (Developer)
for SQL Server 2005 only
Download Trial
Services
Case Studies
Blog
Support
XLeratorDB/windowing Documentation
Home
Search
Recent Changes
Show All Pages
Windowing Functions Index ...
Analytic Functions
LAG  obtain access to multiple rows within a resultant table, without the need for a selfjoin
Running Values
RunningCOUNT  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  sum of column values in an ordered resultant table, without the need for a selfjoin
RunningAVG  average of column values in an ordered resultant table, without having to do a selfjoin
RunningMAX  maximum of column values in an ordered resultant table, without the need for a selfjoin
RunningMIN  minimum of column values in an ordered resultant table, without the need for a selfjoin
RunningDEVSQ  sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin
RunningSTDEV  sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin
RunningSTDEVP  population standard deviation of column values in an ordered resultant table, without the need for a selfjoin
RunningVAR  sample variance of column values in an ordered resultant table, without the need for a selfjoin
RunningVARP  population variance of column values in an ordered resultant table, without the need for a selfjoin
RunningCORREL  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  covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
RunningFORECAST  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  intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
RunningKURT_S  sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin
RunningKURT_P  population kurtosis of column values in an ordered resultant table, without the need for a selfjoin
RunningPRODUCT  product of column values in an ordered resultant table, without the need for a selfjoin
RunningRSQ  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  samples skewness of column values in an ordered resultant table, without the need for a selfjoin
RunningSKEW_P  population skewness of column values in an ordered resultant table, without the need for a selfjoin
RunningSLOPE  slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
RunningSTEYX  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  Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin
RunningVOLATILITY  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  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  sum of column values in an ordered resultant table, without the need for a selfjoin
MovingAVG  moving average of column values in an ordered resultant table, without having to do a selfjoin
MovingMAX  maximum of column values in an ordered resultant table, without the need for a selfjoin
MovingMIN  minimum of column values in an ordered resultant table, without the need for a selfjoin
MovingPRODUCT  product of column values in an ordered resultant table, without the need for a selfjoin
MovingDEVSQ  sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin
MovingSTDEV  sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin
MovingSTDEVP  population standard deviation of column values in an ordered resultant table, without the need for a selfjoin
MovingVAR  sample variance of column values in an ordered resultant table, without the need for a selfjoin
MovingVARP  population variance of column values in an ordered resultant table, without the need for a selfjoin
MovingCORREL  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  covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
MovingFORECAST  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  intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
MovingKURT_S  sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin
MovingKURT_P  population kurtosis of column values in an ordered resultant table, without the need for a selfjoin
MovingRSQ  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  sample skewness of column values in an ordered resultant table, without the need for a selfjoin
MovingSKEW_P  population skewness of column values in an ordered resultant table, without the need for a selfjoin
MovingSLOPE  slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
MovingSTEYX  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  Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin
MovingVOLATILITY  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  daily exponential weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
DWMA  daily weighted moving average across multiple rows within a resultant table, without the need for a selfjoin
RunningEWMA  exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
MovingEWMA  exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
Inventory Calculations
FIFO  FIFO (first in, first out) values in an ordered resultant table
LIFO  LIFO (last in, first out) values in an ordered resultant table
WAC  running weighted average cost in an ordered resultant table
CAPM  Capital Asset Pricing Model
RunningSHARPE  Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin
RunningINFORATIO  information ratio from column values in an ordered resultant table without the need of a selfjoin
MovingSHARPE  Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin
MovingINFORATIO  information ratio from column values in an ordered resultant table without the need for a selfjoin
Misc Functions
XLDB_WINDOWING_VERSION  XLeratorDB / windowing version information
ALL FUNCTIONS (alpahbetical)
DEMA  daily exponential weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
DWMA  daily weighted moving average across multiple rows within a resultant table, without the need for a selfjoin
FIFO  FIFO (first in, first out) values in an ordered resultant table
LAG  obtain access to multiple rows within a resultant table, without the need for a selfjoin
LIFO  LIFO (last in, first out) values in an ordered resultant table
MovingAVG  moving average of column values in an ordered resultant table, without having to do a selfjoin
MovingCORREL  Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
MovingCOUNT  how many rows are included in an ordered resultant table or within a partition in the resultant table, without having to do a selfjoin
MovingCOVAR  covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
MovingDEVSQ  sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin
MovingEWMA  exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
MovingFORECAST  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
MovingINFORATIO  information ratio from column values in an ordered resultant table without the need for a selfjoin
MovingINTERCEPT  intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
MovingKURT_P  population kurtosis of column values in an ordered resultant table, without the need for a selfjoin
MovingKURT_S  sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin
MovingMAX  maximum of column values in an ordered resultant table, without the need for a selfjoin
MovingMIN  minimum of column values in an ordered resultant table, without the need for a selfjoin
MovingPRODUCT  product of column values in an ordered resultant table, without the need for a selfjoin
MovingRSQ  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
MovingSHARPE  Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin
MovingSKEW_P  population skewness of column values in an ordered resultant table, without the need for a selfjoin
MovingSKEW_S  sample skewness of column values in an ordered resultant table, without the need for a selfjoin
MovingSLOPE  slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
MovingSTDEV  sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin
MovingSTDEVP  population standard deviation of column values in an ordered resultant table, without the need for a selfjoin
MovingSTEYX  standard error of the predicted yvalue for each x in a regression within a resultant table or partition, without the need for a selfjoin
MovingSUM  sum of column values in an ordered resultant table, without the need for a selfjoin
MovingTTEST  Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin
MovingVAR  sample variance of column values in an ordered resultant table, without the need for a selfjoin
MovingVARP  population variance of column values in an ordered resultant table, without the need for a selfjoin
MovingVOLATILITY  historical volatility based upon price or valuation data from column values in an ordered resultant table, without the need for a selfjoin
RunningAVG  average of column values in an ordered resultant table, without having to do a selfjoin
RunningCORREL  Pearson product moment correlation coefficient through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
RunningCOUNT  how many rows are included in an ordered resultant table or within a partition in the resultant table, without having to do a selfjoin
RunningCOVAR  covariance through data points in y and xvalues within a resultant table or partition, without the need for a selfjoin
RunningDEVSQ  sum of squares of deviations of column values from their sample mean in an ordered resultant table, without the need for a selfjoin
RunningEWMA  exponentially weighted moving average of column values in an ordered resultant table, without the need for a selfjoin
RunningFORECAST  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
RunningINFORATIO  information ratio from column values in an ordered resultant table without the need of a selfjoin
RunningINTERCEPT  intercept of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
RunningKURT_P  population kurtosis of column values in an ordered resultant table, without the need for a selfjoin
RunningKURT_S  sample kurtosis of column values in an ordered resultant table, without the need for a selfjoin
RunningMAX  maximum of column values in an ordered resultant table, without the need for a selfjoin
RunningMIN  minimum of column values in an ordered resultant table, without the need for a selfjoin
RunningPRODUCT  product of column values in an ordered resultant table, without the need for a selfjoin
RunningRSQ  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
RunningSHARPE  Sharpe ratio from column values in an ordered resultant table without the need to a selfjoin
RunningSKEW_P  population skewness of column values in an ordered resultant table, without the need for a selfjoin
RunningSKEW_S  samples skewness of column values in an ordered resultant table, without the need for a selfjoin
RunningSLOPE  slope of a series of x and yvalues within a resultant table or partition, without the need for a selfjoin
RunningSTDEV  sample standard deviation of column values in an ordered resultant table, without the need for a selfjoin
RunningSTDEVP  population standard deviation of column values in an ordered resultant table, without the need for a selfjoin
RunningSTEYX  standard error of the predicted yvalue for each x in a regression within a resultant table or partition, without the need for a selfjoin
RunningSUM  sum of column values in an ordered resultant table, without the need for a selfjoin
RunningTTEST  Student’s tTest of column values in an ordered resultant table, without the need for a selfjoin
RunningVAR  sample variance of column values in an ordered resultant table, without the need for a selfjoin
RunningVARP  population variance of column values in an ordered resultant table, without the need for a selfjoin
RunningVOLATILITY  historical volatility based upon price or valuation data from column values in an ordered resultant table, without the need for a selfjoin
WAC  running weighted average cost in an ordered resultant table
XLDB_WINDOWING_VERSION  XLeratorDB / windowing version information
Recent Changes
Topic
Updated By
Updated On
List has no results...

Last 24 Hours

Last 7 days

Last Month
