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 all 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 crypto trades, evaluate your strategies, and make more informed decisions, all in one place.
Features:
Main Dashboard: A central dashboard with 8 KPI cards (Net P&L, Win Rate, Profit Factor, Expectancy, Max Drawdown, Total Trades, Avg R-Multiple and Discipline Score), cumulative P&L, profit goal tracking, drawdown curve, R-multiple distribution, Long vs Short performance, expectancy over time, strategy allocation, Top 5 tickers and a capital summary. Filter everything by year, month, account, strategy, ticker and side.
Trade Log: Record every trade in one place, including entry date, ticker, account, strategy, side (long or short), entry price, position size, stop-loss, target, leverage, exit date and price, exit reason, trading fees, profit/loss, R-multiple, duration, emotion, mistake and notes. Max loss, max profit, risk-reward and required margin are calculated automatically.
Strategy Performance Report: Compare every strategy by trades, win rate, Avg R, expectancy, profit factor, max drawdown, net P&L, mistakes and cost of mistakes, with Long and Short results shown separately. Edge Analysis and R-multiple distribution show which strategies to continue, improve or avoid.
Ticker Performance Report: Rank every coin or pair by net P&L and see your top and under-performing tickers, with win rate, profit factor, Avg R, expectancy and Long vs Short results. A color-coded monthly heatmap shows each ticker’s strongest and weakest months, and a strategy profit contribution chart shows where your profit comes from.
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, find your costliest mistakes, and monitor risk with Hit SL and Hit Target rates, winning and losing streaks, largest loss, equity curve, drawdown curve and risk % distribution.
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 trade 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.
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, Long and Short 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 what is 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 several exchanges and brokers together, and compare them side by side.
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 trade spot, futures, or hold longer-term crypto positions, 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 crypto traders alike, 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, and trading involves risk. 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 2019 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.