Login     Register

        Contact Us     Search

XLeratorDB - Financial Functions for SQL Server

 

XLeratorDB / financial 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.

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

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service