Public Comment: ODFF: YIELD function

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • Hide

      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"

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

      Copied from office-comment list

      Original author: "David King" <[email protected]>
      Original date: 6 Sep 2008 09:28:24 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00008.html

            Assignee:
            Robert Weir (Inactive)
            Reporter:
            Robert Weir (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: