1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Custom Functions
  4. Financial Functions
  5. @CalcMgrExcelYIELDDISC

@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 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.