Backtesting & Paper Trade Log
A 10-column Excel log for testing a setup before real money: the hypothesis, paper or live, result in R, a running sample count and a go-live decision.
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 | Setup | Symbol | Paper/Live | Result | R-Multiple | Sample # | Go-live? |
|---|---|---|---|---|---|---|---|
| 26/05/2026 | orb | NIFTY | Paper | Loss | −1.0 | 29 | No |
| 27/05/2026 | orb | NIFTY | Paper | Win | +1.5 | 30 | Yes |
What is inside
A new setup needs a written hypothesis and a sample size before it gets real money. This log keeps both, so a hot streak of five wins does not talk you into live size.
Measure results in R, not rupees. Paper trades have no real fills, so R-multiples carry over to live trading better than paper profits do.
Trade Log · 10 columns
One row per backtest or paper trade.
- Date
- Setup
- Symbol
- Paper/Live
- Hypothesis
- Result
- R-Multiple
- Sample #
- Go-live?
- Notes
Worked example
30 paper ORB trades
16 wins averaging +1.5R and 14 losses of −1R each (illustrative).
If your go-live rule is 30 trades and expectancy above 0.2R, this setup qualifies for live trading at minimum size.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Sample # (H2)
- =COUNTIF($B$2:B2,B2)
- Expectancy in R for a setup
- =AVERAGEIF(B:B,"orb",G:G)
How to fill it
- Write the hypothesisOne sentence: what the setup is and why it should work.
- Set go-live criteria firstFor example 30 trades and expectancy above 0.2R.
- Log every test trade in RInclude losers and skipped signals.
- Go live smallStart at minimum size and keep logging with Paper/Live set to Live.
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 many paper trades before going live?
Thirty is a common minimum. Fewer than that and the win rate is mostly noise.
Why do live results differ from paper results?
Live trades pay slippage and charges, and real money changes behaviour. Expect live expectancy to be somewhat lower and start at small size.
Is the Backtesting & Paper Trade 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.