Documentation/Calc Functions/ODDFPRICE

From The Document Foundation Wiki
Jump to: navigation, search


Under construction.
For now, see the system Help files.

Function name:



Financial Analysis


Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.


ODDFPRICE(Settlement; Maturity; Issue; First Coupon; Rate; Yield; Redemption; Frequency; Basis)



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 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 number of interest payments per year (1, 2 or 4).

Basis (optional) is chosen from a list of options and indicates how the year is to be calculated.

Basis Calculation
0 or missing US method (NASD), 12 months of 30 days each
1 Exact number of days in months, exact number of days in year
2 Exact number of days in month, year has 360 days
3 Exact number of days in month, year has 365 days
4 European method, 12 months of 30 days each

Additional details:


Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: