7e676f |
ACCRINT |
=ACCRINT(DATE(2008,3,1), DATE(2008,8,31), DATE(2011,2,15), 0.1, 1000, 2, 0) |
value |
|
cb3bd3 |
ACCRINT |
=ACCRINT(DATE(2011,2,15), DATE(2011,8,15), DATE(2012,2,15), 0.0575, 1000, 1, 1) |
value |
|
a9f519 |
ACCRINT |
=ACCRINT(DATE(2011,2,15), DATE(2011,5,15), DATE(2012,2,15), 0.0575, 1000, 4, 0) |
value |
1 |
752adb |
ACCRINTM |
=ACCRINTM(DATE(2011,2,15), DATE(2011,11,15), 0.0575, 1000, 0) |
value |
|
65977c |
ACCRINTM |
=ACCRINTM(DATE(2011,2,15), DATE(2011,11,15), 0.0575, 1000, 1) |
value |
|
a64166 |
ACCRINTM |
=ACCRINTM(DATE(2011,2,15), DATE(2011,5,15), 0.065, 1000, 0) |
value |
|
f1902b |
AMORLINC |
=AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 1) |
value |
1 |
897369 |
AMORLINC |
=AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 0) |
value |
1 |
1a44d2 |
COUPDAYBS |
=COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
039474 |
COUPDAYBS |
=COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 1, 1) |
value |
1 |
b66a95 |
COUPDAYBS |
=COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 4, 0) |
value |
1 |
8307c3 |
COUPDAYS |
=COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
72ac0b |
COUPDAYS |
=COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 1) |
value |
1 |
b66641 |
COUPDAYS |
=COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 1, 0) |
value |
1 |
d65c21 |
COUPDAYSNC |
=COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
0a32ce |
COUPDAYSNC |
=COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 4, 1) |
value |
1 |
017d9a |
COUPNCD |
=COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
47f1ce |
COUPNCD |
=COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) |
value |
1 |
9a3186 |
COUPNCD |
=COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) |
value |
1 |
8cec31 |
COUPNUM |
=COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
0c2d18 |
COUPNUM |
=COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 4, 1) |
value |
1 |
9467a0 |
COUPPCD |
=COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) |
value |
1 |
18bed1 |
COUPPCD |
=COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) |
value |
1 |
ea6233 |
COUPPCD |
=COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) |
value |
1 |
065751 |
DISC |
=DISC(DATE(2011,2,15), DATE(2011,11,15), 97.975, 100, 0) |
value |
|
22a8a4 |
DISC |
=DISC(DATE(2011,2,15), DATE(2011,11,15), 97.975, 100, 1) |
value |
|
866acd |
DOLLARDE |
=DOLLARDE(1.02, 16) |
value |
1 |
37ce4c |
DOLLARDE |
=DOLLARDE(1.1, 8) |
value |
1 |
a829d9 |
DOLLARDE |
=DOLLARDE(1.16, 32) |
value |
|
6d5c52 |
DOLLARFR |
=DOLLARFR(1.125, 16) |
value |
1 |
c088d8 |
DOLLARFR |
=DOLLARFR(1.125, 8) |
value |
1 |
676f7f |
DOLLARFR |
=DOLLARFR(1.5, 32) |
value |
1 |
24d7d2 |
DURATION |
=DURATION(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 2, 0) |
value |
|
b471b6 |
DURATION |
=DURATION(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 1, 1) |
value |
|
e6a8d4 |
INTRATE |
=INTRATE(DATE(2011,2,15), DATE(2011,11,15), 1000000, 1014420, 0) |
value |
|
04f4c6 |
INTRATE |
=INTRATE(DATE(2011,2,15), DATE(2011,11,15), 1000000, 1014420, 1) |
value |
|
b89e99 |
MDURATION |
=MDURATION(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 2, 0) |
value |
|
56f35e |
MDURATION |
=MDURATION(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 1, 1) |
value |
|
9f1737 |
PRICE |
=PRICE(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 100, 2, 0) |
value |
|
20bdd1 |
PRICE |
=PRICE(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 100, 1, 1) |
value |
|
086669 |
PRICE |
=PRICE(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 0.065, 100, 4, 0) |
value |
|
d9abb7 |
PRICEDISC |
=PRICEDISC(DATE(2011,2,15), DATE(2011,11,15), 0.0525, 100, 0) |
value |
|
ad2014 |
PRICEDISC |
=PRICEDISC(DATE(2011,2,15), DATE(2011,11,15), 0.0525, 100, 1) |
value |
|
d3fc7c |
PRICEMAT |
=PRICEMAT(DATE(2011,2,15), DATE(2011,11,15), DATE(2010,11,15), 0.0575, 0.065, 0) |
value |
|
64f3bc |
PRICEMAT |
=PRICEMAT(DATE(2011,2,15), DATE(2011,11,15), DATE(2010,11,15), 0.0575, 0.065, 1) |
value |
|
46d75a |
RECEIVED |
=RECEIVED(DATE(2011,2,15), DATE(2011,11,15), 1000000, 0.0575, 0) |
value |
|
aefd22 |
RECEIVED |
=RECEIVED(DATE(2011,2,15), DATE(2011,11,15), 1000000, 0.0575, 1) |
value |
|
56a868 |
TBILLEQ |
=TBILLEQ(DATE(2008,3,31), DATE(2008,6,1), 0.0914) |
value |
|
a73584 |
TBILLEQ |
=TBILLEQ(DATE(2011,2,15), DATE(2011,5,15), 0.065) |
value |
|
2fd27f |
TBILLPRICE |
=TBILLPRICE(DATE(2008,3,31), DATE(2008,6,1), 0.09) |
value |
1 |
efd89c |
TBILLPRICE |
=TBILLPRICE(DATE(2011,2,15), DATE(2011,5,15), 0.065) |
value |
|
eb9a87 |
TBILLYIELD |
=TBILLYIELD(DATE(2008,3,31), DATE(2008,6,1), 98.45) |
value |
|
b5b26f |
TBILLYIELD |
=TBILLYIELD(DATE(2011,2,15), DATE(2011,5,15), 98.5) |
value |
|
fd675d |
YIELD |
=YIELD(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 95.04287, 100, 2, 0) |
value |
|
742611 |
YIELD |
=YIELD(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 95.04287, 100, 1, 1) |
value |
|
36fc34 |
YIELD |
=YIELD(DATE(2011,2,15), DATE(2021,11,15), 0.0575, 95.04287, 100, 4, 0) |
value |
|
b9e2b6 |
YIELDDISC |
=YIELDDISC(DATE(2011,2,15), DATE(2011,11,15), 94.5, 100, 0) |
value |
|
cc53a0 |
YIELDDISC |
=YIELDDISC(DATE(2011,2,15), DATE(2011,11,15), 94.5, 100, 1) |
value |
|
ce7721 |
YIELDMAT |
=YIELDMAT(DATE(2011,2,15), DATE(2011,11,15), DATE(2010,11,15), 0.0575, 99.2, 0) |
value |
|
0a7a57 |
YIELDMAT |
=YIELDMAT(DATE(2011,2,15), DATE(2011,11,15), DATE(2010,11,15), 0.0575, 99.2, 1) |
value |
|