Spreadsheet: 805536d1668748875-rolling-e-transfer-limit-drawdown-calculation-daily-weekly-monthly-rolling-e-transfer-limit-drawdown
Sheet: Sheet1

Rolling e-transfer limit calculation
 |  |  |  | 1 day limit |  | 7 day limit |  | 31 day limit
 |  |  |  | 20000 |  | 50000 |  | 100000
Transaction Date | Rolling Date | Transaction $
2022-10-14 00:00:00 | day 1 | 14859.19 |  | 5140.809999999999
2022-10-15 00:00:00 | day 2 |  |  | 20000
2022-10-16 00:00:00 | day 3 |  |  | 20000
2022-10-17 00:00:00 | day 4 |  |  | 20000
2022-10-18 00:00:00 | day 5 |  |  | 20000
2022-10-19 00:00:00 | day 6 | 11555.56 |  | 8444.44
2022-10-20 00:00:00 | day 7 |  |  | 20000 |  | 23585.25
2022-10-21 00:00:00 | day 8 |  |  | 20000
2022-10-22 00:00:00 | day 9 |  |  | 20000
2022-10-23 00:00:00 | day 10 |  |  | 20000
2022-10-24 00:00:00 | day 11 |  |  | 20000
2022-10-25 00:00:00 | day 12 |  |  | 20000
2022-10-26 00:00:00 | day 13 |  |  | 20000
2022-10-27 00:00:00 | day 14 |  |  | 20000 |  | 50000
2022-10-28 00:00:00 | day 15 |  |  | 20000
2022-10-29 00:00:00 | day 16 |  |  | 20000
2022-10-30 00:00:00 | day 17 |  |  | 20000
2022-10-31 00:00:00 | day 18 |  |  | 20000
2022-11-01 00:00:00 | day 19 | 19748.27 |  | 251.7299999999996
2022-11-02 00:00:00 | day 20 | 19565.73 |  | 434.2700000000004
2022-11-03 00:00:00 | day 21 |  |  | 20000 |  | 10686
2022-11-04 00:00:00 | day 22 |  |  | 20000
2022-11-05 00:00:00 | day 23 |  |  | 20000
2022-11-06 00:00:00 | day 24 |  |  | 20000
2022-11-07 00:00:00 | day 25 |  |  | 20000
2022-11-08 00:00:00 | day 26 |  |  | 20000
2022-11-09 00:00:00 | day 27 |  |  | 20000
2022-11-10 00:00:00 | day 28 |  |  | 20000 |  | 50000
2022-11-11 00:00:00 | day 29 |  |  | 20000
2022-11-12 00:00:00 | day 30 |  |  | 20000
2022-11-13 00:00:00 | day 31 |  |  | 20000 |  |  |  | 34271.25
2022-11-14 00:00:00 | day 1 |  |  | 20000
2022-11-15 00:00:00 | day 2 |  |  | 20000
2022-11-16 00:00:00 | day 3 |  |  | 20000
2022-11-17 00:00:00 | day 4 |  |  | 20000 |  | 50000
2022-11-18 00:00:00 | day 5 |  |  | 20000
2022-11-19 00:00:00 | day 6 |  |  | 20000
2022-11-20 00:00:00 | day 7 |  |  | 20000
2022-11-21 00:00:00 | day 8 |  |  | 20000
2022-11-22 00:00:00 | day 9 |  |  | 20000
2022-11-23 00:00:00 | day 10 |  |  | 20000
2022-11-24 00:00:00 | day 11 |  |  | 20000 |  | 50000
2022-11-25 00:00:00 | day 12 |  |  | 20000
2022-11-26 00:00:00 | day 13 |  |  | 20000
2022-11-27 00:00:00 | day 14 |  |  | 20000
2022-11-28 00:00:00 | day 15 |  |  | 20000
2022-11-29 00:00:00 | day 16 |  |  | 20000
2022-11-30 00:00:00 | day 17 |  |  | 20000
2022-12-01 00:00:00 | day 18 |  |  | 20000 |  | 50000
2022-12-02 00:00:00 | day 19 |  |  | 20000
2022-12-03 00:00:00 | day 20 |  |  | 20000
2022-12-04 00:00:00 | day 21 |  |  | 20000
2022-12-05 00:00:00 | day 22 |  |  | 20000
2022-12-06 00:00:00 | day 23 |  |  | 20000
2022-12-07 00:00:00 | day 24 |  |  | 20000
2022-12-08 00:00:00 | day 25 |  |  | 20000 |  | 50000
2022-12-09 00:00:00 | day 26 |  |  | 20000
2022-12-10 00:00:00 | day 27 |  |  | 20000
2022-12-11 00:00:00 | day 28 |  |  | 20000
2022-12-12 00:00:00 | day 29 |  |  | 20000
2022-12-13 00:00:00 | day 30 |  |  | 20000
2022-12-14 00:00:00 | day 31 |  |  | 20000 |  |  |  | 100000
2022-12-15 00:00:00 | day 1 |  |  | 20000 |  | 50000
2022-12-16 00:00:00 | day 2 |  |  | 20000
2022-12-17 00:00:00 | day 3 |  |  | 20000
2022-12-18 00:00:00 | day 4 |  |  | 20000
2022-12-19 00:00:00 | day 5 |  |  | 20000
2022-12-20 00:00:00 | day 6 |  |  | 20000
2022-12-21 00:00:00 | day 7 |  |  | 20000
2022-12-22 00:00:00 | day 8 |  |  | 20000 |  | 50000
2022-12-23 00:00:00 | day 9 |  |  | 20000
2022-12-24 00:00:00 | day 10 |  |  | 20000
2022-12-25 00:00:00 | day 11 |  |  | 20000
2022-12-26 00:00:00 | day 12 |  |  | 20000
2022-12-27 00:00:00 | day 13 |  |  | 20000
2022-12-28 00:00:00 | day 14 |  |  | 20000
2022-12-29 00:00:00 | day 15 |  |  | 20000 |  | 50000
2022-12-30 00:00:00 | day 16 |  |  | 20000
2022-12-31 00:00:00 | day 17 |  |  | 20000
2023-01-01 00:00:00 | day 18 |  |  | 20000
2023-01-02 00:00:00 | day 19 |  |  | 20000
2023-01-03 00:00:00 | day 20 |  |  | 20000
2023-01-04 00:00:00 | day 21 |  |  | 20000
2023-01-05 00:00:00 | day 22 |  |  | 20000 |  | 50000
2023-01-06 00:00:00 | day 23 |  |  | 20000
2023-01-07 00:00:00 | day 24 |  |  | 20000
2023-01-08 00:00:00 | day 25 |  |  | 20000
2023-01-09 00:00:00 | day 26 |  |  | 20000
2023-01-10 00:00:00 | day 27 |  |  | 20000
2023-01-11 00:00:00 | day 28 |  |  | 20000
2023-01-12 00:00:00 | day 29 |  |  | 20000 |  | 50000
2023-01-13 00:00:00 | day 30 |  |  | 20000
2023-01-14 00:00:00 | day 31 |  |  | 20000 |  |  |  | 100000