OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

Robert Weir  updated OFFICE-1102:

A few corrections:

Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6"


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


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

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