ODDFRRICE is a built-in financial function in WPS Spreadsheet on Windows for pricing a security with an odd first period; 3 core tasks, 3 available without membership, and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
ODDFRRICE is a built-in financial function in WPS Spreadsheet for calculating the price per $100 face value of a security that has an odd first coupon period. You can find it from the Insert Function dialog, enter it directly in a worksheet cell, and review its syntax and parameter guidance before confirming the formula.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | A network connection is not required for local formula entry and calculation; internet access is needed for download, updates, or online help |
| Other | An editable spreadsheet file and complete inputs such as settlement date, maturity date, issue date, first coupon date, rate, yield, redemption value, and frequency |
Download & Installation
Before using ODDFRRICE, install WPS Office for Windows and open WPS Spreadsheet.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet, then confirm that the Formula tab and Insert Function entry are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | ODDFRRICE can be entered directly in WPS Spreadsheet, and the Insert Function dialog helps with parameter entry and syntax review. | Microsoft Word officially supports formulas in table cells through the Formula command, but this is focused on document table calculations rather than a spreadsheet financial function library. | Google Docs officially highlights Gemini features for drafting, refining, summarizing, and asking questions in documents, rather than a spreadsheet-style ODDFRRICE workflow in Docs. | Notion officially describes formulas as calculations based on database properties, built-ins, and functions for database workflows instead of traditional spreadsheet security-pricing functions in cells. | Adobe Acrobat officially supports calculation settings for PDF form fields, which fits form totals and field interactions rather than spreadsheet-based bond pricing formulas. |
| WPS Advantages | Advantage: Built for spreadsheet formula entry on Windows. Distinct: You can use the formula bar, the Insert Function dialog, and parameter guidance in one worksheet workflow. | Compared with WPS: Word formulas are centered on table fields inside documents, so the entry path and financial-function scope differ from spreadsheet formula work. | Compared with WPS: Google Docs official information here focuses on AI writing assistance in documents, not a desktop spreadsheet financial function entry flow. | Compared with WPS: Notion formulas are designed for database properties and logic, so the formula model differs from worksheet cell formulas for financial pricing. | Compared with WPS: Acrobat calculations are designed for PDF form fields, not spreadsheet cells with built-in financial functions such as ODDFRRICE. |
| Official Source | — | Use a formula in a Word table | Gemini in Google Docs | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
For spreadsheet work on Windows that depends on direct financial formula entry, parameter filling, and result calculation, WPS provides a workflow that stays close to the worksheet environment. Microsoft Word, Google Docs, Notion, and Adobe Acrobat each support their own calculation or content workflows, but they are aimed at document tables, AI writing, database logic, or PDF forms rather than this spreadsheet pricing scenario.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How it helps |
|---|---|---|---|---|
| 1 | Bond price estimation | Finance staff | A security price must be calculated quickly under an odd first coupon condition | Enter the ODDFRRICE formula in a worksheet cell to calculate the result |
| 2 | Reusable financial models | Analysts | The same function needs to be reused across a model | Fill in parameters through Insert Function and copy the formula as needed |
| 3 | Formula review and learning | New users | The parameter order and meaning are not yet familiar | Review syntax and parameter guidance before confirming the formula |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Use basic spreadsheet functions in WPS Spreadsheet | ✅ | ✅ |
| Desktop document editing | ✅ | ✅ |
| More advanced PDF, template, and extended office benefits | Partially limited | More benefits available |
| Cloud storage | 1 GB | 20 GB |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily formula entry and basic spreadsheet calculation | Free | Suitable for using worksheet functions such as ODDFRRICE |
| More cloud storage, PDF tools, or broader office benefits | WPS Premium | Better for users who also need expanded document and productivity features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page