ExcelFree · no sign-upRisk and strategy edge

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 →
Trade Log
DateSetupSymbolPaper/LiveResultR-MultipleSample #Go-live?
26/05/2026orbNIFTYPaperLoss−1.029No
27/05/2026orbNIFTYPaperWin+1.530Yes
Illustrative paper trades. Go-live? turns Yes once your criteria are met.
FormatExcel (.xlsx)
Trade Log sheet10 columns
Best forTesting new setups
Fill itEvery test trade

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

Win rate
53%
Total
+10R
Expectancy
+0.33R

If your go-live rule is 30 trades and expectancy above 0.2R, this setup qualifies for live trading at minimum size.

The numbers

Total R = wins × avg win − losses × avg loss16 × 1.5 − 14 × 1 = 10R
Expectancy = total R ÷ trades10 ÷ 30 = 0.33R

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

  1. Write the hypothesisOne sentence: what the setup is and why it should work.
  2. Set go-live criteria firstFor example 30 trades and expectancy above 0.2R.
  3. Log every test trade in RInclude losers and skipped signals.
  4. 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.

Try TradeLyser free

Read next

Free calculators

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.