admin wrote:
Passing the 10,000th LD sold soon (added a countdown for fun), I might work on a little engine giving an approximated price when some transactions do exist.
... and 11 years later we passed the 63,000th and I finally sat down to write a little bit of SQL to try to answer the OP question.
If you go to
your OWN collection page (
others can't see it, only YOU can), you will see a new line in the
Useless Statistics:
Quote:
Collection value: Min $x.xx - Average $x.xx - Max $x.xx
Now, these values probably don't mean much but here is how they are constructed.
- If there is no past sale statistics for a title, it will NOT be accounted by lack of data (value = $0).
- If you haven't provided a grading/status (1 to 10) in your collection, default value will be MINT average, if missing refer to A.
- If you have provided a grading/status, then the default will be their respective USED/MINT/SEALED averages. If USED or SEALED does not exist, then MINT will be used, refer to B.
This should ensure that MIN <= AVG <= MAX and if you haven't provided any grading, then MIN = AVG = MAX.
The underlying sales stats are refreshed periodically.
A better approach might be to use the latest transactions instead of the average since 2004 but I do not have a pre-calculated table available for this, it will need to be generated separately.
Julien