How to Track LEGO Collection Value and Investment Returns

A useful LEGO collection value tracker has to answer two different questions: what would the collection sell for today, and how well has the money invested in it performed? A simple list of retail prices answers neither.

The practical approach is to track each set as an individual position. Record the set number, purchase date, total cost, condition, completeness, and the market used for the latest valuation. This makes the collection auditable and prevents a sealed set from being compared with a built copy that is missing its box.

Start with set number and condition

The LEGO set number is the safest identifier. Names change between regions and are often reused in marketplace listings. Store the number first, then add the official name, theme, release year, and retirement status.

Condition needs more detail than “new” or “used”:

• Sealed with a clean box
• Sealed with box wear or damaged seals
• Open box with sealed bags
• Complete and built, with instructions and box
• Complete without box
• Incomplete or used as parts

These states can have materially different resale values. Do not apply the sealed price to every copy of the same set.

Record cost basis correctly

Cost basis should include the amount actually spent to acquire the set: purchase price, tax, shipping, marketplace fees, and any replacement parts needed to complete it. Manufacturer retail price is useful context, but it is not your cost basis unless that is what you paid.

For each set, calculate:

1. Current value minus total cost for unrealized gain.
2. Unrealized gain divided by total cost for simple ROI.
3. Holding period in years for annualized return.

Annualized return matters when comparing a retired set held for six years with a newer set that moved quickly. A 30% gain over one year is different from a 30% gain over five years.

Choose comparable prices

BrickLink can help establish condition-specific marketplace prices, while recent completed sales on broader marketplaces can show what buyers actually paid. Use the same condition, region, and reasonable date window for every update.

Avoid three common errors:

• Treating active asking prices as completed sales
• Mixing sealed and used copies in one average
• Valuing an incomplete set as complete

For rare sets with few sales, record a range and the date instead of pretending the value is precise.

Add retirement and liquidity context

Retirement can affect supply, but it does not guarantee appreciation. Record the retirement date separately from the valuation. Also record how frequently comparable copies sell. A set with a high theoretical value but almost no buyers is less liquid than a popular set with weekly sales.

Review the portfolio monthly or quarterly rather than reacting to every listing. The useful dashboard shows total cost, current value, top movers, category concentration, and the percentage of value held in sealed versus opened sets.

A spreadsheet structure that lasts

At minimum, use these columns:

set number, name, theme, condition, purchase date, total cost, current value, valuation source, valuation date, retirement status, and notes.

Once the collection grows, manual price updates become the bottleneck. That is the point where a dedicated LEGO investment tracker becomes more useful than adding more spreadsheet formulas.

CollectFolio is being designed to combine LEGO holdings with cards, watches, and vinyl while preserving category-specific fields. Join the waitlist if that matches how you collect.