Kč
-
Kč
(
)
-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
$
-
$
€
-
€
-
€
/
/
/
/
€
-
€
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
-
-
-
-
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
:
:
:
:
Yes
Yes
No
True
True
False
On
On
Off
¥€
(
€
)
.
.
???
Page 1
??? (???)
00.00.0000, 00:00:00
Page 1 / 99
COUPDAYS Function
Result
PRAVDA
Sheet
Result
Description
1
PRAVDA
Simple COUPDAYS formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
Data
Description
182,5
182,5
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3)
25.01.2011
Settlement date
181
181
PRAVDA
=COUPDAYS(I2;I3;I4;I5)
15.11.2011
Maturity date
180
180
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 0)
2
Semiannual coupon (see above)
181
181
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 1)
1
Actual/actual basis (see above)
180
180
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 2)
180
180
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 4)
360
360
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 1; 4)
90
90
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 4; 4)
Err:502
error
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; -4; 4)
basis
0
90
90
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 4; )
1
Err:502
error
PRAVDA
=COUPDAYS("2001-11-15";"2001-01-25"; 4; 1)
2
90
90
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; 4 )
3
Err:502
error
PRAVDA
=COUPDAYS("2001-01-25"; "2001-11-15"; )
4
4