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 |