Login    Register

XLeratorDB/financial Documentation

Home


XLeratorDB/financial

Use XLeratorDB/financial for a wide variety of financial calculations. The feature-rich XLeratorDB function 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.

XLeratorDB/financial is available in two packages - XLeratorDB/financial which requires SQL Server 2005 or later, and XLeratorDB/financial 2008 which requires SQL Server 2008 or later. 

Functions denoted with '2008 only' are only available in the XLeratorDB/financial 2008 package and will not install or run  in SQL Server 2005. XLeratorDB 2008 packages contain functions which leverage SQL CLR features that are only available in SQL Server 2008 or later, namely 'multi-input aggregates' which provide a much easier calling syntax and typically run much faster than their scalar counterparts.

FUNCTION REFERENCE - FINANCIAL FUNCTIONS
RATES OF RETURN
EFV    new! Enhanced Future Value
EMDIETZ - 2008    new! Enhanced Modified Dietz  2008 only
ENPV Enhanced Net Present Value
ENPV_q Enhanced Net Present Value
ENPV - 2008    new! Enhanced Net Present Value  2008 only
EPV    new! Enhanced Present Value
FV Future Value
FVGA    new! Future Value of a Growing Annuity
FVSCHEDULE Future Value based on Compound Rates
IRR Internal Rate of Return
IRR_q Internal Rate of Return
IRR - 2008 Internal Rate of Return  2008 only
MDIETZ Modified Dietz
MDIETZ_q Modified Dietz
MIRR Modified Internal Rate of Return
MIRR_q Modified Internal Rate of Return
MIRR - 2008 Modified Internal Rate of Return  2008 only
NFV - 2008 Net Future Value  2008 only
NOMINAL Annual Nominal Interest Rate
NPER Number of Periods
NPERGA    new! Number of Periods of a Growing Annuity
NPV Net Present Value
NPV_q Net Present Value
NPV - 2008 Net Present Value  2008 only
PMTGA    new! Initial Payment of a Growing Annuity
PV Present Value
PVGA    new! Present Value of a Growing Annuity
RATE Interest Rate of an Annuity
TWRR - 2008    new! Time Weighted Rate of Return  2008 only
XFV    new! Future Value of a Cashflow between two dates
XIRR Internal Rate of Return with non-periodic cashflows
XIRR_q Internal Rate of Return with non-periodic cashflows
XIRR - 2008 Internal Rate of Return with non-periodic cashflows  2008 only
XMIRR - 2008 Modified Internal Rate of Return with non-periodic cashflows  2008 only
XNFV - 2008 Net Future Value for non-periodic cashflows  2008 only
XNPV Net Present Value for non-periodic cashflows
XNPV_q Net Present Value for non-periodic cashflows
XNPV - 2008 Net Present Value for non-periodic cashflows  2008 only
XPV    new! Discounted Value of a Cashflow between two dates
   
BOND FIGURATION
ACCRINT Accrued Interest
ACCRINTM Accrued Interest at Maturity
BONDINT Accrued Interest on a Bond
COUPDAYS Coupon Days
COUPDAYBS Coupon Days - beginning to settlement
COUPDAYSNC Coupon Days - settlement to next coupon
COUPNCD Coupon Days - next coupon date
COUPNUM Number of Coupon Days
COUPPCD Previous Coupon Date
DISC Discount Rate
DURATION Annual Duration of a Security
EDATE Maturity and Due dates
INTRATE Interest Rate of a Security
MDURATION Macauley Duration
ODDFINT Odd First Interest
ODDFPRICE Odd First Period Price
ODDFYIELD Odd First Period Yield
ODDLINT Odd Last Interest
ODDLPRICE Odd Last Period Price
ODDLYIELD Odd Last Period Yield
PRICE Price of a Security
PRICEDISC Price of a Discounted Security
PRICEMAT Price at Maturity
RECEIVED Amount Received at Maturity
TBILLEQ Bond Equivalent Yield of a Treasury Bill
TBILLPRICE Price of a Treasury Bill
TBILLYIELD Yield of a Treasury Bill
YIELD Yield of a Security
YIELDDISC Yield of a Discounted Security
YIELDMAT Yield with Interest at Maturity
   
LOANS
AMORTSCHED Amortization Schedule of a loan
CUMIPMT Cumulative Interest paid
CUMLIPMT Cumulative Interest payments of a loan
CUMLPPMT Cumulative Principal payments of a loan
CUMPRINC Cumulative Principal paid
EFFECT Maturity and Due dates
IPMT Interest Payment based on Constant Rate
LIPMT Interest Payment of a loan
LPMT Periodic Payment of a loan
LPPMT Principal Payment of a loan
NPD Next payment date of a loan
NPNO Next payment number of a loan
PMT Payment of an Annuity
PERIODRATE Adjust the nominal rate of a loan
PMTSCHED Payment Schedule of a loan
PPD Previous Payment date of a loan
PPMT Principal Payment
PPNO Previous Payment number of a loan
R78IPMT Interest Payment of a loan using Rule of 78
R78PAYOFF Payment amount of a loan using Rule of 78
R78PPMT Principal Payment of a loan using Rule of 78
R78REBATE Rebate amount of a loan using Rule of 78
TOTALINT Total interest amount of a loan
   
DEPRECIATION
DB Declining Balance
DDB Double Declining Balance
SLN Straight Line Depreciation
SYD Sum-of-Year's-Digits Depreciation
VDB Depreciation using Declining Balance
   
OTHER
CALCDATE    new! Convert MDY to date
DATEFLOAT    new! Convert MDY to float
DATEINT    new! Convert MDY to int
DOLLARDE Dollar - fraction to Decimal
DOLLARFR Dollar - decimal to Fraction
EOMONTH Last Day of Month
YEARFRAC Fraction of Year
   
   
XLDB_FINANCIAL_VERSION Version Information

 



 |  View Topic History  |
Copyright 2010 WestClinTech LLC         Privacy Policy        Terms of Service