Free Trading Journal: Log Trades, Track Win Rate & R, Export CSV
A journal turns trades into data. Log each one here: it's saved in your own browser, calculates your win rate and average R, and exports to a spreadsheet whenever you want.
A trading journal records for each trade: date, market, setup, risk, result in R, whether you followed your plan, and one lesson. The two numbers that matter are your average R and how that average changes between the trades where you followed the plan and the ones where you did not.
Trading journal (saved in your browser)
What to record for every trade
- Setup: which of your written setups it was, so you can compare them.
- Result in R: +2R, -1R and so on. R makes trades of different sizes comparable.
- Followed plan? The most important column. Losses that followed the plan are normal; wins that broke it are dangerous.
- Notes: what you saw, how you felt, one lesson. Add a screenshot in your own files.
How to review
Once a week, sort by setup and by "followed plan". Typical discoveries: one setup carries all the profit, trades taken outside your session lose, and breaking the plan costs more than any single bad market. Change one thing at a time based on what the data shows.
Chart Bound is a free browser game that drills exactly this on real historical charts: read the candles, make the call, see instantly if you were right.
Play free, no signup →Prefer a spreadsheet? Copy this template
Paste this first line into the top row of a blank Google Sheet or Excel file (Paste special → comma separated), and you have the same journal in a spreadsheet. The journal above exports in exactly this format, so you can start here and import later.
Date,Market,Direction,Setup,Risk %,Entry,Stop,Target,Exit,Result R,Followed plan,Mistake,NoteFour formulas turn that into a dashboard. With results in column J and "followed plan" (y/n) in column K:
| Metric | Formula | What it tells you |
|---|---|---|
| Win rate | =COUNTIF(J:J,">0")/COUNT(J:J) | How often you win. On its own it means nothing. |
| Average R | =AVERAGE(J:J) | Your expectancy per trade. This is the number that matters. |
| Plan-followed % | =COUNTIF(K:K,"y")/COUNTA(K:K) | Your discipline score, independent of results. |
| Average R when you followed it | =AVERAGEIF(K:K,"y",J:J) | What your method is worth when you actually trade it. |
That last row is the one that changes behaviour: most traders find their plan-followed trades have a clearly better average than the rest, and it is difficult to argue with your own spreadsheet.
Your data stays with you
This journal stores entries only in your browser (local storage). Nothing is uploaded. Clearing browser data deletes it, so export to CSV regularly and keep the file somewhere safe.
Frequently asked questions
What should a trading journal include?
Date, market, direction, setup, result (ideally in R), whether you followed your plan, and a short note or lesson for each trade.
Why do traders keep a journal?
To turn trades into data: which setups work, when mistakes happen, and whether rules are being followed.
Is this trading journal free?
Yes. It runs in your browser, saves locally, and exports to CSV for Excel or Google Sheets.
How often should I review my journal?
Weekly is common, with a deeper review monthly once you have enough trades for patterns to be meaningful.
Embed this calculator on your site
Free to use, on any site, with no signup: paste this one line where you want the tool to appear. It loads our hosted version, so it stays up to date, and the link under it credits back to this page.
420×620 by default and it scales down to fit a narrower column. Please keep the attribution link.
Keep learning
Chart Bound is a free browser game that drills exactly this on real historical charts: read the candles, make the call, see instantly if you were right.
Play free, no signup →