Most traders keep their first trading journal in Excel or Google Sheets, and that is the right call. It is free, it is yours, and you can see every formula. This article is not an argument against spreadsheets. It is a precise list of the moments when an Excel trading journal starts giving wrong answers, so you recognise them when they arrive, and a note on what to carry over when you move.

What a spreadsheet does well

  • It costs nothing and asks for no sign-up.
  • You own the file and can take it anywhere.
  • Every number is a formula you can click on and audit.
  • A new column is thirty seconds away when you want to track something nobody thought of.

For the first fifty trades in one market with simple in-and-out entries, a sheet with ten columns beats most apps. The problems start with the first trade that does not fit the row.

Where it breaks

1. Partial exits and scaled entries. The row model assumes one entry price and one exit price. The first time you take half off at target one and the rest at target two, you either average the prices by hand (losing the information) or add a second row (breaking the win rate, the trade count and the average R). Most sheets end up doing both, inconsistently.

2. Shorts. The P&L formula for a short is the mirror of the long formula, and a single sign error in one row turns a loser into a winner forever. Sheets that use a direction column with a multiplier of 1 or −1 fix this, until someone types "Short" in a cell that expected −1.

3. Contract multipliers and lots. One NQ point is $20. One standard forex lot is 100,000 units, and the pip value depends on the quote currency. A crypto perpetual is quoted in the coin but settled in USDT. A sheet that works for stocks gives nonsense for futures unless every symbol has its own multiplier column, maintained by hand.

4. Break-even logic. A trade that nets +$2 should not count as a win. Doing this properly needs a threshold per account and formulas that exclude break-even trades from both sides of the win rate. It is possible in a sheet; almost nobody does it.

5. Drawdown and the equity curve. Maximum drawdown needs a running peak and a running trough over trades sorted by close time. Sorting breaks when rows are inserted out of order, and the formula breaks when a trade is still open. This is the metric sheets most often get wrong without anyone noticing.

6. The cost of each mistake. The single most useful question a journal can answer is "what has 'moved stop' cost me this quarter?" In a sheet that needs a pivot table on a tag column, rebuilt every time you add a tag. Nobody rebuilds the pivot table on a losing day.

7. Logging from a phone. Spreadsheets on a phone are miserable. If you trade from a desk and log from the sofa, the log happens tomorrow or not at all.

8. Broker reports. Importing a MetaTrader statement, a Binance trade history or a TradingView list of trades into a sheet means reconciling date formats, time zones, fee columns and symbol names by hand, every month. Duplicates creep in. The import is where most spreadsheet journals quietly die.

A template that lasts longer

If you want to stay in a spreadsheet for now, these choices buy you time:

  • One row per fill, not per trade. Add a trade id column and let formulas group fills into trades. This is the only way partial exits stay honest.
  • A direction column with +1 / −1, validated so nothing else can be typed in it.
  • A symbol table with the multiplier and the currency for each symbol, looked up by formula.
  • A fixed list of tags on a separate sheet, used as data validation for the setup and mistake columns.
  • A break-even threshold cell that the win-rate formulas reference.
  • Close time as a real date-time, in one time zone, so sorting and sessions work.

With these in place a Google Sheet can carry you to a few hundred trades. Without them it starts lying around trade sixty.

When it is time to move to a trading journal app

Any two of these is the signal:

  • You have more than a hundred trades, or more than one account.
  • You scale in or out of positions.
  • You trade futures or forex, where multipliers matter.
  • You trade under prop firm rules and need the daily loss and drawdown against the limit, live.
  • You want the cost of each mistake tag without building a pivot table.
  • You want to import broker history instead of typing it.
  • You log from a phone.

What to carry over, and what not to lose

Two things in a spreadsheet are worth protecting when you move: the data and the auditability. SetupBook keeps both. Your existing sheet can be imported as a CSV with a column mapping, so the history comes with you and duplicates are skipped. Everything can be exported again as CSV or JSON at any time, so the data remains yours. And the formulas stay visible: P&L and R are derived from the fills you entered, the trader score prints its own formula on the analytics page, and when a result you typed disagrees with the prices the app says so instead of guessing.

What you give up is the freedom to add a column for anything. What you get is a journal that is still correct after your first partial exit, your first NQ trade and your first imported MetaTrader report. The user guide shows the import and the export step by step; a free account has no trade limit, so the spreadsheet's biggest advantage, the price, is matched.