Stock trading journal: how to track executions, slippage, and sector risk
intent: trade · Published
Stock trading involves execution friction that simple closing prices hide: bid-ask spread variations, exchange routing fees, borrowing costs on short positions, and industry sector concentration. A dedicated stock trading journal helps you track execution slippage against your planned trigger price, account for true regulatory and broker costs, and ensure your portfolio is not overexposed to a single market sector.
Why stock execution tracking requires more than closing prices
Traders who only record entry and exit prices miss the true sources of performance drag in equity markets. A strategy that looks profitable on paper can deteriorate once you account for real-world execution factors: order type choice (market versus limit orders), exchange fees (ECN maker-taker fees), SEC section 31 and FINRA transaction fees, and overnight margin or hard-to-borrow fees on short positions.
Logging your order fills in a structured trading journal reveals whether you are losing edge to poor order timing, illiquid spreads, or undisciplined chasing of fast-moving stocks.
Essential stock trading variables to record for every position
To build an actionable log of your equity trades, record these four key variables alongside basic ticker and quantity data:
- Planned trigger price vs fill price (Slippage): The difference between the price where your setup triggered and the actual average execution price delivered by your broker.
- Order type and routing style: Whether the trade was executed via limit order (capturing liquidity rebates) or market/stop-market order (crossing the spread and incurring taker fees).
- Sector and industry classification: Tagging the ticker by sector (such as technology, healthcare, or energy) to monitor portfolio correlation and avoid taking multiple long positions in the same declining sector.
- Market catalyst and volume profile: The specific catalyst behind the move (earnings announcement, FDA decision, gap-and-go, or macro event) and the relative daily volume at entry.
Hypothetical swing trade execution and cost breakdown
Here is a hypothetical scenario comparing two equity swing trades on a 50,000 USD trading account, each with a planned risk of 300 USD (0.60% of equity). Notice how execution slippage and exchange fees directly affect net realized returns:
| Execution metric | Trade A: NVDA Pullback (Limit order) | Trade B: TSLA Momentum Breakout (Market order) |
|---|---|---|
| Sector / Industry | Information Technology (Semiconductors) | Consumer Discretionary (Automotive) |
| Planned trigger price | 135.00 USD | 242.00 USD |
| Planned stop loss | 132.00 USD (3.00 USD risk/share) | 238.00 USD (4.00 USD risk/share) |
| Planned position size | 100 shares (300 USD planned 1R) | 75 shares (300 USD planned 1R) |
| Actual fill price | 135.00 USD (0.00 USD slippage) | 242.80 USD (+0.80 USD slippage / share) |
| Actual exit price | 142.50 USD (Limit exit) | 248.50 USD (Market exit, -0.30 USD slippage) |
| Gross P&L | +750.00 USD | +405.00 USD |
| Broker commissions & regulatory fees | -4.50 USD | -5.20 USD |
| Net realized P&L | +745.50 USD | +399.80 USD |
| Net realized R-multiple | +2.48R | +1.33R |
Reviewing slippage in your trading journal metrics and comparing executions in weekly trading journal reviews helps you adjust order placement strategies and eliminate costly market-order slippage.
Copyable stock trading execution checklist
Copy this checklist into your trade notes before submitting orders on US or international equities:
Ticker symbol and exchange:
Sector and industry classification:
Average daily volume and float liquidity check:
Planned setup catalyst (Earnings / Breakout / Pullback):
Technical invalidation price (Stop Loss):
Planned risk per share and calculated share count (1R):
Order type used (Limit preferred vs Market):
Execution fill price and slippage in cents:
Total open sector exposure across portfolio (% of equity):
Product boundaries, plans and companion guides
Downloading the free CSV trading journal template requires no account or subscription. You can open it in Excel or Google Sheets and enter trades manually at no cost.
In intent: trade, creating, editing, importing and restoring trades requires an active Standard or Grand subscription. Creating an account does not start a free trial. Signed-in users without an active subscription can still read, export and delete existing trades.
Web plans are Standard at 14.99 USD per month and Grand at 29.99 USD per month, before tax. Annual web subscriptions are Standard at 143.90 USD per year or Grand at 287.90 USD per year, saving 20% compared with 12 months at the regular monthly price, before tax and excluding INTT25. Standard includes screenshot imports and up to 15 AI chart analyses per day. Grand includes up to 50 per day, custom pairs and a weekly AI digest when you log at least three trades in the last seven days.
Compare manual spreadsheets and app workflows in our free versus paid trading journal guide, review currency-specific fields in the forex trading journal guide, see our trading journal import guide, or inspect all trading journal features.
For recordkeeping and review. Not investment advice.