Trading Journal Spreadsheet

About this download

A trading journal that handles real trades: scale in, partial exits, stocks, forex, futures and options. It shows your win rate, expectancy and which setups pay. Not financial advice. No live prices.

This is a journal for the trades you type in, not a live portfolio or a broker connection.

WHAT IT DOES

• Log each trade on one row: up to 3 entry fills and up to 3 exit fills, so scaling in and partial exits are easy to record
• Long and short trades
• Average entry, average exit, open quantity, status (Open, Partial, Closed, Check), net P&L after fees, initial risk and R multiple are calculated automatically
• Instruments with multipliers on Settings: stocks, ETFs and crypto 1, options 100 per contract, futures point value, forex pip value per lot and pip size
• Tags for account, strategy, setup and mistake, plus notes and a chart link column
• A Check column tells you when a trade is missing something (exit date, price, instrument)

TABS

• Start Here: quick start, color key and notes
• Dashboard: net P&L, win rate, expectancy, profit factor, average win and loss, max drawdown, closed and open counts, equity curve, recent closed trades, setups ranked by net P&L, net P&L by strategy, weekday and mistake, and an account filter
• Trade Log: room for 600 trades
• Calendar P&L: pick a month and see daily closed P&L in a month grid with week totals and a month summary
• Breakdown: results by strategy, setup, instrument, account, exit weekday, mistake and month
• Review: monthly review notes (what worked, what to fix, a rule for next month) next to that month's numbers
• Settings: theme, sample data switch, currency symbol and your lists

LIGHT AND DARK, SAMPLE DATA

• Choose Light or Dark on Settings and every tab switches
• Show sample data On or Off: 72 fictional example trades show when On, and the switch never changes the cells you type in
• Currency symbol setting for the labels (no currency conversion)

⭐ 𝗗𝗘𝗠𝗢

On the fence? Watch our sample here:

https://youtu.be/_w5D04hIahA

𝗪𝗛𝗔𝗧'𝗦 𝗜𝗡𝗖𝗟𝗨𝗗𝗘𝗗

• START-HERE-Trading-Journal.pdf: your Google Sheets copy link and a step by step guide

𝗜𝗠𝗣𝗢𝗥𝗧𝗔𝗡𝗧

Developed for Google Sheets. An Excel file is included for the latest Microsoft 365 (Office 365 Desktop App). Older Excel versions may not support all features.

ℹ 𝗚𝗢𝗢𝗗 𝗧𝗢 𝗞𝗡𝗢𝗪

• Formula cells are protected without a password. To sort, unprotect the sheet (no password), sort the whole table, then protect it again. Filters work while protected.
• Not financial advice. No live prices. No broker import and no price feeds; you type your own fills.
• Digital download only. No physical item will be shipped.
• Utility Forge Studio is not affiliated with, sponsored by, or endorsed by Google or Microsoft.

Personal use only. Please do not resell, share or redistribute the files.

Designed by me, created using AI tools.

The Etsy listing is the final source for what is included. See it on Etsy.