Google Sheets and PDF Friday review aligned with TradeLyser methodology — seven steps in fifteen minutes after market close.
Download template
Formatted workbook with sample rows, settings, and instructions. Open in Excel or Google Sheets.
| Metric | Value |
|---|---|
| Trades | 12 |
| Net P&L | −₹4,200 |
| Worst setup | expiry-theta (−₹6,100) |
| Discipline avg | 3.2 / 5 |
| One change | No new positions after 2:30 p.m. on expiry |
F&O, intraday, or swing — same review cadence.
Shared sheet for accountability Friday calls.
Bridge before TradeLyser auto-sync.
12 trades, net −₹4,200, two expiry violations.
| Metric | Value |
|---|---|
| Trades | 12 |
| Net P&L | −₹4,200 |
| Worst setup | expiry-theta (−₹6,100) |
| Discipline avg | 3.2 / 5 |
| One change | No new positions after 2:30 p.m. on expiry |
Net loss driven by expiry-theta tag, not ORB. ORB was +₹1,900 on 4 trades. Action: halve size on expiry Thursday only; keep ORB rules unchanged. Monday plan: ORB + VWAP only, max daily loss ₹5,000, RBI event Wednesday — no new trades 10:00–10:45.
The weekly review is where journals, strategies, rules, and insights meet. Fifteen minutes every Friday is enough if trades are tagged and synced — or logged in this sheet. This template implements the exact checklist from TradeLyser Methodology: confirm tags, read expectancy per setup, open three largest losers, score discipline daily, check drawdown vs monthly rupee limit, pick one change, write Monday plan. Without this ritual, templates become data graves. With it, you build the feedback loop Indian retail traders rarely finish.
=(Exit_Premium - Entry_Premium) * Lot_Size * Lots
Multiply premium change by NSE lot size and number of lots. For Nifty, lot size is updated periodically — keep it in a Settings cell.
Example: Nifty CE: (142 - 118) × 25 × 2 = ₹1,200 gross
=Gross_PnL - STT - Brokerage
STT on options applies on the sell side of premium. Net review must use this, not gross — especially for high-frequency Nifty scalping.
=Net_PnL / Planned_Rupee_Risk
Planned rupee risk = (Entry - Stop) × Lot_Size × Lots for options, or stop distance in points × lot size for futures.
Example: ₹1,680 net / ₹1,150 planned risk = 1.46R
=COUNTIFS(Setup_Tag,"ORB",Net_PnL,">0")/COUNTIF(Setup_Tag,"ORB")
Segment expectancy by setup tag — never blend ORB with expiry theta plays.
Click the free download button for your preferred format (Excel, Google Sheets, or PDF). Save a copy to your Drive or local machine — do not edit the master file directly. Rename it with your name and month, e.g. "Weekly Friday Review Sheet - June 2026". If using Google Sheets, use File → Make a copy so formulas stay intact.
Open the Settings sheet and enter your trading capital, max daily loss in rupees, default lot sizes for Nifty and Bank Nifty, and broker name. These values feed position-sizing and risk columns automatically. Update lot sizes when NSE revises contract specifications.
Add one row per active setup in the Setup Tags sheet — e.g. ORB, VWAP rejection, iron condor, expiry theta. Clear names beat vague labels. Every trade you log must link to exactly one setup so weekly review can show real expectancy per edge.
Within 30 minutes of market close (or immediately after exit for intraday), fill Date, symbol, product type (MIS/NRML/CNC), entry, exit, lots, setup tag, and session tag. Add violation flags if you broke a rule — oversize, revenge, late expiry entry. Honest logging beats perfect logging.
Once per week, compare your Net P&L column against Zerodha Console or your broker tax P&L export. Fix charge mismatches before running analytics — a 2% error on STT compounds into wrong expectancy on small premium trades.
Open Weekly Review tab. Link or count this week trades. Fill expectancy from Trade Log pivot. Open three largest losers — mark rule break vs bad luck. Score discipline 1–5 per day. Check drawdown vs Settings monthly limit. Write exactly one change. Draft Monday plan: allowed setups, max ₹ loss, macro events.
If your broker exports trade history, paste into the Import sheet and map columns to the Trade Log. Verify the first import row-by-row. When manual entry becomes the bottleneck on expiry Thursdays, consider TradeLyser auto-sync from supported Indian brokers.
Weekly Friday Review Sheet uses lot size, STT, and brokerage columns designed for NSE and BSE — not dollar tick values from US-centric templates.
Strategy tags force you to measure each edge separately. Blended account P&L hides which setups pay for tuition and which ones should be retired.
Retail F&O participation on NSE continues to grow — process tracking matters more than indicator count.
Dedicated tags and views for expiry sessions prevent quiet weeks from masking Thursday gamma losses — a common blind spot for Indian options traders.
Pre-built summary views align with the TradeLyser weekly review ritual: tagged trades, net figures, and one planned change for Monday.
| Feature | This template | TradeLyser |
|---|---|---|
| Trade entry | Manual logging or CSV import into spreadsheet | Auto-sync from Zerodha, Dhan, Fyers, Angel One, and more |
| Net P&L | Manual STT and brokerage columns — easy to skip on busy days | Synced charges from broker contract notes |
| Setup analytics | Pivot tables or COUNTIF by strategy tag | Strategy board expectancy, profit factor, and win rate per tag |
| Expiry-week filter | Manual expiry tag column and filtered views | Calendar filters and expiry-week reports in one click |
| Discipline tracking | Checkbox or score column you maintain yourself | Discipline diary, rule scores, and violation flags |
| Scalability | Formulas slow or break past ~500 rows | Years of trade history without spreadsheet maintenance |
| Price | ~~₹250~~ Free during promo | TradeLyser trial — automation when the sheet becomes the bottleneck |
Yes. During our launch promo every template shows ~~₹250~~ Free — no signup required. Click download on the detail page and save Excel or PDF to your device. Google Sheets copy links are rolling out per template.
Always net P&L after STT and brokerage for Indian F&O. Gross P&L flatters high-churn strategies — a scalper with ₹200 gross winners and ₹180 costs has no edge. This template includes charge columns for that reason.
You can, but filter by Product Type column in review. Mixing intraday MIS scalps with NRML swing holds blends expectancy beyond recognition. Many traders duplicate the file into two books after month one.
Use session tag expiry-day or a dedicated expiry-week-nifty tag. Never compare quiet Tuesday theta with Thursday gamma in the same bucket — NSE weekly expiry behaviour is structurally different.
Excel works offline and handles heavy formulas — good for privacy. Google Sheets syncs across phone and laptop for traders who journal on the commute. Both formats share the same column structure in this template pack.
When manual entry fails on busy expiry weeks, when you have more than 10% untagged trades, or when you want broker auto-sync and discipline scores without maintaining formulas. The spreadsheet remains a valid starting point.
Download template
Formatted workbook with sample rows, settings, and instructions. Open in Excel or Google Sheets.
Outgrew the spreadsheet?
Sync your broker in TradeLyser.
Auto-import from Zerodha, Dhan, and more. Strategy tags, discipline scores, and Friday review — without maintaining formulas.