@CalcMgrExcelYIELDMAT

Purpose:

Returns the annual yield of a security that pays interest at maturityNote: When using the @CalcMgrExcelYIELDMAT function, the calculations may not match between Calculation Manager and Excel. To make the numbers match, change the decimals to 7 and use Open Office.

Syntax:

Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelFinancialFunctions.YIELDMAT(double,double,double,double,double,double)

CDF Spec: @CalcMgrExcelYIELDMAT(settlement, maturity, issue, rate, pr, basis)

Note:

Date parameters used in @CalcMgrExcel functions must be in an Excel format. See @CalcMgrExcel Custom Functions with Date Parameters.