A trade blotter is the chronological record of every transaction executed on a trading account: one line per execution, timestamped, with the instrument, side, quantity, price and fees.
That single sentence is the whole concept. Everything below is detail — where the word comes from, which columns actually belong in one, what regulators require institutions to keep, and how to produce yours from data your broker already holds.
Blotter, order book, trading journal
Three documents get confused constantly, and the confusion is worth clearing in one table before going further.
| Document | Answers | Whose data |
|---|---|---|
| Trade blotter | What was executed, and when | Yours — historical, factual |
| Order book | What is bid and offered right now | The market's — live, collective |
| Trading journal | Why you took the trade, what you learned | Yours — interpretive |
The blotter is the only one of the three that is purely a record. The order book is a live view of resting liquidity and disappears the moment it changes. The trading journal is where interpretation belongs — and mixing it into the blotter is the fastest way to end up with a document too heavy to maintain.
Where the word comes from
Before electronic order management, a clerk wrote each execution by hand, in ink, on a large ruled pad as the session went on. The pad was called a blotter — after the blotting paper used to absorb excess ink from a line just written. It was the desk's rough log: recorded in the moment, before trades were confirmed, matched and formally booked in the evening.
The name survived the paper. Blotters are generated automatically now, by trading platforms and order management systems, but the definition has not moved: one line per transaction, no interpretation, nothing but facts.
That is the point of the document. The blotter records what happened, not why. It holds neither your strategy, nor your reasoning, nor your emotional state — it is a raw, exhaustive snapshot of execution activity.
What a trade blotter contains
Formats vary across platforms, but the fields split cleanly into two groups: the ones without which the document is not a blotter, and the ones that quietly determine how much you can learn from it later.
The columns you cannot drop
| Column | What it records |
|---|---|
| Execution timestamp | Date and time, to the second or better |
| Instrument | Exact identifier — EUR/USD, ES, AAPL |
| Side | Buy or sell |
| Quantity | Lots, contracts or shares |
| Execution price | The price you actually got |
| Order type | Market, limit, stop |
| Fees and commissions | Broker commission, exchange fees, conversion costs |
| Status | Filled, partially filled, cancelled, rejected |
| Account | Which account the execution belongs to |
Nine fields. Below that, you have an approximation, and every statistic computed on top of it inherits the gap.
The columns that pay for themselves
| Column | What it unlocks |
|---|---|
| Order / execution ID | Reconciliation against the broker in a dispute |
| Position ID | Groups several executions into one trade |
| Requested price | Requested minus filled = your real slippage |
| Position effect | Opening or closing — required to rebuild positions |
| Venue or counterparty | Where the order was actually executed |
| Currency and FX rate | Correct P&L across multi-currency accounts |
| Time in force | Day, GTC, IOC, FOK — explains unfilled orders |
| Overnight financing | Swap and carry, invisible in gross P&L |
| Strategy or setup tag | The one bridge to your journal |
Institutional blotters add compliance fields on top: trader identifier, client reference, regulatory timestamps. For an independent trader, a broker history export already covers most of the first table and a good part of the second.
One detail that matters more than it looks: a blotter records executions, not positions. Scale into a position in three clips and that is three lines, not one. That granularity is exactly what later lets you measure entry quality and real slippage — and it is what you destroy if you record one summary line per trade.
What one actually looks like
A simplified EUR/USD session, as it appears in a blotter:
| Time | Instrument | Side | Qty | Price | Type | Fees | Status |
|---|---|---|---|---|---|---|---|
| 09:31:04 | EUR/USD | Buy | 2 lots | 1.0812 | Market | €7 | Filled |
| 09:47:22 | EUR/USD | Sell | 2 lots | 1.0829 | Limit | €7 | Filled |
| 10:15:40 | EUR/USD | Buy | 1 lot | 1.0821 | Limit | €3.50 | Filled |
| 10:16:05 | EUR/USD | Sell | 1 lot | 1.0815 | Stop | €3.50 | Filled |
Four lines, two complete trades: one winner at +17 pips, one loser at −6 pips, €21 in fees. No emotion, no context, just the facts — which is the entire job of the document.
For a fully populated blotter with every column explained and a template you can copy, see our worked trade blotter example.
What a trade blotter is for
On an institutional desk
The blotter is a regulatory document. It drives daily reconciliation — checking that what the trader executed matches what the back office booked — and it is what internal audit and regulators inspect. In a dispute over an execution, the blotter is the authoritative record. It is the desk's black box.
For an independent trader
You have no regulatory obligation, but the blotter plays a role that is just as structural: it is the source of truth for your performance. Win rate, average win, average loss, expectancy, drawdown — every statistic is computed from these execution lines. If the base data is incomplete, everything built on top of it is wrong in a way no amount of analysis will reveal.
A clean blotter lets you do three things:
- Audit your executions — abnormal slippage, fees creeping up, partial fills you never noticed
- Reconstruct trades exactly — real average entry, real size, real holding time, without trusting memory
- Feed your analysis — the facts your journal then explains
The regulatory side: books and records
The blotter is not a convention. In the United States it is named in the rule text: SEC Rule 17a-3(a)(1) requires broker-dealers to make "blotters (or other records of original entry) containing an itemized daily record of all purchases and sales of securities" — with the date, the account, and the amounts involved.
Retention is governed separately. SEC Rule 17a-4(a) requires those blotters to be preserved for at least six years, the first two in an easily accessible place. FINRA Rule 4511 applies the same six-year default to records with no period otherwise specified.
In the European Union, MiFID II and Commission Delegated Regulation (EU) 2017/565 impose an equivalent duty with a different horizon: records of services, activities and transactions must be retained for at least five years, and up to seven where the competent authority requests it.
Two things follow for an independent trader. First, when a broker only exposes 90 days of history, that is a product decision, not a legal ceiling — the records exist on their side under far longer obligations. Second, the institutional retention window is a sensible personal default: keep your own exports for six years, which also covers the period during which most tax authorities can review a return. In France specifically, the reference is the six-year retention duty of article L102 B of the Livre des procédures fiscales.
This is a record-keeping observation, not tax advice — the treatment of your gains is a separate question, and one worth taking to a professional.
How to build your own
Your broker has already done most of the work.
1. Export your history. Every serious platform — MetaTrader, cTrader, Interactive Brokers, prop firm dashboards — offers a CSV or Excel export of transaction history. That export is your raw blotter. Do it on a fixed schedule, weekly or monthly, and do it before the rolling history window swallows the oldest rows. The step-by-step for the main platforms is in how to export your trading history.
2. Standardise the columns. Keep the nine required fields at minimum, in one consistent format. If you trade with more than one broker, normalise everything into a single file — otherwise your aggregate statistics are not computable at all, and multi-account traders are precisely the ones who need them most.
3. Never reconstruct it from memory. This is the failure that makes the whole exercise pointless. Prices, sizes, fees and timestamps come from the export. Memory supplies the reasoning, never the numbers.
Which tool holds the file afterwards is a separate decision, and a spreadsheet is a legitimate answer — we compare the four honest options in trade blotter software.
FAQ
Is a trade blotter mandatory for a retail trader? No. The obligation in Rule 17a-3 applies to broker-dealers, not to their clients. Your broker effectively maintains one on your behalf; using it is the fastest way to professionalise your tracking.
What is the difference between a blotter and an account statement? The statement aggregates movements — deposits, withdrawals, daily P&L. The blotter itemises every individual execution. The statement tells you how much you made; the blotter shows you how.
Is a spreadsheet enough? For the blotter itself, yes. It is a list of transactions and a spreadsheet handles that well. The limit appears at the analysis stage, once you want statistics broken down by setup, session or instrument.
How long should I keep it? Six years is the sensible default: it matches the institutional retention window and covers most tax review periods.
How often should I review it? Weekly is enough to catch execution and fee problems. Deeper analysis belongs in your journal, at whatever review cadence you already run.
Where TradeStack fits
If you want the blotter to become something you actually act on, that is the problem TradeStack was built for: entries recorded in under a minute, enriched with tags, setups and context, with win rate, expectancy, drawdown and hold rate computed automatically rather than maintained by hand in formulas.
One thing to be explicit about, because it disqualifies us for some traders: TradeStack uses manual trade entry. There is no automatic CSV, MT4, MT5 or broker API import. Your broker export stays what it is — the factual reference you check against while recording. If you take fifty scalps a day, choose something else; we would rather say so now.
Key takeaways
- A blotter is the chronological, factual record of every execution — one line per fill, no interpretation.
- Nine columns are non-negotiable; the second tier is what makes slippage, fees and multi-account P&L measurable.
- It records executions, not positions. Three clips are three lines.
- Institutions are required to keep one — six years in the US, five in the EU. You are not, which is why so few independent traders have a usable one.
- The blotter gives you the facts. Your journal turns them into progress.
