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 →| Setup Tag | Trades | Wins | Win Rate | Avg Win ₹ | Avg Loss ₹ | Profit Factor | Expectancy ₹ | Action |
|---|---|---|---|---|---|---|---|---|
| orb | 22 | 12 | 55% | 1,800 | 1,400 | 1.54 | 345 | keep |
| expiry-theta | 18 | 7 | 39% | 900 | 1,000 | 0.57 | −261 | retire |
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).
With 18 trades and a negative expectancy, expiry-theta is worth pausing. ORB keeps its size.
The numbers
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
- List your tagsOne row per setup tag used in your journal.
- Fill counts and averagesTake trades, wins, average win and average loss from the journal for the period.
- Check sample sizeDo not act on a tag with fewer than 20 trades.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.