Trading Journal Tracker
๐ FIND YOUR TRADING EDGE, IN THE DATA
Stop wondering if you're actually profitable. This Trading Journal logs every trade and instantly reveals your real performance: win rate, R multiple, profit factor, expectancy, and a live equity curve. Know which setups make you money and which ones quietly drain your account.
Works in BOTH Microsoft Excel and Google Sheets. (Many trading journals are Google Sheets ONLY, this one works in both.) No subscriptions. Buy once, use forever.
WHAT'S INSIDE (6 connected tabs)
- DASHBOARD: Your performance at a glance: Net P/L, Win Rate, Profit Factor, Average R Multiple, and Expectancy, plus charts for your equity curve, monthly P/L, win/loss ratio, and net P/L by strategy.
- TRADE LOG: Log each trade in simple input columns; the journal auto calculates P/L, R multiple, return %, and win/loss for every trade. Handles both long and short positions.
- POSITION CALCULATOR: Size every trade properly. Enter your account balance, risk %, entry, and stop, get your exact position size and dollar risk instantly.
- MONTHLY SUMMARY: Trades, wins, net P/L, and a running equity curve month by month, plus a performance breakdown by strategy.
- SETTINGS: Set your account balance, default risk %, and your own custom strategy names once.
- START HERE: Simple setup steps plus plain English explanations of every metric.
THE METRICS THAT MATTER
- Win Rate, your percentage of profitable trades
- R Multiple, profit/loss measured against your risk
- Profit Factor, gross profit vs. gross loss
- Expectancy, your statistical edge per trade
- Equity Curve, watch your account grow over time
- Strategy Performance, discover your best setups
WHY TRADERS LOVE IT
- Works for stocks, forex, crypto, options & futures
- Auto calculates everything, no manual math
- Built in position size & risk calculator
- See which strategies actually work
- Works in Excel AND Google Sheets
- Comes pre filled with sample trades so it makes sense instantly
- Fully editable, no monthly subscription
PERFECT FOR
- Day traders, swing traders & position traders
- Stock, forex, crypto, options & futures traders
- Anyone serious about improving their results
- Traders who want data instead of guesswork
INSTANT DIGITAL DOWNLOAD
Your files are available immediately after purchase. Nothing is shipped.
You'll receive:
- The spreadsheet file (.xlsx, opens in Excel & uploads to Google Sheets)
- A Start Here guide with setup instructions
HOW TO USE IN GOOGLE SHEETS
- Go to Google Drive, New, File Upload, select the file
- Open it, then choose File, Save as Google Sheets
- Done! All formulas and charts carry over.
(Full instructions are included on the Start Here tab.)
NEED HELP?
Questions or a hiccup? Just message the shop, we respond quickly and we're happy to help you get set up. Your success (and a kind review!) means everything to a small shop like ours. ๐
This tool is for informational and educational purposes only and is not financial or investment advice. Trading involves substantial risk of loss. Always do your own research.
ยฉ McGuigan Software ยท Smart Sheets. Powerful Insights.