Free

Trading journal template

The template for Excel and Google Sheets: log your trades – equity curve, win rate, profit factor, drawdown and your best setups calculate themselves.

  • Dashboard with equity curve, win rate, profit factor, average R and max. drawdown
  • Results per month, setup, market, weekday and direction – you see what works for you
  • R multiple and planned risk-reward straight from entry, stop and target
  • Columns for emotion and "Plan followed?" – mistakes and losing streaks become visible
  • For Excel, Google Sheets, Numbers and LibreOffice, in English and German

Get the journal free

You get the journal together with the Albrecht Edge newsletter. Confirm your email first; you can unsubscribe with one click at any time and keep the journal. Details in the privacy policy.

Albrecht Edge trading journal: the trades sheet and the automatic statistics sheet
Real view of the file with twelve example trades.

What is inside

  • 1

    Trades

    One row per trade with drop-downs for market, direction, timeframe, setup and emotion. R multiple, planned risk-reward, outcome, balance and drawdown calculate themselves.

  • 2

    Statistics

    A dashboard with twelve key figures, your equity curve and tables per month, setup, market, weekday and direction – plus "plan followed" versus "not followed".

  • 3

    Lists

    Your own setups, markets and emotions. Whatever you change here shows up in the drop-downs and in the statistics right away.

How to get the most out of your journal

  1. Log every trade right after you close it – the bad ones too.
  2. Take a screenshot of the chart at entry and paste the link.
  3. After 20 to 30 trades, open the statistics: which setup really works for you?
  4. Compare "plan followed" with "not followed" – that is often where the biggest lever is.

More in the guide to trading psychology and journaling

Free tool Work out your position size Enter your balance, risk and stop – the calculator shows the position size for forex, gold, indices and futures.

Frequently asked questions

Does the journal cost anything?

No. You get it free when you subscribe to the Albrecht Edge newsletter and confirm your email address.

Does it work with Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. It also works in Excel, Numbers and LibreOffice.

Can I keep the journal if I unsubscribe?

Yes. Once downloaded, the file is yours. You can unsubscribe at any time with one click in every newsletter.

I am already subscribed. How do I get the journal?

Just enter your email address again. You will get an email with the download link.

Can I change the columns?

Yes. Change setups and emotions in the "Lists" sheet. Do not overwrite the grey columns with formulas.