# Free Trading Journal Template

> Download the free trading journal template as a CSV file and open it in Excel or Google Sheets. It has 18 columns covering the entry, stop, exit, charges and lessons of each trade, with formulas for initial risk, gross and net P&L, R-multiple and holding days. Copy the formulas down as you add trades.

Canonical: https://www.nexusjournal.co.in/trading-journal-template
Last updated: 2026-11-15

This free trading journal template gives you the columns that matter for reviewing trades, with the calculations already written as formulas. It opens in Excel, Google Sheets and LibreOffice, and can be imported into a Notion database.

Reviewed 2026-11-15 by [Nexus Journal product team](https://www.nexusjournal.co.in/about-nexus-journal).

## What is in the template

Trade details: trade date, symbol, segment (equity delivery, intraday, F&O or commodity), side (long or short) and the setup you traded.

Plan and execution: entry price, quantity, stop loss, exit date and exit price. Results: gross P&L, charges, net P&L, R-multiple and holding days. Review: mistakes or rule breaks, and the lesson from the trade.

Two example rows show how it works. Replace them with your own trades and copy the formulas in the calculated columns down to new rows.

## The formulas, explained

Initial Risk is the distance from entry to stop multiplied by quantity: ABS(entry - stop) x quantity. It is the amount you planned to lose if the stop was hit.

Gross P&L is (exit - entry) x quantity for a long trade and (entry - exit) x quantity for a short. Net P&L subtracts the charges you enter, such as brokerage, STT, exchange charges, GST, stamp duty and DP charges.

R Multiple is net P&L divided by initial risk, so a trade that risked 1,000 and netted 2,155 is a 2.2R trade. Holding Days is the exit date minus the trade date.

## How to use the template in Google Sheets, Excel or Notion

Google Sheets: choose File, Import, Upload, and select the CSV. Excel: open the CSV directly, then save it as an .xlsx workbook so formulas and formatting are kept. Dates are written as year-month-day so both read them correctly.

Notion: create a database and use Merge with CSV, or import the file as a new database. Notion imports the values but not spreadsheet formulas, so recreate the calculated columns as Notion formula properties.

## A weekly review routine

Fill in the plan columns (setup, entry, stop, quantity) when you enter the trade, not afterwards, so the record shows what you intended rather than what you remember.

Once a week, sort by setup and by mistakes. Look at average R per setup, the share of trades with a rule break, and whether losses stayed close to -1R. Those three checks show more than the week's total P&L.

## When a spreadsheet stops being enough

The template assumes one entry and one exit per row. Positions built in several entries and reduced in several exits need either many rows per position or manual averaging, and both make the P&L and R calculations harder to trust.

Charges also have to be typed in per trade. A journal app such as Nexus Journal imports executions and charges from Indian brokers, keeps every entry and exit of a position, and calculates these metrics automatically. Its free plan covers up to 25 trades.

## Related

- [Free Trading Journal](https://www.nexusjournal.co.in/free-trading-journal)
- [Trading Journal vs Excel Spreadsheet](https://www.nexusjournal.co.in/trading-journal-vs-spreadsheet)
- [How to Keep a Trading Journal That Improves Decisions](https://www.nexusjournal.co.in/how-to-keep-a-trading-journal)
- [Trading Journal Metrics Explained](https://www.nexusjournal.co.in/trading-journal-metrics)
- [Trading Journal for Indian Market Traders](https://www.nexusjournal.co.in/trading-journal-india)
- [TradeZella Alternative for Indian Traders](https://www.nexusjournal.co.in/tradezella-alternative)
