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

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]