Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''COUPPCD'''(settle, M, F, basis) where, '''Settle''' - the security's settlement date. '''M''' - the secur..."
<div id="6SpaceContent" class="zcontent" align="left">
'''COUPPCD'''(settle, M, F, basis)
where,
'''Settle''' - the security's settlement date.
'''M''' - the security's maturity date.
'''F''' - the number of coupon payments per year and '''Basis'''- Type of day count basis.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">
This function returns a date that represents previous coupon date before the settlement date.
</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
F must be 1,2,or 4
COUPPCD shows there value when Basis<0 or Basis>4, and settlement date greaterthan or equal to maturity date.
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
COUPPCD
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
Lets see an example in (Column3,Row1)
<nowiki>=COUPPCD(B2,B3,B4,B5)</nowiki>
Where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPPCD returns (Sun Oct 15, 2006).
</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=" " | Column2
| class=" " | Column3
| class=" " | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 2/25/2007
| class=" sshl_f " |
| class="sshl_f" | Sun Oct 15 00:00:00 UTC+0530 2006
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 10/15/2008
|
| class=" sshl_f " |
| class="SelectTD" |
|- class="odd"
| Row3
| class=" " | 2
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 1
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" |
|
| class=" sshl_f " |
|
|- class="even"
| Row6
| class="sshl_f" |
|
|
|
|}
<div align="left"></div>''''''</div>
----
'''COUPPCD'''(settle, M, F, basis)
where,
'''Settle''' - the security's settlement date.
'''M''' - the security's maturity date.
'''F''' - the number of coupon payments per year and '''Basis'''- Type of day count basis.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">
This function returns a date that represents previous coupon date before the settlement date.
</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
F must be 1,2,or 4
COUPPCD shows there value when Basis<0 or Basis>4, and settlement date greaterthan or equal to maturity date.
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
COUPPCD
</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">
Lets see an example in (Column3,Row1)
<nowiki>=COUPPCD(B2,B3,B4,B5)</nowiki>
Where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPPCD returns (Sun Oct 15, 2006).
</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=" " | Column2
| class=" " | Column3
| class=" " | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 2/25/2007
| class=" sshl_f " |
| class="sshl_f" | Sun Oct 15 00:00:00 UTC+0530 2006
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 10/15/2008
|
| class=" sshl_f " |
| class="SelectTD" |
|- class="odd"
| Row3
| class=" " | 2
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 1
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" |
|
| class=" sshl_f " |
|
|- class="even"
| Row6
| class="sshl_f" |
|
|
|
|}
<div align="left"></div>''''''</div>
----