ExcelFree · no sign-upReview and discipline

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 →
Trade Log
DateMistake TypeSymbolEst. ₹ CostTriggerCorrective ActionRepeat Count
04/06/2026revenge+oversizeBANKNIFTY8,400morning lossstop after 2 losses2
09/06/2026fomoNIFTY1,950gap-up openno entry before 9:301
Illustrative mistake rows. Est. ₹ Cost is the loss that following your rules would have avoided.
FormatExcel (.xlsx)
Trade Log sheet8 columns
Best forTraders breaking their own rules
Fill itSame day as the mistake

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

Loss on the trade
−₹8,400
Of which oversize
−₹4,200
Repeat count
2

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

Loss = 140 × 30 × 2₹8,400 (check the current NSE circular, lot sizes are revised periodically)
Oversize share = 140 × 30 × 1₹4,200

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

  1. Fix your mistake typesUse a short list: revenge, oversize, fomo, early-exit, moved-stop.
  2. Log the same dayWrite the trigger while you still remember it.
  3. Estimate the rupee costUse the loss beyond what your rules allowed.
  4. 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.

Try TradeLyser free

Read next

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.