Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceInvestment TrackingStock Trading Journal

SpreadsheetInvestment TrackingFree

Stock Trading Journal

Log every trade with entry, stop and exit, and see P&L, R-multiples, win rate, profit factor and which setups actually make money.

Shown with sample data

Colour

Stock Trading Journal

Log every trade with entry, stop and exit, and see P&L, R-multiples, win rate, profit factor and which setups actually make money.

Net P&L
$2,364
Win rate
55%
Average R
0.6
Profit factor
2.3
Gross wins ÷ gross losses
Expectancy per trade
$214.91
Win rate when plan followed
75%
Net P&L by setup
  • Trend continuation$1,381
  • Breakout$1,147
  • Earnings gap$612.50
  • Mean reversion-$226.50
  • Pullback-$550
R multiple by trade
  • NVDA2.5
  • AAPL-1
  • TSLA1.1
  • AMD-1
  • MSFT2.1
  • NFLX1.8
  • META-0.5
  • JPM1.4
  • SHOP-1.1
  • AMZN2.2
  • CRM-0.5

How to use it

  1. 1On Settings, type your account size and the share of it you are willing to risk per trade (1% is common).
  2. 2Before entering a trade, use the Position size sheet to work out how many shares your stop allows.
  3. 3Log the trade with date, ticker, long or short, setup, shares, entry and stop. Leave Exit blank while it is open.
  4. 4When you close it, enter the exit price, whether you followed your plan and one lesson.
  5. 5Review By setup each week: stop trading setups with negative expectancy and size up the ones that work.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Most traders remember their winners and forget why they lost. Record each trade with direction, setup, size, entry, stop and exit; the journal calculates P&L, the risk you took and the R-multiple, then summarises win rate, average R, profit factor and expectancy overall, by setup and when you followed your plan, with a position-size calculator that keeps every trade within your risk rule.

Who it’s for

  • Swing and day traders reviewing performance weekly
  • Finding which setups have a real edge
  • Building discipline around stops and position sizing

What’s included

  • Trades sheet: One row per trade. Leave Exit blank while a trade is open.
  • By setup sheet: Which setups make money.
  • Position size sheet: How many shares each planned trade allows under your risk rule.
  • Settings sheet: Your account and risk rule.

How to use it

  1. 1On Settings, type your account size and the share of it you are willing to risk per trade (1% is common).
  2. 2Before entering a trade, use the Position size sheet to work out how many shares your stop allows.
  3. 3Log the trade with date, ticker, long or short, setup, shares, entry and stop. Leave Exit blank while it is open.
  4. 4When you close it, enter the exit price, whether you followed your plan and one lesson.
  5. 5Review By setup each week: stop trading setups with negative expectancy and size up the ones that work.

Tips

  • R-multiple (P&L ÷ initial risk) lets you compare trades of different sizes. A strategy with a 40% win rate can be very profitable if winners average 2.5R.
  • Compare results when you followed your plan with when you did not. The gap is usually the cheapest improvement available.
  • Include commissions and fees in your exit price if your broker charges them.

Questions

What is an R-multiple?

The profit or loss on a trade divided by the amount you risked (entry to stop × shares). A trade that makes twice what you risked is +2R; hitting your stop is −1R.

What is a good win rate for trading?

It depends on the size of wins versus losses. Expectancy = (win rate × average win) − (loss rate × average loss). Positive expectancy is what matters, not a high win rate.

What is profit factor?

Gross profits ÷ gross losses. Above 1.0 is profitable; above 1.5 is generally considered solid over a large sample of trades.

How do I size a position?

Shares = (account size × risk %) ÷ (entry − stop). The Position size sheet does this for each planned trade.

Related searchestrading journalstock trading journal templatetrade log spreadsheetr multiple calculatorwin rate calculatorposition size calculatorday trading journal

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInvestment TrackingFree

Stock Trading Journal

Log every trade with entry, stop and exit, and see P&L, R-multiples, win rate, profit factor and which setups actually make money.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More investment tracking templates

View all
Investment Portfolio Tracker2 sheets

Portfolio value

$74,144

Unrealised gain

$13,013

Total return

21%

Allocation by asset class
51%
  • US stocks
  • International stocks
  • Bonds
  • Real estate
SpreadsheetInvestment Tracking

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

10 min setupPreview
Dividend Income Tracker3 sheets

Forward annual income

$1,439

Per month

$120

Portfolio yield

2%

Dividends by month
$183.04
$178.14
$172.74
$110.28
$106.08
SepJunMarOctJan
SpreadsheetInvestment Tracking

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

10 min setupPreview
Asset Allocation & Rebalancing Planner3 sheets

Portfolio value

$117,300

Classes out of range

2

Largest drift

10%

ABCD
1Asset classTargetCurrent valueCurrent share
2Global equities55%$75,70065%
3Home equities10%$9,8008%
4Bonds20%$17,40015%
5Property5%$6,1005%
Allocation
SpreadsheetInvestment Tracking

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ