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