Use XLeratorDB/financial for a wide variety of financial 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.

XLeratorDB / financial includes SQL Server functions for:

• Rates of Return - IRR, XIRR, NPV, RATE, DIETZ, etc.
• Bond Figurations - ACCRINT, PRICE and YIELD for both ODDF and ODDL coupons, etc.
• Capital Asset Pricing Model - INFORATIO, SHARPE, SORTINO, TREYNOR, etc.
• Loans - PMT, IPMT, CUMPRINC, AMORTSCHED, etc.
• Depreciation - DB, DDB, SLN, SYD,VDB
• Yield Curve Construction - SWAPCURVE, NELSONSIEGEL, INTERPDFACT, ZEROCOUPON, etc.
• Business Dates - EOMONTH, FIRSTWEEKDAY, BUSDAYS, DAYS360, YEARFRAC, TENOR2DATE, etc.

Click Here for the full Product Details

Use the XLeratorDB/statistics package for a wide variety of advanced in-database analytics statistical functions. 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 documentation, below, includes sample SQL.

XLeratorDB / statistics includes SQL Server functions for:

• Descriptive statistics
• Statistical inference – specific tests - CHISQ, TTEST, etc.
• Correlation and Regression Analysis
• Data collection - STYEX
• Probabilities

Click Here for the full Product Details

Use XLeratorDB/math for a wide variety of mathematical 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 documentation, below, includes sample SQL.

XLeratorDB / math includes SQL Server functions for:

• Arithmetic/Algebra - PRODUCT, MROUND, etc.
• Trigonometry - ACOSH, SEC, TANH, etc.
• Number Generators - RANDBETWEEN, SERIESINT, etc.
• Interpolations - INTERP, SPLINE, etc.
• Matrix Functions  - MMULT, MINVERSE, etc.

Click Here for the full Product Details

Use XLeratorDB/engineering for a wide variety of engineering 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.

XLeratorDB / engineering includes SQL Server functions for:

• Engineering – BESSELI/J/K/Y, ERFC, etc.
• Base Conversions – BIN2DEC, OCT2HEX, etc.
• Complex Numbers – COMPLEX, IMSQRT, IMREAL, etc.

Plus over 70 unit conversion functions for:

• Area, Length, Speed, Temperature, Volume, Weight

Click Here for the full Product Details

Use XLeratorDB/strings for a wide variety of string manipulations. The feature-rich XLeratorDB function library lets you include text manipulations 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.

XLeratorDB / strings includes SQL Server functions for:

• Formatting – CONCAT, PARSE, TEXT, SPLIT, etc.
• Information – COUNTSTRING, FIND, ISALPHA, etc.
• Calendarizations – NETWORKDAYS, WORKDAYS,etc.
• Conditional formatting - IIFSTR

Click Here for the full Product Details

XLeratorDB/financial-options is a PREMIUM XLeratorDB function package, which contains specialized, high-valued functions for specific industry segments.

Use XLeratorDB/financial-options for OTC and ETO financial-options 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.

XLeratorDB / financial-options includes SQL Server functions for:

• Binomials - BinomialAmerican, BinomialEuro, Binomial Tree
• Binary Barrier Options
• Bjerksund-Stensland
• Black-Scholes-Merton
• Option Matrix and OptionPL Matrix

Click Here for the full Product Details

XLeratorDB Suite includes all functions from these XLeratorDB packages - functions to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

Includes all functions from these XLeratorDB packages:

• XLeratorDB / financial
• XLeratorDB / math
• XLeratorDB / statistics
• XLeratorDB / engineering (includes unit conversions)
• XLeratorDB / strings

Click Here for the full Product Details

Click Here for SuitePLUS

XLeratorDB Developer includes all functions from these XLeratorDB packages. For use with SQL Server Developer editions, use this package to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

Includes all functions from these XLeratorDB packages:

• XLeratorDB / financial
• XLeratorDB / math
• XLeratorDB / statistics
• XLeratorDB / engineering (& unit conversions)
• XLeratorDB / strings

Click Here for the full Product Details

Click Here for Developer PLUS

XLeratorDB Suite - Annual Subscription includes all functions from these XLeratorDB packages. For use with SQL Server 2008, 2012, 2014, 2016, use this package to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

The subscription package license is valid for one year and is suitable for installation on development and test servers. Unlike XLeratorDB-Developer this package does not require the Developer Edition of SQL Server.

Includes all functions from these XLeratorDB packages:

• XLeratorDB / financial 2008
• XLeratorDB / math 2008
• XLeratorDB / statistics 2008
• XLeratorDB / engineering (& unit conversions)
• XLeratorDB / strings

Click Here for the full Product Details

Click Here for Subscription PLUS

XLeratorDB SuitePLUS includes all functions from the XLeratorDB Suite package PLUS XLeratorDB/financial-options - functions to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

Includes all functions from these XLeratorDB packages:

• XLeratorDB / financial
• XLeratorDB / math
• XLeratorDB / statistics
• XLeratorDB / engineering (includes unit conversions)
• XLeratorDB / strings
• XLeratorDB / financial-options

Click Here for the full Product Details

XLeratorDB DeveloperPLUS includes all functions from the XLeratorDB Developer package PLUS XLeratorDB/financial-options. For use with SQL Server Developer editions, use this package to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

Includes functions from all these packages, including:

• XLeratorDB / financial
• XLeratorDB / math
• XLeratorDB / statistics
• XLeratorDB / engineering (& unit conversions)
• XLeratorDB / strings
• XLeratorDB / financial-options

Click Here for the full Product Details

XLeratorDB SuitePLUS - annual subscription includes all functions from the XLeratorDB Subscription package PLUS XLeratorDB/financial-options. For use with SQL Server 2008 / 2012 / 2014 / 2016, use this package to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel you can now bring the power of those functions into the T-SQL environment.

The SubscriptionPLUS package license is valid for one year and is suitable for installation on development and test servers. Unlike XLeratorDB Developer this package does not require the Developer Edition of SQL Server.

Includes functions from these XLeratorDB packages:

• XLeratorDB / financial 2008
• XLeratorDB / math 2008
• XLeratorDB / statistics 2008
• XLeratorDB / engineering (& unit conversions)
• XLeratorDB / strings
• XLeratorDB / financial-options

Click Here for the full Product Details

XLeratorDB/windowing contains advanced windowing analytical functions for SQL Server 2005 and later.

Use XLeratorDB/windowing to perform sophisticated windowing queries that cannot be done with the native SQL Server windowing functions.

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.

XLeratorDB/windowing is a stand-alone package. It is not included in the XLeratorDB Suite, Developer or Subscription compilation packages.

XLeratorDB/windowing includes SQL Server functions for:

• Lag
• Running Count, Sum, Avg, STDEV, VAR, etc.
• Moving Count, Sum, Avg, STDEV, VAR, etc
• Running Slope, Intercept, Forecast, etc.
• Moving Slope, Intercept, Forecast, etc.
• Moving Averages
• Moving and Running Kurtosis, Skew, T-Test, etc.

Click Here for the full Product Details

The XLeratorDLL function library for .NET complements the XLeratorDB family of products and is perfect for organizations that can benefit from rapidly building sophisticated financial applications using the same rich set of functions found in XLeratorDB but without the SQL Server requirement!

XLeratorDLL/financial includes .NET functions for:

• Rates of Return - IRR, XIRR, NPV, RATE, DIETZ, etc.
• Bond Figurations - ACCRINT, PRICE and YIELD for both ODDF and ODDL coupons, etc.
• Capital Asset Pricing Model - INFORATIO, SHARPE, SORTINO, TREYNOR, etc.
• Loans - PMT, IPMT, CUMPRINC, AMORTSCHED, etc.
• Depreciation - DB, DDB, SLN, SYD,VDB
• Yield Curve Construction - SWAPCURVE, NELSONSIEGEL, INTERPDFACT, ZEROCOUPON, etc.
• Business Dates - EOMONTH, FIRSTWEEKDAY, BUSDAYS, DAYS360, YEARFRAC, TENOR2DATE, etc.

Click Here for the full Product Details