@CalcMgrExcelYIELDDISC
Purpose:
Returns the annual yield for a discounted security; for example, a Treasury billNote: When using the @CalcMgrExcelYIELDDISC
function, the calculations may not match between Oracle Hyperion 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.YIELDDISC(double,double,double,double,double)
CDF Spec: @CalcMgrExcelYIELDDISC(settlement, maturity, pr, redemption, basis)
Note:
Date parameters used in @CalcMgrExcel
functions must be in an Excel format. See @CalcMgrExcel Custom Functions with Date Parameters.