Excel & Google Sheets
Free trading journal template
One spreadsheet for your trades, lessons and results. Open it in Excel, Google Sheets or LibreOffice.
- Free, no signup
- 500 trade rows
Preview of the trading journal spreadsheet
| Date | Market | Direction | Setup | Risk | Net result | R multiple | Outcome | Plan kept? | Emotion | Lesson |
|---|---|---|---|---|---|---|---|---|---|---|
| 28 Oct | EUR/USD | Long | Breakout retest | 100 | +180 | +1.8R | Win | Yes | Calm | Waited for the close |
| 29 Oct | XAU/USD | Short | Range fade | 100 | −100 | −1.0R | Loss | No | Impatient | Entered before confirmation |
| 30 Oct | BTC/USD | Long | Trend pullback | 80 | 0 | 0.0R | Breakeven | Yes | Neutral | Stop to entry at 1R |
| 31 Oct | GBP/USD | Short | Breakout retest | 100 | +240 | +2.4R | Win | Yes | Confident | Let the runner work |
Illustrative sample. Teal columns calculate automatically. The file also includes entry and exit prices, fees, mistakes and a chart link.
Inside the file
Three tabs, ready to use.
Journal
500 trade rows, drop-down choices and automatic result calculations.
Summary
Win rate, R multiples, profit factor and expectancy, overall and by setup.
How to use
Column explanations, a sample row and the formulas behind the numbers.
Google Sheets
Download. Import. Start your journal.
Download the file
Download the trading journal template (.xlsx) to your computer. It is free and needs no signup.
Import it into Google Sheets
In Google Sheets, open File › Import › Upload and choose the file.
Replace the spreadsheet
Pick “Replace spreadsheet”. The formulas, drop-downs and colors all keep working, in Excel and LibreOffice too.
Excel and LibreOffice can open the .xlsx file directly.
FAQ
A few things to know.
Is the trading journal template really free?
Yes. Download it, use it and change it as you like. There is no signup and no email required.
Does it work in Google Sheets and Excel?
Yes. It is an Excel (.xlsx) file that opens in Excel, LibreOffice and Numbers. In Google Sheets, use File › Import › Upload and every formula keeps working.
What should a trading journal include?
At minimum: the market, direction, entry, stop, exit, size, risk and result. The part most traders skip is the process: the setup, whether you followed your plan, how you felt before entry and the lesson. The template has a column for each.
How is the R multiple calculated?
Net result divided by the amount you risked at your stop. If you risked 100 and made 150, the trade is +1.5R. The template calculates it for every row that has both numbers.
Does it work for forex, crypto, gold and stocks?
Yes. Results are entered in money and prices are free-form, so it works for any market and any account currency.
What is the difference from AlgoVistra's AI trading journal?
The template is a spreadsheet you fill in by hand. AlgoVistra's trading journal logs trades from a chat message, imports MetaTrader 5 and Binance history, shows each trade on its chart and reviews your results with you.
The template is for record keeping and education. It is not financial advice.
Bring your trading history into the conversation.
Log and review trades with your AI trading assistant.
Explore the trading journal