tcg_collection_value_with_market
Calculate cost basis and current market value for your TCG collection by matching owned cards with recent pricing snapshots. Shows unpriced items to track what's missing.
Instructions
Cost basis + live market value across the collection.
For each owned card with an attached pricing listing, we look up the
most recent pricing snapshot (matching the card's grade for graded
cards). Cards without an attachment or without a snapshot land in
unpriced_count so you know what's missing.
Run tcg_pricing_snapshot periodically to keep the join fresh.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |