Login     Register

        Contact Us     Search

XLeratorDB - Financial Analytics Package

  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 financial data; XLeratorDB/financial gives you a new level of power and accuracy to measure the returns and manage the risks.

XLeratorDB / financial includes functions for:

  • Rates of Return - IRR, XIRR, NPV, RATE, DIETZ, etc.
  • Bond Figurations - ACCRINT, PRICE and YIELD for ODD-First and ODD-Last 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.


XLeratorDB / financial - Documentation

SQL SERVER HAS NO NATIVE FINANCIAL FUNCTIONS. XLeratorDB functions combine the ease of use and flexibility of Excel functions with the power and reliability of SQL Server.  Plus XLeratorDB/financial offers a host of additional industry standard financial functions that are not available in Excel.

The XLeratorDB team has been creating, testing and optimizing complex financial functions for the SQL CLR platform since 2008. They are designed by leading industry professionals and utilize comprehensive testing harnesses to ensure accuracy.  In many cases, XLeratorDB functions produce results that are more accurate and reliable than those found in Excel.

In a matter of seconds you can calculate rates of return on millions of cashflows; calculate price and yield on millions of bonds, treasuries and securities; plus scores of other functions. All without moving data out of the database, and without incurring expensive man hours and resources to build and test complex financial algorithms.

Find out how our clients have experienced up to a 99% reduction in processing times simply by eliminating exports and imports to Excel - With precisely the same calculations running directly on the database.

All XLeratorDB functions are fully documented online and include a host of examples.  Plus you are provided with support via email and phone.  Don't see the function you need? - let us know!

 

 

Articles & Code Examples

Testimonials

"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

“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

"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

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service