public class Excel
extends java.lang.Object
Modifier and Type | Method and Description |
---|---|
static double |
ACCRINT(java.util.Date issueDate,
java.util.Date firstInterestDate,
java.util.Date settlementDate,
java.lang.Object couponRate,
java.lang.Object parValue,
PaymentFrequency paymentFrequency)
Calculates the total accrued interest from issue to settlement
for a security that pays periodic interest based on US (NASD) 30/360 day
count basis.
|
static double |
ACCRINT(java.util.Date issueDate,
java.util.Date firstInterestDate,
java.util.Date settlementDate,
java.lang.Object couponRate,
java.lang.Object parValue,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the total accrued interest from issue to settlement
for a security that pays periodic interest based on specified day
count basis.
|
static double |
ACCRINT(java.util.Date issueDate,
java.util.Date firstInterestDate,
java.util.Date settlementDate,
java.lang.Object couponRate,
java.lang.Object parValue,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis,
InterestCalcMethod method)
Calculates the accrued interest for a security that pays periodic
interest.
|
static double |
ACCRINTM(java.util.Date issueDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object parValue)
Calculates the accrued interest for a security that pays interest at
maturity based on US (NASD) 30/360 day count basis.
|
static double |
ACCRINTM(java.util.Date issueDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object parValue,
DayCountBasis dayCountBasis)
Calculates the accrued interest for a security that pays interest at
maturity.
|
static double |
AMORDEGRC(java.lang.Object costOfAsset,
java.util.Date purchaseDate,
java.util.Date firstPeriod,
java.lang.Object salvageValue,
java.lang.Object period,
java.lang.Object rateOfDepreciation)
Calculates the depreciation for each accounting period based on 360 days
(NASD method) year basis.
|
static double |
AMORDEGRC(java.lang.Object costOfAsset,
java.util.Date purchaseDate,
java.util.Date firstPeriod,
java.lang.Object salvageValue,
java.lang.Object period,
java.lang.Object rateOfDepreciation,
YearBasis yearBasis)
Calculates the depreciation for each accounting period.
|
static double |
AMORLINC(java.lang.Object costOfAsset,
java.util.Date purchaseDate,
java.util.Date firstPeriod,
java.lang.Object salvageValue,
java.lang.Object period,
java.lang.Object rateOfDepreciation)
Calculates the depreciation for each accounting period based on 360 days
(NASD method) year basis.
|
static double |
AMORLINC(java.lang.Object costOfAsset,
java.util.Date purchaseDate,
java.util.Date firstPeriod,
java.lang.Object salvageValue,
java.lang.Object period,
java.lang.Object rateOfDepreciation,
YearBasis yearBasis)
Calculates the depreciation for each accounting period.
|
static double |
COUPDAYBS(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates the number of days from the beginning of a coupon period until
its settlement date based on US (NASD) 30/360 day count basis.
|
static double |
COUPDAYBS(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the number of days from the beginning of a coupon period until
its settlement date.
|
static double |
COUPDAYS(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates the number of days in the coupon period that contains the
settlement date based on US (NASD) 30/360 day count basis.
|
static double |
COUPDAYS(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the number of days in the coupon period that contains the
settlement date.
|
static double |
COUPDAYSNC(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates the number of days from the settlement date to the next coupon
date based on US (NASD) 30/360 day count basis.
|
static double |
COUPDAYSNC(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the number of days from the settlement date to the next coupon
date.
|
static java.util.Date |
COUPNCD(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates a number that represents the next coupon date after the
settlement date based on US (NASD) 30/360 day count basis.
|
static java.util.Date |
COUPNCD(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates a number that represents the next coupon date after the
settlement date.
|
static double |
COUPNUM(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates the number of coupons payable between the settlement date and
maturity date based on US (NASD) 30/360 day count basis.
|
static double |
COUPNUM(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the number of coupons payable between the settlement date and
maturity date.
|
static java.util.Date |
COUPPCD(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency)
Calculates the previous coupon date before the settlement date based on a
360 day year basis.
|
static java.util.Date |
COUPPCD(java.util.Date settlementDate,
java.util.Date maturityDate,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the previous coupon date before the settlement date.
|
static double |
CUMIPMT(java.lang.Object interestRate,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object startPeriod,
java.lang.Object endPeriod,
PaymentType paymentType)
Calculates the cumulative interest paid on a loan between starting period (see section Value Reference)
and ending period.
|
static double |
CUMPRINC(java.lang.Object interestRate,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object startPeriod,
java.lang.Object endPeriod,
PaymentType paymentType)
Calculates cumulative principal paid on a loan between a start period and
ending period.
|
static double |
DATEDIF(java.util.Date startDate,
java.util.Date endDate)
Calculates the number of days between two dates.
|
static double |
DATEDIF(java.util.Date startDate,
java.util.Date endDate,
DateUnit unit)
Calculates the number of days, months, or years between two dates.
|
static double |
DB(java.lang.Object intialCostOfAsset,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods,
java.lang.Object period)
Calculates the depreciation of an asset for a specified period by using
the double-declining balance method or some other method that you specify.
|
static double |
DB(java.lang.Object intialCostOfAsset,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods,
java.lang.Object period,
java.lang.Object months)
Calculates the depreciation of an asset for a specified period by using
the double-declining balance method or some other method that you specify.
|
static double |
DDB(java.lang.Object intialCostOfAsset,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods,
java.lang.Object period)
Calculates the depreciation of an asset for a specified period by using
the double-declining balance method.
|
static double |
DDB(java.lang.Object intialCostOfAsset,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods,
java.lang.Object period,
java.lang.Object factor)
Calculates the depreciation of an asset for a specified period by using
the double-declining balance method or some other method that you specify.
|
static double |
DISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object price,
java.lang.Object redemptionValue)
Calculates the discount rate for a security based on US (NASD) 30/360 day
count basis.
|
static double |
DISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object price,
java.lang.Object redemptionValue,
DayCountBasis dayCountBasis)
Calculates the discount rate for a security.
|
static double |
DOLLARDE(java.lang.Object dollarValue,
java.lang.Object fraction)
Converts a dollar price expressed as an integer part and a fraction part,
such as 1.02, into a dollar price expressed as a decimal number.
|
static double |
DOLLARFR(java.lang.Object dollarValue,
java.lang.Object fraction)
Converts decimal number to fractional dollar number, such as securities
price.
|
static double |
DURATION(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYeld,
PaymentFrequency paymentFrequency)
Calculates the annual duration of a security with periodic interest
payments based on US (NASD) 30/360 day count basis.
|
static double |
DURATION(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYeld,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the annual duration of a security with periodic interest
payments.
|
static java.util.Date |
EDATE(java.util.Date startDate,
java.lang.Object adjustmentMonths)
Returns the date that is the indicated number of months before or after a
specified date.
|
static double |
EFFECT(java.lang.Object interestRate,
java.lang.Object numberOfPeriods)
Calculates the effective annual interest rate.
|
static java.util.Date |
EOMONTH(java.util.Date startDate,
java.lang.Object adjustmentMonths)
Returns the last day of the month before or after a specified number of
months.
|
static java.lang.Object |
FV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment)
Calculates the future value of an investment based on a constant interest
rate when payments are due at the end of the period and present value is
assumed to be zero.
|
static java.lang.Object |
FV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue)
Calculates the future value of an investment based on a constant interest
rate when payments are due at the end of the period.
|
static java.lang.Object |
FV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue,
PaymentType paymentType)
Calculates the future value of an investment based on a constant interest
rate.
|
static java.lang.Object |
FVSCHEDULE(java.lang.Object presentValue,
java.lang.Iterable ratesToApply)
Calculates the future value of an initial principal after applying a
series of compound interest rates.
|
static java.lang.Object |
FVSCHEDULE(java.lang.Object presentValue,
java.lang.Object... ratesToApply)
Calculates the future value of an initial principal after applying a
series of compound interest rates.
|
static double |
INTRATE(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object investmentAmount,
java.lang.Object redemptionAmount)
Calculates the interest rate for a fully invested security based on a 360
day year basis.
|
static double |
INTRATE(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object investmentAmount,
java.lang.Object redemptionAmount,
DayCountBasis dayCountBasis)
Calculates the interest rate for a fully invested security.
|
static double |
IPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue)
Calculates the interest payment for an investment for a given period when
payments are due at the end of the period and future value is assumed to
be zero.
|
static double |
IPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object futureValue)
Calculates the interest payment for an investment for a given period when
payments are due at the end of the period.
|
static double |
IPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the interest payment for an investment for a given period.
|
static double |
IRR(java.lang.Iterable values)
Calculates the internal rate of return for a series of cash flows with a
10 percent guess rate.
|
static double |
IRR(java.lang.Iterable values,
java.lang.Object guessRate)
Calculates the internal rate of return for a series of cash flows.
|
static double |
IRR(java.lang.Object... values)
Calculates the internal rate of return for a series of cash flows with a
10 percent guess rate.
|
static double |
ISPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayment,
java.lang.Object presentValue)
Calculates the interest paid during a specific period of an investment.
|
static double |
MDURATION(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYeld,
PaymentFrequency paymentFrequency)
Calculates modified Macauley duration for a security with an assumed par
value of $100 based on US (NASD) 30/360 day count basis.
|
static double |
MDURATION(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYeld,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates modified Macauley duration for a security with an assumed par
value of $100.
|
static double |
MIRR(java.lang.Iterable values,
java.lang.Object interestRate,
java.lang.Object reinvestmentRate)
Calculates the internal rate of return where positive and negative cash
flows are financed at different rates.
|
static double |
NETWORKDAYS(java.util.Date startDate,
java.util.Date endDate)
Returns the number of whole working days between start date and end date.
|
static double |
NETWORKDAYS(java.util.Date startDate,
java.util.Date endDate,
java.lang.Iterable<java.util.Date> holidays)
Returns the number of whole working days between start date and end date
excluding specified holidays.
|
static double |
NOMINAL(java.lang.Object effectInterestRate,
java.lang.Object numberOfPeriods)
Calculates the annual nominal interest rate.
|
static double |
NPER(java.lang.Object interestRate,
java.lang.Object payment,
java.lang.Object presentValue)
Calculates the number of periods for an investment when payments are due
at the end of the period and future value is assumed to be zero.
|
static double |
NPER(java.lang.Object interestRate,
java.lang.Object payment,
java.lang.Object presentValue,
java.lang.Object futureValue)
Calculates the number of periods for an investment when payments are due
at the end of the period.
|
static double |
NPER(java.lang.Object interestRate,
java.lang.Object payment,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the number of periods for an investment.
|
static double |
NPV(java.lang.Object rateOfDiscount,
java.lang.Iterable values)
Calculates the net present value of an investment based on a series of
periodic cash flows and a discount rate.
|
static double |
NPV(java.lang.Object rateOfDiscount,
java.lang.Object... values)
Calculates the net present value of an investment based on a series of
periodic cash flows and a discount rate.
|
static java.util.Date |
pbcsValueToDate(double pbcsValue)
Returns a date from a PBCS value in YYYYMMDD format.
|
static double |
PMT(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object presentValue)
Calculates the periodic payment for an annuity when payments are due at
the end of the period and future value is assumed to be zero.
|
static double |
PMT(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object presentValue,
java.lang.Object futureValue)
Calculates the periodic payment for an annuity when payments are due at
the end of the period.
|
static double |
PMT(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the periodic payment for an annuity.
|
static double |
PPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue)
Calculates the payment on the principal for an investment for a given
period when payments are due at the end of the period and future value is
assumed to be zero.
|
static double |
PPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object futureValue)
Calculates the payment on the principal for an investment for a given
period when payments are due at the end of the period.
|
static double |
PPMT(java.lang.Object interestRate,
java.lang.Object period,
java.lang.Object numberOfPayments,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the payment on the principal for an investment for a given
period.
|
static double |
PRICE(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYield,
java.lang.Object redemptionAmount,
PaymentFrequency paymentFrequency)
Calculates the price per $100 face value of a security that pays periodic
interest based on US (NASD) 30/360 day count basis.
|
static double |
PRICE(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object couponRate,
java.lang.Object annualYield,
java.lang.Object redemptionAmount,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the price per $100 face value of a security that pays periodic
interest.
|
static double |
PRICEDISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object discountRate,
java.lang.Object redemptionAmount)
Calculates the price per $100 face value of a discounted security based
on a 360 day year basis.
|
static double |
PRICEDISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object discountRate,
java.lang.Object redemptionAmount,
DayCountBasis dayCountBasis)
Calculates the price per $100 face value of a discounted security.
|
static double |
PRICEMAT(java.util.Date settlementDate,
java.util.Date maturityDate,
java.util.Date issueDate,
java.lang.Object interestRate,
java.lang.Object annualYield)
Calculates the price per $100 face value of a security that pays interest
at maturity based on US (NASD) 30/360 day count basis.
|
static double |
PRICEMAT(java.util.Date settlementDate,
java.util.Date maturityDate,
java.util.Date issueDate,
java.lang.Object interestRate,
java.lang.Object annualYield,
DayCountBasis dayCountBasis)
Calculates the price per $100 face value of a security that pays interest
at maturity.
|
static double |
PV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment)
Calculates the present value of an investment when payments are due at
the end of the period and future value is assumed to be zero.
|
static double |
PV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object futureValue)
Calculates the present value of an investment when payments are due at
the end of the period.
|
static double |
PV(java.lang.Object interestRate,
java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the present value of an investment.
|
static double |
RATE(java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue)
Calculates the interest rate per period of an annuity when payments are
due at the end of the period and future value is assumed to be zero and
with a 10 percent guess rate.
|
static double |
RATE(java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue,
java.lang.Object futureValue)
Calculates the interest rate per period of an annuity when payments are
due at the end of the period and with a 10 percent guess rate.
|
static double |
RATE(java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType)
Calculates the interest rate per period of an annuity with a 10 percent
guess rate.
|
static double |
RATE(java.lang.Object numberOfPayment,
java.lang.Object payment,
java.lang.Object presentValue,
java.lang.Object futureValue,
PaymentType paymentType,
java.lang.Object guessRate)
Calculates the interest rate per period of an annuity.
|
static double |
RECEIVED(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object investmentAmount,
java.lang.Object discountRate)
Calculates the amount received at maturity for a fully invested security
based on US (NASD) 30/360 day count basis.
|
static double |
RECEIVED(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object investmentAmount,
java.lang.Object discountRate,
DayCountBasis dayCountBasis)
Calculates the amount received at maturity for a fully invested security.
|
static java.util.Date |
serialToDate(double serialdate)
Returns a date object from an
Excel serial date number. |
static double |
SLN(java.lang.Object initialCost,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods)
Calculates the straight-line depreciation of an asset for one period.
|
static double |
SYD(java.lang.Object initialCost,
java.lang.Object salvageValue,
java.lang.Object numberOfPeriods,
java.lang.Object period)
Calculates the sum-of-years' digits depreciation of an asset for a
specified period.
|
static double |
TBILLEQ(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object discountRate)
Calculates the bond-equivalent yield for a Treasury bill.
|
static double |
TBILLPRICE(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object discountRate)
Calculates the price per $100 face value for a Treasury bill.
|
static double |
TBILLYIELD(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object price)
Calculate yield for a Treasury bill.
|
static java.util.Date |
WORKDAY(java.util.Date startDate,
java.lang.Object days)
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date).
|
static java.util.Date |
WORKDAY(java.util.Date startDate,
java.lang.Object days,
java.lang.Iterable<java.util.Date> holidays)
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date).
|
static double |
XIRR(java.lang.Iterable values,
java.lang.Iterable<java.util.Date> paymentDates)
Calculates the internal rate of return for a schedule of cash flows that
is not necessarily periodic with 10 percent guess rate.
|
static double |
XIRR(java.lang.Iterable values,
java.lang.Iterable<java.util.Date> paymentDates,
java.lang.Object guessRate)
Calculates the internal rate of return for a schedule of cash flows that
is not necessarily periodic.
|
static double |
XNPV(java.lang.Object discountRate,
java.lang.Iterable values,
java.lang.Iterable<java.util.Date> paymentDates)
Calculates the net present value for a schedule of cash flows that is not
necessarily periodic.
|
static double |
YEARFRAC(java.util.Date startDate,
java.util.Date endDate)
Calculates the fraction of the year represented by the number of whole
days between two dates (the start date and the end date) based on a 360
day year basis.
|
static double |
YEARFRAC(java.util.Date startDate,
java.util.Date endDate,
DayCountBasis dayCountBasis)
Calculates the fraction of the year represented by the number of whole
days between two dates (the start date and the end date).
|
static double |
YIELD(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object annualCouponRate,
java.lang.Object price,
java.lang.Object redemptionAmount,
PaymentFrequency paymentFrequency)
Calculates the yield on a security that pays periodic interest based on a
360 day year basis.
|
static double |
YIELD(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object annualCouponRate,
java.lang.Object price,
java.lang.Object redemptionAmount,
PaymentFrequency paymentFrequency,
DayCountBasis dayCountBasis)
Calculates the yield on a security that pays periodic interest.
|
static double |
YIELDDISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object price,
java.lang.Object redemptionAmount)
Calculates the annual yield for a discounted security based on US (NASD)
30/360 day count basis.
|
static double |
YIELDDISC(java.util.Date settlementDate,
java.util.Date maturityDate,
java.lang.Object price,
java.lang.Object redemptionAmount,
DayCountBasis dayCountBasis)
Calculates the annual yield for a discounted security.
|
static double |
YIELDMAT(java.util.Date settlementDate,
java.util.Date maturityDate,
java.util.Date issueDate,
java.lang.Object interestRate,
java.lang.Object price)
Calculates annual yield of a security that pays interest at maturity
based on US (NASD) 30/360 day count basis.
|
static double |
YIELDMAT(java.util.Date settlementDate,
java.util.Date maturityDate,
java.util.Date issueDate,
java.lang.Object interestRate,
java.lang.Object price,
DayCountBasis dayCountBasis)
Calculates annual yield of a security that pays interest at maturity.
|
public static double ACCRINT(java.util.Date issueDate, java.util.Date firstInterestDate, java.util.Date settlementDate, java.lang.Object couponRate, java.lang.Object parValue, PaymentFrequency paymentFrequency)
Example call from Groovy:
/* RTPS: {issueDate},{interestDate},{settlementDate} */ Excel.ACCRINT(rtps.issueDate as Date, rtps.interestDate as Date, rtps.settlementDate as Date, 0.1, 1000, PaymentFrequency.SEMIANNUAL)
issueDate
- issue datefirstInterestDate
- first interest datesettlementDate
- settlement datecouponRate
- annual coupon rate (see section Value Reference)parValue
- par value (see section Value Reference)paymentFrequency
- number of coupon payments per yearpublic static double ACCRINT(java.util.Date issueDate, java.util.Date firstInterestDate, java.util.Date settlementDate, java.lang.Object couponRate, java.lang.Object parValue, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
/* RTPS: {issueDate},{interestDate},{settlementDate} */ Excel.ACCRINT(rtps.issueDate as Date, rtps.interestDate as Date, rtps.settlementDate as Date, 0.1, 1000, PaymentFrequency.SEMIANNUAL, DayCountBasis.US_30_360)
issueDate
- issue datefirstInterestDate
- first interest datesettlementDate
- settlement datecouponRate
- annual coupon rate (see section Value Reference)parValue
- par value (see section Value Reference)paymentFrequency
- number of coupon payments per yeardayCountBasis
- day count basispublic static double ACCRINT(java.util.Date issueDate, java.util.Date firstInterestDate, java.util.Date settlementDate, java.lang.Object couponRate, java.lang.Object parValue, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis, InterestCalcMethod method)
Example call from Groovy:
/* RTPS: {start} */ Excel.ACCRINT(rtps.start as Date, Excel.pbcsValueToDate(20080831), Excel.pbcsValueToDate(20080501), 0.1, 1000, PaymentFrequency.SEMIANNUAL, DayCountBasis.US_30_360, InterestCalcMethod.ISSUE_TO_SETTLEMENT)
issueDate
- issue datefirstInterestDate
- first interest datesettlementDate
- settlement datecouponRate
- annual coupon rate (see section Value Reference)parValue
- par value (see section Value Reference)paymentFrequency
- number of coupon payments per yeardayCountBasis
- day count basismethod
- calc methodpublic static double ACCRINTM(java.util.Date issueDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object parValue)
Example call from Groovy:
Excel.ACCRINTM(Excel.serialToDate(39539), Excel.serialToDate(39614), 0.1, 1000)
issueDate
- issue datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)parValue
- par value (see section Value Reference)public static double ACCRINTM(java.util.Date issueDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object parValue, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.ACCRINTM(Excel.serialToDate(39539), Excel.serialToDate(39614), 0.1, 1000, DayCountBasis.ACTUAL_365)
issueDate
- issue datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)parValue
- par value (see section Value Reference)dayCountBasis
- day count basispublic static double AMORDEGRC(java.lang.Object costOfAsset, java.util.Date purchaseDate, java.util.Date firstPeriod, java.lang.Object salvageValue, java.lang.Object period, java.lang.Object rateOfDepreciation)
Example call from Groovy:
Excel.AMORDEGRC(2400, Excel.serialToDate(39679), Excel.serialToDate(39813), 300, 1, 0.15)
costOfAsset
- cost of asset (see section Value Reference)purchaseDate
- date of purchase of the assetfirstPeriod
- end date of first period (see section Value Reference)salvageValue
- salvage value at the end of the life of asset (see section Value Reference)period
- period (see section Value Reference)rateOfDepreciation
- rate of depreciation (see section Value Reference)public static double AMORDEGRC(java.lang.Object costOfAsset, java.util.Date purchaseDate, java.util.Date firstPeriod, java.lang.Object salvageValue, java.lang.Object period, java.lang.Object rateOfDepreciation, YearBasis yearBasis)
Example call from Groovy:
Excel.AMORDEGRC(2400, Excel.serialToDate(39679), Excel.serialToDate(39813), 300, 1, 0.15, YearBasis.ACTUAL)
This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.
costOfAsset
- cost of asset (see section Value Reference)purchaseDate
- date of purchase of the assetfirstPeriod
- end date of first period (see section Value Reference)salvageValue
- salvage value at the end of the life of asset (see section Value Reference)period
- period (see section Value Reference)rateOfDepreciation
- rate of depreciation (see section Value Reference)yearBasis
- year basispublic static double AMORLINC(java.lang.Object costOfAsset, java.util.Date purchaseDate, java.util.Date firstPeriod, java.lang.Object salvageValue, java.lang.Object period, java.lang.Object rateOfDepreciation)
Example call from Groovy:
Excel.AMORLINC(2400, Excel.serialToDate(39679), Excel.serialToDate(39813), 300, 1, 0.15)
costOfAsset
- cost of asset (see section Value Reference)purchaseDate
- date of purchase of the assetfirstPeriod
- end date of the first periodsalvageValue
- salvage value at the end of the life of asset (see section Value Reference)period
- period (see section Value Reference)rateOfDepreciation
- rate of depreciation (see section Value Reference)public static double AMORLINC(java.lang.Object costOfAsset, java.util.Date purchaseDate, java.util.Date firstPeriod, java.lang.Object salvageValue, java.lang.Object period, java.lang.Object rateOfDepreciation, YearBasis yearBasis)
This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.
Example call from Groovy:
Excel.AMORLINC(2400, Excel.serialToDate(39679), Excel.serialToDate(39813), 300, 1, 0.15, YearBasis.ACTUAL)
costOfAsset
- cost of asset (see section Value Reference)purchaseDate
- date of purchase of the assetfirstPeriod
- end date of the first periodsalvageValue
- salvage value at the end of the life of asset (see section Value Reference)period
- period (see section Value Reference)rateOfDepreciation
- rate of depreciation (see section Value Reference)yearBasis
- year basispublic static double COUPDAYBS(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPDAYBS(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static double COUPDAYBS(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPDAYBS(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static double COUPDAYS(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPDAYS(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static double COUPDAYS(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPDAYS(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static double COUPDAYSNC(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPDAYSNC(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static double COUPDAYSNC(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPDAYSNC(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static java.util.Date COUPNCD(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPNCD(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static java.util.Date COUPNCD(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPNCD(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static double COUPNUM(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPNUM(Excel.pbcsValueToDate(20070125), Excel.pbcsValueToDate(20081115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static double COUPNUM(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPNUM(Excel.pbcsValueToDate(20070125), Excel.pbcsValueToDate(20081115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static java.util.Date COUPPCD(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.COUPPCD(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yearpublic static java.util.Date COUPPCD(java.util.Date settlementDate, java.util.Date maturityDate, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.COUPPCD(Excel.pbcsValueToDate(20110125), Excel.pbcsValueToDate(20111115), PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datepaymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static double CUMIPMT(java.lang.Object interestRate, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object startPeriod, java.lang.Object endPeriod, PaymentType paymentType)
Example call from Groovy:
Excel.CUMIPMT(0.09/12.0, 30 * 12, 125000, 13, 24, PaymentType.END_OF_PERIOD)
interestRate
- interest rate per period (see section Value Reference)numberOfPayments
- total number of payment periods (see section Value Reference)presentValue
- present value (see section Value Reference)startPeriod
- first period in the calculation (see section Value Reference)endPeriod
- last period in the calculation (see section Value Reference)paymentType
- payement typepublic static double CUMPRINC(java.lang.Object interestRate, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object startPeriod, java.lang.Object endPeriod, PaymentType paymentType)
Example call from Groovy:
Excel.CUMPRINC(0.09/12.0, 30*12, 125000, 13, 24, PaymentType.END_OF_PERIOD)
interestRate
- interest rate per period (see section Value Reference)numberOfPayments
- total number of payment periods (see section Value Reference)presentValue
- present value (see section Value Reference)startPeriod
- first period in the calculation (see section Value Reference)endPeriod
- last period in the calculation (see section Value Reference)paymentType
- payement typepublic static double DATEDIF(java.util.Date startDate, java.util.Date endDate)
Example call from Groovy:
Excel.DATEDIF(Excel.pbcsValueToDate(20010101), Excel.pbcsValueToDate(20030101))
startDate
- start dateendDate
- end date
nullpublic static double DATEDIF(java.util.Date startDate, java.util.Date endDate, DateUnit unit)
Example call from Groovy:
Excel.DATEDIF(Excel.pbcsValueToDate(20010101), Excel.pbcsValueToDate(20030101), DateUnit.YEARS) Excel.DATEDIF(Excel.pbcsValueToDate(20010101), Excel.pbcsValueToDate(20030101), DateUnit.DAYS) Excel.DATEDIF(Excel.pbcsValueToDate(20010101), Excel.pbcsValueToDate(20030101), DateUnit.DAYS_IGNORE_YEAR)
public static double DB(java.lang.Object intialCostOfAsset, java.lang.Object salvageValue, java.lang.Object numberOfPeriods, java.lang.Object period)
Example call from Groovy:
Excel.DB(1000000, 100000, 6, 4)
intialCostOfAsset
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is being depreciated (see section Value Reference)period
- period for which depreciation is calculated (see section Value Reference)public static double DB(java.lang.Object intialCostOfAsset, java.lang.Object salvageValue, java.lang.Object numberOfPeriods, java.lang.Object period, java.lang.Object months)
Example call from Groovy:
Excel.DB(1000000, 100000, 6, 4, 7)
intialCostOfAsset
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is being depreciated (see section Value Reference)period
- period for which depreciation is calculated (see section Value Reference)months
- number of months in the first yearpublic static double DDB(java.lang.Object intialCostOfAsset, java.lang.Object salvageValue, java.lang.Object numberOfPeriods, java.lang.Object period)
Example call from Groovy:
Excel.DDB(2400, 300, 10, 10)
intialCostOfAsset
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is being depreciated (see section Value Reference)period
- period for which depreciation is calculated (see section Value Reference)public static double DDB(java.lang.Object intialCostOfAsset, java.lang.Object salvageValue, java.lang.Object numberOfPeriods, java.lang.Object period, java.lang.Object factor)
Example call from Groovy:
Excel.DDB(2400, 300, 10, 10, 2)
intialCostOfAsset
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is being depreciated (see section Value Reference)period
- period for which depreciation is calculated (see section Value Reference)factor
- rate at which the balance declines (see section Value Reference)public static double DISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object price, java.lang.Object redemptionValue)
Example call from Groovy:
Excel.DISC(Excel.pbcsValueToDate(20180701), Excel.pbcsValueToDate(20480101), 97.975, 100)
settlementDate
- settlement datematurityDate
- maturity dateprice
- security's price (see section Value Reference)redemptionValue
- security's redemption value (see section Value Reference)public static double DISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object price, java.lang.Object redemptionValue, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.DISC(Excel.pbcsValueToDate(20180701), Excel.pbcsValueToDate(20480101), 97.975, 100, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity dateprice
- security's price (see section Value Reference)redemptionValue
- security's redemption value (see section Value Reference)dayCountBasis
- day count basispublic static double DOLLARDE(java.lang.Object dollarValue, java.lang.Object fraction)
Example call from Groovy:
Excel.DOLLARDE(1.02,16)
dollarValue
- dollar value (see section Value Reference)fraction
- fraction denominator (see section Value Reference)public static double DOLLARFR(java.lang.Object dollarValue, java.lang.Object fraction)
Example call from Groovy:
Excel.DOLLARFR(1.125,16)
dollarValue
- dollar value (see section Value Reference)fraction
- fraction denominator (see section Value Reference)public static double DURATION(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYeld, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.DURATION(Excel.pbcsValueToDate(20080701), Excel.pbcsValueToDate(20480101), 8/100, 9/100, PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYeld
- annual yield (see section Value Reference)paymentFrequency
- coupon payments per yearpublic static double DURATION(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYeld, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.DURATION(Excel.pbcsValueToDate(20080701), Excel.pbcsValueToDate(20480101), 8/100, 9/100, PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYeld
- annual yield (see section Value Reference)paymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static java.util.Date EDATE(java.util.Date startDate, java.lang.Object adjustmentMonths)
Example call from Groovy:
Excel.EDATE(Excel.pbcsValueToDate(20110115), 1) Excel.EDATE(Excel.pbcsValueToDate(20110115), -1)
startDate
- start dateadjustmentMonths
- number of months before or after start date
A positive value for months yields a future date; a negative value yields
a past date (see section Value Reference)public static double EFFECT(java.lang.Object interestRate, java.lang.Object numberOfPeriods)
Example call from Groovy:
Excel.EFFECT(0.0525,4)
interestRate
- nominal interest rate (see section Value Reference)numberOfPeriods
- number of compounding periods per year (see section Value Reference)public static java.util.Date EOMONTH(java.util.Date startDate, java.lang.Object adjustmentMonths)
Example call from Groovy:
Excel.EOMONTH(Excel.pbcsValueToDate(20110101), 1) Excel.EOMONTH(Excel.pbcsValueToDate(20110101), -3)
startDate
- start dateadjustmentMonths
- number of months before or after start date (see section Value Reference)public static java.lang.Object FV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment)
Example call from Groovy:
Excel.FV(0.06/12, 10, -200)
interestRate
- interest rate per period (see section Value Reference)numberOfPayment
- number of paymentpayment
- payment made each period (see section Value Reference)public static java.lang.Object FV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue)
Example call from Groovy:
Excel.FV(0.06/12, 10, -200, -500)
interestRate
- interest rate per period (see section Value Reference)numberOfPayment
- number of paymentpayment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)public static java.lang.Object FV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue, PaymentType paymentType)
Example call from Groovy:
Excel.FV(0.06/12, 10, -200, -500, PaymentType.BEGINNING_OF_PERIOD)
interestRate
- interest rate per period (see section Value Reference)numberOfPayment
- number of payment (see section Value Reference)payment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)paymentType
- payment typepublic static java.lang.Object FVSCHEDULE(java.lang.Object presentValue, java.lang.Iterable ratesToApply)
Example call from Groovy:
Excel.FVSCHEDULE(1, [0.09,0.11,0.1])
presentValue
- present value (see section Value Reference)ratesToApply
- interest rates to apply (see section Value References)public static java.lang.Object FVSCHEDULE(java.lang.Object presentValue, java.lang.Object... ratesToApply)
Example call from Groovy:
Excel.FVSCHEDULE(1, 0.09,0.11,0.1)
presentValue
- present value (see section Value Reference)ratesToApply
- interest rates to apply (see section Value Reference)public static double INTRATE(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object investmentAmount, java.lang.Object redemptionAmount)
Example call from Groovy:
Excel.INTRATE(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080515), 1000000, 1014420)
settlementDate
- settlement datematurityDate
- maturity dateinvestmentAmount
- amount invested (see section Value Reference)redemptionAmount
- amount to be received at maturity (see section Value Reference)public static double INTRATE(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object investmentAmount, java.lang.Object redemptionAmount, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.INTRATE(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080515), 1000000, 1014420, DayCountBasis.ACTUAL_360)
settlementDate
- settlement datematurityDate
- maturity dateinvestmentAmount
- amount investedredemptionAmount
- amount to be received at maturitydayCountBasis
- day count basispublic static double IPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue)
Example call from Groovy:
Excel.IPMT(0.1, 3, 3, 8000)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPaymentsnumberOfPayments
- total number of payment periods (see section Value Reference)presentValue
- present value (see section Value Reference)public static double IPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object futureValue)
Example call from Groovy:
Excel.IPMT(0.1, 3, 3, 8000, 0)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPaymentsnumberOfPayments
- total number of payment periods (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)public static double IPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.IPMT(0.1, 3, 3, 8000, 0, PaymentType.END_OF_PERIOD)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPayments (see section Value Reference)numberOfPayments
- total number of payment periods (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payement typepublic static double IRR(java.lang.Iterable values)
Example call from Groovy:
Excel.IRR([-70000, 12000, 15000, 18000, 21000, 26000])
values
- values for which you want to calculate the internal rate of
return (see section Value Reference)public static double IRR(java.lang.Iterable values, java.lang.Object guessRate)
Example call from Groovy:
Excel.IRR([-70000, 12000, 15000, 18000, 21000, 26000], -0.1)
values
- values for which you want to calculate the internal rate of
return (see section Value References)guessRate
- an optional rate guess, default to 10 percent (see section Value Reference)public static double IRR(java.lang.Object... values)
Example call from Groovy:
Excel.IRR(-70000, 12000, 15000, 18000, 21000, 26000)
values
- values for which you want to calculate the internal rate of
return (see section Value Reference)public static double ISPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayment, java.lang.Object presentValue)
Example call from Groovy:
Excel.ISPMT(10/100,1,4,4000)
interestRate
- interest rate (see section Value Reference)period
- period for which you want to find the interest (see section Value Reference)numberOfPayment
- total number of payment periods (see section Value Reference)presentValue
- present value of the investment (see section Value Reference)public static double MDURATION(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYeld, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.MDURATION(Excel.pbcsValueToDate(20080101), Excel.pbcsValueToDate(20160101), 8/100, 9/100, PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYeld
- annual yield (see section Value Reference)paymentFrequency
- coupon payments per yearpublic static double MDURATION(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYeld, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.MDURATION(Excel.fromPBSDate(20080101), Excel.fromPBSDate(20160101), 8/100, 9/100, PaymentFrequency.SEMIANNUAL, DayCountBasis.ACTUAL_ACTUAL)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYeld
- annual yield (see section Value Reference)paymentFrequency
- coupon payments per yeardayCountBasis
- day count basispublic static double MIRR(java.lang.Iterable values, java.lang.Object interestRate, java.lang.Object reinvestmentRate)
Example call from Groovy:
Excel.MIRR([-120000, 39000, 30000, 21000, 37000, 46000], 0.1, 0.12)
values
- values representing a series of payments (negative values)
and income (positive values) occurring at regular periods (see section Value References)interestRate
- interest rate (see section Value Reference)reinvestmentRate
- reinvest rate (see section Value Reference)public static double NETWORKDAYS(java.util.Date startDate, java.util.Date endDate)
Example call from Groovy:
Excel.NETWORKDAYS(Excel.pbcsValueToDate(20120101), Excel.pbcsValueToDate(20130301))
startDate
- start dateendDate
- end date
excludepublic static double NETWORKDAYS(java.util.Date startDate, java.util.Date endDate, java.lang.Iterable<java.util.Date> holidays)
Example call from Groovy:
Working days exclude weekends and any dates identified in holidays.Excel.NETWORKDAYS(Excel.pbcsValueToDate(20121001), Excel.pbcsValueToDate(20130301), [ Excel.pbcsValueToDate(20121122), Excel.pbcsValueToDate(20121204), Excel.pbcsValueToDate(20130121) ])
startDate
- start dateendDate
- end dateholidays
- an optional range of one or more dates to exclude (see section Date References)public static double NOMINAL(java.lang.Object effectInterestRate, java.lang.Object numberOfPeriods)
Example call from Groovy:
Excel.NOMINAL(0.053543, 4)
effectInterestRate
- effective interest rate (see section Value Reference)numberOfPeriods
- number of compounding periods per year (see section Value Reference)public static double NPER(java.lang.Object interestRate, java.lang.Object payment, java.lang.Object presentValue)
Example call from Groovy:
Excel.NPER(0.12/12, -100, -1000)
interestRate
- interest rate (see section Value Reference)payment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)public static double NPER(java.lang.Object interestRate, java.lang.Object payment, java.lang.Object presentValue, java.lang.Object futureValue)
Example call from Groovy:
Excel.NPER(0.12/12, -100, -1000, 10000)
interestRate
- interest rate (see section Value Reference)payment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)public static double NPER(java.lang.Object interestRate, java.lang.Object payment, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.NPER(0.12/12, -100, -1000, 10000, PaymentType.BEGINNING_OF_PERIOD)
interestRate
- interest rate (see section Value Reference)payment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payment typepublic static double NPV(java.lang.Object rateOfDiscount, java.lang.Iterable values)
Example call from Groovy:
Excel.NPV(0.08, [8000, 9200, 10000, 12000, 14500])
rateOfDiscount
- rate of discount over the length of one period (see section Value Reference)values
- values representing the payments and income (see section Value References)public static double NPV(java.lang.Object rateOfDiscount, java.lang.Object... values)
Example call from Groovy:
Excel.NPV(0.08, 8000, 9200, 10000, 12000, 14500)
rateOfDiscount
- rate of discount over the length of one period (see section Value Reference)values
- values representing the payments and income (see section Value Reference)public static java.util.Date pbcsValueToDate(double pbcsValue)
pbcsValue
- PBCS value in YYYYMMDD formatpublic static double PMT(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object presentValue)
Example call from Groovy:
Excel.PMT((8/100)/12,10,10000)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of paymentspresentValue
- present value (see section Value Reference)public static double PMT(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object presentValue, java.lang.Object futureValue)
Example call from Groovy:
Excel.PMT((8/100)/12,10,10000, 0)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of paymentspresentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)public static double PMT(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.PMT((8/100)/12,10,10000, 0, PaymentType.END_OF_PERIOD)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of payments (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payment typepublic static double PPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue)
Example call from Groovy:
Excel.PPMT(8/100, 10, 10, 200000)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPaymentsnumberOfPayments
- total number of payment periods in an annuitypresentValue
- present value (see section Value Reference)public static double PPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object futureValue)
Example call from Groovy:
Excel.PPMT(8/100, 10, 10, 200000, 0)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPaymentsnumberOfPayments
- total number of payment periods in an annuitypresentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)public static double PPMT(java.lang.Object interestRate, java.lang.Object period, java.lang.Object numberOfPayments, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.PPMT(8/100, 10, 10, 200000, 0, PaymentType.END_OF_PERIOD)
interestRate
- interest rate per period (see section Value Reference)period
- period and must be in the range 1 to numberOfPayments (see section Value Reference)numberOfPayments
- total number of payment periods in an annuity (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payement typepublic static double PRICE(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYield, java.lang.Object redemptionAmount, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.PRICE(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20171115), 5.75/100, 6.5/100, 100, PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYield
- annual yield (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)paymentFrequency
- number of coupon payments per yearpublic static double PRICE(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object couponRate, java.lang.Object annualYield, java.lang.Object redemptionAmount, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.PRICE(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20171115), 5.75/100, 6.5/100, 100, PaymentFrequency.SEMIANNUAL, DayCountBasis.US_30_360)
settlementDate
- settlement datematurityDate
- maturity datecouponRate
- annual coupon rate (see section Value Reference)annualYield
- annual yield (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)paymentFrequency
- number of coupon payments per yeardayCountBasis
- day count basispublic static double PRICEDISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object discountRate, java.lang.Object redemptionAmount)
Example call from Groovy:
Excel.PRICEDISC(Excel.pbcsValueToDate(20080216), Excel.pbcsValueToDate(20080301), 5.25/100, 100)
settlementDate
- settlement datematurityDate
- maturity datediscountRate
- discount rate (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)public static double PRICEDISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object discountRate, java.lang.Object redemptionAmount, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.PRICEDISC(Excel.pbcsValueToDate(20080216), Excel.pbcsValueToDate(20080301), 5.25/100, 100, DayCountBasis.ACTUAL_360)
settlementDate
- settlement datematurityDate
- maturity datediscountRate
- discount rate (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)dayCountBasis
- day count basispublic static double PRICEMAT(java.util.Date settlementDate, java.util.Date maturityDate, java.util.Date issueDate, java.lang.Object interestRate, java.lang.Object annualYield)
Example call from Groovy:
Excel.PRICEMAT(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080413), Excel.pbcsValueToDate(20071111), 6.1/100, 6.1/100)
settlementDate
- settlement datematurityDate
- maturity dateissueDate
- issue dateinterestRate
- interest rate (see section Value Reference)annualYield
- annual yield (see section Value Reference)public static double PRICEMAT(java.util.Date settlementDate, java.util.Date maturityDate, java.util.Date issueDate, java.lang.Object interestRate, java.lang.Object annualYield, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.PRICEMAT(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080413), Excel.pbcsValueToDate(20071111), 6.1/100, 6.1/100, DayCountBasis.US_30_360)
settlementDate
- settlement datematurityDate
- maturity dateissueDate
- issue dateinterestRate
- interest rate (see section Value Reference)annualYield
- annual yield (see section Value Reference)dayCountBasis
- day count basispublic static double PV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment)
Example call from Groovy:
Excel.PV((8/100)/12, 12*20, 500)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of payment periods (see section Value Reference)payment
- payment made each period (see section Value Reference)public static double PV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object futureValue)
Example call from Groovy:
Excel.PV((8/100)/12, 12*20, 500, 0)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of payment periods (see section Value Reference)payment
- payment made each period (see section Value Reference)futureValue
- future value (see section Value Reference)public static double PV(java.lang.Object interestRate, java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.PV((8/100)/12, 12*20, 500, 0, PaymentType.END_OF_PERIOD)
interestRate
- interest rate (see section Value Reference)numberOfPayment
- total number of payment periods (see section Value Reference)payment
- payment made each period (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payment typepublic static double RATE(java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue)
Example call from Groovy:
Excel.RATE(4 * 12, -200, 8000)
numberOfPayment
- total number of paymentpayment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)public static double RATE(java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue, java.lang.Object futureValue)
Example call from Groovy:
Excel.RATE(4 * 12, -200, 8000, 0)
numberOfPayment
- total number of paymentpayment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future valuepublic static double RATE(java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType)
Example call from Groovy:
Excel.RATE(4 * 12, -200, 8000, 0, PaymentType.END_OF_PERIOD)
numberOfPayment
- total number of paymentpayment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payment typepublic static double RATE(java.lang.Object numberOfPayment, java.lang.Object payment, java.lang.Object presentValue, java.lang.Object futureValue, PaymentType paymentType, java.lang.Object guessRate)
Example call from Groovy:
Excel.RATE(4 * 12, -200, 8000, 0, PaymentType.END_OF_PERIOD, 10/100)
numberOfPayment
- total number of payment (see section Value Reference)payment
- payment made each period (see section Value Reference)presentValue
- present value (see section Value Reference)futureValue
- future value (see section Value Reference)paymentType
- payment typeguessRate
- an optional rate guess, default to 10 percent (see section Value Reference)public static double RECEIVED(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object investmentAmount, java.lang.Object discountRate)
Example call from Groovy:
Excel.RECEIVED(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080515), 1000000.00, 5.75/100)
settlementDate
- settlement datematurityDate
- maturity dateinvestmentAmount
- amount investeddiscountRate
- discount rate (see section Value Reference)public static double RECEIVED(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object investmentAmount, java.lang.Object discountRate, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.RECEIVED(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20080515), 1000000.00, 5.75/100, DayCountBasis.ACTUAL_360)
settlementDate
- settlement datematurityDate
- maturity dateinvestmentAmount
- amount invested (see section Value Reference)discountRate
- discount rate (see section Value Reference)dayCountBasis
- day count basispublic static java.util.Date serialToDate(double serialdate)
Excel
serial date number.serialdate
- numeric representation of a date in Excel
Excel
serial date numberpublic static double SLN(java.lang.Object initialCost, java.lang.Object salvageValue, java.lang.Object numberOfPeriods)
Example call from Groovy:
Excel.SLN(30000, 7500, 10)
initialCost
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is depreciated (see section Value Reference)public static double SYD(java.lang.Object initialCost, java.lang.Object salvageValue, java.lang.Object numberOfPeriods, java.lang.Object period)
Example call from Groovy:
Excel.SYD(30000.00, 7500, 10, 10)
initialCost
- initial cost of asset (see section Value Reference)salvageValue
- value at the end of the depreciation (see section Value Reference)numberOfPeriods
- number of periods over which the asset is depreciated (see section Value Reference)period
- period, must use the same units as numberOfPeriods (see section Value Reference)public static double TBILLEQ(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object discountRate)
Example call from Groovy:
Excel.TBILLEQ(Excel.pbcsValueToDate(20080331), Excel.pbcsValueToDate(20080601), 9.14/100)
settlementDate
- settlement datematurityDate
- maturity datediscountRate
- discount rate (see section Value Reference)public static double TBILLPRICE(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object discountRate)
Example call from Groovy:
Excel.TBILLPRICE(Excel.pbcsValueToDate(20080331), Excel.pbcsValueToDate(20080601), 9.0/100)
settlementDate
- settlement datematurityDate
- maturity datediscountRate
- discount rate (see section Value Reference)public static double TBILLYIELD(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object price)
Example call from Groovy:
Excel.TBILLYIELD(Excel.pbcsValueToDate(20080331), Excel.pbcsValueToDate(20080601), 98.45)
settlementDate
- settlement datematurityDate
- maturity dateprice
- Treasury bill's price per $100 face value (see section Value Reference)public static java.util.Date WORKDAY(java.util.Date startDate, java.lang.Object days)
Example call from Groovy:
Excel.WORKDAY(Excel.pbcsValueToDate(20081001), 151)
startDate
- start datedays
- number of nonweekend days before or after
start date. A positive value for days yields a future date; a negative
value yields a past datepublic static java.util.Date WORKDAY(java.util.Date startDate, java.lang.Object days, java.lang.Iterable<java.util.Date> holidays)
Example call from Groovy:
Excel.WORKDAY(Excel.pbcsValueToDate(20081001), 151, [ Excel.pbcsValueToDate(20081126), Excel.pbcsValueToDate(20081204), Excel.pbcsValueToDate(20090121) ])
startDate
- start datedays
- number of nonweekend and nonholiday days before or after
start date. A positive value for days yields a future date; a negative
value yields a past date (see section Value Reference)holidays
- an optional range of one or more dates to exclude (see section Date References)public static double XIRR(java.lang.Iterable values, java.lang.Iterable<java.util.Date> paymentDates)
Example call from Groovy:
/* RTPS: {fvalue} {svalue} {start} {febDate} */ Excel.XIRR([rtps.fvalue, rtps.svalue, 4250.0, 3250.0, 2750], [ rtps.start as Date, Excel.pbcsValueToDate(20080301), Excel.pbcsValueToDate(20081030), rtps.febDate as Date, Excel.pbcsValueToDate(20090401) ])
values
- values corresponds to a schedule of payments in dates (see section Value References)paymentDates
- schedule of payment dates that corresponds to the
cash flow payments (see section Date References)public static double XIRR(java.lang.Iterable values, java.lang.Iterable<java.util.Date> paymentDates, java.lang.Object guessRate)
Example call from Groovy:
/* RTPS: {fvalue} {svalue} {start} {febDate} */ Excel.XIRR([rtps.fvalue, rtps.svalue, 4250.0, 3250.0, 2750], [ rtps.start as Date, Excel.pbcsValueToDate(20080301), Excel.pbcsValueToDate(20081030), rtps.febDate as Date, Excel.pbcsValueToDate(20090401) ], 0.1)
values
- values corresponds to a schedule of payments in dates (see section Value References)paymentDates
- schedule of payment dates that corresponds to the
cash flow payments (see section Date References)guessRate
- an optional rate guess, default to 10 percent (see section Value Reference)public static double XNPV(java.lang.Object discountRate, java.lang.Iterable values, java.lang.Iterable<java.util.Date> paymentDates)
Example call from Groovy:
/* RTPS: {fvalue} {svalue} {start} {febDate} */ Excel.XNPV(0.09, [rtps.fvalue, rtps.svalue, 4250.0, 3250.0, 2750], [ rtps.start as Date, Excel.pbcsValueToDate(20080301), Excel.pbcsValueToDate(20081030), rtps.febDate as Date, Excel.pbcsValueToDate(20090401) ])
discountRate
- discount rate (see section Value Reference)values
- values corresponds to a schedule of payments in dates (see section Value References)paymentDates
- schedule of payment dates that corresponds to the
cash flow payments (see section Date References)public static double YEARFRAC(java.util.Date startDate, java.util.Date endDate)
Example call from Groovy:
Excel.YEARFRAC(Excel.pbcsValueToDate(20120101), Excel.pbcsValueToDate(20120730))
startDate
- start dateendDate
- end datepublic static double YEARFRAC(java.util.Date startDate, java.util.Date endDate, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.YEARFRAC(Excel.pbcsValueToDate(20120101), Excel.pbcsValueToDate(20120730), DayCountBasis.US_30_360) Excel.YEARFRAC(Excel.pbcsValueToDate(20120101), Excel.pbcsValueToDate(20120730), DayCountBasis.ACTUAL_ACTUAL) Excel.YEARFRAC(Excel.pbcsValueToDate(20120101), Excel.pbcsValueToDate(20120730), DayCountBasis.ACTUAL_365)
startDate
- start dateendDate
- end datedayCountBasis
- day count basispublic static double YIELD(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object annualCouponRate, java.lang.Object price, java.lang.Object redemptionAmount, PaymentFrequency paymentFrequency)
Example call from Groovy:
Excel.YIELD(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20161115), 5.75/100, 95.04287, 100, PaymentFrequency.SEMIANNUAL)
settlementDate
- settlement datematurityDate
- maturity dateannualCouponRate
- annual coupon rate (see section Value Reference)price
- security's price per $100 face value.redemptionAmount
- redemption value (see section Value Reference)paymentFrequency
- number of coupon payments per yearpublic static double YIELD(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object annualCouponRate, java.lang.Object price, java.lang.Object redemptionAmount, PaymentFrequency paymentFrequency, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.YIELD(Excel.pbcsValueToDate(20080215), Excel.pbcsValueToDate(20161115), 5.75/100, 95.04287, 100, PaymentFrequency.SEMIANNUAL, DayCountBasis.US_30_360)
settlementDate
- settlement datematurityDate
- maturity dateannualCouponRate
- annual coupon rate (see section Value Reference)price
- security's price per $100 face value (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)paymentFrequency
- number of coupon payments per yeardayCountBasis
- day count basispublic static double YIELDDISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object price, java.lang.Object redemptionAmount)
Example call from Groovy:
Excel.YIELDDISC(Excel.pbcsValueToDate(20080216), Excel.pbcsValueToDate(20080301), 99.795, 100)
settlementDate
- settlement datematurityDate
- maturity dateprice
- security's price per $100 face value (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)public static double YIELDDISC(java.util.Date settlementDate, java.util.Date maturityDate, java.lang.Object price, java.lang.Object redemptionAmount, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.YIELDDISC(Excel.pbcsValueToDate(20080216), Excel.pbcsValueToDate(20080301), 99.795, 100, DayCountBasis.ACTUAL_360)
settlementDate
- settlement datematurityDate
- maturity dateprice
- security's price per $100 face value (see section Value Reference)redemptionAmount
- redemption value (see section Value Reference)dayCountBasis
- day count basispublic static double YIELDMAT(java.util.Date settlementDate, java.util.Date maturityDate, java.util.Date issueDate, java.lang.Object interestRate, java.lang.Object price)
Example call from Groovy:
Excel.YIELDMAT(Excel.pbcsValueToDate(20080315), Excel.pbcsValueToDate(20081103), Excel.pbcsValueToDate(20071108), 6.25/100, 100.0123)
settlementDate
- settlement datematurityDate
- maturity dateissueDate
- issue dateinterestRate
- interest rate (see section Value Reference)price
- price per $100 face value (see section Value Reference)public static double YIELDMAT(java.util.Date settlementDate, java.util.Date maturityDate, java.util.Date issueDate, java.lang.Object interestRate, java.lang.Object price, DayCountBasis dayCountBasis)
Example call from Groovy:
Excel.YIELDMAT(Excel.pbcsValueToDate(20080315), Excel.pbcsValueToDate(20081103), Excel.pbcsValueToDate(20071108), 6.25/100, 100.0123, DayCountBasis.US_30_360)
settlementDate
- settlement datematurityDate
- maturity dateissueDate
- issue dateinterestRate
- interest rate (see section Value Reference)price
- price per $100 face value (see section Value Reference)dayCountBasis
- day count basisCopyright © 2017, 2024, Oracle and/or its affiliates. All rights reserved.