Column Name Example Formula (Excel)
Trade Number 1,2,3… (drag down)
Capital Before Trade ($) Err:508
Risk per Trade (1R) ($) Err:509
Win/Loss (1=Win, 0=Loss) Manual input (or =RANDBETWEEN(0,1) for random)
Profit/Loss ($) #NAME?
Cumulative Capital ($) Err:509
Purpose/Instructions
Trade serial number
Capital before entering trade
Calculate risk amount per trade based on capital
Input win (1) or loss (0) for each trade outcome
Calculate profit or loss based on win/loss result
Running total capital after each trade