[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]