Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-916 Public Comment: ODFF: yet more suggestions
  3. OFFICE-2224

TBILLEQ: add formula, needs better description

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Add to Semantics:

      TBILLEQ is calculated as
      TBILLEQ = (365 * rate) / (360 - (rate * DSM))
      where DSM is the number of days between settlement and maturity computed according to the 360 days per year basis.

      If no one comes up with a clarification for "bond-equivalent yield for a treasury bill", leave it as is.

      Show
      Add to Semantics: TBILLEQ is calculated as TBILLEQ = (365 * rate) / (360 - (rate * DSM)) where DSM is the number of days between settlement and maturity computed according to the 360 days per year basis. If no one comes up with a clarification for "bond-equivalent yield for a treasury bill", leave it as is.
    • Resolution:
      Hide

      Added to Semantics:

      TBILLEQ is calculated as
      TBILLEQ = (365 * rate) / (360 - (rate * DSM))
      where DSM is the number of days between settlement and maturity computed according to the 360 days per year basis (basis 2, 3.10.6).

      Show
      Added to Semantics: TBILLEQ is calculated as TBILLEQ = (365 * rate) / (360 - (rate * DSM)) where DSM is the number of days between settlement and maturity computed according to the 360 days per year basis (basis 2, 3.10.6).

      Description

      Broken out from OFFICE-916

      TBILLEQ

      • Excel gives the formula:
        "TBILLEQ is calculated as TBILLEQ = (365 x rate)/360-(rate x DSM), where DSM
        is the number of days between settlement and maturity computed according to
        the 360 days per year basis."
        That's wrong - should be (365 x rate)/[360-(rate x DSM)]. Also: using the
        360 day year is vital information which needs to be included.

      [ed:] TODO: add formula.

      • "bond-equivalent yield for a treasury bill" is probably lifted from Excel's
        Help, and comes across as jargon; needs more explanation, especially for
        non-US people.

      [ed:] TODO: any native English speaker knowledgeable in that domain?

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              erack Eike Rathke (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: