ODDLPRICE in Collabora Office: Price a Security with an Irregular Last Period
Use Collabora ODDLPRICE with the last-interest date, coupon rate and yield; reproduce99.87829 and independently reconcile the example’s price arithmetic.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ODDLPRICE calculates a security’s price per 100 units of par value when the last interest date is irregular. Collabora’s documented example returns 99.87829, using a 3.75% annual coupon rate and a 4.05% annual yield.
Syntax and inputs
=ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield;
Redemption; Frequency [; Basis])
| Argument | Meaning |
|---|---|
| Settlement | Purchase/settlement date |
| Maturity | Date the security matures |
| LastInterest | Last interest date anchoring the irregular final period |
| Rate | Annual coupon interest rate |
| Yield | Annual yield used in pricing |
| Redemption | Redemption value per 100 units of par value |
| Frequency | Payments per year: 1, 2 or 4 |
| Basis | Optional day-count convention; default 0 |
All arguments except Basis are required. Rate and Yield are separate inputs. Enter 3.75% as 0.0375 or a percentage, not as 3.75. Redemption is a per-100 quote rather than the total face amount of a holding.
Basis0 or omitted means US NASD 30/360; 1 means actual days and actual year length; 2 means actual/360; 3 means actual/365; 4 means European 30/360. The documented frequencies correspond to annual, semiannual and quarterly payments.
Example: reproduce the published price
Enter this dataset:
| Cell | Entry |
|---|---|
| B2 | =DATE(1999;2;7) |
| B3 | =DATE(1999;6;15) |
| B4 | =DATE(1998;10;15) |
| B5 | 3.75% |
| B6 | 4.05% |
| B7 | 100 |
| B8 | 2 |
| B9 | 0 |
Then calculate:
=ODDLPRICE(B2;B3;B4;B5;B6;B7;B8;B9)
The vendor reports 99.87829. An equivalent date-explicit formula is:
=ODDLPRICE(DATE(1999;2;7);DATE(1999;6;15);DATE(1998;10;15);
0.0375;0.0405;100;2;0)
The price is quoted per 100 units of par value. DATE avoids relying on locale-sensitive date strings.
Independent reconciliation of this example
The help supplies the example result but no general algorithm. The following is an independent 30/360 cash-flow reconstruction of this specific fixture, not a verified implementation specification for arbitrary odd periods.
On the non-month-end dates in this example, the 30/360 day counts are 240 from October15 to June15, 112 from October15 to February7, and 128 from February7 to June15. A regular semiannual period has 180 days, and a regular coupon is 100 × 0.0375 ÷ 2 = 1.875.
Under this reconstruction:
- Final coupon: 1.875 × 240/180 = 2.5.
- Final redemption plus coupon: 100 + 2.5 = 102.5.
- Accrued coupon at settlement: 1.875 × 112/180 = 1.166666666667.
- Discounted final cash flow: 102.5 ÷ (1 + 0.0405/2 × 128/180) ≈ 101.044952681388.
- Price after subtracting that accrual: approximately 99.878286014721, rounding to the documented 99.87829.
The matching check explains this sample’s scale and timing. It does not certify how the native function handles all long or short final periods, other bases, boundary dates or invalid inputs.
Advanced application: scale the quote to a holding
For an illustrative face amount of 10000, multiplying the rounded documented quote by 10000/100 gives 9987.829 before currency rounding. If the price result is in B11 and face amount in D2, use:
=B11*D2/100
Using the independently reconstructed unrounded quote instead gives approximately 9987.828601472. The small difference comes from quoting precision. Preserve the function’s stored result until the reporting step rather than replacing it with the five-decimal display.
This scales the price quote only. It does not establish a trade’s complete settlement cash amount, accrued-interest treatment, transaction fees or market quotation conventions. Those must be established separately for the actual instrument.
Errors and troubleshooting
Verify all three dates, especially LastInterest. Replacing that date with the settlement date or an assumed regular coupon date changes the period being described. Check that Frequency is one of 1, 2 or 4 and that Basis is selected explicitly when comparing results.
A common comparison mistake is to mix a coupon rate with a yield, or a per-100 redemption value with a total holding amount. Another is to compare examples with different settlement dates. Keep the dates and rates alongside the result.
The dedicated vendor section does not document a full native error-code or date-truncation matrix. Do not import such rules from another spreadsheet product. Use ROUND only for a defined reporting step, and keep the original unrounded result available for reconciliation. This guide is a function example rather than an investment valuation recommendation.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: ODDLPRICE (checked October 17, 2026).
- Editorial testing standards.