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