Difference between revisions of "Documentation/How Tos/Calc: DURATION ADD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 28: | Line 28: | ||
: returns approximately <tt>'''2.33'''</tt> years. | : returns approximately <tt>'''2.33'''</tt> years. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[Documentation/How_Tos/Calc: DURATION function| | + | * [[Documentation/How_Tos/Calc: DURATION function|DURATION]], |
| − | [[Documentation/How_Tos/Calc: MDURATION function| | + | * [[Documentation/How_Tos/Calc: MDURATION function|MDURATION]] |
| − | [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems| | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] |
| − | [[Documentation/How_Tos/Calc: Financial functions| | + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
=== Issues: === | === Issues: === | ||
Revision as of 13:45, 25 February 2009
DURATION_ADD
Returns the Macaulay duration of a security.
This function is only available if the Analysis AddIn is installed.
Syntax:
DURATION_ADD(settlementdate; maturitydate; rate; yield; frequency; basis)
- settlementdate: the settlement (purchase) date of the bond.
- maturitydate: the maturity (redemption) date of the bond.
- rate: the (annual) interest rate of the bond.
- yield: the (annual) yield of the bond.
- frequency: the number of interest payments per year (1, 2 or 4).
- basis: is the calendar system to use. Defaults to 0 if omitted.
- 0 - US method (NASD), 12 months of 30 days each
- 1 - Actual number of days in months, actual number of days in year
- 2 - Actual number of days in month, year has 360 days
- 3 - Actual number of days in month, year has 365 days
- 4 - European method, 12 months of 30 days each
- This function returns the Macaulay duration of a security, which is a measure of price volatility and interest rate sensitivity. It is the weighted average of the times to receipt of income from the security, where the weight for each time is the present value of that income divided by the present value of the security itself; the result is thus the sum of:
- time_until_receipti * present_value_of_incomei / present_value_of_security.
Example:
DURATION_ADD("2008-2-28"; "2010-8-31"; 5%; 6%; 2; 0)
- returns approximately 2.33 years.
Template:Documentation/SeeAlso
Issues:
- This function is implemented as DURATION in Gnumeric and Excel.
- The DURATION function in Calc is entirely different.
- This function uses YEARFRAC in the calculation. There are known slight inaccuracies (both in Calc and in Excel) in YEARFRAC.
