• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Fprice()

Description:

The function equals the Excel PRICE, PRICEDISC or PRICEMAT function.

Syntax:

 Fprice(settlement,maturity,rate,yld,redemption) Equivalent to Excel PRICE function. It calculates the price per ¥100 par value of a security that pays periodic interest. Annually. Specify the day count basis method US (NASD) 30/360 Fprice@d(settlement,maturity,discount,0,redemption) Equivalent to Excel PRICEDISC function. It calculates the price per ¥100 par value of a discounted security. Specify the day count basis method US (NASD) 30/360 Fprice@m(settlement,maturity,issue,rate,yld) Equivalent to Excel PRICEMAT function. It calculates the price per ¥100 par value of a security that pays interest at maturity. Specify the day count basis method US (NASD) 30/360

Note:

The external library function (See External Library Guide) returns the price of a security that pays periodic interest, or of a discounted security, or of a security that pays periodic interest

Parameter:

 settlement The security's settlement date maturity The security's maturity date rate The security's annual coupon rate yld The security's annual yield redemption The security's redemption value discount The security's discount rate issue The security’s issue date

Option

 @2 Semi-annually. It corresponds to the Excel frequency parameter @4 Quarterly. It corresponds to the Excel frequency parameter @1 Specify the day count basis method Actual/Actual. It corresponds to the Excel basis parameter @0 Specify the day count basis method Actual/360. It corresponds to the Excel basis parameter @5 Specify the day count basis method Actual/365. It corresponds to the Excel basis parameter @e Specify the day count basis method European 30/360. It corresponds to the Excel basis parameter

Example:

 Fprice@m(date("2001-2-15"),date("2002-4-13"),date("2000-11-11"),0.061,0.061) 99.8946 Fprice@d1(date("2001-2-15"),date("2002-4-13"),0.4,0,0.061) 0.0327896