writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 24:
Line 24: − + Line 31:
Line 31: − + Line 42:
Line 42: − + + + Line 50:
Line 52: + + + − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − | Column4 − + − | class=" " | September 10, 2010+ − − + − | class="sshl_f" | September 10, 2016 − | Row3+ − − | Row4+ − − + − + − | class=" " | − |- class="even" − | Row6 − | class="sshl_f " | 1 − | class="sshl_f sshl_f " | 5.0458 − | class=" sshl_f " | − | class=" SelectTD SelectTD" |
Manuals/calci/DURATION (view source)
Revision as of 22:06, 26 November 2013
, 22:06, 26 November 2013no edit summary
For Quarterly payment, frequency = 4.
For Quarterly payment, frequency = 4.
*'basis' value is optional. If omitted, Calci assumes to be 0.
*'basis' value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of 'basis' values:
Below table shows the use of 'basis' values:
! Basis !! Description
! Basis !! Description
|-
|-
| 0 || USD*30/360
| 0 || US(NASD) 30/360
|-
|-
| 1 || Actual/actual
| 1 || Actual/actual
|}
|}
*If 'basis' value other than 0 to 4, Calci displays an error message.
*If 'basis' value is other than 0 to 4, Calci displays an error message.
== Examples ==
== Examples ==
Consider the following example that shows the use of DURATION function:
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class=" " | September 10, 2010
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row1
| class="sshl_f" | September 10, 2016
| class=" " |
| class=" sshl_f " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class=" " | Row2
| class=" " | 6%
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | 9.0%
| class="SelectTd " | 6%
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class=" " | 2
| class=" " | 9.0%
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row5
| class=" " | 1
| class=" " | 2
| class=" " | 5.0458
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
|}