Login     Register

XLeratorDB - Be an Analytics Hero

XLeratorDB lets you invoke an umatched range of functions for financial operating analytics right in SQL Server. Run rates of return, bond pricing, loan and lease schedules – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

If you know T-SQL and have used Excel, you will find these familiar functions so easy to use that you could be getting results within minutes after installing them. SQL Server can hold more than a terabyte of critical operational data; XLeratorDB gives you a new level of power and accuracy for your enterprise analytics computations.

NEW!
Premium Package
also available in Suite-PLUS
NEW!
Stand-alone
Package
Licensed for
Development
use only
Includes
Premium
Packages

XLeratorDB (Financial)

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 CLR 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

XLeratorDB (Statistics)

Realize the full power of SQL Server with in-database analytics. XLeratorDB lets you invoke dozens of standard statistical functions within the database – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

XLeratorDB/statistics 2008 includes SQL CLR 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

XLeratorDB (Math)

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 CLR 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

XLeratorDB (Engineering)

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 over 40 SQL CLR 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

XLeratorDB (Strings)

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 over 40 SQL CLR 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 (Suite)

XLeratorDB/suite includes all functions from all of the non-premium 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 of the functions from all of the non-premium 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)

XLeratorDB/developer includes all functions from all non-premium 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 all non-premium 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 (Financial-Options)

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 CLR functions for:

  • Binomials - BinomialAmerican, BinomialEuro, etc.
  • Bjerksund-Stensland
  • Black-Scholes-Merton
  • Option Matrix and OptionPL Matrix
  • Option Binomial Tree

Click Here for the full Product Details

XLeratorDB (Suite PLUS)

XLeratorDB Suite-PLUS includes all functions from all of the XLeratorDB packages including PREMIUM function packages such as 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 of the functions from all of the XLeratorDB packages, including PREMIUM 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)

XLeratorDB Developer-PLUS includes all functions from all XLeratorDB packages including PREMIUM function packages such as 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 all functions from all XLeratorDB packages, including PREMIUM packages:

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

Click Here for the full Product Details

XLeratorDB (Windowing)

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 native SQL Server 2005, 2008 and 2012.

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, SuitePLUS, or Developer compilation packages.

 

XLeratorDB/windowing includes SQL CLR 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

Click Here for the full Product Details

Additional Information

XLeratorDB Utilities

Verify your Server Name Configuration BEFORE YOU PURCHASE!

 

USE XLeratorDB/util's TestServer() function to verify that XLeratorDB products will install successfully with the server name you specify during checkout.

 

Testimonials

"Any company currently using the Excel kernel within its applications to handle complex calculations will find XLeratorDB most beneficial, It’s an overall great product – flexible, yet reliable."

Chet Cotter
Director of Financial Systems
Newland Communities, LLC

“Before XLeratorDB, there was no easy-to-use, built in solution for XIRR calculation in SQL Server, XLeratorDB is the first product to bridge that gap and streamlines the process for us.

Munish Kumar
Investment Analyst
The Sentient Group

"We’ve saved as much as 20-30 percent of total development time thanks to XLeratorDB, With XLeratorDB, we can give our clients the means to automate many of their underwriting decisions, lowering their costs and reducing errors."

Jason Daniels
Chief Operating Officer
Verde International

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service