Google Sheets Trading Journal Template

Build a more consistent trading review process with a ready-to-use journal created in Google Sheets.

Record your entries and exits, track risk and trading costs, add context to your decisions, and review your monthly performance without building a spreadsheet from scratch.

Most traders can remember the outcome of their most recent trade.

It becomes much harder to remember why the trade was taken, how much was originally at risk, whether the plan changed, or which decisions repeatedly affected the result.

A trading journal creates a record of those details before they are forgotten.

This Google Sheets trading journal template gives you a structured place to document each completed trade and connect the outcome with the decisions that produced it.

As your journal grows, you can use it to examine questions such as:

• How much of the account am I risking per trade?
• Are my average winners larger than my average losses?
• How much are commissions and fees affecting my results?
• Am I managing trades according to the original plan?
• Is my account performance becoming more consistent?
• Are a few unusually large trades distorting the overall result?

The goal is not simply to fill a spreadsheet with transactions.

The goal is to create a trading history that becomes more useful each time you review it.

The template is divided into three worksheets that support different parts of the review process.

Start Here

The opening worksheet introduces the journal and gives you an overview of how the template is organized.

Use it as a reference before entering your first trade.

Trade Log

The Trade Log is the main working area of the journal.

Each completed trade is recorded in one row, keeping the position details, risk information, costs, result, notes, and rating together.

This makes it easier to return to a trade later and understand what happened without searching across multiple files.

Trade Summary

The Trade Summary organizes the data from your Trade Log into a monthly performance overview.

Select a year and compare your trading activity and results from January through December.

Instead of calculating each statistic manually, you can use the summary to review how your performance changes over time.

Entry and exit prices show where a position began and ended, but they do not explain how the trade was planned or managed.

The Trade Log gives you space to record the key details behind each completed position:

• Trade date
• Trade time
• Symbol or instrument
• Long or short direction
• Entry price
• Exit price
• Position quantity
• Starting account balance
• Stop-loss price
• Take-profit price
• Trading costs
• Account risk
• Closed-position P&L
• Account percentage change
• Updated account balance
• Trade notes
• Trade rating

Keeping this information together helps you review the trade as a complete decision rather than only as a profit or loss.

A profitable trade is not always a well-executed trade.

A losing trade is not always evidence of a bad decision.

The quality of a trade depends on what was planned, how the position was managed, and whether the original process was followed.

The template helps you review these stages together.

Before the Outcome Is Known

Record the entry price, stop-loss level, take-profit level, position size, and account balance.

These fields preserve the assumptions and risk plan behind the position.

After the Position Closes

Enter the exit price and trading costs.

The journal can then show the closed result and its effect on the account.

During the Review

Use the Trade Notes and Trade Rating fields to document the quality of your execution.

For example, you might record whether you:

• Followed the original stop
• Exited earlier than planned
• Increased the position without a clear reason
• Hesitated before entering
• Changed the target during the trade
• Managed the position according to your rules

Separating execution quality from the financial result can make the journal more useful for improving future decisions.

Profit and loss alone do not show how much risk was required to produce the result.

Two trades may generate the same profit while having very different effects on the account.

One trade may have used a controlled position size and a clearly defined stop. Another may have exposed the account to significantly more risk.

Trading costs can also change the quality of a result, particularly for active traders or strategies with smaller profit targets.

By recording the account balance, quantity, stop loss, take profit, and trade costs, the template helps you review:

• The percentage of the account placed at risk
• The planned relationship between risk and reward
• The result after trading costs
• The percentage change in the account
• The updated account balance

Over time, these records can reveal whether your position sizing and risk management are supporting or weakening your performance.

Several weeks after a trade closes, the chart and P&L may not be enough to explain what happened.

The Trade Notes field gives you a place to preserve information that would otherwise be lost.

You can use it to record:

• Why you entered the position
• What setup or market condition you identified
• What you expected to happen
• Whether the trade followed your plan
• Why you decided to exit
• What changed while the position was open
• What you handled well
• What you would do differently next time

The Trade Rating field can be used to evaluate how well the trade was executed.

The rating does not have to match the financial result.

A planned loss that followed your rules may deserve a stronger rating than an impulsive trade that happened to make money.

This encourages you to evaluate the quality of your process, not only the outcome.

Individual trade reviews help you understand specific decisions.

Monthly reviews help you identify broader changes in your performance.

The Trade Summary organizes your trading statistics by month so you can compare results without manually reviewing every row.

Depending on the selected year, the summary can show:

• Total trades
• Winning trades
• Losing trades
• Break-even trades
• Win rate
• Average winning trade
• Average losing trade
• Largest winning trade
• Largest losing trade
• Total trading costs
• Total P&L
• Average P&L per trade
• Account change
• Average risk per trade
• Average reward per trade
• Average risk-to-reward ratio

These figures help provide context around the final P&L.

For example, a profitable month may have resulted from consistently controlled losses and larger average winners. It may also have resulted from one unusually large trade while the remaining trades performed poorly.

Looking at the supporting statistics makes it easier to tell the difference.

A trading journal becomes valuable through repeated use.

The template is designed to support a simple routine rather than create another complicated task after every trading session.

After Closing a Trade

Record the position details while the decision is still fresh.

Add the prices, quantity, risk information, costs, notes, and rating before too much time has passed.

At the End of the Day

Read through the trades completed during the session.

Do not review only the total P&L. Look at whether the positions followed your intended process.

Consider whether any trades were rushed, oversized, hesitant, poorly managed, or inconsistent with your rules.

At the End of the Month

Use the Trade Summary to step back from individual positions.

Compare the number of trades, win rate, average winner, average loser, total costs, total P&L, account change, and risk statistics with previous months.

The purpose of the review is not to search for a perfect month.

It is to understand what is changing and which behaviors are affecting the results.

You can create your own editable copy directly in Google Sheets.

1. Make Your Own Copy

Click Make a Copy in Google Sheets.

Google will prompt you to save a copy of the template to your own Google Drive.

Your changes will not affect the original template.

2. Review the Worksheets

Open the Start Here, Trade Log, and Trade Summary worksheets before entering your trading history.

This will help you understand how information entered into the journal is used in the performance summary.

3. Enter Your Starting Information

Add your starting account balance and begin recording completed trades in the Trade Log.

Review the first few entries to make sure the journal matches the way you calculate position size, risk, and trading costs.

4. Control Your Own Sharing Settings

Your copy is stored in your Google Drive.

You decide whether the journal remains private or is shared with a mentor, trading coach, or accountability partner.

CTA: Make a Copy in Google Sheets

The included fields provide a practical starting point, but every trader reviews performance differently.

Because the template is built in Google Sheets, you can adjust your copy around your market, strategy, and review process.

You may choose to add columns for:

• Broker account
• Asset class
• Trading strategy
• Market session
• Entry reason
• Exit reason
• Time frame
• Trade duration
• Screenshot link
• Market condition
• Mistake
• Emotion
• Rule followed or broken

You can also rename worksheets, change the formatting, create additional summary sections, or remove fields you do not use.

When changing the structure, avoid deleting or moving cells used by existing formulas unless you also update the related formulas.

The journal should contain enough detail to support your review without becoming so complicated that you stop maintaining it.

The general trade log can be adapted to different types of trading.

Stock Traders

Record the symbol, direction, entry, exit, share quantity, risk, costs, and account result.

You may also add fields for the market session, catalyst, or setup.

Options Traders

Add instrument-specific details such as:

• Call or put
• Strike price
• Expiration date
• Contract quantity
• Premium
• Multi-leg position details

Futures Traders

You may want to include:

• Contract name
• Contract month
• Number of contracts
• Tick size
• Tick value
• Trading session

Forex Traders

Additional fields may include:

• Currency pair
• Lot size
• Trading session
• Pip risk
• Pip result

The included template provides the base journal structure. You can add the fields required by the instruments you trade.

A spreadsheet can be an effective starting point when you want control over the journal and prefer entering trades manually.

The template may fit your workflow when:

• You are creating your first trading journal
• You already use Google Sheets
• You place a manageable number of trades
• You prefer manual trade entry
• You want to customize the spreadsheet yourself
• You want to track risk as well as P&L
• You need a straightforward monthly overview
• You are still deciding which review fields matter to you

Google Sheets also allows you to access your journal from different devices connected to your Google account.

For many traders, that flexibility is enough to establish a consistent journaling habit.

A manual spreadsheet may become harder to maintain as your trading history grows.

The issue is not necessarily the number of rows. It is the amount of work required to keep the records accurate and useful.

You may begin to outgrow the template when:

• You place a large number of trades
• A position contains multiple entries and exits
• You trade through several broker accounts
• You repeatedly copy data from broker statements
• Executions need to be combined into complete positions
• You want to analyze results by symbol, strategy, tag, or account
• You need notes and screenshots connected to individual trades
• Spreadsheet formulas require frequent maintenance
• Updating the journal takes more time than reviewing it

At that stage, a more structured trading journal can reduce manual work and provide more flexible analysis.

TradeBB is an online trading journal designed for traders who want to organize and review their trading history without manually maintaining a large spreadsheet.

Depending on the broker and account, trades can be added through:

• Supported read-only broker sync
• Broker trade history file imports
• Manual trade entry

Once the trades are added, TradeBB organizes the data into connected views and reports, including:

• Trading dashboard
• Trade history
• Trading calendar
• Symbol reports
• Strategy reports
• Tag and mistake analysis
• Broker account reports
• Trade notes
• Screenshots
• Daily journal entries
• Custom filters

The Google Sheets template can help you establish a consistent review process.

TradeBB becomes useful when you need to manage more trading data, reduce manual entry, or examine performance from more angles.

Both approaches can support a trading review process, but they solve different needs.

Use the Google Sheets Template When

You want a flexible journal that you can control and customize.

You prefer manual entry, place a manageable number of trades, and do not yet need broker imports or detailed reporting across multiple accounts.

Use TradeBB When

You want to spend less time copying transactions and maintaining formulas.

You need to manage more complex executions, multiple broker accounts, screenshots, notes, filters, and reports by symbol, strategy, tag, or account.

You do not need to choose the most advanced workflow immediately.

Start with the journal you can maintain consistently. Change tools when the spreadsheet begins limiting the efficiency or depth of your review.