Spreadsheet: 705728d1606286742-xirr-dynamic-range-xirr-help-solved-
Sheet: Sheet1

XIRR
ENDING VALUE | 5500000
ENDING DATE
Holding Period
LAST XACTION DATE
FIRST XACTION DATE
Last Value Address
First Value Address
[NAME] DATE | EQUITY CASHFLOWS
2017-01-23 00:00:00 | -194425.1913
2017-02-08 00:00:00 | -156727.69294
2017-02-08 00:00:00 | 207851.5404
2017-02-09 00:00:00 | -189274.61306
2018-06-04 00:00:00 | 610767.444
2018-10-19 00:00:00 | -92730.1428
2018-10-19 00:00:00 | -117760.1428
2018-11-15 00:00:00 | -392892.75622
2018-11-16 00:00:00 | -58135.82938
2019-03-12 00:00:00 | -292600.7
2019-04-15 00:00:00 | -95614.6
2019-05-21 00:00:00 | -98317.84
2019-05-21 00:00:00 | -140518.42
2019-05-21 00:00:00 | -82599
2019-05-29 00:00:00 | -112635
2019-06-03 00:00:00 | -60072
2019-06-14 00:00:00 | 2000
2019-08-11 00:00:00 | 0
2019-08-14 00:00:00 | 2800
2019-08-19 00:00:00 | 2000
2019-10-01 00:00:00 | 5500
2019-10-03 00:00:00 | 375
2019-12-28 00:00:00 | 0
2020-01-16 00:00:00 | 3750
2020-02-20 00:00:00 | 1800
2020-02-20 00:00:00 | 2500
2020-02-28 00:00:00 | 2100
2020-03-13 00:00:00 | -33565.23
2020-03-13 00:00:00 | -14362.214
2020-03-13 00:00:00 | -14362.214
2020-03-13 00:00:00 | 13833.38
2020-04-01 00:00:00 | 291899.3
2020-04-01 00:00:00 | -170454.3
2020-04-01 00:00:00 | -139246.896
2020-04-15 00:00:00 | -124399.1
2020-04-15 00:00:00 | -119570.3124
2020-04-16 00:00:00 | -33665.35
2020-04-16 00:00:00 | -24654.55
2020-04-16 00:00:00 | -59771.64
2020-04-16 00:00:00 | -71585.8
2020-04-16 00:00:00 | -257934.15
2020-04-16 00:00:00 | -63451.05
2020-04-16 00:00:00 | -77154.975
2020-04-22 00:00:00 | -25530.6
2020-04-22 00:00:00 | -15668.78
2020-04-27 00:00:00 | -14517.4
2020-04-27 00:00:00 | 139832
2020-04-30 00:00:00 | -43537.182
2020-05-04 00:00:00 | -75240.18
2020-05-12 00:00:00 | -14967.94
2020-05-12 00:00:00 | -21675.98
2020-05-18 00:00:00 | -11563.86
2020-05-18 00:00:00 | -50760.84
2020-05-18 00:00:00 | -53113.66
2020-05-18 00:00:00 | -19973.94
2020-05-21 00:00:00 | -39347.16
2020-05-22 00:00:00 | -51061.2
2020-06-01 00:00:00 | -48708.38
2020-06-02 00:00:00 | 519
2020-06-02 00:00:00 | 250
2020-06-08 00:00:00 | 36201.506
2020-06-08 00:00:00 | 116859.6
2020-06-10 00:00:00 | -72587
2020-06-12 00:00:00 | -14016.8
2020-06-17 00:00:00 | -65578.6
2020-06-22 00:00:00 | -57068.4
2020-06-23 00:00:00 | 305183.34
2020-06-26 00:00:00 | -167701
2020-07-06 00:00:00 | 373231.584
2020-07-08 00:00:00 | 1539
2020-07-09 00:00:00 | 7631.250000000001
2020-07-09 00:00:00 | -77342.7
2020-07-09 00:00:00 | -130156
2020-07-09 00:00:00 | -307368.4
2020-07-13 00:00:00 | 79395.31116000001
2020-07-13 00:00:00 | 159.20872
2020-07-16 00:00:00 | -62575
2020-07-20 00:00:00 | 61026.68
2020-07-20 00:00:00 | -22466.928
2020-07-21 00:00:00 | 62974.34
2020-07-24 00:00:00 | 10667.184
2020-07-28 00:00:00 | -165198
2020-08-07 00:00:00 | 1500
2020-08-31 00:00:00 | -236533.5
2020-08-31 00:00:00 | -235031.7
2020-09-01 00:00:00 | -16294.53
2020-09-02 00:00:00 | -90108
2020-09-07 00:00:00 | -89607.4
2020-09-08 00:00:00 | -44102.86
2020-09-08 00:00:00 | -87104.4
2020-09-09 00:00:00 | -42050.4
2020-09-09 00:00:00 | -135162
2020-09-21 00:00:00 | 3750
2020-09-24 00:00:00 | -41049.2
2020-09-24 00:00:00 | -18772.5
2020-09-24 00:00:00 | -47056.4
2020-09-25 00:00:00 | -20399.45
2020-09-30 00:00:00 | -57569
2020-10-07 00:00:00 | 2750
2020-10-08 00:00:00 | 3100
2020-10-08 00:00:00 | 7500
2020-10-08 00:00:00 | -52062.4
2020-10-08 00:00:00 | -60672.72
2020-10-09 00:00:00 | -61799.07
2020-10-12 00:00:00 | -81597.8
2020-10-12 00:00:00 | -40548.6
2020-10-12 00:00:00 | -40298.3
2020-10-13 00:00:00 | -19773.7
2020-10-14 00:00:00 | -50060
2020-10-14 00:00:00 | -55066
2020-10-16 00:00:00 | -80096
2020-10-20 00:00:00 | -188225.6
2020-10-28 00:00:00 | -40298.3
2020-10-28 00:00:00 | 1680
2020-11-12 00:00:00 | 6750
2020-11-12 00:00:00 | -197987.3
2020-11-12 00:00:00 | -39297.1
2020-11-13 00:00:00 | -156187.2
2020-11-13 00:00:00 | -38796.5
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0