Trading Mistake & Discipline Log
An 8-column Excel log of mistakes, not trades: what kind of mistake it was, what triggered it, what it cost in rupees, the fix, and how many times it has happened.
The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.
See a worked example →| Date | Mistake Type | Symbol | Est. ₹ Cost | Trigger | Corrective Action | Repeat Count |
|---|---|---|---|---|---|---|
| 04/06/2026 | revenge+oversize | BANKNIFTY | 8,400 | morning loss | stop after 2 losses | 2 |
| 09/06/2026 | fomo | NIFTY | 1,950 | gap-up open | no entry before 9:30 | 1 |
What is inside
A trade log shows what happened. A mistake log shows what keeps happening. Repeat Count is the column to watch: the same mistake three times in a month needs a hard rule, not another note.
Est. ₹ Cost turns a vague feeling into a number. Most traders find two or three mistake types account for most of the cost.
Trade Log · 8 columns
One row per mistake.
- Date
- Mistake Type
- Symbol
- Est. ₹ Cost
- Trigger
- Corrective Action
- Repeat Count
- Notes
Worked example
Revenge after a morning loss
After a ₹3,000 loss at 10 a.m., an untagged Bank Nifty futures trade was taken at 2 lots instead of 1 and lost 140 points (illustrative).
The whole ₹8,400 goes in Est. ₹ Cost because the trade was outside the plan. The fix is a daily stop after two losses.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Repeat Count (G2)
- =COUNTIF($B$2:B2,B2)
- Cost by mistake type
- =SUMIF(B:B,"fomo",D:D)
How to fill it
- Fix your mistake typesUse a short list: revenge, oversize, fomo, early-exit, moved-stop.
- Log the same dayWrite the trigger while you still remember it.
- Estimate the rupee costUse the loss beyond what your rules allowed.
- Act on repeatsWhen Repeat Count reaches 3, add a hard rule to your checklist.
Same review, without the typing
TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.
Related templates
Read next
Free calculators
Terms on this sheet
Questions traders ask
How do I estimate the cost of a revenge trade?
If the trade should not have been taken at all, its whole loss is the cost. If it was a valid trade at the wrong size, only the extra loss from the extra size counts.
Should I log mistakes on winning trades?
Yes. Record them with a cost of zero or the profit you gave up. A rule broken on a winner is still a rule broken.
Is the Trading Mistake & Discipline Log free?
Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.