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.89464887553818

Fprice@d1(date("2001-2-15"),date("2002-4-13"),0.4,0,0.061)

0.03278958904109588