Description:
The function equals the ExcelYIELD, YIELDDISC or YIELDMAT functions.
Syntax:
|
Fyield(settlement,maturity,rate,pr,redemption) |
Equivalent to Excel YIELD function. It calculates the yield rate of a security. Annually. Specify the day count basis method US (NASD) 30/360. |
|
Fyield@d(settlement,maturity,0,pr,redemption) |
Equivalent to Excel YIELDDISC function. It calculates the annual yield rate of a discounted security. Specify the day count basis method US (NASD) 30/360. |
|
Fyield@m(settlement,maturity,issue,rate,pr) |
Equivalent to Excel YIELDMAT function. It calculates the yield rate 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 yield rate 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. |
|
pr |
The security's price. |
|
redemption |
The security's redemption value. |
|
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:
|
Fyield@2(date("2008-2-15"),date("2016-11-15"),0.0575,95.04287,100) |
0.06500000688109805 |
|
Fyield@d0(date("2008-2-16"),date("2008-3-1"),0,99.795,100) |
0.05282257198685834 |
|
Fyield@m(date("2008-3-15"),date("2008-11-3"),date("2007-11-8"),0.0625,100.0123) |
0.060954333691538576 |