ACCRINT
ACCRINT(issue, first_interest, settlement, ...)
ACCRINTM
ACCRINTM(issue, settlement, rate, par, [basis])
AMORDEGRC
AMORDEGRC(cost, date_purchased, ...)
AMORLINC
AMORLINC(cost, date_purchased, first_period, ...)
COUPDAYBS
COUPDAYBS(settlement, maturity, frequency, [basis])
COUPDAYS
COUPDAYS(settlement, maturity, frequency, [basis])
COUPDAYSNC
COUPDAYSNC(settlement, maturity, frequency, [basis])
COUPNCD
COUPNCD(settlement, maturity, frequency, [basis])
COUPNUM
COUPNUM(settlement, maturity, frequency, [basis])
COUPPCD
COUPPCD(settlement, maturity, frequency, [basis])
CUMIPMT
CUMIPMT(rate, nper, pv, start_period, end_period, type)
CUMPRINC
CUMPRINC(rate, nper, pv, start_period, end_period, type)
DB
DB(cost, salvage, life, period, [month])
DDB
DDB(cost, salvage, life, period, [factor])
DISC
DISC(settlement, maturity, pr, redemption, [basis])
DOLLARDE
DOLLARDE(fractional_dollar, fraction)
DOLLARFR
DOLLARFR(decimal_dollar, fraction)
DURATION
DURATION(settlement, maturity, coupon, ...)
EFFECT
EFFECT(nominal_rate, npery)
FV
FV(rate, nper, pmt, [pv], [type])
FVSCHEDULE
FVSCHEDULE(principal, schedule)
INTRATE
INTRATE(settlement, maturity, investment, ...)
IPMT
IPMT(rate, per, nper, pv, [fv], [type])
IRR
IRR(values, [guess])
ISPMT
ISPMT(rate, per, nper, pv)
MDURATION
MDURATION(settlement, maturity, ...)
MIRR
MIRR(values, finance_rate, reinvest_rate)
NOMINAL
NOMINAL(effect_rate, npery)
NPER
NPER(rate, pmt, pv, [fv], [type])
NPV
NPV(rate, value1, [value2], ...)
ODDFPRICE
ODDFPRICE(settlement, maturity, ...)
ODDFYIELD
ODDFYIELD(settlement, maturity, ...)
ODDLPRICE
ODDLPRICE(settlement, maturity, ...)
ODDLYIELD
ODDLYIELD(settlement, maturity, ...)
PDURATION
PDURATION(rate, pv, fv)
PMT
PMT(rate, nper, pv, [fv], [type])
PPMT
PPMT(rate, per, nper, pv, [fv], [type])
PRICE
PRICE(settlement, maturity, rate, ...)
PRICEDISC
PRICEDISC(settlement, maturity, ...)
PRICEMAT
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
PV
PV(rate, nper, pmt, [fv], [type])
RATE
RATE(nper, pmt, pv, [fv], [type], [guess])
RECEIVED
RECEIVED(settlement, maturity, investment, ...)
RRI
RRI(nper, pv, fv)
SLN
SLN(cost, salvage, life)
SYD
SYD(cost, salvage, life, per)
TBILLEQ
TBILLEQ(settlement, maturity, discount)
TBILLPRICE
TBILLPRICE(settlement, maturity, discount)
TBILLYIELD
TBILLYIELD(settlement, maturity, pr)
VDB
VDB(cost, salvage, life, start_period, ...)
XIRR
XIRR(values, dates, [guess])
XNPV
XNPV(rate, values, dates)
YIELD
YIELD(settlement, maturity, rate, ...)
YIELDDISC
YIELDDISC(settlement, maturity, pr, redemption, [basis])
YIELDMAT
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Financial
Financial functions allow to calculate financial metrics.