Spreadsheet: 707999d1607581754-xirr-keeping-first-cell-blank-in-some-columns-xirr-sample
Sheet: DataFunds

Date | Fund Name | Type | Units | NAV | Amount
2018-12-03 00:00:00 | FUND 03 | BUY | 135.391 |  | 4999.98963
2018-12-03 00:00:00 | FUND 06 | BUY | 111.742 |  | 5000.007532000001
2018-12-03 00:00:00 | FUND 08 | BUY | 36.174 |  | 4999.97028
2018-12-03 00:00:00 | FUND 07 | BUY | 197.683 |  | 4999.996118999999
2018-12-10 00:00:00 | FUND 09 | BUY | 397.63 |  | 19999.99374
2018-12-10 00:00:00 | FUND 03 | BUY | 418.76 |  | 14999.9832
2018-12-10 00:00:00 | FUND 06 | BUY | 347.737 |  | 14999.983232
2018-12-10 00:00:00 | FUND 08 | BUY | 112.579 |  | 15000.02596
2018-12-10 00:00:00 | FUND 07 | BUY | 614.679 |  | 15000.011637
2019-01-10 00:00:00 | FUND 09 | BUY | 378.487 |  | 20000.010054
2019-01-10 00:00:00 | FUND 03 | BUY | 534.045 |  | 19999.98525
2019-01-10 00:00:00 | FUND 06 | BUY | 439.967 |  | 20000.019886
2019-01-10 00:00:00 | FUND 08 | BUY | 144.103 |  | 20000.05537
2019-01-10 00:00:00 | FUND 07 | BUY | 788.581 |  | 19999.991322
2019-02-11 00:00:00 | FUND 09 | BUY | 387.222 |  | 20000.0163
2019-02-11 00:00:00 | FUND 03 | BUY | 542.299 |  | 19999.98712
2019-02-11 00:00:00 | FUND 06 | BUY | 463.618 |  | 20000.016902
2019-02-11 00:00:00 | FUND 08 | BUY | 154.548 |  | 20000.05668
2019-02-11 00:00:00 | FUND 07 | BUY | 842.247 |  | 19999.997262
2019-03-11 00:00:00 | FUND 09 | BUY | 367.08 |  | 19999.98672
2019-03-11 00:00:00 | FUND 03 | BUY | 519.346 |  | 20000.01446
2019-03-11 00:00:00 | FUND 06 | BUY | 428.192 |  | 19999.991936
2019-03-11 00:00:00 | FUND 08 | BUY | 144.456 |  | 19999.9332
2019-03-11 00:00:00 | FUND 07 | BUY | 779.271 |  | 19999.990215
2019-04-10 00:00:00 | FUND 09 | BUY | 356.652 |  | 19999.974204
2019-04-10 00:00:00 | FUND 03 | BUY | 512.952 |  | 19999.99848
2019-04-10 00:00:00 | FUND 06 | BUY | 421.603 |  | 20000.003114
2019-04-10 00:00:00 | FUND 08 | BUY | 141.183 |  | 19999.98378
2019-04-10 00:00:00 | FUND 07 | BUY | 782.014 |  | 20000.00805
2019-05-10 00:00:00 | FUND 09 | BUY | 369.679 |  | 20000.003579
2019-05-10 00:00:00 | FUND 03 | BUY | 529.521 |  | 20000.00817
2019-05-10 00:00:00 | FUND 06 | BUY | 448.39 |  | 19999.98756
2019-05-10 00:00:00 | FUND 08 | BUY | 148.566 |  | 19999.95492
2019-05-10 00:00:00 | FUND 07 | BUY | 819.135 |  | 20000
2019-06-10 00:00:00 | FUND 09 | BUY | 346.5 |  | 20000
2019-06-10 00:00:00 | FUND 03 | BUY | 503.525 |  | 20000
2019-06-10 00:00:00 | FUND 06 | BUY | 433.454 |  | 20000
2019-06-10 00:00:00 | FUND 08 | BUY | 143.854 |  | 20000
2019-06-10 00:00:00 | FUND 07 | BUY | 799.233 |  | 20000
2019-07-10 00:00:00 | FUND 09 | BUY | 359.35 |  | 20000
2019-07-10 00:00:00 | FUND 03 | BUY | 519.211 |  | 20000
2019-07-10 00:00:00 | FUND 06 | BUY | 454.164 |  | 20000
2019-07-10 00:00:00 | FUND 08 | BUY | 148.434 |  | 20000
2019-07-10 00:00:00 | FUND 07 | BUY | 825.696 |  | 20000
2019-08-13 00:00:00 | FUND 09 | BUY | 372.003 |  | 20000
2019-08-13 00:00:00 | FUND 03 | BUY | 528.681 |  | 20000
2019-08-13 00:00:00 | FUND 06 | BUY | 492.065 |  | 20000
2019-08-13 00:00:00 | FUND 08 | BUY | 158.554 |  | 20000
2019-08-13 00:00:00 | FUND 07 | BUY | 897.948 |  | 20000
2019-09-11 00:00:00 | FUND 09 | BUY | 363.26 |  | 20000
2019-09-11 00:00:00 | FUND 03 | BUY | 519.211 |  | 20000
2019-09-11 00:00:00 | FUND 06 | BUY | 489.333 |  | 20000
2019-09-11 00:00:00 | FUND 08 | BUY | 155.69 |  | 20000
2019-09-11 00:00:00 | FUND 07 | BUY | 876.732 |  | 20000
2019-10-10 00:00:00 | FUND 09 | BUY | 362.943 |  | 20000
2019-10-10 00:00:00 | FUND 03 | BUY | 491.884 |  | 20000
2019-10-10 00:00:00 | FUND 06 | BUY | 495.638 |  | 20000
2019-10-10 00:00:00 | FUND 08 | BUY | 152.462 |  | 20000
2019-10-10 00:00:00 | FUND 07 | BUY | 880.359 |  | 20000
2019-11-11 00:00:00 | FUND 09 | BUY | 334.79 |  | 20000
2019-11-11 00:00:00 | FUND 03 | BUY | 469.373 |  | 20000
2019-11-11 00:00:00 | FUND 06 | BUY | 479.409 |  | 20000
2019-11-11 00:00:00 | FUND 08 | BUY | 144.949 |  | 20000
2019-11-11 00:00:00 | FUND 07 | BUY | 842.779 |  | 20000
2019-12-10 00:00:00 | FUND 09 | BUY | 336.298 |  | 20000
2019-12-10 00:00:00 | FUND 10 | BUY | 355.733 |  | 20000
2019-12-10 00:00:00 | FUND 11 | BUY | 1828.655 |  | 20000
2019-12-10 00:00:00 | FUND 04 | BUY | 1547.988 |  | 20000
2019-12-10 00:00:00 | FUND 13 | BUY | 352.004 |  | 20000
2020-01-10 00:00:00 | FUND 09 | BUY | 320.539 |  | 20000
2020-01-10 00:00:00 | FUND 10 | BUY | 343.885 |  | 20000
2020-01-10 00:00:00 | FUND 11 | BUY | 1735.659 |  | 20000
2020-01-10 00:00:00 | FUND 04 | BUY | 1510.574 |  | 20000
2020-01-10 00:00:00 | FUND 13 | BUY | 339.515 |  | 20000
2020-02-10 00:00:00 | FUND 09 | BUY | 319.77 |  | 20000
2020-02-10 00:00:00 | FUND 10 | BUY | 348.092 |  | 20000
2020-02-10 00:00:00 | FUND 11 | BUY | 1696.065 |  | 20000
2020-02-10 00:00:00 | FUND 04 | BUY | 1461.988 |  | 20000
2020-02-10 00:00:00 | FUND 13 | BUY | 323.057 |  | 20000
2020-03-11 00:00:00 | FUND 09 | BUY | 359.738 |  | 20000
2020-03-11 00:00:00 | FUND 10 | BUY | 394.984 |  | 20000
2020-03-11 00:00:00 | FUND 11 | BUY | 1913.326 |  | 20000
2020-03-11 00:00:00 | FUND 04 | BUY | 1591.09 |  | 20000
2020-03-11 00:00:00 | FUND 13 | BUY | 352.938 |  | 20000
2020-04-13 00:00:00 | FUND 09 | BUY | 419.965 |  | 20000
2020-04-13 00:00:00 | FUND 10 | BUY | 460.214 |  | 20000
2020-04-13 00:00:00 | FUND 11 | BUY | 2319.647 |  | 20000
2020-04-13 00:00:00 | FUND 04 | BUY | 1808.318 |  | 20000
2020-04-13 00:00:00 | FUND 13 | BUY | 431.279 |  | 20000
2020-04-28 00:00:00 | FUND 12 | BUY | 10392.202 |  | 500000
2020-04-30 00:00:00 | FUND 01 | BUY | 1866.818 |  | 500000
2020-05-11 00:00:00 | FUND 09 | BUY | 407.407 |  | 20000
2020-05-11 00:00:00 | FUND 10 | BUY | 450.816 |  | 20000
2020-05-11 00:00:00 | FUND 11 | BUY | 2270.148 |  | 20000
2020-05-11 00:00:00 | FUND 04 | BUY | 1805.054 |  | 20000
2020-05-11 00:00:00 | FUND 13 | BUY | 426.126 |  | 20000
2020-06-02 00:00:00 | FUND 05 | BUY | 232.361 |  | 1000000
2020-06-02 00:00:00 | FUND 02 | BUY | 449.716 |  | 1000000
2020-06-10 00:00:00 | FUND 09 | BUY | 373.587 |  | 20000
2020-06-10 00:00:00 | FUND 10 | BUY | 413.462 |  | 20000
2020-06-10 00:00:00 | FUND 11 | BUY | 2055.71 |  | 20000
2020-06-10 00:00:00 | FUND 04 | BUY | 1712.329 |  | 20000
2020-06-10 00:00:00 | FUND 13 | BUY | 389.015 |  | 20000
2020-06-15 00:00:00 | FUND 05 | BUY | 115.87 |  | 500000
2020-06-15 00:00:00 | FUND 02 | BUY | 224.539 |  | 500000
2020-07-10 00:00:00 | FUND 09 | BUY | 346.904 |  | 19999
2020-07-10 00:00:00 | FUND 10 | BUY | 386.074 |  | 19999
2020-07-10 00:00:00 | FUND 11 | BUY | 1922.426 |  | 19999
2020-07-10 00:00:00 | FUND 04 | BUY | 1633.905 |  | 19999
2020-07-10 00:00:00 | FUND 13 | BUY | 364.031 |  | 19999
2020-07-15 00:00:00 | FUND 05 | BUY | 115.004 |  | 499975
2020-08-10 00:00:00 | FUND 09 | BUY | 328.493 |  | 19999
2020-08-10 00:00:00 | FUND 10 | BUY | 365.092 |  | 19999
2020-08-10 00:00:00 | FUND 11 | BUY | 1784.032 |  | 19999
2020-08-10 00:00:00 | FUND 04 | BUY | 1564.867 |  | 19999
2020-08-10 00:00:00 | FUND 13 | BUY | 340.573 |  | 19999
2020-09-10 00:00:00 | FUND 09 | BUY | 322.455 |  | 19999
2020-09-10 00:00:00 | FUND 10 | BUY | 358.078 |  | 19999
2020-09-10 00:00:00 | FUND 11 | BUY | 1763.58 |  | 19999
2020-09-10 00:00:00 | FUND 04 | BUY | 1558.769 |  | 19999
2020-09-10 00:00:00 | FUND 13 | BUY | 317.526 |  | 19999
2020-10-12 00:00:00 | FUND 09 | BUY | 311.968 |  | 19999
2020-10-12 00:00:00 | FUND 10 | BUY | 347.482 |  | 19999
2020-10-12 00:00:00 | FUND 11 | BUY | 1708.586 |  | 19999
2020-10-12 00:00:00 | FUND 04 | BUY | 1513.929 |  | 19999
2020-10-12 00:00:00 | FUND 13 | BUY | 318.66 |  | 19999
2020-11-10 00:00:00 | FUND 09 | BUY | 291.692 |  | 19999
2020-11-10 00:00:00 | FUND 10 | BUY | 329.343 |  | 19999
2020-11-10 00:00:00 | FUND 11 | BUY | 1583.954 |  | 19999
2020-11-10 00:00:00 | FUND 04 | BUY | 1415.357 |  | 19999
2020-11-10 00:00:00 | FUND 13 | BUY | 300.754 |  | 19999