[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

ODDLPRICE

This function calculates the price per $100 face value of a security with an odd last coupon period.

Syntax

ODDLPRICE(settle, maturity, last, rate, yield, redeem, freq, [basis])

Arguments

This function has these arguments:

Argument

Description

settle

[Required] Settlement date for the security

maturity

[Required] Maturity date for the security

last

[Required] Last coupon date

rate

[Required] Annual interest rate

yield

[Required] Annual yield for the security

redeem

[Required] Redemption value per $100 face value for the security

freq

[Required] Frequency of payment, number of payments per year

basis

[Optional] Integer representing the basis for day count

Remarks

This function returns a #VALUE! error when settle, maturity, or last is invalid. Settle, maturity, issue, last, and basis are truncated to integers.

  • If rate is less than 0 or yield is less than 0, a #NUM! error is returned.

  • If basis is less than 0 or greater than 4, a #NUM! error is returned.

Maturity should be greater than settle which should be greater than last. Otherwise a #NUM! error is returned.

Examples

ODDLPRICE(C1,C2,A3,C4,C5,C6,C7,C8)