Difference between revisions of "Manuals/calci/coupncd"

Revision as of 06:01, 12 February 2014

COUPNCD(settle, M, F, basis)

Settle - the security's settlement date.
M - the security's maturity date.
F - the number of coupon payments per year
Basis - Type of day count basis.

Description

This function returns a date that represents next coupon date after the settlement date.
F must be 1,2 or 4
COUPNCD shows there value when Basis<0 or Basis>4,
Settlement date greater than or equal to maturity date.

Examples

?UNIQ17b134979b170de4-nowiki-00000003-QINU?

where

B2=2/25/2007

B3=10/15/2008

B4=2

B5=1

COUPNCD returns (Sun APRIL 15, 2007).

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:30px">'''COUPNCD(settle, M, F, basis)'''</div><br/>
-'''COUPNCD'''(settle, M, F, basis)
+*Settle - the security's settlement date.
+*M - the security's maturity date.
+*F - the number of coupon payments per year
+*Basis - Type of day count basis.
+==Description==
+*This function  returns  a date that represents next coupon date after the settlement date.
+*F must be 1,2 or 4
+*COUPNCD shows there value  when  Basis&lt;0 or Basis&gt;4,
+*Settlement date greater than or equal to maturity date.
-where,
+==Examples==
+UNIQ17b134979b170de4-nowiki-00000003-QINU
-'''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 next coupon date after the settlement date.
-</div>
-----
-<div id="7SpaceContent" class="zcontent" align="left">
-F must be 1,2or 4
-COUPNCD shows there value  when  Basis&lt;0 or Basis&gt;4, and settlement date greaterthan or equal to maturity date.
-</div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-COUPNCD
-</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-Lets see an example in (Column3,Row2)
-<nowiki>=COUPNCD(B2,B3,B4,B5)</nowiki>
 where
@@ Line 51: / Line 26: @@
 COUPNCD returns (Sun APRIL 15, 2007).
-</div>
+==References==
-----
-<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
-| Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f" | 2/25/2007
-| class="                                 " |
-| class="sshl_f" | Sun Apr 15 00:00:00 UTC+0530 2007
-| class="                                       sshl_f  " |
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | 10/15/2008
-|
-| class="SelectTD                                                                                        sshl_t ChangeBGColor" |
-|
-|- class="odd"
-| Row3
-| class="         " | 2
-|
-| class="sshl_t" |
-|
-|- class="even"
-| Row4
-| class=" " | 1
-|
-| class="sshl_t" |
-|
-|- class="odd"
-| class=" " | Row5
-| class="                                                                                                                                                         " |
-|
-|
-|
-|- class="even"
-| Row6
-|
-|
-|
-|
-|}
-<div align="left"></div>''''''</div>
-----

Difference between revisions of "Manuals/calci/coupncd"

Revision as of 06:01, 12 February 2014

Description

Examples

References

Navigation menu

Search