Login     Register

        Contact Us     Search

XLeratorDB for SQL Server 2008


XLeratorDB (Financial 2008)

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

XLeratorDB (Statistics 2008)

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

XLeratorDB (Math 2008)

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 for SQL 2008

What's the difference between XLeratorDB and XLeratorDB for SQL Server 2008?


XLeratorDB for SQL Server 2008 must be run in a SQL Server 2008 or later version of SQL Server.  These XLeratorDB packages utilize SQL 2008 specific capabilites. Many 2008 functions are implemented as 'multi input aggregates' which have an easier calling syntax and typcially run much faster than their SQL 2005 equivalents.

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

"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

“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

"This is a very data processing intensive system that would not be possible without the use of XLeratorDB and SQL Server. XLeratorDB has made us a 15X return and it offers 500 times the processing that Excel is capable of."

Kenneth Jones
Founder and Managing Partner
Fusion Ventures

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service