It’s been a while since I mentioned iGPC. I haven’t done much, but I did have a nice chat with JJ from VGPC who kindly informed me I was
Still, I recon I have an up to 50 times head start. Bonus points to JJ if he figures out how/why. Or even reads this. So, I went about cleaning up some code, removing debug scripts, changing the price grabbing to include the total for all BiNs, Best Offers and Auctions (it previously would only do Auctions unless there were none). And then running some automated updates.
Nice to see a new game at the top of the PS2 price charts. FWIW, it hasn’t updated today as no sold listings were found. Unsold ones may have been, but they’re now completely ignored for a few technical reasons. Anyway, code wise, iGPC is now about one cron job and 18,000 game entries away from VGPC’s crown
Anyone fancy a data entry job? You can start with this lot:
http://inaudible.co.uk/games/files/psprices0810.ods
My gift to the hoarding world. Around 1266 PS2 games, 433 PS1 games, and related accessories (give or take the odd multiple entry) with eBay UK auction sale prices hand compiled since 2008. Still roughly accurate, although some are over two years old. It’s in OpenOffice.org spreadsheet format; it’s free, so get downloading
Description of fields:
* Date of last price update (anything without one is *real* old).
* Name.
* Minimum observed sold auction.
* Maximum observed sold auction (older entries won’t have one).
* Minimum profit to be made on eBay if selling at min value (it dose a rough job at calculating and deducting postage/fees from the min price).
* Computer Exchange trade in value.
* Calculated average price from min and max prices.
* Rough stamp cost (anything that’s not 0.76p probably isn’t accurate).
* Calculation of eBay fees for each item, based on the average value and stamp cost plus paypal and ebay percentages and insertion. Again, a rough guess at what gets taken off the final price.


I think these are some great improvements to your process and data gathering. I’m sure it will give you much more data and much better data too. It was great talking with you about your project.
Hey JJ, nice to see you here
I’ve just run an update on all prices. I have the time for 775 updates, was around 520 seconds. I would have it for all 1775 but for some reason the time wasn’t echoed to my debug file once it finised looping through all the entries. Around 20 minutes though. Which puts it around 3 and a half hours for 17,000, which I think is pretty good
The 50 time head start thing is, I’m grabbing a completed item page with (up to) 50 completed items listed on it. So for 50 items I only have to do one wget and parse. You’d be doing that 50 times I think. Data isn’t as accurate, but it does me fine. Then again, I did just spent another 10 minutes (un)changing the parse string due to an ebay template change, after doing the same thing a couple days ago. If I had time to look in to the api, I’d probably be doing it about now…