The template is one Excel file with two sheets. The first is the trade log. The second reads the log and calculates the statistics. It works in Excel, Google Sheets and LibreOffice.
What is in the template
Sheet 1, Journal. One row per trade and sixteen columns: date, instrument, direction, setup, entry, stop loss, take profit, exit, size, risk in money, result in money, R multiple, plan followed, state of mind, notes and a screenshot link. The R multiple fills itself in from risk and result.
Sheet 2, Statistics. Nine numbers calculated from the log: number of trades, winning trades, win rate, average win, average loss, profit factor, total result, total R and expectancy in R per trade.
The first row of the journal holds an example trade. Replace it with your own.
How to use it
- 1Download the file and open it in Excel, or upload it to Google Drive and open it with Google Sheets.
- 2Decide on a fixed list of setup names before the first trade. Three to five names are enough. The statistics are only useful if the same setup is always called the same thing.
- 3Before you enter a trade, write the planned entry, stop loss and risk in money.
- 4After the trade closes, add the exit, the result and whether you followed the plan.
- 5Once a week, open the Statistics sheet and read expectancy first.
How the formulas work
The R multiple is the result divided by the risk. A trade that risked $100 and made $175 shows 1.75. A trade that lost the full risk shows -1.
Expectancy is total R divided by the number of trades. It is the average amount you make per trade, measured in units of risk. Above zero, the strategy makes money over this sample. Below zero, it loses, whatever the win rate says.
Profit factor is gross profit divided by gross loss. A value of 1.5 means the winners brought in one and a half times what the losers took out.
Add a breakdown by setup
The statistics sheet covers all trades together. The most useful next step is the same numbers per setup. In Excel or Google Sheets, select the journal and insert a pivot table with Setup in rows and the average of R multiple in values. The result is expectancy per setup, the number that decides what to keep trading.
Repeat it with weekday or hour in rows to see when you trade well.
Where a spreadsheet stops helping
A template is the right start, and it has three limits:
- Every trade is typed by hand. With ten trades a day, entry takes longer than the review.
- Typing errors change the statistics. One wrong digit in the risk column distorts expectancy.
- Screenshots and notes live elsewhere. The chart you need during the review is in another folder.
When that starts to cost you reviews, move the log to a journal that imports trades by itself. Tradeart connects to MetaTrader 5, cTrader and DXtrade, imports each trade and calculates the same R-based statistics without the typing. How the options compare is covered in the comparison of trading journals, and the method behind the columns in the trading journal guide.
