General Category > General Discussion
Collection Price/Appraisal?
madrocsz:
Title says it all, wanting to know if anyone knows an easier way to put a value on your collection, mainly for insurance purposes but also so wife gets off my case about it.
I know that w/ vgpricecharting.com you can do so, but compiling a list is quite tedious
Also, I use game collectorz and I know I can manually input prices but again, thats 1 by 1
Just curious if anyone has attempted to do this with a larger collection or has any suggestions of how I might accomplish this.
zygmuray:
Im not sure what you have for a collection,
But if you have a system that is pretty close to complete instead of 1 by 1 you could always copy and paste the whole list from video game price charts into an excel speedsheet and just use the "sum function" to get a rough value.
Again this is completely relying on if you have the whole system or close enough to delete the games you dont have.
shenske:
--- Quote from: madrocsz on March 07, 2013, 01:20:07 AM ---..... but also so wife gets off my case about it.
--- End quote ---
Didn't you mention once that your wife works at gamestop? I'm surprised she'd be on your case about it :P
mojoeskateco:
--- Quote from: madrocsz on March 07, 2013, 01:20:07 AM ---Title says it all, wanting to know if anyone knows an easier way to put a value on your collection, mainly for insurance purposes but also so wife gets off my case about it.
I know that w/ vgpricecharting.com you can do so, but compiling a list is quite tedious
Also, I use game collectorz and I know I can manually input prices but again, thats 1 by 1
Just curious if anyone has attempted to do this with a larger collection or has any suggestions of how I might accomplish this.
--- End quote ---
I'm not sure if this is doable but you could try:
1. Export an online price list to excel
2. Export your collection to excel from your collectorz software
3. Use the Vlookup function in excel to match game titles from your collection spreadsheet to the price list spreadsheet
4. Work the Vlookup formula so that when it finds a match with the price list that it looks to the next cell to get the price and inputs that value beside the title on your collection list spreadsheet.
It would be nice of the software updated the prices for you.
Like every time you log in checks a pricing site and updates the values.
The other issue is once you get this working there's so many other things to take into consideration such as completeness, condition, sealed, packaging version (i.e. greatest hits) etc.
I may try the excel thing on my lunch break ... the nerdy accountant in me is getting curious if this could work.
SnesGuy:
I've just slowly been doing it on game collector pro as I have time. Only have prices in for my consoles and I am at $2,500 (based on selling price)