[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1102) Public Comment: ODFF:INTRATE function
[ http://tools.oasis-open.org/issues/browse/OFFICE-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eike Rathke updated OFFICE-1102:
--------------------------------
Proposal:
A few corrections:
Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6"
with
"Basis: [optional] indicates the day count basis to use; see section 3.11.6"
Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error."
with
Constraints: Settlement < Maturity
And add the formula:
The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis)
was:
A few corrections:
Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6"
with
"Basis: [optional] indicates the day count basis to use; see section 3.11.6"
Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error."
with
"If the Settlement date is equal to or after the Maturity date, an error is returned." (Also, delete the redundant copy of this constraint). I don't think it makes sense to talk about an "invalid" date.
And add the formula:
The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis)
Instead of removing the constraint and adding a sentence to semantics, simply change the constraint to
Constraints: Settlement < Maturity
This implies returning an error if the constraint is not met.
> Public Comment: ODFF: INTRATE function
> --------------------------------------
>
> Key: OFFICE-1102
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-1102
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Reporter: Robert Weir
> Assignee: Robert Weir
> Priority: Blocker
> Fix For: ODF 1.2 Part 2 CD 3
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com>
> Original date: 5 Sep 2008 17:35:41 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00007.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]