Fill Quality CSV Template

Evaluate zero-commission brokers, Direct Market Access (DMA), and prop firms. Compare order routing quality, slippage, and spread consistency for high-volume scalping.
Post Reply
NYC88
Posts: 50
Joined: Sat Sep 05, 2026 7:19 am

Fill Quality CSV Template

Post by NYC88 »

You cannot improve what you refuse to measure. This CSV is boring on purpose. Boring is how I stopped arguing with marketing pages.

I used to "feel" fills were fine. Then I logged them for two weeks and found OPEN15 was quietly taxing me more than my edge. Feeling retired. Sheet stayed.

### Header

Code: Select all

date_et,time_et,ticker,side,order_type,intent_price,fill_price,shares,slip_cents,spread_cents_at_send,venue_or_broker,session_tag,setup_id,notes
### Definitions (so we argue about the same thing)

- `intent_price` — price you accepted when clicking (mid, bid, ask, or trigger — note which in `notes` once per style)
- `slip_cents` — signed from your perspective (adverse positive as cost)
- `spread_cents_at_send` — snapshot discipline beats vibes
- `session_tag` — `OPEN15` / `AM` / `LUNCH` / `PM` / `AH`

### Example rows

Code: Select all

2026-09-04,09:34:12,EXAMPLE,B,MKT,12.50,12.53,200,3.0,4,BrokerA,OPEN15,OR_HOLD,chased break
2026-09-04,10:12:44,EXAMPLE,S,LMT,12.80,12.80,200,0.0,2,BrokerA,AM,OR_HOLD,limit joined ask
### Weekly rollups I actually run

Code: Select all

avg slip by session_tag
avg slip by order_type
avg slip by ticker (min 10 samples)
% fills with slip > your max
median slip OPEN15 vs midday (same ticker)
### Rules for posting here

Aggregate stats OK; no account numbers. Compare **same** order style when blaming a broker. 30+ fills before hot takes. Changed platforms mid-week? Split the sample.

Sticky because every broker argument without a sheet is theater.

Are you logging slip today, or still going on feel?
What's your median OPEN15 slip vs midday on your top name?
Marketable vs limit — which order type is quietly costing you more?
30-fill sample before opinions — agree, or do you shoot from the hip?
Post Reply