Difference between revisions of "Manuals/calci/coupncd"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''COUPNCD( | + | <div style="font-size:30px">'''COUPNCD(s,m,f,b)'''</div><br/> |
| − | *<math> | + | *<math>s</math> is the security's settlement date. |
| − | *<math> | + | *<math>m</math> is the security's maturity date(Expire date). |
| − | *<math> | + | *<math>f</math> is the number of coupon(interest) payments per year(1,2 or 4) |
| − | *<math> | + | *<math>b</math> is the Type of day count basis. |
==Description== | ==Description== | ||
*This function returns a date that represents next coupon date after the settlement date. | *This function returns a date that represents next coupon date after the settlement date. | ||
| − | *<math> | + | *<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, | *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>Settlement date</math> must be greater than or equal to maturity date. | ||
| − | *<math> | + | *<math>b</math> is the calender system to use. |
0 - US method (NASD), 12 months of 30 days each | 0 - US method (NASD), 12 months of 30 days each | ||
1 - Actual number of days in months, actual number of days in year | 1 - Actual number of days in months, actual number of days in year | ||
Revision as of 23:22, 17 February 2014
COUPNCD(s,m,f,b)
- is the security's settlement date.
- is the security's maturity date(Expire date).
- is the number of coupon(interest) payments per year(1,2 or 4)
- is the Type of day count basis.
is the security's settlement date.
is the security's maturity date(Expire date).
is the number of coupon(interest) payments per year(1,2 or 4)
is the Type of day count basis.Description
- This function returns a date that represents next coupon date after the settlement date.
- must be 1,2 or 4
- COUPNCD shows there value when Failed to parse (unknown function "\lt"): {\displaystyle basis\lt 0} or Failed to parse (unknown function "\gt"): {\displaystyle basis\gt 0} Basis>4,
- must be greater than or equal to maturity date.
- is the calender system to use.
must be greater than or equal to maturity date.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
?UNIQ17b134979b170de4-nowiki-00000003-QINU?
where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPNCD returns (Sun APRIL 15, 2007).