accrint

double accrint(Object issue, Object firstIneterest, Object settlement, double rate,double par, double frequency, double basis)

返回定期付息证券的应计利息。

double

accrintm

accrintm(Object issue, Object maturity, double rate, double par,double basis)

返回在到期日支付利息的债券的应计利息。

double

amordegrc

amordegrc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, intbasis)

返回使用折旧系数的每个记帐期的折旧值。

double

amorlinc

amorlinc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, int basis)

返回每个记帐期的折旧值。

double

coupdaybs

coupdaybs(Object settlement, Object maturity, double frequency, int basis)

返回从付息期开始到成交日之间的天数。

double

coupdays

coupdays(Object settlement, Object maturity, double frequency, double basis)

返回在优惠期的天数，包括结算日期。

int

coupdaysnc

coupdaysnc(Object settlement, Object maturity, double frequency, double basis)

返回从成交日到下一付息日之间的天数。

double

coupncd

coupncd(Object settlement, Object maturity, double frequency, double basis)

返回成交日之后的下一个付息日。

date

coupnum

coupnum(Object settlement, Object maturity, double frequency, double basis)

返回成交日和到期日之间的应付利息次数。

int

couppcd

couppcd(Object settlement, Object maturity, double frequency, double basis)

返回成交日之前的上一付息日。

date

cumipmt

cumipmt(double rate, int nper, double pv, double start,double end, int type)

返回两个付款期之间累积支付的利息。

double

cumprinc

cumprinc(double rate, int nper, double pv, double start, double end,int type)

返回两个付款期之间为贷款累积支付的本金。

double

financialDb

financialDb

(double cost, double salvage, double life, double period, double month)

使用固定余额递减法，返回一笔资产在给定期间内的折旧值。

double

ddb

ddb(double cost, double salvage, double life, double period, double factor)

使用双倍余额递减法或其他指定方法，返回一笔资产在给定期间内的折旧值。

double

disc

disc(Object settlement, Object maturity, double pr, double redemption, double basis)

返回债券的贴现率。

double

duration

duration(Object settlement, Object maturity, double coupon, double yld, double frequency, double basis)

返回定期支付利息的债券的每年期限。

double

effect

effect(double nominal_rate, double npery)

返回年有效利率。

double

fv

fv(double rate, int nper, double pmt, double pv, int type)

返回一笔投资的未来值。

double

fvschedule

fvschedule(double principal, Object scheduleObj)

返回应用一系列复利率计算的初始本金的未来值。

double

intrate

intrate(Object settlement, Object maturity, double investment,double redemption, double basis)

返回完全投资型债券的利率。

double

ipmt

ipmt(double rate, int per, int nper, double pv, double fv, int type)

返回一笔投资在给定期间内支付的利息。

double

ispmt

ispmt(double rate, int per, int nper, double pv)

计算特定投资期内要支付的利息。

double

mduration

mduration(Object settlement, Object maturity, double coupon, double yld,double frequency, double basis)

返回假设面值为￥100的有价证券的Macauley修正期限。

double

mirr

mirr(Object valuesObj, double finance_rate, double reinvest_rate)

返回正和负现金流以不同利率进行计算的内部收益率。

String

nominal

nominal(double rate, double npery)

返回年度的名义利率。

double

nper

nper(double rate, double pmt, double pv, double fv, int type)

返回投资的期数。

double

npv

npv(double rate, Object valuesObj)

返回基于一系列定期的现金流和贴现率计算的投资净现值。

double

pmt

pmt(double rate, int nper, double pv, double fv, int type)

返回年金的定期支付金额。

double

ppmt

ppmt(double rate, int per, int nper, double pv, double fv, int type)

返回一笔投资在给定期间内偿还的本金。

double

price

price(Object settlement, Object maturity, double rate, double yield,double redemption, double frequency, int basis)

返回每张票面为￥100且定期支付利息的债券的现价。

double

pricedisc

pricedisc(Object settlement, Object maturity, double discount,double redemption, double basis)

返回每张票面为￥100的已贴现债券的现价。

double

pricemat

pricemat(Object settlement, Object maturity, Object issue, double rate,double yield, double basis)

返回每张票面为￥100且在到期日支付利息的债券的现价。

double

pv

pv(double rate, int nper, double pmt, double fv, int type)

返回投资的现值。

double

received

received(Object settlement, Object maturity, double investment, double discount, double basis)

返回完全投资型债券在到期日收回的金额。

double

sln

sln(double cost, double salvage, int life)

返回固定资产的每期线性折旧费。

double

syd

syd(double cost, double salvage, double life, double per)

资产在某一特定时期内年数总和折旧值。

double

tbilleq

tbilleq(Object settlement, Object maturity, double discount)

返回国库券的等价债券收益。

double

tbillprice

tbillprice(Object settlement, Object maturity, double discount)

返回面值￥100的国库券的价格。

double

tbillyield

tbillyield(Object settlement, Object maturity, double par)

返回国库券的收益率。

double

vdb

vdb(double cost, double salvage, double life, double start_period,double end_period, double factor, boolean flag)

使用余额递减法，返回一笔资产在给定期间或部分期间内的折旧值。

double

xnpv

xnpv(double rate, Object valuesObj, Object datesObj)

返回一组现金流的净现值，这些现金流不一定定期发生。

double

yielddisc

yielddisc(Object settlement, Object maturity, double pr, double redemption,double basis)

返回已贴现债券的年收益。

➢例如：短期国库券

double

yieldmat

yieldmat(Object settlement, Object maturity, Object issue, double rate, double pr, double basis)

返回在到期日支付利息的债券的年收益。

double