• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# 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.065 Fyield@d0(date("2008-2-16"),date("2008-3-1"),0,99.795,100) 0.0528226 Fyield@m(date("2008-3-15"),date("2008-11-3"),date("2007-11-8"),0.0625,100.0123) 0.0609543