Free Trading Journal

Download an Excel trading journal to record your plan and actual fills separately.

Sheets and columns in the actual file

The Korean workbook has 시작하기, 매매일지, 월별요약 and 작성예시. The English workbook has Getting Started, Journal, Monthly Summary and Examples. Example-sheet rows are excluded from the input ledger’s statistics.

Column	Value to record
B / record_type	PLAN / CLOSED
C / cost_basis	ESTIMATED / ACTUAL
H·I / entry_time·exit_time	yyyy-mm-dd hh:mm:ss / Asia/Seoul
J·K·L	Actual entry, exit and quantity
M·N·O	Entry fee, exit fee, funding expense
P / initial_risk	Predefined initial risk

OPEN is not a supported record type in this file. An unfinished plan is PLAN; only valid CLOSED/ACTUAL records enter CONFIRMED statistics after exit and cost checks. See the journal example to connect plans and fills.

Reconcile one row from the Examples sheet

The first trade in the downloaded Examples sheet is hypothetical. Its record type is CLOSED, cost basis ACTUAL and direction LONG. Exchange Example and symbol DEMOUSDT identify the sample. Entry time is 2026-09-01 09:00:00 and exit time 2026-09-01 10:00:00, both in Seoul time.

Input columns	Sample values
J / K / L: entry / exit / quantity	100 / 110 / 2
M / N / O: entry fee / exit fee / funding paid	0.2 / 0.22 / 1 USDT
P: initial risk fixed before the trade	10 USDT

Gross P&L: (110 − 100) × 2 = 20 USDT.
Total costs: 0.2 + 0.22 + 1 = 1.42 USDT.
Net P&L: 20 − 1.42 = 18.58 USDT. Compare this with column AK.
Realized R: 18.58 ÷ initial risk 10 = 1.858 R. Compare this with column AL.

Column AI shows CONFIRMED and the exit month is 2026-09. This row stays on the Examples sheet, so the input ledger’s monthly trade count remains 0. In your own ledger, check fills and actual costs before pasting values into the input columns. Keep the calculation formulas intact, and keep planned risk separate from the P&L that actually occurred.

How to use

The English workbook has four sheets and space for 300 trades. Export calculator results as CSV/TSV for transfer into the journal. Only valid CLOSED trades with ACTUAL costs enter confirmed statistics.

Scope and assumptions

This workbook is designed for linear USDT contract records. It does not automatically determine exchange fees. Record actual entry and exit fees plus funding from your trade history; leave unconfirmed costs blank and enter 0 only when there was no cost.

Blank costs mean unconfirmed; an explicit zero means no cost. Record dates as Seoul-time text and import date columns as text when using CSV.

The workbook accepts actual funding paid or received. It does not derive funding from a rate and holding period. Do not use this template unchanged for spot, stocks, options or coin-margined inverse contracts. Those products need a ledger that matches their currency, contract multiplier and tax treatment. If you combine partial fills into one row, define the average fill price, total quantity, total costs and timestamp convention first. Realized R remains unavailable unless initial risk is a valid positive value.

Related recordkeeping guides

Separating plans and fills in a journal · Net P&L and the cost ledger · Expectancy from confirmed trade outcomes