Fyield()

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