writer
6,694
edits
Changes
Manuals/calci/COUPDAYS (view source)
Revision as of 20:26, 15 November 2018
, 20:26, 15 November 2018→Related Videos
=COUPDAYS(settlement, maturity, frequency, basis)=
<div style="font-size:25px">'''COUPDAYS (SettlementDate,MaturityDate,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>SettlementDate</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>MaturityDate</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.
**COUPDAYS(), returns the number of days in the coupon period that contains the settlement date.
COUPDAYS() calculates the number of days in the coupon period.
== Description ==
== Description ==
COUPDAYS(settlement, maturity, frequency, basis)
COUPDAYS (SettlementDate,MaturityDate,Frequency,Basis)
*COUPDAYS() calculates the number of days between the coupon dates surrounding the settlement date.
*COUPDAYS() calculates the number of days between the coupon dates surrounding the settlement date.
*<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>SettlementDate</math> and <math>MaturityDate</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>SettlementDate</math> ≥ <math>MaturityDate</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"
{| class="wikitable"
| 3 || Actual/365
| 3 || Actual/365
|-
|-
| 4 || European 30/365
| 4 || European 30/360
|}
|}
*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 ==
== Examples ==
=COUPDAYS(A1,A2,A3,A4) ''displays 183'' as a result.
=COUPDAYS(A1,A2,A3,A4) ''displays 183'' as a result.
=COUPDAYS(DATE(2012,1,1),DATE(2013,1,1),1,1) ''displays 366'' as a result.
=COUPDAYS(DATE(2012,1,1),DATE(2013,1,1),1,1) ''displays 366'' as a result.
==Related Videos==
{{#ev:youtube|v=Sdod6NuKvOU|280|center|COUPDAYS}}
== See Also ==
== See Also ==
*[http://en.wikipedia.org/wiki/Coupon_(bond) Coupon]
*[http://en.wikipedia.org/wiki/Coupon_(bond) Coupon]
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]