[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


From Semantics remove
"If the Settlement date is equal to or after the maturity date, an Error is returned."

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

Constraints: Settlement < Maturity

And add the formula:

The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis)



> 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" <> 
> 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