Skip to content

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

algovistra-trading-journal-template.xlsxIllustrative · Sample data
DateMarketDirectionSetupRiskNet resultR multipleOutcomePlan kept?EmotionLesson
28 OctEUR/USDLongBreakout retest100+180+1.8RWinYesCalmWaited for the close
29 OctXAU/USDShortRange fade100−100−1.0RLossNoImpatientEntered before confirmation
30 OctBTC/USDLongTrend pullback8000.0RBreakevenYesNeutralStop to entry at 1R
31 OctGBP/USDShortBreakout retest100+240+2.4RWinYesConfidentLet 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.

  1. Download the file

    Download the trading journal template (.xlsx) to your computer. It is free and needs no signup.

  2. Import it into Google Sheets

    In Google Sheets, open File › Import › Upload and choose the file.

  3. Replace the spreadsheet

    Pick “Replace spreadsheet”. The formulas, drop-downs and colors all keep working, in Excel and LibreOffice too.

Download the template (.xlsx)

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.