ODDLPRICE in WPS on Windows: Introduction

ODDLPRICE in WPS is a spreadsheet financial function for pricing a security with an odd last coupon period; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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

ODDLPRICE is a financial function in WPS Spreadsheet that returns the price per 100 face value of a security with an odd last coupon period. It is useful for bond pricing, irregular coupon-period analysis, and spreadsheet models that combine dates, rates, yields, and referenced cells.

Core capabilities include:

Use the ODDLPRICE function directly in a worksheet cell.
Enter settlement date, maturity date, last interest date, rate, yield, and related arguments in the required order.
Work with cross-sheet references and nested formulas.
Recalculate results automatically when referenced values change.

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 for local formula calculation; internet is needed for download, installation, and account-related actions
Other	You need access to open WPS Spreadsheet files and edit cells and formulas

Download & Installation

Before using ODDLPRICE, install WPS Office on your Windows device and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open Spreadsheet, and confirm that you can type formulas in a cell and access the Formulas tab

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet supports the ODDLPRICE function for bond pricing in worksheet cells, with cross-sheet references, nested formulas, and automatic recalculation.	Excel provides the ODDLPRICE function to return the price per $100 face value of a security with an odd last coupon period.	Google Sheets documents the PRICE function for securities paying periodic interest, but the referenced official page does not document ODDLPRICE.	Notion formulas perform calculations with database properties, built-ins, and functions, but they are not a spreadsheet financial-function library.	Adobe Acrobat supports calculated fields in PDF forms, which are designed for form-field calculations rather than spreadsheet-based bond pricing.
WPS Advantages	Advantage: Use ODDLPRICE directly in spreadsheet cells for this bond-pricing scenario. Distinct: It also supports cross-sheet references, nested calculations, and automatic recalculation in the worksheet workflow.	Compared with WPS: Excel offers the same named function for a similar financial calculation workflow.	Compared with WPS: Google Sheets officially documents PRICE on the cited page, so this workflow may require a different function setup instead of the same named function.	Compared with WPS: Notion formulas are centered on database properties and workspace logic rather than spreadsheet-style financial functions.	Compared with WPS: Adobe calculation features are focused on PDF form fields, not worksheet-based financial modeling.
Official Source	—	ODDLPRICE function	PRICE	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If you need to calculate the price of a security with an odd last coupon period directly in a spreadsheet, WPS and Microsoft Excel both provide a close match for that workflow. Google Sheets, Notion, and Adobe each support calculation features, but their cited official pages focus on different calculation models or product contexts.

Use Cases

No.	Scenario	Suitable for	Main challenge	How ODDLPRICE helps
1	Bond pricing analysis	Finance staff	Need to calculate the price of a security with an irregular last coupon period quickly	Enter ODDLPRICE in a cell and provide the required arguments
2	Investment modeling	Analysts and researchers	Need to include bond-pricing logic in a larger model	Combine ODDLPRICE with other formulas in the workbook
3	Cross-sheet data models	Spreadsheet users	Input values are stored across multiple sheets	Reference cells across sheets and let the result update automatically
4	Training and practice	Students and trainees	Need to understand financial-function syntax and argument order	Use formula prompts and sample data to practice repeatedly
5	Daily result checking	Office users	Need to verify whether updated inputs change the result	Review recalculated results after editing referenced values

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Enter formulas in WPS Spreadsheet	✅	✅
Use ODDLPRICE for calculation	✅	✅
Additional premium services and extended benefits	Use the features included in the free plan	Access the benefits included in the selected subscription plan
Cloud storage and some extended capabilities	Basic storage and basic capabilities	Higher storage or more extended capabilities depending on plan

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need ODDLPRICE and regular spreadsheet formulas	Free	The feature description shows no membership restriction for this function
You also need more cloud storage or other premium services	WPS Premium	Suitable when you want broader subscription benefits in the same account

WPS membership center: Subscribe now