Dashboard Overview
Dashboard Overview
Know exactly where your profit comes from, where your risk is building, and what your habits are costing you, all inside one Excel sheet.
This journal goes much further. Log your trades once, and the Main Dashboard plus seven detailed reports update automatically, covering strategies, tickers, psychology, risk, weekly, monthly and yearly performance, and your full account summary. Filter by account, year, month, week, strategy, ticker or side, and every chart and table responds instantly.
You get a complete trading setup in a single Excel sheet, with lifetime access and no subscription.
Capture and organize your trading activity with our notes management system. Track and review every trade with complete accuracy. Visualize all entries and exits directly on a View chart, enhanced with advanced drawing tools and indicators. Use our trading diary to record your thoughts, observations, and key lessons from every trade.
Top and under-performing tickers, a full ticker table (Win Rate, Profit Factor, Avg R, Expectancy), Long vs Short split, strategy profit contribution, and a color-coded monthly heatmap that shows your strongest and weakest months for every instrument.
Track Emotional Balance, Decision Quality and your Discipline Score. See how each emotion affects Win Rate, Net P&L and Cost of Mistake. Behavioral Mistake Analytics shows which mistakes happen most often and what they cost. Risk tracking includes Hit SL, Hit Target, streaks, largest loss, Equity Curve, Drawdown Curve and Risk % Distribution.
Compare every strategy by Net P&L, Win Rate, Profit Factor, Expectancy, Avg R, Max Drawdown, mistakes and cost of mistakes, with Long and Short results shown separately. Edge Analysis and R-Multiple Distribution help you decide what to continue, improve or avoid.
Net P&L, trades and Win Rate for every day from Monday to Sunday, with Day-of-Week P&L, Daily Growth Rate and Trade Frequency charts, so you know which days to push and which to skip.
A calendar view of daily P&L in green and red with weekly totals, Key Monthly Statistics, Strategy Breakdown, Emotional Impact, Weekly Mistake Trend and Ticker Performance.
A month-by-month table with Trading Days, Total Trades, Win Rate, Gross P&L, Target Goal, Tax Rate, Tax Amount, Trading Fees, Net P&L, Goal %, Profit Factor, Avg R and Profit/Loss Status. Set your monthly day and trade limits, and the sheet highlights the months where you overtraded.
Gross and Net P&L, Win Rate, Profit Factor, Expectancy, Max Drawdown and Mistake Rate for your entire history. Account Health shows trading charges, taxes, deposits, withdrawals, Long and Short P&L and balance. Compare every year and every broker side by side.
Log every deposit and withdrawal with amount, charges, bank, payment mode, UTR and reference number. Net amount is calculated automatically, so you always know your real fund flow.
Setup is where you customize your entire tracker - set monthly and yearly profit targets, add your tickers, strategies, emotions, and broker accounts. It's the control center that keeps every trade, chart, and report in your tracker accurate and consistent.
A straightforward, powerful Excel trading journal designed to help you track your Options trades, evaluate your strategies, and make more informed decisions, all in one place.
Features
Main Dashboard: A central dashboard with KPI cards (Net P&L, Win Rate, Profit Factor, Expectancy, Max Drawdown, Total Trades, Avg R-Multiple and Discipline Score), cumulative P&L, goal tracking, drawdown curve, R-multiple distribution, Call vs Put performance, strategy and ticker insights, and a capital summary. Filter everything by year, month, account, strategy, ticker and side (Call or Put).
Trade Log: Record every Options trade in one place, including date, account, ticker, strategy, side (Call or Put), entry price, quantity (lots), stop-loss, target, exit date and price, exit reason, trading fees, profit/loss, R-multiple, duration, emotion, mistake and notes. Max loss, max profit and risk-reward are calculated automatically.
Strategy Performance Report: Compare every strategy (Breakout, Reversal, Scalping, Momentum, Trend Following, Swing Trade and more) by trades, win rate, Avg R, expectancy, profit factor, max drawdown, net P&L, mistakes and cost of mistakes, with Call and Put results shown separately. Edge Analysis and R-multiple distribution show which strategies to continue, improve or avoid.
Ticker Performance Report: Rank every ticker (Nifty, Banknifty, Sensex, stocks and more) by net P&L and see your top and under-performing tickers, with win rate, profit factor, Avg R, expectancy, mistakes and Call vs Put results. A color-coded monthly heatmap shows each ticker’s strongest and weakest months.
Psychology & Risk Analysis: Track emotional balance, decision quality and your Discipline Score. See how each emotion affects win rate, net P&L, mistake rate and cost of mistakes. Behavioral Mistake Analytics shows which mistakes (FOMO, early entry, moved stop-loss, overleveraged and more) cost you the most, along with monthly mistake frequency. Monitor risk with average risk per trade, max drawdown and Avg R.
Position Calculator: Calculate position size, risk amount, lot size, risk-reward ratio and potential profit or loss before entering a trade.
Weekly Performance Report: See net P&L, trades and win rate for every day from Monday to Sunday, along with your best and worst day, daily growth rate and mistake frequency. Filter by account, year, month and week.
Monthly Performance Report: Review any month with a color-coded daily P&L calendar and weekly totals, key statistics (best and worst day, most traded ticker, best strategy, winning and losing streaks), and charts for strategy breakdown, emotional impact, weekly mistake trend and ticker performance.
Yearly Report: Track your year month by month in one table: trading days, total trades, win rate, gross P&L, target goal, tax, trading fees, net P&L, goal %, profit factor, Avg R and profit/loss status. Set monthly limits for trading days and number of trades, and the sheet highlights the months where you exceed them, helping you avoid overtrading.
Trading Summary: Your complete scorecard, with gross and net P&L, win rate, profit factor, expectancy, max drawdown and mistake rate for your entire history. It also shows account health (trading charges, taxes, deposits, withdrawals, Call and Put P&L and balance), a yearly performance table and a broker/account comparison with allocation overview.
Transaction Details Report: Track and manage all deposits, withdrawals and account transfers separately for accurate capital management and financial record-keeping.
Benefits:
Structured Record-Keeping: Say goodbye to messy handwritten notes and disconnected spreadsheets. Every trade lives in one organized, easy-to-navigate system.
Better Decision-Making: Detailed trade logs let you honestly evaluate past performance, identify which strategies and tickers are working, and refine your approach based on real data.
Smarter Risk Control: Assess potential risk and reward before every trade, so you protect your capital and trade with a clear plan.
Built-In Discipline: Track your emotions, mistakes and Discipline Score, and use monthly limits to spot overtrading early.
Multi-Account Ready: Track trades across multiple broker accounts and compare their performance in one place.
Easy to Use: Simple, intuitive and ready from day one. No complicated setup and no technical knowledge required.
Built for Long-Term Growth: Whether you scalp, trade intraday or swing trade, this journal grows with you, tracking your progress month after month and year after year.
Who Is This For?
This template is ideal for beginner and experienced Options traders alike, including index and stock Options traders, anyone who wants to move away from scattered notes and guesswork and start making decisions based on real data.
What’s Included
Step-by-step setup instructions
Excel workbook with 11 sheets
Sample Excel file with mock data
Blank Excel file, ready for your own trades
Requirements
Microsoft Excel (desktop version recommended)
A desktop or laptop is recommended for the best editing experience
Basic spreadsheet familiarity
Important Notes
This is a digital product. No physical items will be shipped.
All sales are final. Refunds are not available for digital downloads.
Screenshots show sample (mock) data.
This template is for record-keeping and educational purposes only. It is not financial advice. Options trading involves substantial risk, and you can lose your entire investment. No profits or results are guaranteed.
SYSTEM REQUIREMENTS:
To ensure all features and automated functions work correctly, you will need:
HOW IT WORKS & REQUIREMENTS
System Requirements:
To ensure all features and automated functions work correctly, you will need:
Microsoft Excel: An active Microsoft 365 subscription is required. Older versions (Excel 2016 or earlier) may not support all formulas.
Google Sheets: Any free Google Account works for the browser-based version.
Device: A desktop or laptop is recommended for the best experience. Mobile editing is limited.
Compatibility:
Built exclusively for Microsoft 365 and Google Sheets
Usage Rights:
Your purchase includes a single-user license for personal use only. Reselling, sharing, or redistributing this file is not permitted and is protected under copyright.