Difference between revisions of "Manuals/calci/couppcd"
| (5 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">''' | + | <div style="font-size:30px">'''COUPPCD(settle, M, F, basis)'''</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== | ||
| Line 17: | Line 17: | ||
3 - Actual number of days in month, year has 365 days | 3 - Actual number of days in month, year has 365 days | ||
4 - European method, 12 months of 30 days each | 4 - European method, 12 months of 30 days each | ||
| − | * | + | *COUPPCD returns errors when |
Settlement<math>(s)</math> or Maturity<math>(m)</math> is not a valid date. | Settlement<math>(s)</math> or Maturity<math>(m)</math> is not a valid date. | ||
Frequency<math>(f)</math> is any number other than 1, 2, or 4. | Frequency<math>(f)</math> is any number other than 1, 2, or 4. | ||
| Line 24: | Line 24: | ||
==Examples== | ==Examples== | ||
| − | |||
*=COUPPCD("2007/02/21","2009/02/21",2,1) | *=COUPPCD("2007/02/21","2009/02/21",2,1) | ||
Wed Feb 21 2007 00:00:00 GMT+0530 (India Standard Time) | Wed Feb 21 2007 00:00:00 GMT+0530 (India Standard Time) | ||
*=COUPPCD("2005-07-13", "2009-01-18", 2, 3) | *=COUPPCD("2005-07-13", "2009-01-18", 2, 3) | ||
Tue Jan 18 2005 05:30:00 GMT+0530 (India Standard Time) | Tue Jan 18 2005 05:30:00 GMT+0530 (India Standard Time) | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|gyPAbeZAG4M|280|center|COUPPCD}} | ||
| + | |||
| + | ==See Also== | ||
| + | |||
| + | *[[Manuals/calci/coupncd | COUPNCD]] | ||
| + | *[[Manuals/calci/cumipmt | CUMIPMT ]] | ||
| + | *[[Manuals/calci/cumprinc | CUMPRINC]] | ||
==References== | ==References== | ||
[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUPPCD_function COUPPCD] | [https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUPPCD_function COUPPCD] | ||
Latest revision as of 12:01, 19 July 2015
COUPPCD(settle, M, F, basis)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s} is the security's settlement date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is the security's maturity date(Expire date).
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle f} is the number of coupon(interest) payments per year(1,2 or 4)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b} is the Type of day count basis.
Description
- This function returns a date that represents next coupon date after the settlement date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle f} must be 1,2 or 4
- COUPNCD shows there value when Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle basis\lt 0} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle basis\gt 0} Basis>4,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Settlement date} must be greater than or equal to maturity date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b} 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
- COUPPCD returns errors when
SettlementFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (s)}
or MaturityFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (m)}
is not a valid date.
FrequencyFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (f)}
is any number other than 1, 2, or 4.
BasisFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (b)}
< 0 or if BasisFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (b)}
> 4.
SettlementFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (s)}
≥ MaturityFailed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (m)}
.
Examples
- =COUPPCD("2007/02/21","2009/02/21",2,1)
Wed Feb 21 2007 00:00:00 GMT+0530 (India Standard Time)
- =COUPPCD("2005-07-13", "2009-01-18", 2, 3)
Tue Jan 18 2005 05:30:00 GMT+0530 (India Standard Time)