---
title: "Comment by Arnold Holm on \"Know your room left before every trade: a daily loss limit tracker in a spreadsheet\" | Hashnode"
description: "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"
url: "https://hashnode.com/posts/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet/6aeb7582d633047a97b53e28/comment/6aed94c9da154a02e4b6b9af"
---

[Discussion](https://hashnode.com/posts/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet/6aeb7582d633047a97b53e28)

Comment [Know your room left before every trade: a daily loss limit tracker in a spreadsheet](https://hashnode.com/posts/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet/6aeb7582d633047a97b53e28)

[Arnold Holm](https://hashnode.com/@stratcorealpha)

[Nov 6](https://hashnode.com/posts/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet/6aeb7582d633047a97b53e28/comment/6aed94c9da154a02e4b6b9af)

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.
