Spreadsheet: 674813d1588023079-calculations-based-on-segments-in-a-table-pl-calcs
Sheet: Sheet1

 | Open Date | Close Date | Symbol | Action | Commission | Swap | Amount | Balance |  | Step 1: Sum of F:H before any subsequent "Deposit" or "Withdraw": | Step 2: ROI of Segment | Step 3:  Total ROI During a Month
 | 2016-09-30 11:24:00 |  |  | Deposit | 0 | 0 | 500
 | 2016-09-30 12:03:00 |  |  | Deposit | 0 | 0 | 100
(beginning of Month) | 2016-10-03 00:30:00 | 2016-10-03 16:00:00 | EURUSD | Sell | -0.04 | 0 | -0.16
 | 2016-10-03 00:50:00 | 2016-10-03 20:00:00 | USDCHF | Sell | -0.03 | 0 | -2.44
 | 2016-10-03 23:37:00 | 2016-10-04 09:40:00 | AUDNZD | Buy | -0.02 | -0.01 | -1.73
 | 2016-10-04 17:00:00 |  |  | Withdrawal | 0 | 0 | -95
 | 2016-10-04 20:11:00 | 2016-10-04 20:47:00 | AUDCAD | Buy | -0.02 | 0 | 0.69
 | 2016-10-04 23:03:00 |  |  | Deposit | 0 | 0 | 500
 | 2016-10-04 18:01:00 | 2016-10-05 02:20:00 | AUDNZD | Sell | -0.05 | -0.01 | -7.62
 | 2016-10-04 23:00:00 | 2016-10-05 02:20:00 | AUDNZD | Sell | -0.05 | -0.01 | -5.15
 | 2016-10-04 19:49:00 | 2016-10-05 04:59:00 | AUDNZD | Sell | -0.02 | 0 | -5.54
 | 2016-10-04 23:01:00 | 2016-10-05 04:59:00 | AUDNZD | Sell | -0.02 | 0 | -4.59
 | 2016-10-05 18:42:00 | 2016-10-06 00:28:00 | AUDNZD | Sell | -0.1 | 0.07 | 0.4
 | 2016-10-10 18:18:00 | 2016-10-10 22:35:00 | AUDNZD | Sell | -0.1 | 0 | 3.33
 | 2016-10-10 19:17:00 | 2016-10-11 02:47:00 | AUDCAD | Sell | -0.05 | -0.07 | 1.51
 | 2016-10-12 20:47:00 | 2016-10-13 00:23:00 | AUDNZD | Buy | -0.05 | -0.05 | 1.84
 | 2016-10-14 01:00:00 | 2016-10-14 12:00:00 | EURUSD | Sell | -0.07 | 0 | 5.69
 | 2016-10-17 00:30:00 | 2016-10-17 12:10:00 | EURUSD | Buy | -0.07 | 0 | 4.77
 | 2016-10-17 03:00:00 | 2016-10-17 12:12:00 | USDCHF | Sell | -0.06 | 0 | 5.08
 | 2016-10-17 18:50:00 | 2016-10-18 00:10:00 | AUDNZD | Sell | -0.1 | 0.03 | 2.87
 | 2016-10-17 19:03:00 | 2016-10-18 00:44:00 | AUDNZD | Sell | -0.05 | 0.01 | 2.61
 | 2016-10-18 18:41:00 | 2016-10-18 22:46:00 | AUDNZD | Buy | -0.1 | 0 | 6.2
 | 2016-10-19 20:57:00 | 2016-10-19 22:26:00 | AUDCAD | Buy | -0.05 | 0 | 1.08
 | 2016-10-19 19:12:00 | 2016-10-20 03:31:00 | AUDNZD | Sell | -0.1 | -0.07 | 4.89
 | 2016-10-21 22:36:00 | 2016-10-21 23:29:00 | GBPCAD | Buy | -0.16 | 0 | 4.46
 | 2016-10-21 18:00:00 | 2016-10-24 00:02:00 | AUDNZD | Buy | -0.1 | -0.02 | 1.11
 | 2016-10-24 03:00:00 | 2016-10-24 18:48:00 | USDCHF | Sell | -0.06 | 0 | 5
 | 2016-10-24 18:05:00 | 2016-10-24 20:07:00 | AUDNZD | Sell | -0.1 | 0 | 2.24
 | 2016-10-24 19:22:00 | 2016-10-24 23:07:00 | AUDCAD | Sell | -0.05 | 0 | 2.26
 | 2016-10-25 17:01:00 |  |  | Withdrawal | 0 | 0 | -15
 | 2016-10-26 11:00:00 | 2016-10-26 22:00:00 | EURUSD | Sell | -0.07 | 0 | 1.79
 | 2016-10-27 22:15:00 | 2016-10-28 04:26:00 | AUDNZD | Buy | -0.1 | -0.02 | 0.42
 | 2016-10-28 20:19:00 | 2016-10-28 21:29:00 | AUDNZD | Buy | -0.1 | 0 | 2.99
 | 2016-10-28 20:39:00 | 2016-10-31 16:40:00 | AUDCAD | Sell | -0.05 | -0.11 | -3.42
 | 2016-10-28 20:50:00 | 2016-10-31 16:55:00 | AUDCAD | Sell | -0.05 | -0.11 | -1.89
 | 2016-10-31 00:30:00 | 2016-10-31 08:49:00 | EURUSD | Sell | -0.07 | 0 | 4.19
 | 2016-10-31 03:00:00 | 2016-10-31 22:15:00 | USDCHF | Buy | -0.06 | 0 | 1.4
 | 2016-10-31 18:05:00 | 2016-10-31 23:09:00 | AUDNZD | Sell | -0.1 | 0 | 2.24
(beginning of Month) | 2016-11-02 18:51:00 | 2016-11-02 21:45:00 | AUDNZD | Buy | -0.1 | 0 | -0.66
 | 2016-11-02 20:03:00 |  |  | Deposit | 0 | 0 | 10
 | 2016-11-03 02:03:00 |  |  | Deposit | 0 | 0 | 15000
 | 2016-11-03 10:03:00 |  |  | Withdrawal | 0 | 0 | -21
 | 2016-11-03 12:03:00 |  |  | Deposit | 0 | 0 | 10
 | 2016-11-03 13:03:00 |  |  | Withdrawal | 0 | 0 | -14
 | 2016-11-03 19:00:00 | 2016-11-03 20:07:00 | NZDSGD | Sell | -0.63 | 0 | 1.32
 | 2016-11-30 19:00:00 | 2016-11-30 23:06:00 | NZDSGD | Sell | -0.1 | -0.05 | 79.21