admin wrote:
[*] Unless the prices have remained flat since 2004, average will
overestimate price drops and
underestimate price increases.

Could be improved by using moving averages or "X most recent" when available.
I made a quick update to
only consider the most recent used/mint/sealed transaction prices for each title and updated the Collection stats.
Approach is the same: no past sale = $0, mint by default, and mint by default if used or sealed data are not available.
Quote:
Collection value based on all historical data: Min $x.xx - Average $y.yy - Max $z.zz
If only the most recent transactions are considered: $x.xx
Re-evaluating the total in collection as of today with the average method, we are now at:
Min: $10,115,223.67
Avg: $10,614,213.85Max: $11,317,750.83
And the "last prices" method shows that recent prices are slightly below their historical average:
$10,446,546.93Julien