Recover Password

Or login with:

  • Facebookhttp://facebook.com/
  • Googlehttps://www.google.com/accounts/o8/id
  • Yahoohttp://yahoo.com/
get GPL
COST (GBP)
this unit 2.81
sub units 12.37
add licence
0
FinanceBanking

coupon Next Date

viewed 1593 times and licensed 42 times
Calculate the next coupon date for a security. Excel: COUPNCD
Controller:

buy now get GPL add to cart

Dependents

Info

Interface

C++

CouponNextDate

 
intcouponNextDateintsett
intmat
Finance::Banking::YearlyFreqfreq
Finance::Banking::YearBasisbasis = yb_USA )
Calculate the next coupon date after the settlement date. This value may never be equal to the settlement date.

For a security, the settlement date is the date after issue when the security is traded to the buyer. The maturity date is the date at which the security expires.

The yearly frequency to be used in financial calculations <table border="0"> <tr align="center"><td width="100"> <strong>Type</strong></td><td><strong>Description</strong></td></tr> <tr> <td align="center" valign="top"><em>yf_Annual</em></td> <td>Payments are made annually.</td> </tr> <tr> <td align="center" valign="top"><em>yf_SemiAnnual</em></td> <td>Payments are semi-annual (2 per year).</td> </tr> <tr> <td align="center" valign="top"><em>yf_Quarterly</em></td> <td>Payments are quarterly (4 per year).</td> </tr> </table>

Authors

James Warren (August 2005)

<div align="center"> <table border="0"> <tr align="center"><td width="100"> <strong>Type</strong></td><td><strong>Value</strong></td><td><strong>Description</strong></td></tr> <tr><td align="center" valign="top"><em>yb_US</em></td><td valign="top">0</td><td>US (NASD) 30/360 - As with the European 30/360 (yb_EU, with the additional provision that if the end date occurs on the 31st of a month it is moved to the 1st of the next month if the start date is earlier than the 30th.</td></tr> <tr><td align="center" valign="top"><em>yb_Act</em></td><td valign="top">1</td><td>Uses the exact number of elapsed days between the two dates, as well as the exact length of the year.</td></tr> <tr><td align="center" valign="top"><em>yb_Act360</em></td><td valign="top">2</td><td>Uses the exact number of elapsed days between two dates but assumes the year only have 360 days</td></tr> <tr><td align="center" valign="top"><em>yb_Act365</em></td><td valign="top">3</td><td>Uses the exact number of elapsed days between two dates but assumes the year always has 365 days</td></tr> <tr><td align="center" valign="top"><em>yb_EU</em></td><td valign="top">4</td><td>European 30/360 - Each month is assumed to have 30 days, such that the year has only 360 days. Start and end dates that occur on the 31st of a month become equal to the 30th of the same month.</td></tr> </table> </div>

Parameters

settThe settlement date, expressed as a serial Julian date.
matThe maturity date of the settlement, expressed as a serial Julian date.
freqThe frequency with which payments are made:
basisThe year basis to use for the calculation:

Returns

The next coupon date of the security.

Authors

James Warren (August 2005)
Source Code

Source code is available when you agree to a GP Licence or buy a Commercial Licence.

Not a member, then Register with CodeCogs. Already a Member, then Login.


 

Page Comments

 
 Format Excel Equations

  You must login to leave a messge