Logging XAUUSD costs trade by trade: a template
Posted: Thu Oct 29, 2026 6:01 pm
Gold cost discussions usually rely on broker marketing. A trade-by-trade cost log for one week gives you real numbers instead, and it's not much work.
Columns per trade:
Things the log tends to reveal:
Columns per trade:
- Spread at entry, in dollars (14 cents shows as 1.4 "pips" on most platforms).
- Commission converted to dollars per ounce at your size.
- Slippage on entry: fill minus requested price.
- Slippage on exit, separately for stops and targets.
- Whether US data was within 10 minutes.
Things the log tends to reveal:
- Stop slippage is usually the biggest variable, not spread. The damage happens on exits during fast moves.
- Data days carry a disproportionate share of slippage, so sort by the news column.
- Calm hours can be perfectly acceptable for scalping.