ACCRINT |
ACCRINT(issue;first_interest;settlement;rate;par;frequency;basis) |
ACCRINTM |
ACCRINTM(issue;maturity;rate;par;basis) |
AMORDEGRC |
AMORDEGRC(cost;date_purchased;first_period;salvage;period;rate;basis) |
AMORLINC |
AMORLINC(cost;date_purchased;first_period;salvage;period;rate;basis) |
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;yld;frequency;basis) |
EFFECT |
EFFECT(nominal_rate;npery) |
FV |
FV(rate;nper;pmt;pv;type) |
FVSCHEDULE |
FVSCHEDULE(principal;schedule) |
INTRATE |
INTRATE(settlement;maturity;investment;redemption;basis) |
IPMT |
IPMT(rate;per;nper;pv;fv;type) |
IRR |
IRR(values;guess) |
ISPMT |
ISPMT(rate;per;nper;pv) |
MDURATION |
MDURATION(settlement;maturity;coupon;yld;frequency;basis) |
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;issue;first_coupon;rate;yld;redemption;frequency;basis) |
ODDFYIELD |
ODDFYIELD(settlement;maturity;issue;first_coupon;rate;pr;redemption;frequency;basis) |
ODDLPRICE |
ODDLPRICE(settlement;maturity;last_interest;rate;yld;redemption;frequency;basis) |
ODDLYIELD |
ODDLYIELD(settlement;maturity;last_interest;rate;pr;redemption;frequency;basis) |
PMT |
PMT(rate;nper;pv;fv;type) |
PPMT |
PPMT(rate;per;nper;pv;fv;type) |
PRICE |
PRICE(settlement;maturity;rate;yld;redemption;frequency;basis) |
PRICEDISC |
PRICEDISC(settlement;maturity;discount;redemption;basis) |
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;discount;basis) |
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;end_period;factor;no_switch) |
XIRR |
XIRR(values;dates;guess) |
XNPV |
XNPV(rate;values;dates) |
YIELD |
YIELD(settlement;maturity;rate;pr;redemption;frequency;basis) |
YIELDDISC |
YIELDDISC(settlement;maturity;pr;redemption;basis) |
YIELDMAT |
YIELDMAT(settlement;maturity;issue;rate;pr;basis) |