---
title: "Discussion on \"Know your room left before every trade: a daily loss limit tracker in a spreadsheet\" | Hashnode"
description: "Discussion on \"Know your room left before every trade: a daily loss limit tracker in a spreadsheet\". By Richard C, AIL Studio\nMost prop traders know their daily loss limit. Fewer know, at 1:30 PM after three trades, exactly how much of it is left, and whether the stop on the next trade still fits ins"
url: "https://hashnode.com/posts/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet/6aeb7582d633047a97b53e28"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Know your room left before every trade: a daily loss limit tracker in a spreadsheet](https://ailstudio.hashnode.dev/know-your-room-left-before-every-trade-a-daily-loss-limit-tracker-in-a-spreadsheet?utm_source=hashnode&utm_medium=feed)

By Richard C, AIL Studio Most prop traders know their daily loss limit. Fewer know, at 1:30 PM after three trades, exactly how much of it is left, and whether the stop on the next trade still fits ins

Nov 4 · 5 min read · ailstudio.hashnode.dev  
Updated Nov 7  
Read the article

-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)
-   [#googlesheets](https://hashnode.com/tag/googlesheets)
-   [#productivity](https://hashnode.com/tag/productivity)
-   [#trading](https://hashnode.com/tag/trading)

## Written by

[Richard C](https://hashnode.com/@ailstudio)

@ailstudio

  
[View profile](https://hashnode.com/@ailstudio)

Richard C · AIL Studio

## Responses 1

Markdown supported · ⌘↵ to post

[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.
