ExcelFree · no sign-upRisk and strategy edge

Setup Edge Tracker by Strategy Tag

A 9-column Excel table with one row per setup tag: trades, wins, win rate, average win and loss, profit factor, expectancy and an action to keep, resize or retire it.

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
Setup TagTradesWinsWin RateAvg Win ₹Avg Loss ₹Profit FactorExpectancy ₹Action
orb221255%1,8001,4001.54345keep
expiry-theta18739%9001,0000.57−261retire
Illustrative tags after a quarter of trading.
FormatExcel (.xlsx)
Trade Log sheet9 columns
Best forDeciding which setups to keep
Fill itMonthly

What is inside

Total P&L hides which setups pay for the others. One row per tag shows it directly, and expectancy in rupees per trade is the column that decides.

Sample size matters as much as the result. Under 20 trades, treat any number as a hint. The Trades column is there so you never retire or scale a setup on five trades.

Trade Log · 9 columns

One row per setup tag.

  • Setup Tag
  • Trades
  • Wins
  • Win Rate
  • Avg Win ₹
  • Avg Loss ₹
  • Profit Factor
  • Expectancy ₹
  • Action

Worked example

ORB against expiry-theta

Three months of tagged trades (illustrative).

orb expectancy
+₹345
expiry-theta
−₹261
orb profit factor
1.54

With 18 trades and a negative expectancy, expiry-theta is worth pausing. ORB keeps its size.

The numbers

Expectancy = Win rate × Avg win − Loss rate × Avg loss(12/22 × 1,800) − (10/22 × 1,400) = ₹345
Profit factor = Wins × Avg win ÷ (Losses × Avg loss)21,600 ÷ 14,000 = 1.54
expiry-theta expectancy(6,300 − 11,000) ÷ 18 = −₹261

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Win Rate (D2)
=C2/B2
Profit Factor (G2)
=(C2*E2)/((B2-C2)*F2)
Expectancy ₹ (H2)
=(C2*E2-(B2-C2)*F2)/B2

How to fill it

  1. List your tagsOne row per setup tag used in your journal.
  2. Fill counts and averagesTake trades, wins, average win and average loss from the journal for the period.
  3. Check sample sizeDo not act on a tag with fewer than 20 trades.
  4. Write an actionkeep, resize or retire, and apply it next month.

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

What is a good expectancy per trade?

Any positive expectancy after charges over a fair sample is an edge. Compare it with your average risk per trade: ₹345 on ₹1,400 of risk is about 0.25R.

How many trades before I judge a setup?

At least 20, and more is better. Win rate on 10 trades can swing by 30 percentage points from luck alone.

Is the Setup Edge Tracker by Strategy Tag 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.