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.89464887553818 |
|
Fprice@d1(date("2001-2-15"),date("2002-4-13"),0.4,0,0.061) |
0.03278958904109588 |