Changes

3,371 bytes added , 02:32, 25 October 2013

Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font color="#000000">'''<font face="Arial, sans-serif"><font size="2">COUPDAYBS(settle, M, F, basis)</font></font>'''</f..."

<div id="6SpaceContent" class="zcontent" align="left"><font color="#000000">'''<font face="Arial, sans-serif"><font size="2">COUPDAYBS(settle, M, F, basis)</font></font>'''</font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'F' is the number of coupon payments per year and 'B' is the type of day count basis to use.</font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"><font color="#000000"><font face="Arial, sans-serif"><font size="2">This function returns the number of days from the beginning of the coupon period to the settlement date.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis must be between 0 and 4 and 'F' should be 1,2 or 4</font></font></font>

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">When settlement ≥ maturity, COUPDAYBS shows the error value. </font></font></font>

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

COUPDAYBS

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Lets see an example,'''</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">COUPDAYBS(settle, M, F, basis)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">January 25, 2008</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">November 15, 2009</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">3</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">1</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=COUPDAYBS(B2,B3,B4,B5) is 71</nowiki></font></font></font>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class="SelectTD" | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | January 25, 2008
| class=" " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | November 15, 2009
|
|
|
|- class="odd"
| Row3
| class="sshl_f" | 3
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 1
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 71
|
|
|
|- class="even"
| Row6
| class="sshl_f" |
|
|
|
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/COUPDAYBS (view source)

Revision as of 02:32, 25 October 2013

Navigation menu

Search