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.

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.
• Loans - PMT, IMPT, CUMPRINC, AMORTSCHED, etc.
• Depreciation - DB, DDB, SLN, SYD,VDB
• Other Financial - EOMONTH, DOLLARFR, etc.

Click Here for the full Product Details

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

• Descriptive statistics – MODE, PERCENTILE, SKEW, etc.
• Statistical inference – CHISQ, TTEST, etc.
• Correlation & Regression Analysis - CORREL, SLOPE, etc
• Data collection – STEYX
• Probabilities – BETADIST, BETAI, PERMUT, etc.

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

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

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