ODDLPRICE
Syntax:
ODDLPRICE ( settlement , maturity , last-interest , rate , yld , redemption ,frequency [ , [ basis ] ] )
Description: Computes the price per $100 face value of a security having an odd (short or long) last coupon period.
Arguments:
Name |
Type |
Description |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
settlement |
number |
The security's settlement date. |
||||||||||||
maturity |
number |
The security's maturity date. |
||||||||||||
last-interest |
number |
The security's last coupon date. |
||||||||||||
rate |
number |
The security's interest rate. |
||||||||||||
yld |
number |
The security's annual yield. |
||||||||||||
redemption |
number |
The security's redemption value per $100 face value. |
||||||||||||
frequency |
number |
the number of coupon payments per year. (For annual payments, frequency is 1; for semiannual payments, frequency is 2; for quarterly payments, frequency is 4.) |
||||||||||||
basis |
number |
The truncated integer type of day count basis to use, as follows:
|
Time information in the date arguments is ignored.
Return Type and Value: number – The price per $100 face value of a security having an odd (short or long) last coupon period.
However, if
settlement, maturity, or last-interest is out of range for the current date base value,
#NUM!
is returned.The following is not true: maturity is later than settlement, which is later than last-interest, so
#NUM!
is returned.rate or yld < 0,
#NUM!
is returned.frequency is any number other than 1, 2, or 4,
#NUM!
is returned.basis < 0 or basis > 4,
#NUM!
is returned.