Manuals/calci/ODDLPRICE

ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)

• $Settle$ is the security's settlement date
• $M$ is the security's maturity date
• $LI$ is the security's last coupon date
• $R$ is the security's interest rate
• $Yield$ is the security's annual yield
• $Redem$ is the security's redemption value
• $F$ is the number of coupon payments per year
• $Basis$ is the type of day count basis to use.

Description

• This function computes the price per $100 face value of a security having an odd last coupon period.
• ODDLPRICE shows the error value when

1.Settle, M, I, or FC is not a valid date
2.R or Yield< 0.
3.Basis must between 0 and 4.
4.M > settle > LI

Example

Lets see an example

ODDLPRICE(settle, M, LI, R,yield, redem, F, basis) B

01-08-2008

05-18-2008

11-15-2007

4.35%

5.25%

$100

2

0

?UNIQ3ca8cc865116b625-nowiki-00000002-QINU?

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3	Column4
Row1	01-08-2008	99.6691
Row2	05-18-2008
Row3	11-15-2007
Row4	4.35%
Row5	5.25%
Row6	$100
Row7	2
Row8	0
Row9
Row10