org.zkoss.zssex.formula.fn

Class FinancialFns

java.lang.Object

org.zkoss.zssex.formula.fn.FinancialFns

public class FinancialFns
extends java.lang.Object

Excel financial functions.

Author:

henrichen

Method Summary

Modifier and Type	Method and Description
static ValueEval	accrint(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	accrintm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	amordegrc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	amorlinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	coupdaybs(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	coupdays(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	coupdaysnc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	coupncd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	coupnum(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	couppcd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	cumipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	cumprinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	db(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	ddb(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	disc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	dollarde(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	dollarfr(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	duration(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	effect(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	fvschedule(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	intrate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	ipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	nominal(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	npv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	ppmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	price(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	pricedisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	pricemat(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	received(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	sln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	syd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	tbilleq(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	tbillprice(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	tbillyield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	xnpv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	yield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	yielddisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ValueEval	yieldmat(ValueEval[] args, int srcRowIndex, int srcColumnIndex)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

db

public static final ValueEval db(ValueEval[] args,
                                 int srcRowIndex,
                                 int srcColumnIndex)

ddb

public static final ValueEval ddb(ValueEval[] args,
                                  int srcRowIndex,
                                  int srcColumnIndex)

ipmt

public static final ValueEval ipmt(ValueEval[] args,
                                   int srcRowIndex,
                                   int srcColumnIndex)

ppmt

public static final ValueEval ppmt(ValueEval[] args,
                                   int srcRowIndex,
                                   int srcColumnIndex)

sln

public static final ValueEval sln(ValueEval[] args,
                                  int srcRowIndex,
                                  int srcColumnIndex)

syd

public static final ValueEval syd(ValueEval[] args,
                                  int srcRowIndex,
                                  int srcColumnIndex)

accrint

public static final ValueEval accrint(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

accrintm

public static final ValueEval accrintm(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

amordegrc

public static final ValueEval amordegrc(ValueEval[] args,
                                        int srcRowIndex,
                                        int srcColumnIndex)

amorlinc

public static final ValueEval amorlinc(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

coupdaybs

public static final ValueEval coupdaybs(ValueEval[] args,
                                        int srcRowIndex,
                                        int srcColumnIndex)

coupdays

public static final ValueEval coupdays(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

coupdaysnc

public static final ValueEval coupdaysnc(ValueEval[] args,
                                         int srcRowIndex,
                                         int srcColumnIndex)

coupncd

public static final ValueEval coupncd(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

coupnum

public static final ValueEval coupnum(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

couppcd

public static final ValueEval couppcd(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

cumipmt

public static final ValueEval cumipmt(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

cumprinc

public static final ValueEval cumprinc(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

disc

public static final ValueEval disc(ValueEval[] args,
                                   int srcRowIndex,
                                   int srcColumnIndex)

dollarde

public static final ValueEval dollarde(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

dollarfr

public static final ValueEval dollarfr(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

duration

public static final ValueEval duration(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

effect

public static final ValueEval effect(ValueEval[] args,
                                     int srcRowIndex,
                                     int srcColumnIndex)

fvschedule

public static final ValueEval fvschedule(ValueEval[] args,
                                         int srcRowIndex,
                                         int srcColumnIndex)

intrate

public static final ValueEval intrate(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

nominal

public static final ValueEval nominal(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

npv

public static final ValueEval npv(ValueEval[] args,
                                  int srcRowIndex,
                                  int srcColumnIndex)

price

public static final ValueEval price(ValueEval[] args,
                                    int srcRowIndex,
                                    int srcColumnIndex)

pricedisc

public static final ValueEval pricedisc(ValueEval[] args,
                                        int srcRowIndex,
                                        int srcColumnIndex)

pricemat

public static final ValueEval pricemat(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

received

public static final ValueEval received(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)

tbilleq

public static final ValueEval tbilleq(ValueEval[] args,
                                      int srcRowIndex,
                                      int srcColumnIndex)

tbillprice

public static final ValueEval tbillprice(ValueEval[] args,
                                         int srcRowIndex,
                                         int srcColumnIndex)

tbillyield

public static final ValueEval tbillyield(ValueEval[] args,
                                         int srcRowIndex,
                                         int srcColumnIndex)

xnpv

public static final ValueEval xnpv(ValueEval[] args,
                                   int srcRowIndex,
                                   int srcColumnIndex)

yield

public static final ValueEval yield(ValueEval[] args,
                                    int srcRowIndex,
                                    int srcColumnIndex)

yielddisc

public static final ValueEval yielddisc(ValueEval[] args,
                                        int srcRowIndex,
                                        int srcColumnIndex)

yieldmat

public static final ValueEval yieldmat(ValueEval[] args,
                                       int srcRowIndex,
                                       int srcColumnIndex)