Spreadsheet: 711764d1609885886-xirr-formula-error-returning-tiny-decimal-2-98e-09-xirrerror
Sheet: XIRR Error

 | Cash Flows (3/14/18-1/4/21) |  |  |  |  |  | XNPV Curve
 | Date | Cashflow |  | XIRR: |  |  | Discount Rate | XNPV
 | 2018-03-14 00:00:00 | 6752.03 |  |  |  |  | -0.99
 | 2019-03-14 00:00:00 | -6752.03 |  |  |  |  | -0.9
 | 2019-06-21 00:00:00 | 6000 |  |  |  |  | -0.8
 | 2019-06-25 00:00:00 | -679.3 |  |  |  |  | -0.7
 | 2019-06-25 00:00:00 | -3253.2 |  |  |  |  | -0.6
 | 2019-06-25 00:00:00 | -2112.1 |  |  |  |  | -0.5
 | 2019-07-17 00:00:00 | 65000 |  |  |  |  | -0.4
 | 2019-07-18 00:00:00 | -18179.91 |  |  |  |  | -0.3
 | 2019-07-18 00:00:00 | -5000 |  |  |  |  | -0.2
 | 2019-07-18 00:00:00 | -20000 |  |  |  |  | -0.1
 | 2019-07-23 00:00:00 | -19658.1 |  |  |  |  | 0
 | 2019-07-30 00:00:00 | 1.98 |  |  |  |  | 0.1
 | 2019-08-01 00:00:00 | -1976.6 |  |  |  |  | 0.2
 | 2019-08-29 00:00:00 | 0.09 |  |  |  |  | 0.3
 | 2019-09-30 00:00:00 | 5.2 |  |  |  |  | 0.4
 | 2019-12-27 00:00:00 | 5.2 |  |  |  |  | 0.5
 | 2020-02-11 00:00:00 | 6000 |  |  |  |  | 0.6
 | 2020-02-12 00:00:00 | 1106.86 |  |  |  |  | 0.7
 | 2020-02-12 00:00:00 | -3082.71 |  |  |  |  | 0.8
 | 2020-02-12 00:00:00 | -2051.7 |  |  |  |  | 0.9
 | 2020-02-12 00:00:00 | 383.76 |  |  |  |  | 1
 | 2020-02-12 00:00:00 | -2021.98 |  |  |  |  | 1.1
 | 2020-03-30 00:00:00 | 6.24 |  |  |  |  | 1.2
 | 2020-04-02 00:00:00 | 3509.46 |  |  |  |  | 1.3
 | 2020-05-01 00:00:00 | -611.63 |  |  |  |  | 1.4
 | 2020-05-01 00:00:00 | -4215 |  |  |  |  | 1.5
 | 2020-05-07 00:00:00 | 20000 |  |  |  |  | 1.6
 | 2020-05-28 00:00:00 | 0.21 |  |  |  |  | 1.7
 | 2020-06-01 00:00:00 | 41000 |  |  |  |  | 1.8
 | 2020-06-01 00:00:00 | -19487.16 |  |  |  |  | 1.9
 | 2020-06-05 00:00:00 | -14838.78 |  |  |  |  | 2
 | 2020-06-05 00:00:00 | -20154.35 |  |  |  |  | 3
 | 2020-06-05 00:00:00 | -6187.1 |  |  |  |  | 4
 | 2020-06-08 00:00:00 | 702.69 |  |  |  |  | 5
 | 2020-06-29 00:00:00 | 0.13 |  |  |  |  | 6
 | 2020-06-30 00:00:00 | 6.24 |  |  |  |  | 7
 | 2020-07-13 00:00:00 | 21436.31 |  |  |  |  | 8
 | 2020-07-13 00:00:00 | -11989 |  |  |  |  | 9
 | 2020-07-13 00:00:00 | -9337.05 |  |  |  |  | 10
 | 2020-07-13 00:00:00 | -623.01
 | 2020-07-21 00:00:00 | 3687.79
 | 2020-07-21 00:00:00 | 2953.12
 | 2020-07-21 00:00:00 | -7903.03
 | 2020-07-21 00:00:00 | 786.34
 | 2020-08-05 00:00:00 | 51210.52
 | 2020-08-05 00:00:00 | 32549.28
 | 2020-08-05 00:00:00 | -83485.85
 | 2020-08-07 00:00:00 | 2614.44
 | 2020-08-14 00:00:00 | 100000
 | 2020-08-18 00:00:00 | -49625.4
 | 2020-08-18 00:00:00 | -9881.28
 | 2020-08-18 00:00:00 | -4963.72
 | 2020-08-18 00:00:00 | -24980.48
 | 2020-08-18 00:00:00 | -10652.6
 | 2020-08-18 00:00:00 | -11287.43
 | 2020-08-27 00:00:00 | 10814.16
 | 2020-08-28 00:00:00 | 0.17
 | 2020-08-31 00:00:00 | -2473.88
 | 2020-08-31 00:00:00 | -318.68
 | 2020-09-03 00:00:00 | 4521.52
 | 2020-09-03 00:00:00 | 9997.24
 | 2020-09-03 00:00:00 | 653.9699999999999
 | 2020-09-03 00:00:00 | -14747.4
 | 2020-09-03 00:00:00 | -152.69
 | 2020-09-04 00:00:00 | 10000
 | 2020-09-04 00:00:00 | -9609.57
 | 2020-09-30 00:00:00 | 6.24
 | 2020-11-03 00:00:00 | 8000
 | 2020-11-03 00:00:00 | -2730.26
 | 2020-12-04 00:00:00 | 3392.11
 | 2020-12-04 00:00:00 | 3065.93
 | 2020-12-04 00:00:00 | 9270.57
 | 2020-12-04 00:00:00 | -21380.73
 | 2020-12-08 00:00:00 | 1536.23
 | 2021-01-04 00:00:00 | 608418.76
 | 2021-01-04 00:00:00 | 83760.06
 | 2021-01-04 00:00:00 | 64764.81
 | SUM: