I would add a sequence number for trades with the same timestamp. With the current SUMIFS, a loss and a gain recorded at the same time are both included in each running total, so the sheet can miss the low point between them. I would test two trades at 13:30, first -500 and then +500, and check that the worst point still shows -500.