Sold comps worksheet

Mark each sold comp kept or cut, with the reason written down, and get a list price range you can explain later.

Sold comps, one per linePrice, then a note. Start a line with x to cut it, and say why.42.00, used, complete 44.99 x 120, lot of 3 45.00 47.50, box worn x 18, for parts 49.00 46.00 51.99 48.00 x 89, new sealed 52.50 44.00

Your copy vs. the kept compsLots of competing listings, or I want it goneAbout the sameBetter condition, or hard to find

List at $46 to $48. Confidence is medium: 10 kept comps with a tight spread. Enough comps to work with. Add more to firm it up.

Median sold

$46.75average $47.10, for comparison

Middle 50%

$45–$4910 comps kept (workable), 3 cut. Spread 8%, tight

Suggested list price

$46–$48confidence: medium

Every comp, in the order you pasted

Line	Sold	Status	Note
1	$42.00	Kept	used, complete
2	$44.99	Kept
3	$120.00	Cut	lot of 3
4	$45.00	Kept
5	$47.50	Kept	box worn
6	$18.00	Cut	for parts
7	$49.00	Kept
8	$46.00	Kept
9	$51.99	Kept
10	$48.00	Kept
11	$89.00	Cut	new sealed
12	$52.50	Kept
13	$44.00	Kept

Show the math

1. Kept comps, sorted: 42, 44, 44.99, 45, 46, 47.5, 48, 49, 51.99, 52.5
2. Median: middle of 10 = $46.75. Average: $470.98 ÷ 10 = $47.10
3. Middle 50%: 25th percentile $44.99 to 75th percentile $48.75
4. Spread: ($48.75 − $44.99) ÷ $46.75 = 8%
5. List range for a typical copy: halfway from 25th percentile to median ($45.87) to halfway from median to 75th ($47.75)
6. Open-it flag: below $39.36 or above $54.39 (1.5 × the middle-50% width past either end)

Why write down every cut

A median is only as good as the comps behind it. The lot of three, the for-parts unit and the sealed one don't belong next to your used copy. Cutting them is the job. Writing why is what lets you trust the number a month from now, when the item still hasn't sold and you're wondering if the price was wrong.

So nothing gets dropped silently here. Every line stays in the table as Kept or Cut, with your note beside it. Download the CSV and you have the record.

How to mark the comps

• Kept: just the price, with an optional note. 47.50, box worn
• Cut: an x first, then the price, then why. x 120, lot of 3
• Paste sold prices only, not asking prices. How to see sold items on eBay shows where they are.

Cut on the five things a comp has to match: identity, condition band, completeness, size or variant, and recency. What makes a good sold comp goes through each one.

The math

Confidence uses this site's rules of thumb from median and outliers: under 8 comps is provisional and 15 is comfortable. A spread under 25% is tight, 25% to 60% moderate, over 60% very wide. They're rules of thumb, not a standard. High means 15+ comps and a tight spread. Low means under 8 comps or a very wide spread.

What it can't see

It can't tell a lot from a single sale, or a used copy from a new one. That's what your x and your note are for. A very wide spread usually means two products or two condition bands are mixed in the list. Split them and run each one. If your copy is in worse shape than the clean comps, the condition price range tool works out what that costs.

Questions

Related

• Condition price range: What your copy should sell for once its condition is priced in, and whether it still pays at the low end.
• No-comps price ladder: A dated markdown schedule for an item with no sold history: start high, cut on fixed days, stop at your floor.
• Comp analyzer
• What makes a good sold comp
• Median, outliers and spread
• All What's It Sold For tools