Manuals/calci/couppcd - Revision history

Swapna at 18:01, 19 July 2015

2015-07-19T18:01:12Z

Abin at 08:26, 24 February 2014

2014-02-24T08:26:45Z

Abin: /* Examples */

2014-02-24T08:01:46Z

Examples

Abin: /* See Also */

2014-02-24T08:01:14Z

Abin: /* Examples */

2014-02-24T08:00:27Z

Examples

Abin at 07:30, 24 February 2014

2014-02-24T07:30:13Z

Abin: /* Description */

2014-02-24T07:28:44Z

Description

Abin: /* References */

2014-02-24T07:28:03Z

References

Abin: /* Examples */

2014-02-24T07:27:14Z

Examples

Abin: /* References */

2014-02-12T11:44:35Z

References

@@ Line 28: / Line 28: @@
 *=COUPPCD("2005-07-13", "2009-01-18", 2, 3)
   Tue Jan 18 2005 05:30:00 GMT+0530 (India Standard Time)
 ==See Also==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''COUPPCD(settle, M, F, basis)'''</div><br/>
-*<math>Settle</math> is the security's settlement date.
+*<math>s</math> is the security's settlement date.
-*<math>M</math> is the security's maturity date(Expire date).
+*<math>m</math> is the security's maturity date(Expire date).
-*<math>F</math> is the number of coupon(interest) payments per year(1,2 or 4)
+*<math>f</math> is the number of coupon(interest) payments per year(1,2 or 4)
-*<math>basis</math> is the Type of day count basis.
+*<math>b</math> is the Type of day count basis.
 ==Description==

@@ Line 24: / Line 24: @@
 ==Examples==
 *=COUPPCD("2007/02/21","2009/02/21",2,1)
   Wed Feb 21 2007 00:00:00 GMT+0530 (India Standard Time)

@@ Line 32: / Line 32: @@
 ==See Also==
-*[[Manuals/calci/couppcd | COUPNCD]]
+*[[Manuals/calci/coupncd | COUPNCD]]
 *[[Manuals/calci/cumipmt | CUMIPMT ]]
 *[[Manuals/calci/cumprinc | CUMPRINC]]

@@ Line 29: / Line 29: @@
 *=COUPPCD("2005-07-13", "2009-01-18", 2, 3)
   Tue Jan 18 2005 05:30:00 GMT+0530 (India Standard Time)
 ==References==
 [https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUPPCD_function COUPPCD]

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''COUPNCD(settle, M, F, basis)'''</div><br/>
+<div style="font-size:30px">'''COUPPCD(settle, M, F, basis)'''</div><br/>
 *<math>Settle</math> is the security's settlement date.
@@ Line 17: / Line 17: @@
 - Actual number of days in month, year has 365 days
 - European method, 12 months of 30 days each
-*COUPNCD returns errors when
+*COUPPCD returns errors when
   Settlement<math>(s)</math> or Maturity<math>(m)</math> is not a valid date.
   Frequency<math>(f)</math> is any number other than 1, 2, or 4.

@@ Line 8: / Line 8: @@
 ==Description==
 *This function returns a date that represents next coupon date after the settlement date.
-*<math>F</math> must be 1,2 or 4
+*<math>f</math> must be 1,2 or 4
-*COUPNCD shows there value  when  <math>basis\lt 0</math> or <math>basis\gt 0</math>Basis&gt;4,
+*COUPNCD shows there value when <math>basis\lt 0</math> or <math>basis\gt 0</math>Basis&gt;4,
 *<math>Settlement date</math> must be greater than or equal to maturity date.
-*<math>basis</math> is the calender system to use.
+*<math>b</math> is the calender system to use.
 - US method (NASD), 12 months of 30 days each
 - Actual number of days in months, actual number of days in year
@@ Line 17: / Line 17: @@
 - Actual number of days in month, year has 365 days
 - European method, 12 months of 30 days each
 ==Examples==

← Older revision		Revision as of 07:28, 24 February 2014
Line 26:		Line 26:

	==References==		==References==
		+	[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUPPCD_function COUPPCD]

← Older revision		Revision as of 11:44, 12 February 2014
Line 34:		Line 34:

	==References==		==References==
−
−
−
−
−
−
−
−
−
−
−
−
−	~~UNIQ7cf1cacc92d99ec2-nowiki-00000002-QINU~~
−
−	~~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>~~
−	~~----~~