TL;DR — Most traders know their win rate but not their real cost per trade. Tracking your trading costs monthly — spreads, swaps and rebates in one simple spreadsheet — shows you exactly where your money goes and how much a per-lot rebate lowers your cost on every lot, win or lose.
Ask an active trader what they paid in costs last month and you will usually get a shrug. Spreads feel invisible because they are baked into the fill price. Swaps appear as a small line item at rollover. Commissions show up on a statement nobody reads closely. Add them together over a few hundred trades and the number is rarely small. That is why a monthly cost review is one of the highest-value habits a forex or gold trader can build.
Why monthly tracking beats a vague sense of your costs
Costs are the one part of trading you can measure with certainty. You cannot control whether the next trade wins, but you can control what you pay to place it. A monthly review turns a fuzzy feeling ("my broker feels expensive") into a concrete figure you can compare, negotiate around, or reduce.
Monthly is the right rhythm for three reasons. First, it is long enough to smooth out a quiet week or a burst of activity, so the average cost per lot is meaningful. Second, it is short enough that you still remember why you traded the way you did. Third, it lines up with how most statements and rebate payouts are reported, which makes reconciliation quick.
Once you have a few months of data, patterns appear. Maybe your costs spike on news days. Maybe one instrument quietly eats a disproportionate share of your budget. You cannot fix what you have never measured.
What to record in your trading cost tracker
You do not need accounting software. A single spreadsheet tab with one row per trade, or one row per day if you trade heavily, is enough. The columns that matter are the ones that change your bottom line:
- Date and instrument — so you can spot which markets cost you most. Gold (XAUUSD) often behaves differently from major FX pairs.
- Lots traded — the unit that spreads, commissions and rebates are all priced against.
- Spread cost — the spread at entry, converted into account currency. If your platform shows spread in pips, multiply by pip value and lot size.
- Commission — the per-lot or per-side fee charged by your broker, if any.
- Swap or rollover — the overnight financing credited or debited for positions held past the daily cut-off.
- Rebate earned — the cashback credited for that trade, if you use a rebate service.
- Net cost — spread plus commission plus swap, minus rebate. This is the number that actually matters.
If you are unsure how a term is defined on your statement, the trading glossary covers spreads, swaps and commissions in plain language.
A simple spreadsheet template you can build in ten minutes
Set up two tabs. The first is your trade log with the columns above. The second is a monthly summary that pulls totals together. Keep the formulas basic:
- Total lots — sum of the lots column for the month.
- Total cost before rebates — sum of spread, commission and swap.
- Total rebates — sum of the rebate column.
- Net cost — total cost before rebates minus total rebates.
- Cost per lot — net cost divided by total lots. This single figure is the clearest health check on your trading cost.
Track cost per lot month over month rather than in isolation. A rising trend usually means wider spreads, more overnight holds, or a change in your instrument mix — all things you can act on.
Reading the numbers: what your monthly costs are telling you
Once the summary tab is populated, a few questions become answerable:
- Is most of my cost spread, commission, or swap? Each points to a different fix.
- Do I hold positions overnight often enough that swap is a real line item rather than noise?
- Is one instrument, such as gold, costing me far more per lot than my FX pairs?
- How much of my gross cost is being returned as rebates, and is that share stable?
If swaps dominate, you may be paying for a strategy you did not intend to run. If spreads dominate, execution quality and broker choice matter more than anything else. If rebates are a meaningful offset, you are already recovering part of your cost — but it is worth checking whether you are on the best available rate.
In our view — the traders who last are rarely the ones with the highest win rate; they are the ones who know their cost per lot to the cent and treat it as a number to manage, not a mystery to ignore.
Where rebates fit into the monthly picture
A per-lot rebate changes the arithmetic in a useful way. Because it is paid on volume rather than profit, it reduces your cost on every lot you trade — including the losing ones. That makes it a genuine cost offset rather than a bonus that only shows up in good months.
For example, if a hypothetical rebate returned a modest fixed amount per lot and you traded 40 lots in a month, the credit would be a visible line in your summary rather than a rounding error. The exact rates depend on the broker and account type, and they change, so the live figures sit on the rate board rather than in a static article.
Two practical points. First, rebates are usually reported separately from your broker statement, so add them to the spreadsheet manually or export them if your provider allows it. Second, compare gross cost and net cost side by side — the gap between them is the value the rebate is adding each month.
If you want to see how different rates would affect your own volume, the cashback calculator lets you plug in lots and see the monthly figure. If you already have an account elsewhere, the switch calculator estimates what you might be leaving on the table by not tracking this at all.
Turning the review into a monthly routine
The habit only pays off if it is repeatable. A fifteen-minute routine on the first of each month is enough:
- Export or copy your trades for the previous month into the log tab.
- Confirm lots, spreads, commissions and swaps against your statement.
- Add rebate credits and calculate net cost and cost per lot.
- Compare against the previous two months and note any jump.
- If cost per lot is rising, check whether it is spreads, swaps, or your instrument mix — then decide on one change for the coming month.
Keep the file simple and consistent. A tracker you actually update beats an elaborate one you abandon after three weeks. Over a year, this routine gives you something rare: a documented history of what your trading actually costs, and evidence for every decision you make about brokers, instruments and holding periods.
Where to go next: if you have never separated gross cost from net cost, start this month. Compare live rebate rates on the broker rate board, run your own volume through the rebate calculator, and if the numbers look better elsewhere, see how to get cashback on an existing account without switching broker.
