Difference between revisions of "Manuals/calci/ODDLPRICE"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
*This function computes the price per $100 face value of a security having an odd last coupon period. | *This function computes the price per $100 face value of a security having an odd last coupon period. | ||
*ODDLPRICE shows the error value when | *ODDLPRICE shows the error value when | ||
| − | * | + | *Settle, M, I, or FC is not a valid date |
| + | *R or Yield< 0. | ||
*Basis must between 0 and 4. | *Basis must between 0 and 4. | ||
*M > settle > LI | *M > settle > LI | ||
| Line 122: | Line 123: | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 03:19, 28 February 2014
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.
- This function computes the price per $100 face value of a security having an odd last coupon period.
- ODDLPRICE shows the error value when
- Settle, M, I, or FC is not a valid date
- R or Yield< 0.
- Basis must between 0 and 4.
- M > settle > LI
ODDLPRICE
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 |