Login     Register

XLeratorDB Technical Documentation

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.

View a full function list of each library by clicking the links below.

XLeratorDB Financial

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.

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

View Complete Financial Function Reference

XLeratorDB Financial Options Functions

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, including:

  • Calculations for American and European options
  • Implied Volatility, Price, Greeks, Derivatives, Trees
  • BinomialAmerican, BinomialEuro, Binomial Tree
  • Binary Barrier options, Standard Barrier options
  • Bjerksund-Stensland
  • Black-Scholes-Merton
  • Option Matrix and OptionPL Matrix
  • Binomial Discrete Dividends
  • Proportional Dividends
  • Non-recombining Trees

View Complete Financial Options Function Reference

XLeratorDB Statistics Functions

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.

  • Continuous data - MODE, GEOMEAN, etc.
  • Dispersion  - PERCENTILE, COVAR, etc.
  • Shape - KURT, SKEW, etc.
  • Statistical inference including: specific tests - CHISQ, TTEST, etc.
  • Correlation and Regression Analysis including: Correlation - CORREL, PROB, etc.
  • Linear regression - SLOPE, TREND, etc.
  • Data collection: Sampling - STEYX
  • Probabilities including: Distributions - BETADIST, LOGINV, etc.
  • Combinatory - BETAI, PERMUT, etc.
  • Interobserver Agreeement including: Cohen's Kappa, Fleiss's Kappa (κ)
  • Intra Class Coefficient - ICC
  • Kendall's tau (τ), Kendall's coefficient of concordance (w)
  • Wilcoxon signed-rank and Wilcoxon matched-pair
  • McNemar, Spearman, etc.

View Complete Statistics Function Reference

XLeratorDB Math Functions

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.

  • Arithmetic/Algebra - PRODUCT, MROUND, WAVG, GCD, QUOTIENT, PRODUCT38, DISTANCE, etc.
  • Trigonometry - ACOSH, SEC, CSC, TANH, etc.
  • Number Generators - RANDBETWEEN, SERIESINT, RANDNORMAL, etc.
  • Interpolations - INTERP, SPLINE, POLYFIT, POLYINTERP, etc.
  • Numerical Integration - QUAD, QUADTS, QUADOSC, etc.
  • Matrix Functions - MMULT, MINVERSE, QRdecomp, LUdecomp, BKSUB, FWDSUB, TRANSPOSE, etc.

View Complete Math Function Reference

XLeratorDB Engineering Functions

Anyone familiar with the engineering functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB / engineering

  • Engineering Functions - Engineering / Base Conversions / Complex Numbers
  • Unit Conversion Functions - Area / Length / Speed / Temperature / Volume / Weight

View Complete Engineering Function Reference

XLeratorDB String Functions

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.

  • Formatting / Inspection / Calendar / Logic

View Complete String Function Reference

XLeratorDB Windowing Analytical Functions

Use XLeratorDB / windowing for a wide variety of windowing analytical calculations.

  • Analytic Functions / Running Values / Moving Values / Moving Averages / Inventory Calculations / CAPM (Capital Asset Pricing Model)

View Complete Windowing Analytical Function Reference

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service