Trading journal

Separate plans from actual trades. Summarize completed trades with confirmed costs by month.

XLSX 300 records

From calculation to a record

A workbook with formulas and monthly summaries. Keep your downloaded journal locally; trade records are not sent to this website.

Separate plans, actual costs and estimates
Exit-month P&L, win rate and average R
Instructions and separate hypothetical examples

Choose your language

Korean journal English journal

Free · No macros · Excel format

Move a result into the journal

Copy a result
Select “Copy for journal” in a calculator.
Paste values in a new row
Start at A3 in Journal and paste into column A of a new row. A:AH are inputs; AI:AR contain formulas.
Complete the actual details
Confirm actual fill times in Seoul time and actual fees. Estimated-fee records are excluded from confirmed statistics until costs are checked.

Dates, formula protection and precision

Timestamps use Asia/Seoul, YYYY-MM-DD HH:mm:ss. Import CSV through Excel’s Text/CSV import and set H:I to Text. No cost = 0; unknown = blank.

Inputs are yellow; formulas are green. Unprotect the sheet before sorting or folding plan columns; there is no password. Near-zero net after cost cancellation can be held as CHECK_NUMBERS because of Excel precision.

For education and research. Calculations do not guarantee execution or returns.