Fibonaccistraders Excel Trading Journal

i've had quite a few requests for a copy of the spreadsheet I use for my trading journal. I've made it available here; please feel free to Download it for free

Why are trading journals important?

A trading journal will help you develop a trading style that fits your personality and beliefs about the market. Anyone who has ever kept a personal diary knows the value of being able to reflect on the past and learning from it. A trading journal performs the same function. You’ll start to spot what’s working and, even more importantly, avoid making the same mistake time after time.

Trading journal template tips

I’ve kept this simple. Each trade gets its own row. If you scale into or out of a position, each lot gets its own line. I’ve color-keyed each cell to show what you need to enter and what is calculated for you.

If you’re an Excel wonk, you can go bananas calculating the most obscure ratios and making distant forecasts about how much your portfolio might be worth in ten years. That’s fun, but always remember that the biggest benefits of a journal will be found in three columns: the profit or loss on each trade, why you did it, and what you learned from that trade.

Every trade gets an entry in your journal, and it gets entered as quickly as possible after each trade. It’s best to keep your journal current; otherwise you might build up a backlog of trades and it’ll be a struggle to remember why you entered or exited each one.