This free Excel day trading journal template is purpose-built for active retail traders who need more than a basic trade log. Where generic spreadsheets treat all trades equally, this template is structured around time-of-day performance — breaking your trading day into session buckets, tracking commission drag per trade, and auto-flagging the hidden losers that look profitable before costs. Download it free, open it in Excel 2016 or later, and start finding your actual edge.
What’s Included
- Trade Log worksheet — Captures ticker, direction, entry time, exit time, shares or contracts, gross P&L, and commissions. Hold duration in column E auto-calculates using
=TEXT(D2-C2,"h:mm")so overholding patterns surface without manual time math. - Session Summary sheet — Splits every trading day into pre-market, 9:30–11:00 AM, 11:00 AM–2:00 PM, and 2:00–4:00 PM buckets using SUMPRODUCT formulas on the HOUR() of each timestamp. No pivot tables or VBA required.
- Commission Tracker — Computes per-trade net P&L after broker fees. Supports per-share pricing (IBKR: $0.005/share) and per-contract pricing ($0.65/contract for options). Switch modes via a dropdown — no formula editing needed.
- Daily Dashboard — A single tab driven by SUMIF on the date column. Change the date in cell B1 to see any trading day: total trades, gross P&L, net P&L, win rate, and a session-level callout.
- 30-day equity curve — Auto-populates from the Trade Log as you add rows. Plots cumulative net P&L so drawdown periods are immediately visible without building charts manually.
- Conditional formatting rules — Rows turn green (net positive), red (net negative), or yellow (gross positive, net negative after commissions). Yellow rows are the most actionable signal in the sheet.
How to Use
Step 1: Import or Enter Your Trades
Paste broker CSV exports into the Trade Log starting at row 2. Most brokers (IBKR, TD Ameritrade, E*TRADE, Schwab) export trade history including timestamps — match their columns to the Trade Log headers. At minimum, fill columns A (ticker), B (date), C (entry time), D (exit time), E (direction), F (shares or contracts), and I (gross P&L). Hold duration in column G and session labels in column H populate automatically.
Step 2: Configure Your Commission Rate
Open the Commission Tracker tab and enter your broker’s rate in cell C2. For IBKR stock traders, use $0.005 per share (minimum $1 per order). For options traders at E*TRADE, Schwab, or Fidelity, switch the mode dropdown to “Options” and leave the rate at $0.65 per contract. The tracker references these settings to calculate net P&L for every row in the Trade Log.
Step 3: Review Session Performance
The Session Summary sheet recalculates automatically as you add trades. The core formula — =SUMPRODUCT((HOUR(B2:B200)>=9)*(HOUR(B2:B200)under 11)*G2:G200) — sums net P&L for the 9:30–11:00 AM window. Run two to three weeks of data before drawing conclusions; session patterns stabilize around 30–40 trading days of data.
Step 4: Use the Daily Dashboard for Same-Day Review
At the end of each trading session, open the Daily Dashboard and confirm the date in cell B1 matches today. The dashboard shows gross P&L, total commissions, net P&L, trade count, and win rate — plus a flag cell that turns red if afternoon session P&L is negative while the morning was positive. This is the primary signal to consider an earlier cutoff.
Step 5: Act on the Yellow Rows
Sort the Trade Log by the color-code column (column J) or filter for yellow rows monthly. These are trades where execution was profitable but commissions erased the gain — the clearest signal that a trade idea needs a higher gross target or higher win rate to justify its cost.
Key Benefits
- Session-level edge identification — Most day traders find 60% or more of net profits concentrate in the first 90 minutes. The session buckets make this visible in weeks, not months of manual analysis.
- Commission drag quantified per trade — IBKR traders doing 10 round-trip stock trades on 200 shares per day pay $20/day in commissions — over $5,000 annually. The tracker makes this visible at the trade level, not just the monthly statement.
- Overholding detection without manual review — The hold-duration column flags trades held 3–5 times longer than your average. Traders averaging 8-minute holds who occasionally hold 45 minutes often find those outlier holds are net losers.
- Single-sheet design — SUMIF on the date column means one Trade Log sheet covers the entire year. No new tab per day, no copy-pasting formulas, no version drift between daily files.
- Works in Excel 2016+ — All formulas use standard functions (SUMPRODUCT, HOUR, SUMIF, TEXT). No Power Query, no VBA macros, no add-ins required.
Template vs JournalPlus App
| Feature | This Template | JournalPlus App |
|---|---|---|
| Auto-Import Trades | Manual entry or CSV paste | Automatic from 50+ brokers |
| Session Time Analysis | SUMPRODUCT formulas (manual setup) | Built-in time-of-day heatmap |
| Commission Tracking | Formula-based, requires broker rate input | Automatic with broker data |
| Hold Duration | =TEXT(C2-B2,"h:mm") formula | Calculated automatically on import |
| Equity Curve | 30-day chart, manual data | Real-time, unlimited history |
| Win Rate by Session | Manual COUNTIF setup | 30+ performance metrics built-in |
| Price | Free | $159 one-time |
This template is a genuine tool for building the habit of structured review — session bucketing, commission awareness, and hold-duration tracking are all things most retail traders never measure. When you’re ready to skip the CSV imports and get automatic broker sync with advanced analytics, JournalPlus picks up where the spreadsheet leaves off.
Example: What the Session Breakdown Actually Shows
A trader takes 6 trades on SPY on a Tuesday. Morning: buys 200 shares at $521.00 at 9:42 AM, sells at $522.30 at 10:05 AM (+$260 gross); buys 200 at $521.80 at 10:22 AM, sells at $521.10 at 10:35 AM (-$140 gross). Four afternoon trades net -$80 gross. Without session analysis, the day looks like a $40 gross profit — barely worth noting.
The Excel template tells a different story. Morning session (9:30–11:00 AM): +$120 net after $12 in IBKR commissions. Afternoon session: -$92 net including $12 in commissions. The Daily Dashboard flags: morning edge positive, afternoon negative. The Commission Tracker shows $24 total commissions eroded 38% of gross P&L for the day. The trader’s actual takeaway isn’t “I made $40” — it’s “I have a morning edge I’m currently giving back every afternoon.”
This kind of session-level clarity is exactly what the scalping journal and swing trading journal templates can’t provide — they’re not structured around intraday time windows.
Download
Download the free Day Trading Excel Journal and start tracking your trades by session today. No account required, no email needed — open in Excel 2016 or later and add your first trade in under five minutes.
For traders comparing spreadsheet-based tracking to dedicated software, the JournalPlus vs Excel comparison covers the practical differences at different trade volumes.
Frequently Asked Questions
Is this Excel day trading journal template free to download?
Yes, the template is completely free with no account or email required. Download, open in Excel 2016 or later (or Google Sheets with minor formula adjustments), and start logging trades immediately.
What broker CSV formats work with this day trading Excel template?
The Trade Log sheet accepts manual entry or pasted CSV data from any broker. TD Ameritrade, IBKR, E*TRADE, and Schwab all export trade history as CSV — paste the relevant columns (ticker, date, time, price, shares or contracts, P&L) into the matching columns in the Trade Log.
How does the session time bucketing formula work in Excel?
The Session Summary sheet uses SUMPRODUCT with HOUR() to group trades without pivot tables: =SUMPRODUCT((HOUR(B2:B200)>=9)*(HOUR(B2:B200)under 11)*G2:G200) sums net P&L for the 9–11 AM window. This works in Excel 2016 and later and requires no VBA or Power Query.
Can I track options commissions in this day trading journal template?
Yes. The Commission Tracker includes a dropdown to switch between per-share mode (IBKR at $0.005/share) and per-contract mode (standard $0.65/contract). Enter your contract count in the shares column and select “Options” to get accurate net P&L after fees. An options trader doing 5 round-trip spreads — 20 contracts — pays $13/day at that rate, or roughly $3,000 per year.
What is the difference between this template and the scalping journal template?
The day trading Excel template focuses on session-level analysis across the full trading day, with four time buckets and a 30-day dashboard. The scalping journal is optimized for very short hold times (under 5 minutes), with tighter focus on spread cost and tick-level entry fields rather than session patterns.
