Manuals/calci/COUPNCD - Revision history

Devika: /* Examples */

2022-05-11T09:34:14Z

Examples

Devika: /* Related Videos */

2018-11-15T20:40:34Z

Devika at 21:58, 22 August 2018

2018-08-22T21:58:52Z

Devika at 20:23, 23 July 2018

2018-07-23T20:23:18Z

Devika at 22:57, 13 July 2018

2018-07-13T22:57:30Z

Devika at 22:48, 27 June 2018

2018-06-27T22:48:11Z

Swapna: /* Related Videos */

2017-03-16T10:17:37Z

Swapna: /* Examples */

2017-03-16T10:12:50Z

Examples

Swapna: /* Examples */

2017-03-16T10:12:27Z

Examples

Swapna: /* Examples */

2017-03-16T10:11:24Z

Examples

@@ Line 68: / Line 68: @@
 |}
-. =COUPNCD(A1,A2,A3,A4) displays '''Mon Dec 20 2010 15:30:06 GMT+0530 (India Standard Time)''' as a result.
+. =COUPNCD(A1,A2,A3,A4) displays '''12/20/2010''' as a result.
-. =COUPNCD(DATE(2012,1,31),DATE(2014,1,6),1,1) displays '''Sun Jan 06 2013 00:00:00 GMT+0530 (India Standard Time)''' as a result.
+. =COUPNCD(DATE(2012,1,31),DATE(2014,1,6),1,1) displays '''01/06/2013''' as a result.
 ==Related Videos==

@@ Line 74: / Line 74: @@
 ==Related Videos==
-{{#ev:youtube|sH0foB1oh0Q|280|center|COUPNCD}}
+{{#ev:youtube|v=pPRoSLoPLcA|280|center|COUPNCD}}
 == See Also ==

@@ Line 5: / Line 5: @@
 *<math>Frequency</math> is the number of coupon payments per year, and
 *<math>Basis</math> is the type of day count basis to use.
+**COUPNCD(), returns the next coupon date after the settlement date.
 == Description ==

@@ Line 6: / Line 6: @@
 *<math>Basis</math> is the type of day count basis to use.
-COUPNCD() calculates the next coupon date after the settlement date.
+COUPNCD(), returns the next coupon date after the settlement date.
 == Description ==

← Older revision		Revision as of 22:57, 13 July 2018
Line 1:		Line 1:
−	=COUPNCD(Settlement, Maturity, Frequency, Basis)=	+	<div style="font-size:25px">'''COUPNCD(Settlement, Maturity, Frequency, Basis)'''</div><br/>

	*Where <math>Settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),		*Where <math>Settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),

@@ Line 1: / Line 1: @@
-=COUPNCD(settlement, maturity, frequency, basis)=
+=COUPNCD(Settlement, Maturity, Frequency, Basis)=
-*Where <math>settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),
+*Where <math>Settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),
-*<math>maturity</math> is the security's maturity date (a date when coupon or a bond expires),
+*<math>Maturity</math> is the security's maturity date (a date when coupon or a bond expires),
-*<math>frequency</math> is the number of coupon payments per year, and
+*<math>Frequency</math> is the number of coupon payments per year, and
-*<math>basis</math> is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
 COUPNCD() calculates the next coupon date after the settlement date.
@@ Line 10: / Line 10: @@
 == Description ==
-COUPNCD(settlement, maturity, frequency, basis)
+COUPNCD(Settlement, Maturity, Frequency, Basis)
-*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>Settlement</math> and <math>Maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-*If <math>settlement</math> date = <math>maturity</math> date, Calci displays #N/A error message.
+*If <math>Settlement</math> date = <math>Maturity</math> date, Calci displays #N/A error message.
-*The values for <math>frequency</math> should be 1,2 or 4.
+*The values for <math>Frequency</math> should be 1,2 or 4.
 For Annual payment, frequency = 1,
@@ Line 21: / Line 21: @@
 For Quarterly payment, frequency = 4.
-*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 39: / Line 39: @@
 |}
-*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 == Examples ==

@@ Line 69: / Line 69: @@
 |}
-. =COUPNCD(A1,A2,A3,A4) ''displays Mon Dec 20 2010 15:30:06 GMT+0530 (India Standard Time)'' as a result.
+. =COUPNCD(A1,A2,A3,A4) displays '''Mon Dec 20 2010 15:30:06 GMT+0530 (India Standard Time)''' as a result.
-. =COUPNCD(DATE(2012,1,31),DATE(2014,1,6),1,1) ''displays Sun Jan 06 2013 00:00:00 GMT+0530 (India Standard Time)'' as a result.
+. =COUPNCD(DATE(2012,1,31),DATE(2014,1,6),1,1) displays '''Sun Jan 06 2013 00:00:00 GMT+0530 (India Standard Time)'' as a result.
 ==Related Videos==