writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + + + + − where,+ + + + + + + + + + + − '''Settle''' - the security's settlement date.+ + − '''M''' - the security's maturity date.+ − '''F''' - the number of coupon payments per year and '''Basis'''- Type of day count basis.+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − This function returns a date that represents previous coupon date before the settlement date.+ − </div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − F must be 1,2,or 4+ − COUPPCD shows there value when Basis<0 or Basis>4, and settlement date greaterthan or equal to maturity date.+ − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − COUPPCD − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − Lets see an example in (Column3,Row1) − <nowiki>=COUPPCD(B2,B3,B4,B5)</nowiki>+ + + + + + + +
Manuals/calci/couppcd (view source)
Revision as of 11:43, 12 February 2014
, 11:43, 12 February 2014no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''COUPNCD(settle, M, F, basis)'''</div><br/>
'''COUPPCD'''(settle, M, F, basis)
*<math>Settle</math> is the security's settlement 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>basis</math> is the Type of day count basis.
==Description==
*This function returns a date that represents next coupon date after the settlement date.
*<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>4,
*<math>Settlement date</math> must be greater than or equal to maturity date.
*<math>basis</math> is the calender system to use.
0 - US method (NASD), 12 months of 30 days each
1 - Actual number of days in months, actual number of days in year
2 - Actual number of days in month, year has 360 days
3 - Actual number of days in month, year has 365 days
4 - European method, 12 months of 30 days each
==Examples==
=COUPPCD(B2,B3,B4,B5)
Where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPPCD returns (Sun Oct 15, 2006).
==References==
UNIQ7cf1cacc92d99ec2-nowiki-00000002-QINU
Where
Where