Manuals/calci/ODDLPRICE

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

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Settle} is the security's settlement date
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle M} is the security's maturity date
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle LI} is the security's last coupon date
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle R} is the security's interest rate
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Yield} is the security's annual yield
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Redem} is the security's redemption value
• $F$ is the number of coupon payments per year
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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