Calc Guide

Syntax Description
Redemption is the redemption value per 100
currency units of par value. Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
ODDFYIELD(settlement;
maturity; issue;
first_coupon; rate; price;
redemption; frequency;
basis)
Calculates the yield of a security if the first
interest date falls irregularly. Settlement is
the date of purchase of the security. Maturity
is the date on which the security matures
(expires). Issue is the date of issue of the
security. First_coupon is the first interest
period of the security. Rate is the annual rate
of interest. Price is the price of the security.
Redemption is the redemption value per 100
currency units of par value. Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
ODDLPRICE(settlement;
maturity; last_interest;
rate; yield; redemption;
frequency; basis)
Calculates the price per 100 currency units
par value of a security, if the last interest date
falls irregularly. Settlement is the date of
purchase of the security. Maturity is the date
on which the security matures (expires).
Last_interest is the last interest date of the
security. Rate is the annual rate of interest.
Yield is the annual yield of the security.
Redemption is the redemption value per 100
currency units of par value. Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
ODDLYIELD(settlement;
maturity; last_interest;
rate; price; redemption;
frequency; basis)
Calculates the yield of a security if the last
interest date falls irregularly. Settlement is
the date of purchase of the security. Maturity
is the date on which the security matures
(expires). Last_interest is the last interest
date of the security. Rate is the annual rate of
interest. Price is the price of the security.
Redemption is the redemption value per 100
currency units of par value. Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
PMT(rate; NPER; PV; FV; Returns the periodic payment for an annuity
444 OpenOffice.org 3.x Calc Guide