Manuals/calci/COUPPCD - Revision history

Devika: /* Examples */

2022-05-11T09:48:02Z

Examples

Devika: /* Related Videos */

2018-11-15T20:43:19Z

Devika at 22:02, 22 August 2018

2018-08-22T22:02:20Z

Devika at 20:29, 29 June 2018

2018-06-29T20:29:52Z

Swapna: /* COUPPCD(settlement, maturity, frequency, basis) */

2017-03-16T10:29:13Z

COUPPCD(settlement, maturity, frequency, basis)

Swapna: Created page with "=COUPPCD(settlement, maturity, frequency, basis)= Where $settlement$ is the security's settlement date (a date when coupon or a bond is purchased), $maturi..."$

2017-03-16T10:22:02Z

Created page with "=COUPPCD(settlement, maturity, frequency, basis)= *Where <math>settlement</math> is the security's settlement date (a date when coupon or a bond is purchased), *<math>maturi..."

New page

=COUPPCD(settlement, maturity, frequency, basis)=

*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>frequency</math> is the number of coupon payments per year, and
*<math>basis</math> is the type of day count basis to use.

COUPPCD() calculates the next coupon date after the settlement date.

== Description ==

COUPPCD(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.
*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.
For Annual payment, frequency = 1,

For Semi-annual payment, frequency = 2,

For Quarterly payment, frequency = 4.

*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of <math>basis</math> values:

{| class="wikitable"
|-
! Basis !! Description
|-
| 0 || US (NASD) 30/360
|-
| 1 || Actual/actual
|-
| 2 || Actual/360
|-
| 3 || Actual/365
|-
| 4 || European 30/360
|}

*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.

== Examples ==

Consider the following example that shows the use of COUPPCD function:

<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " | 06/20/2010
| class=" " |
| class=" " |

|- class="odd"
| class="sshl_f" | 12/20/2014
| class=" " |
| class=" " |

|- class="even"
| class=" " | 2
| class=" " |
| class=" " |

|- class="odd"
| class=" " | 1
| class=" " |
| class=" " |
|}

1. =COUPPCD(A1,A2,A3,A4) displays '''Mon Dec 20 2010 15:30:06 GMT+0530 (India Standard Time)''' as a result.

2. =COUPPCD(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==

{{#ev:youtube|gyPAbeZAG4M|280|center|COUPPCD}}

== See Also ==

*[[Manuals/calci/COUPNUM | COUPNUM]]
*[[Manuals/calci/COUPNCD | COUPNCD]]
*[[Manuals/calci/COUPDAYS | COUPDAYS]]
*[[Manuals/calci/COUPDAYBS | COUPDAYBS]]

== References ==

*[http://en.wikipedia.org/wiki/Coupon_(bond) Coupon]
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]

*[[Z_API_Functions | List of Main Z Functions]]

*[[ Z3 | Z3 home ]]

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

@@ 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.
+**COUPPCD(), returns the previous coupon date before the settlement date.
 == Description ==

@@ Line 1: / Line 1: @@
-=COUPPCD(settlement, maturity, frequency, basis)=
+<div style="font-size:30px">'''COUPPCD(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),
-*<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.
-COUPPCD() calculates the previous coupon date, before the settlement date for a security.
+COUPPCD(), returns the previous coupon date before the settlement date.
 == Description ==
-COUPPCD(settlement, maturity, frequency, basis)
+COUPPCD(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,
+For Annual payment, Frequency = 1,
-For Semi-annual payment, frequency = 2,
+For Semi-annual payment, Frequency = 2,
-For Quarterly payment, frequency = 4.
+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 74: / Line 74: @@
 ==Related Videos==
-{{#ev:youtube|gyPAbeZAG4M|280|center|COUPPCD}}
+{{#ev:youtube|v=cKGhoc9o3sg|280|center|COUPPCD}}
 == See Also ==