Finance

ACCRINT — accrued interest
ACCRINTM — accrued interest
AMORDEGRC — depreciation of an asset using French accounting conventions
AMORLINC — depreciation of an asset using French accounting conventions
COUPDAYBS — number of days from coupon period to settlement
COUPDAYS — number of days in the coupon period of the settlement date
COUPDAYSNC — number of days from the settlement date to the next coupon period
COUPNCD — the next coupon date after settlement
COUPNUM — number of coupons
COUPPCD — the last coupon date before settlement
CUM_BIV_NORM_DIST — cumulative bivariate normal distribution
CUMIPMT — cumulative interest payment
CUMPRINC — cumulative principal
DB — depreciation of an asset
DDB — depreciation of an asset
DISC — discount rate
DOLLARDE — convert to decimal dollar amount
DOLLARFR — convert to dollar fraction
DURATION — the (Macaulay) duration of a security
EFFECT — effective interest rate
EURO — equivalent of 1 EUR
EUROCONVERT — pre-Euro amount from one currency to another
FV — future value
FVSCHEDULE — future value
G_DURATION — the duration of a investment
INTRATE — interest rate
IPMT — interest payment for period
IRR — internal rate of return
ISPMT — interest payment for period
MDURATION — the modified (Macaulay) duration of a security
MIRR — modified internal rate of return
NOMINAL — nominal interest rate
NPER — number of periods
NPV — net present value
ODDFPRICE — price of a security that has an odd first period
ODDFYIELD — yield of a security that has an odd first period
ODDLPRICE — price of a security that has an odd last period
ODDLYIELD — yield of a security that has an odd last period
OPT_2_ASSET_CORRELATION — theoretical price of options on 2 assets with correlation rho
OPT_AMER_EXCHANGE — theoretical price of an American option to exchange assets
OPT_BAW_AMER — theoretical price of an option according to the Barone Adesie & Whaley approximation
OPT_BINOMIAL — theoretical price of either an American or European style option using a binomial tree
OPT_BJER_STENS — theoretical price of American options according to the Bjerksund & Stensland approximation technique
OPT_BS — price of a European option
OPT_BS_CARRYCOST — elasticity of a European option
OPT_BS_DELTA — delta of a European option
OPT_BS_GAMMA — gamma of a European option
OPT_BS_RHO — rho of a European option
OPT_BS_THETA — theta of a European option
OPT_BS_VEGA — vega of a European option
OPT_COMPLEX_CHOOSER — theoretical price of a complex chooser option
OPT_EURO_EXCHANGE — theoretical price of a European option to exchange assets
OPT_EXEC — theoretical price of executive stock options
OPT_EXTENDIBLE_WRITER — theoretical price of extendible writer options
OPT_FIXED_STRK_LKBK — theoretical price of a fixed-strike lookback option
OPT_FLOAT_STRK_LKBK — theoretical price of floating-strike lookback option
OPT_FORWARD_START — theoretical price of forward start options
OPT_FRENCH — theoretical price of a European option adjusted for trading day volatility
OPT_GARMAN_KOHLHAGEN — theoretical price of a European currency option
OPT_JUMP_DIFF — theoretical price of an option according to the Jump Diffusion process
OPT_MILTERSEN_SCHWARTZ — theoretical price of options on commodities futures according to Miltersen & Schwartz
OPT_ON_OPTIONS — theoretical price of options on options
OPT_RGW — theoretical price of an American option according to the Roll-Geske-Whaley approximation
OPT_SIMPLE_CHOOSER — theoretical price of a simple chooser option
OPT_SPREAD_APPROX — theoretical price of a European option on the spread between two futures contracts
OPT_TIME_SWITCH — theoretical price of time switch options
PMT — payment for annuity
PPMT — interest payment for period
PRICE — price of a security
PRICEDISC — discounted price
PRICEMAT — price at maturity
PV — present value
RATE — rate of investment
RECEIVED — amount to be received at maturity
RRI — equivalent interest rate for an investment increasing in value
SLN — depreciation of an asset
SYD — sum-of-years depreciation
TBILLEQ — bond-equivalent yield for a treasury bill
TBILLPRICE — price of a treasury bill
TBILLYIELD — yield of a treasury bill
VDB — depreciation of an asset
XIRR — internal rate of return
XNPV — net present value
YIELD — yield of a security
YIELDDISC — yield of a discounted security
YIELDMAT — yield of a security