Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Stock Trading Journal Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Stock Trading Journal Spreadsheet Template for Google Sheets & Excel

Each of the thirty rows is one side of a trade, so buys and sells are logged apart and the cash flow takes its direction from the side, its size from the quantity and price, and its fees netted in. The Essentials Stock Trading Journal spreadsheet template settles a realised figure on closing rows against what you paid for that ticker, and an open position stays visible as a buy with no sell against it. Two working sheets and a chart, Google Sheets or Excel. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Stock Trading Journal Spreadsheet Template
$29
Essentials Stock Trading Journal spreadsheet template - Google Sheets and Excel preview

What's Included

  • One row per side of a trade, so buys and sells are logged separately
  • Cash flow derived with its direction set by the side
  • Fees netted into every row
  • A realised figure on closing rows, matched against what you paid for that ticker
  • Open positions visible as a buy with no sell against it yet
  • Dashboard with the net total, the win rate and the trade count
  • Winners and losers counted among closed positions
  • A chart carrying the same picture
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • One row per side of a trade, so buys and sells are logged separately
  • Cash flow derived with its direction set by the side
  • Fees netted into every row
  • A realised figure on closing rows, matched against what you paid for that ticker
Ultimate - $29
  • A Trade Log carrying both prices on the same row
  • Result and percentage return derived, so different position sizes compare
  • A strategy label and a notes column on every trade
  • Performance Summary by ticker with wins and win rate
  • Strategy Analysis with result, count, win rate and average return per approach
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Stock Trading Journal Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that works the money out of each side of a trade, with a How to Use guide on a third tab. It works as an Essentials Stock Trading Journal Excel template and an Essentials Stock Trading Journal Google Sheets template from the same download. Where the Free build takes a result you have already worked out, this Essentials Stock Trading Journal spreadsheet template derives the cash flow from the side, the size, the price and the fees, and settles a realised figure when a position closes. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Stock Trading Journal spreadsheet template

The FinancialAha Essentials Stock Trading Journal Spreadsheet Template runs on two working sheets - one you type into, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Stock Trading Journal spreadsheet holds.

  1. 01 of 02

    Trade Log

    The sheet you type into - each row is one side of a trade rather than a whole one. That is the shape worth understanding: a buy and its eventual sell occupy separate lines, and the side you pick decides whether the money leaves or arrives. The cash flow follows from the size, the price and the fees, and on a closing row a realised figure appears, matched against what you paid for that ticker. It means a position in progress is visible as a buy with no sell against it yet. A Trade ID sits beside the ticker for exactly this reason: trading the same stock twice in a row would otherwise leave two round trips with nothing to tell them apart, so the sell side matches only the buy sharing its own ID.

    FinancialAha Stock Trading Journal spreadsheet template - Trade Log sheet

  2. 02 of 02

    Dashboard

    The journal summarised: the net across every row, the share of closed trades that finished ahead, how many rows are logged, and how the closed ones split between winners and losers. A chart carries the same picture. The win rate here counts closed positions rather than rows, which is the more meaningful reading of the two.

    FinancialAha Stock Trading Journal Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column expects, how the cash flow and the realised figure are arrived at, and what the colour coding means. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Stock Trading Journal Spreadsheet template for Google Sheets

Upload the Essentials Stock Trading Journal Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Stock Trading Journal Google Sheets template needs no conversion step and the chart survives the trip intact - the totals keep working exactly as they do in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials Stock Trading Journal Google Sheets template setup

A shared copy of the Essentials Stock Trading Journal Google Sheets template works where a journal is reviewed by someone other than the person trading, and Sheets version history covers a row edited after the fact. Because the reporting sits on its own tab, the log stays a log.

Sharing the Essentials Stock Trading Journal Google Sheet

Day to day the Essentials Stock Trading Journal Google Sheet is a single line: date, ticker, side, size, price and fees. The dashboard follows from that, so logging never involves a calculation.

Also available as:

Essentials Stock Trading Journal Spreadsheet template for Excel

The Essentials Stock Trading Journal spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Stock Trading Journal Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as rows go in. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Stock Trading Journal Excel template setup

The same Essentials Stock Trading Journal Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Stock Trading Journal spreadsheet download to choose between.

Essentials Stock Trading Journal spreadsheet Excel notes

The Essentials Stock Trading Journal spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Stock Trading Journal spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Stock Trading Journal spreadsheet Excel file

Nothing in the Essentials Stock Trading Journal Excel template is version-specific, so this Essentials Stock Trading Journal spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Stock Trading Journal spreadsheet template tracks

You log each side as it happens and the Essentials Stock Trading Journal Spreadsheet Template works out the money:

Date
the day the trade was placed
Ticker
the stock or fund traded
Trade ID
your own label, so a second round trip on the same ticker is not matched against the first
Buy/Sell
the side, which sets the direction of the cash
Shares
how many the row covers
Price
the per-share price for that side
Fees
what the trade cost to place
Total auto
derived, the cash flow with its sign from the side and fees netted in
Realized P&L auto
derived on a closing row, matched against what you paid for that ticker

Compare builds

FinancialAha Stock Trading Journal spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Trade capacity 16 trades 30 rows - 15 round trips 200 trades
Row records A complete trade One side of a trade A complete trade
Result per row Entered by you Derived on the sell side Derived, with % return
Fees counted – Yes Within the prices
Win rate – Yes Yes, and per strategy
Charts – 1 1
Performance by ticker – – Dedicated sheet
Strategy breakdown – – Dedicated sheet
Month-by-month – – By strategy
Risk analysis – – Dedicated sheet

The FinancialAha Essentials Stock Trading Journal Spreadsheet Template covers two working sheets, and it changes the shape of the record. The Free Stock Trading Journal Spreadsheet Template puts a whole trade on one line with a result you supply. This build logs each side separately - a buy and its later sell on different rows - so the cash flow is derived from the price, the size and the fees, and a realised figure settles when the position closes. It also means an open position is visible as a buy without a matching sell. The Ultimate Stock Trading Journal Spreadsheet Template goes back to one row per complete trade, across 200, and adds a percentage return, performance by ticker and by strategy, a month-by-month view and a risk sheet.

Compare the other builds: Free Stock Trading Journal spreadsheet template or the Ultimate Stock Trading Journal spreadsheet template .

Good to know

Notes on working in the Essentials Stock Trading Journal spreadsheet template

  • Each row is one side of a trade, so a round trip takes two lines and a position still open shows as a buy with nothing against it.
  • The side sets the direction of the money, which makes it the field most worth getting right.
  • The Trade ID keeps repeat round trips on the same ticker separate, so a sell only matches the buy that shares its ID.
  • Fees are netted into the cash flow, so the totals describe what actually reached the account.
  • The win rate counts closed positions rather than logged rows, which is the more useful of the two readings.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Stock Trading Journal spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Stock Trading Journal Spreadsheet Template

1

Log the side

Enter the date, the ticker, and whether the row is a buy or a sell.

2

Add size and price

Enter how many shares the row covers and the per-share price.

3

Include the fees

Add what the trade cost to place. It is netted into the cash flow.

4

Read the dashboard

Net total, win rate across closed positions, the count, and how the closed ones split.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Stock Trading Journal Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Stock Trading Journal Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials Stock Trading Journal Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Stock Trading Journal Excel template opens directly in Excel with no import step. The chart is a native Excel chart, and there are no macros or VBA.

Will the FinancialAha Essentials Stock Trading Journal spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Stock Trading Journal spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

How does the Essentials Stock Trading Journal spreadsheet record a trade?

One side at a time. A buy and its eventual sell sit on separate rows, and the side you pick decides whether the cash leaves or arrives. It means a position still open is visible as a buy with nothing against it, which a one-row-per-trade log cannot show.

How does the Essentials Stock Trading Journal work out the realised figure?

On a closing row, matched against what you paid for that ticker. Until a position is closed there is no realised figure for it.

Are fees included in the Essentials Stock Trading Journal spreadsheet?

Yes, netted into the cash flow on each row, so the totals describe what actually reached the account rather than the gross trade value.

What does the win rate in the Essentials Stock Trading Journal spreadsheet measure?

The share of closed positions that finished profitable, rather than the share of logged rows. Since a round trip occupies two rows, counting rows would be misleading.

How do I open the Essentials Stock Trading Journal spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Investing & Trading Templates

Investment Portfolio Tracker

A name beside every ticker and a percentage return on each position, so holdings of very different sizes can be compared. The Essentials Investment Portfolio Tracker spreadsheet template carries 20 holdings, works out market value and gain per position, and puts total portfolio value and total gain on a dashboard with a chart of how the value splits between holdings. Google Sheets and Excel, one file. No macros, no VBA.

$19

Options Trading Journal

Pick the leg you traded and the money works itself out - direction, premium, contract count and fees all folded into one cash flow. The Essentials Options Trading Journal spreadsheet template handles opening and closing legs in both directions so the sign follows the action, nets fees into the result rather than reporting them separately, holds thirty trades on a single log, and shows the net total, the win rate and the number logged on a dashboard. Google Sheets and Excel. No macros, no VBA.

$19

Crypto Portfolio Tracker

Percentage return sits beside value and gain on every one of twenty holdings, so a small position that doubled is tellable from a large one that drifted. The Essentials Crypto Portfolio Tracker spreadsheet template takes coin, symbol, quantity, average cost and current price per row, with a Dashboard carrying total value, total gain, overall return, total cost basis and how many holdings are ahead. Two working sheets and an allocation chart. Google Sheets and Excel. No macros, no VBA.

$19

ETF & Index Fund Tracker

Cost basis against current value on fifteen funds, and the gain, the overall return and each holding's share of the portfolio all follow from that pair. The Essentials ETF & Index Fund Tracker spreadsheet template records the annual charge per fund and weights it by holding size instead of averaging it flat, then reports the whole portfolio on a Dashboard. Two working sheets and an allocation chart. One file for Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Investing Ultimate Pack 8 templates included • Save $123

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →