Spreadsheet: 799369d1665059024-xirr-weird-results-xirr-calculation-error-
Sheet: Sheet1

 | Date | Cashflow | Balance | Microsoft Excel | Google Docs | LibreOffice |  | LIVE
 | 2012-12-31 00:00:00 | -8041.43 |  | Err:502 |  | Err:502
 | 2013-02-28 00:00:00 | -7899.18 |  | Err:502 |  | Err:502
 | 2013-06-30 00:00:00 | -64911.42 |  | Err:502 |  | Err:502
 | 2013-08-31 00:00:00 | -84409.38 |  | Err:502 |  | Err:502
 | 2013-09-30 00:00:00 | -403750 |  | Err:502 |  | Err:502
 | 2014-01-07 00:00:00 | 60715.36 |  | 4.9e-09 |  | Err:502
 | 2014-01-20 00:00:00 | -7500 |  | 4.9e-09 |  | Err:502
 | 2014-02-10 00:00:00 | 7650752.21 |  | 148.22609375 | 148.226094536155 | 148.226094536155
 | 2014-10-17 00:00:00 | -6000 |  | 148.22058875 | 148.220589165573 | 148.220589165573
 | 2014-11-20 00:00:00 | -7.45 |  | 148.22058375 | 148.220584877052 | 148.220584877052
 | 2014-11-21 00:00:00 | -4560.03 |  | 148.21799625 | 148.217995659497 | 148.217995659497
 | 2015-02-23 00:00:00 | -129600 |  | 148.19771625 | 148.197717247708 | 148.197717247708
 | 2015-02-24 00:00:00 | -4592.41 |  | 148.19700875 | 148.197008368376 | 148.197008368376
 | 2015-03-26 00:00:00 | -20811.34 |  | 148.19487875 | 148.194879372124 | 148.194879372124
 | 2015-04-01 00:00:00 | -275000 |  | 148.16896375 | 148.168963811626 | 148.168963811626
 | 2015-05-05 00:00:00 | -258882.09 |  | 148.15365375 | 148.153653605626 | 148.153653605626
 | 2015-05-11 00:00:00 | -25611.85 |  | 148.15225875 | 148.152258378473 | 148.152258378473
 | 2015-05-22 00:00:00 | -52425.36 |  | 148.14980125 | 148.149802244717 | 148.149802244717
 | 2015-06-01 00:00:00 | -17597.9 |  | 148.14908375 | 148.149083406375 | 148.149083406375
 | 2015-06-02 00:00:00 | -34401.21 |  | 148.14769625 | 148.147697300247 | 148.147697300247
 | 2015-06-22 00:00:00 | -3254.56 |  | 148.14759875 | 148.147597617939 | 148.147597617939
 | 2015-07-23 00:00:00 | -39803.63 |  | 148.14680125 | 148.146800645106 | 148.146800645106
 | 2015-08-20 00:00:00 | -2866.38 |  | 148.14676125 | 148.14676155067 | 148.14676155067
 | 2015-09-24 00:00:00 | -37783.02 |  | 148.14644375 | 148.146442653462 | 148.146442653462
 | 2015-10-22 00:00:00 | -13295.03 |  | 148.14636625 | 148.146366216706 | 148.146366216706
 | 2015-11-25 00:00:00 | -95.96 |  | 148.14636625 | 148.146365870583 | 148.146365870583
 | 2015-11-26 00:00:00 | -22569.69 |  | 148.14628625 | 148.146285571484 | 148.146285571484
 | 2015-12-14 00:00:00 | -196004.66 |  | 148.14574125 | 148.145740739219 | 148.145740739219
 | 2016-01-26 00:00:00 | -40852.69 |  | 148.14567875 | 148.145677766711 | 148.145677766711
 | 2016-02-01 00:00:00 | -16511.44 |  | 148.14565375 | 148.145654325223 | 148.145654325223
 | 2016-02-02 00:00:00 | -17817.06 |  | 148.14562875 | 148.145629374598 | 148.145629374598
 | 2016-02-26 00:00:00 | -14949.7 |  | 148.14561375 | 148.145614310062 | 148.145614310062
 | 2016-03-23 00:00:00 | -25118.86 |  | 148.14559625 | 148.145596588954 | 148.145596588954
 | 2016-04-29 00:00:00 | -34981.04 |  | 148.14558125 | 148.145581730102 | 148.145581730102
 | 2016-05-24 00:00:00 | -24293.7 |  | 148.14557375 | 148.145574405755 | 148.145574405755
 | 2016-06-22 00:00:00 | -26642.76 |  | 148.14556875 | 148.145569008701 | 148.145569008701
 | 2016-06-29 00:00:00 | 1999470.97 |  | 148.14593625 | 148.14593697202 | 148.14593697202
 | 2016-07-27 00:00:00 | -26125.15 |  | 148.14593375 | 148.145933697083 | 148.145933697083
 | 2016-08-24 00:00:00 | -189265.3 |  | 148.14591875 | 148.145917535923 | 148.145917535923
 | 2016-10-25 00:00:00 | -107290.31 |  | 148.14591375 | 148.145913620795 | 148.145913620795
 | 2016-11-23 00:00:00 | -42427.41 |  | 148.14591375 | 148.145912580553 | 148.145912580553
 | 2016-12-22 00:00:00 | -44039.51 |  | 148.14591125 | 148.145911855062 | 148.145911855062
 | 2017-02-24 00:00:00 | -5667.28 |  | 148.14591125 | 148.145911816243 | 148.145911816243
 | 2017-03-23 00:00:00 | -98089.08 |  | 148.14591125 | 148.145911352267 | 148.145911352267
 | 2017-05-30 00:00:00 | -216267.99 |  | 148.14591125 | 148.145910949623 | 148.145910949623
 | 2017-06-23 00:00:00 | -8665.71 |  | 148.14591125 | 148.145910938013 | 148.145910938013
 | 2017-07-12 00:00:00 | -10816.45 |  | 148.14591125 | 148.145910926846 | 148.145910926846
 | 2017-10-23 00:00:00 | -38717.48 |  | 148.14591125 | 148.14591091711 | 148.14591091711
 | 2017-11-21 00:00:00 | -112158.83 |  | 148.14591125 | 148.145910898159 | 148.145910898159
 | 2017-12-25 00:00:00 | -30871.82 |  | 148.14591125 | 148.145910894887 | 148.145910894887
 | 2018-01-26 00:00:00 | -96843.72 |  | 148.14591125 | 148.145910888267 | 148.145910888267
 | 2018-02-05 00:00:00 | -909099.17 |  | 148.14591125 | 148.145910834091 | 148.145910834091
 | 2018-02-20 00:00:00 | -24241.86 |  | 148.14591125 | 148.145910832915 | 148.145910832915
 | 2018-03-27 00:00:00 | -56440.25 |  | 148.14591125 | 148.14591083122 | 148.14591083122
 | 2018-04-30 00:00:00 | -57122.63 |  | 148.14591125 | 148.145910830144 | 148.145910830144
 | 2018-05-31 00:00:00 | -30883.34 |  | 148.14591125 | 148.145910829764 | 148.145910829764
 | 2018-06-30 00:00:00 | -66200.79 |  | 148.14591125 | 148.145910829224 | 148.145910829224
 | 2018-07-25 00:00:00 | -96777.16 |  | 148.14591125 | 148.145910828663 | 148.145910828663
 | 2018-08-24 00:00:00 | -47153.74 |  | 148.14591125 | 148.145910828482 | 148.145910828482
 | 2018-09-25 00:00:00 | -678164.49 |  | 148.14591125 | 148.145910826804 | -0.244670958555486
 | 2018-09-30 00:00:00 | -183600 |  | 148.14591125 | -0.228278795083909 | -0.228278795083909
 | 2019-08-31 00:00:00 | -71150.48 |  | 148.14591125 | -0.220754991383868 | -0.220754991383868
 | 2020-02-29 00:00:00 | -99873.16 |  | 148.14591125 | -0.209650553164951 | -0.209650553164941
 | 2020-05-31 00:00:00 | -87156.86 |  | 148.14591125 | -0.200227927359933 | -0.200227927359933
 | 2020-06-30 00:00:00 | -189001.26 |  | 148.14591125 | -0.18179419705141 | -0.181794197049026
 | 2020-07-31 00:00:00 | -436297.04 |  | 148.14591125 | -0.147194598656216 | -0.147194598656216
 | 2020-08-31 00:00:00 | -1090386.11 |  | 148.14591125 | -0.0869485668080825 | -0.086948566808083
 | 2020-09-30 00:00:00 | -168699.79 |  | 148.14591125 | -0.079554111655501 | -0.079554111655501
 | 2021-06-30 00:00:00 | -39395.75 |  | 148.14591125 | -0.0777783713398541 | -0.077778371339854
 | 2021-08-31 00:00:00 | -9033.01 |  | 148.14591125 | -0.0773695087200316 | -0.077369508720032
 | 2021-11-30 00:00:00 | -29804.12 |  | 148.14591125 | -0.0760046312017747 | -0.076004631201774
 | 2021-12-15 00:00:00 | 600000 |  | 148.14591125 | -0.107985762218015 | -0.107985762217105
 | 2021-12-31 00:00:00 | -648259.52 |  | 148.14591125 | -0.0737274423254442 | -0.073727442325444
 | 2022-01-21 00:00:00 | 600000 |  | 148.14591125 | -0.105209282003118 | -0.105209282003088
 | 2022-01-31 00:00:00 | -159403.47 |  | 148.14591125 | -0.0957710606592077 | -0.095771060659202
 | 2022-02-28 00:00:00 | -2066.46 |  | 148.14591125 | -0.0956538378050128 | -0.095653837805006