Day Trading Journal Spreadsheet | Stock Trade Tracker, Profit, ROI (Digital Download)

Track Every Trade. Master Your Edge.

Stop guessing what's working. This all-in-one Day Trading Journal automatically calculates your profits, win rate, ROI, and account growth so you can spot patterns, plug leaks, and trade smarter. Just plug in your trade data — the spreadsheet does the rest.

What's Included

A Year-to-Date Dashboard showing total pre-tax profit and account growth, plus 12 dedicated monthly tabs (January through December) each with up to 5 weeks of trade logs. As you enter your trades, a Weekly Summary automatically calculates Average Daily Profit, Average ROI, Winning Percentage, Average Winner/Loser, Short Percentage, and Average Trade Duration.
Each trade captures: Ticker, Bias (Long/Short), Strategy, Quantity, Entry, Exit, Fees, Profit in dollars and percent, Entry/Exit Time, Duration, and Closing Method. Bias and Closing Method use drop-down menus so data entry is fast and consistent.
Formulas are locked to prevent accidental edits — the unlock password is included in the Instructions tab.

Why Traders Use It

Everything calculates automatically. There are no formulas to write and no math to do manually. The built-in instructions tab walks you through setup in minutes. It works for stocks, ETFs, futures, forex — anything with a ticker — making it useful whether you're day trading, swing trading, or scalping.

File Details

Instant digital download — one Microsoft Excel file (.xlsx). Compatible with Excel 2016, Microsoft 365, and Excel Online. Also works with Google Sheets by uploading and converting. No physical item will be shipped.

How It Works

Open the Instructions tab and enter your starting account balance. Log your trades as you go and all metrics update automatically. Review your weekly and monthly summaries to see what strategies are working and where you're leaving money on the table.
Questions? Send me a message and I'll help you get set up.
Due to the digital nature of this product, all sales are final.