ODDLPRICE in WPS returns the price per $100 face value of a security with an odd last coupon period; this guide covers 3 core tasks, with 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 |
| Version limit | No version limit | You can follow the current desktop interface |
About This Feature
Overview
The ODDLPRICE function in WPS Spreadsheets returns the price per $100 face value of a security with an odd last coupon period. It is useful for bond pricing, coupon settlement review, and financial modeling in spreadsheet workflows.
Core tasks include:
- Insert ODDLPRICE from the Insert Function dialog box.
- Type
=ODDLPRICE(...)directly in a cell or in the formula bar. - Review the function syntax and parameter details for settlement, maturity, last_coupon, rate, yld, redemption, frequency, and
[basis].
For users searching how to use the ODDLPRICE function in WPS on Windows, these workflows cover the main entry points in WPS Spreadsheets.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory internet connection is required for local formula entry; internet access is needed for online help or downloads |
| Other | You need to open WPS Spreadsheets and edit worksheet cells |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, create or open a spreadsheet, and confirm that the Formulas tab and Insert Function entry are available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Spreadsheets lets you use ODDLPRICE through Insert Function or direct formula entry for security price calculations in worksheet cells. | Microsoft Word supports formulas in table cells through the Formula dialog, but the official page focuses on table calculations rather than a spreadsheet financial function such as ODDLPRICE. | Google Docs supports inserting equations and math symbols in documents, but the official page does not describe spreadsheet-style financial functions in document cells. | Notion formulas work with database properties and built-in functions for structured record calculations rather than spreadsheet financial functions in grid cells. | Adobe Acrobat supports calculated PDF form fields, which is useful for form automation rather than spreadsheet-based security pricing formulas. |
| WPS Advantages | Advantage: WPS supports direct financial formula entry in spreadsheet cells together with a parameter dialog for structured input. Distinct: It combines function search, direct typing, and syntax review in one spreadsheet workflow. | Compared with WPS: the official Microsoft page is centered on Word table formulas under Table Layout, so the workflow is document-table based instead of spreadsheet-function based. | Compared with WPS: the official Google page is centered on equation insertion for document editing, not on worksheet financial functions like ODDLPRICE. | Compared with WPS: Notion formulas depend on database properties and formula fields, so the experience differs from cell-based spreadsheet finance calculations. | Compared with WPS: Acrobat calculations are designed for PDF form fields and field relationships, not for spreadsheet cells and finance function syntax. |
| Official Source | — | Use a formula in a Word table | Use equations in a document | Formula syntax & functions | Configure form field calculations in Acrobat |
Overall Conclusion: WPS is a practical fit when you need a spreadsheet workflow for ODDLPRICE and similar finance functions on Windows. Microsoft, Google, Notion, and Adobe each support calculation-related tasks in their own products, but their official workflows focus on document tables, document equations, database formulas, or PDF form fields rather than spreadsheet security pricing.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How WPS helps |
|---|---|---|---|---|
| 1 | Bond price estimation | Finance staff | Need to calculate the price of a security with an odd last coupon period quickly | Enter ODDLPRICE in a worksheet cell and fill in the required arguments |
| 2 | Reusable valuation templates | Analysts | Need to apply the same function structure repeatedly | Use the Insert Function dialog to enter arguments in a consistent way |
| 3 | Formula training and review | Learners | Need help understanding syntax and argument order | Review the syntax first, then complete the formula entry |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic spreadsheet functions | ✅ | ✅ |
| Basic PDF features | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced templates and features |
Source: WPS Office pricing page
Recommendations
| Use case | Recommended plan | Why |
|---|---|---|
| Learning formulas and handling everyday spreadsheet calculations | Free | The ODDLPRICE function workflow is available without a membership requirement |
| Needing more cloud storage, templates, or broader office benefits | WPS Premium | A membership is more suitable when you also need expanded office benefits beyond basic formula use |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page