XLeratorDB is a collection of function libraries to suit all of your needs. Every XLeratorDB 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.
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.
XLeratorDB / math adds dozens of new mathematical tools (that are precisely matched to Excel) to the two dozen native functions built into SQL Server. Plus, there are additional functions for the kind of large dataset analytics you wouldn’t dream of doing in a spreadsheet application.
Anyone familiar with the engineering functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB / engineering
XLeratorDB Financial Options package is a PREMIUM function package for SQL Server that contains specialized functions for Over-The-Counter (OTC) and Exchange-Traded-Options (ETO) option calculations.
XLeratorDB / statistics adds dozens of new statistical tools (that are precisely matched to Excel) to the native functions built into SQL Server. Plus, there are additional functions for the kind of large dataset analytics you wouldn’t dream of doing in a spreadsheet application.
Use XLeratorDB / strings for a wide variety of string processing and text manipulations. Anyone familiar with the string functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/strings.
Use XLeratorDB / windowing for a wide variety of windowing analytical calculations.
Learn how to authenticate your API requests.
Read about the different types of errors returned by the API.
Learn how to programmatically configure webhooks for your app.
Understand how to work with paginated responses.