# 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 function returns the price of a security that pays periodic interest, or of a discounted security, or of a security that pays periodic interest

Parameters:

 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

Options

 @2 Semi-annually. It corresponds to the Excel frequency parameter. @4 Quaterly. 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