[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1103) Public Comment: ODFF:YIELD function
[ http://tools.oasis-open.org/issues/browse/OFFICE-1103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Weir updated OFFICE-1103: --------------------------------- Proposal: Replace definition with: Summary: Calculate the yield of a bond Syntax: YIELD( DateParam Settlement ; DateParam Maturity ; Number Rate ; Number Price ; Number Redemption ; Number Frequency [ ; Basis Basis = 0 ] ) Returns: Number Constraints: Rate, Price, and Redemption should be greater than 0. Semantics: The parameters are Settlement: the settlement date of the bond Maturity: the maturity date of the bond Rate: the coupon rate of the bond Price: the market price of the bond per 100 currency units face value Redemption: the redemption value of the bond per 100 currency units face value Frequency: the coupon payments frequency. 1=annually; 2=semiannually; 4=quarterly Basis: the day count convention to use, see section 3.10.6 (Note that we should use the universal currency symbol 'ยค' (U+00A4) instead of writing "currency units" Priority: Major (was: Blocker) > Public Comment: ODFF: YIELD function > ------------------------------------ > > Key: OFFICE-1103 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-1103 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Affects Versions: ODF 1.2 > Reporter: Robert Weir > Assignee: Robert Weir > Fix For: ODF 1.2 > > > Copied from office-comment list > Original author: "David King" <openoffice@drking.plus.com> > Original date: 6 Sep 2008 09:28:24 -0000 > Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00008.html -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]