How to track your card collection's value

Log each card against its exact print and condition once, then let market prices update against it automatically. A spreadsheet works for the logging part but goes stale the moment prices move, which is why most collectors abandon theirs within a few months.

Updated 2026-08-26

Why spreadsheets stop working

A spreadsheet is fine on day one. You type in a card and the price you believe it is worth. The problem arrives in month three, when a hundred rows all hold prices from a market that has since moved and you have no idea which ones are stale.

Updating by hand means looking up every card again. Nobody does this twice.

Log which exact print you own

The single thing that makes a collection log useful later is recording which exact print you own. "Charizard" is not a record. "Charizard, Base Set, 4/102, unlimited, near mint" is.

Scanning handles this automatically, which is the practical reason to scan rather than type. The set, collector number, and variant come along for free.

Track cost basis alongside current value

Current value answers what the collection is worth. Cost basis answers whether you are up or down, which is the more interesting question and the one that matters at tax time in most jurisdictions.

Record what you paid and when, including the pack or box price if the card came from sealed product. Splitting a $120 box across the cards you pulled is imperfect but far better than nothing.

Watch a few cards rather than all of them

Most collections have a handful of cards carrying most of the value. Those are the ones worth an alert. Everything else can sit in the total and be checked once a quarter.

Setting a target price on the top five or ten turns tracking from a chore into something that tells you when to act.

Decide what counts as your collection

Collectors usually end up with three piles: cards they would sell tomorrow at the right price, cards they will never sell, and bulk. Tracking all three the same way makes the total number meaningless.

A useful split is to track the first two by card and treat bulk as a single line item with an estimated weight value. That keeps the portfolio honest without you logging four thousand commons.

Revisit the numbers on a schedule

Prices drift. A collection valued in January and ignored until December will be wrong in both directions, with some cards up and others quietly down after a reprint.

Checking the total once a month takes a minute when the prices update themselves, and it catches reprint announcements before they finish working through the market.

Common questions

Should I track sealed product the same way?

Yes, and sealed is often easier because there are fewer variables. A sealed booster box has one identity and one condition, so its price history is cleaner than a single card's.

How often do card prices actually change?

Chase cards from current sets can move weekly, especially around set releases and tournament results. Vintage moves more slowly, often in steps after a notable sale.

Related guides