I was able to quickly make these graphs from the website data. 1st edition Charizard and Blastoise have exploded in the last year. It will be interesting to explore other cards/grades and see where the prices go in the future.
2 Likes
Glad you’re finding the data useful. The plan is to have graphs like that for every card so you won’t need to manually create them soon 
3 Likes
I figured this will be coming eventually. It will be an awesome tool.
How did you pull the certification number? I would image it’s not in plain text for any of the eBay listings. Did you have to do some image processing?
Nothing fancy haha, I’m gonna copy and paste what I posted above because @zap2 asked it the other day 
All the data is scraped from PSA’s auction prices section, so I don’t really need to worry about reading cert numbers and stuff because it’s already done for me. If the auctions aren’t on their site then they don’t get recorded in my database.
1 Like
This is fantastic work! can’t wait for the finished product.
- one tweak I would add (if you haven’t thought of it already - and if it’s possible) a search tool that finds the mean average of each card / PSA grade, from a choice of the last 3 / 6 / 12 / 24 months or 3 / 5 / 10 sales?
It could go at the top of each card page or perhaps on separate ‘set’ page that shows the mean average of all the cards / variations / grades from the set.
This would be help show data more clearly and quickly for those wanting to get a better picture of trends and values from short to medium term but also towards speculating future value.
I just “borrowed” your spreadsheet to look at Fossil 1st editions (one i’m currently collecting) and, in excel, quickly formulated the data. It was a great indication to quickly work out how much all the holos could theoretically cost and how much each one would be too - very useful to now know my price points when bidding or BIN on eBay etc.
Hope this helps.
Cheers.
1 Like
Very interesting - the spike lines up with christmas too so somebody got a great christmas stocking!
Wonder if it will hold / drop as quickly as it rose or rise even more…
My interest lies in the later sets and to see what is worth investing in now for the next 5-10 years (Base Unlimited / Jungle 1st / Fossil 1st / Team Rocket 1st). Base 1st / Shadowless have edged out of my price zone for completion now.
1 Like
I have been planning to make a web app to record sealed sales, mostly for sealed product sales as i am gathering funds to purchase a ex booster box. Looks like i have been beaten to it. Well done @pierce
2 Likes
You were way 2 slow, bro
5 Likes
Classic 
Still think there may be value in creating this when I have time. Bogged down in a Spotify Data Visualiser at the moment. Could reuse some of the services with a PokePrice web app. Will be a vast different in data throughput though. I haven’t even look about how to scrape data from auction sites such as eBay and YahooJpn. The current sites available are lacking in accuracy and not particular functional in my opinion. Could possibly a Heroku datastore to speed up the process.
Getting sales on sealed data would definitely be valuable since this website will only provide us with info on PSA graded cards (which is probably a great majority of what all of us are interested in). I played around with eBay’s APIs and it would be very difficult to do something like this through scraping eBay. Let me know if you come up with something.
How often is the data going to update?
It updates every 5 days but I can change that, I will probably swap it to daily once I upgrade the hosting plan. I can trigger an update manually anytime.
My bad, I just thought if I read the pop report update date that would be the date for everything.
“Population Report (as of Thursday, March 15, 2018)”
But I guess they are scraped on separate schedules
Ahh no that dates wrong, it’s a bug, I’ll fix it when I can Thanks for pointing it out.