Welcome to another action packed edition of The Nutt Draw! I’m starting to come down with a cold or flu or something, so you better sit further away from the monitor than usual… I don’t want you to get sick too.
After the last article I took in all the data and answers and start working on tuning things a bit more toward what the folken are clamoring for and came up with some new things that I think you’re going to like. There are going to be a lot of instructions and caveats, but please read them all, it will make things go a little smoother.
First off we have the obligatory barrage of data. My usual source data for prices has been corrupt for weeks and it’s forced me to do some re-imagining. For now, I can’t generate the data for the Demand Index numbers or the Womby List, but I’ll have those back online as soon as I can. Because the survey indicated that the most interesting articles were those centered around Buy Lists I’ve taken that on as my first rebuild. My spreadsheets were getting too large, so for now I’ve decided it would be best to only present information for the Standard format. I intend to bring Extended online sometime before the Extended season officially kicks off. It will just come down to having the time to expand the sheets. Our first chart is of the top 30 cards in Standard sorted by their average buy price.
[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdGREaGlyaHhfOWU0OXBRWmVhUDItbWc&hl=en&single=true&gid=1&output=html&widget=false 567px 600px]
There aren’t really any surprises on this list. Well, there were some surprises but they turned out to errors so I had to fix them… AdventuresOn/BlackBorder lists their prices a little strangely (I had to correct for the fact that they list the cards below $1 in whole numbers with no decimal point, so Haunting Echoes was coming up at $20 instead of $0.20.) I hope you are all pleased to see that I am now tracking 10 buy lists which makes the chart very wide. Currently being calculated we have, in no particular order, Cool Stuff Inc, AdventuresOn, Troll and Toad, Starcity Games, Channel Fireball, Card Haus Games, AlterReality Games, Stike Zone, MTG Mint Card, and ABU Games.
I’ll link to the full printable list below (as well as these other charts) but I wanted to embed the charts that I divided by rarity. These can be pretty interesting to look over and might also be a bit useful. We’ll start off with Mythics.
[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdGREaGlyaHhfOWU0OXBRWmVhUDItbWc&hl=en&single=true&gid=3&output=html&widget=false 567px 600px]
Across the 10 vendors being tracked, every single Mythic card is on a Buy List somewhere. ABU games seems to be the only one currently buying them all, but several others are acquiring nearly all of them. I can’t imagine why Starcity might not need any Cast Through Time cards right now…
[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdGREaGlyaHhfOWU0OXBRWmVhUDItbWc&hl=en&single=true&gid=5&output=html&widget=false 567px 600px]
At the time of writing this 229 of the 247 Rare cards in Standard are also present... so all you Rare drafters out there are hate drafting a gold mine.
[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdGREaGlyaHhfOWU0OXBRWmVhUDItbWc&hl=en&single=true&gid=7&output=html&widget=false 567px 600px]
[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdGREaGlyaHhfOWU0OXBRWmVhUDItbWc&hl=en&single=true&gid=8&output=html&widget=false 567px 100%]
There also seems to be a decent amount of cash available in Uncommons with 120 of the 280 on the list as well as Commons with 109 of the 463 listed. (By the way, I think my sheet is cutting off the commons at 100, but I’ll get it fixed.) Maybe one day I’ll be able to incorporate so many buy lists that every card will be accounted for?
Here is that link I promised you so you can view and print them all on one page…
And now with the appetizer out of the way I bring to the two final courses in this article. These are far from perfect, but I think they are still very useful, and it’s the best I can do using Google Spreadsheets at the moment.
First is a template that allows you to enter in card names and get back a printable sheet with all the current prices on them. The idea is that you can enter in some of the key cards in your trade binder as well as some of the cards that you’re looking to acquire and bring the list with you to your FNM or other event. You can of course use this online as well, but data entry on Google Docs isn’t very good on the mobile phone platforms right now. You could always enter them from a computer and then just look them up on your phone though I suppose.
The second and last bit of new hotness is a similar tool I whipped up that deals with buy lists. On this one we can really see the limitations of complex online spreadsheets. It’s a bit finicky, you’ll have to wait for it to load and if you enter things too fast it might not catch it in the update. Enduring these little hitches though will give you two sorted lists. The first is a list of the best places to sell your hate drafted treasures for the most money, and the second is a list that details out the most money you can get if you’d prefer to deal with fewer buyers.
I can think of a lot more features I’d like to add to these sheets but I’m pretty limited by the abilities of the online sheets.
So here are some things you need to keep in mind with these spread sheets.
2. None of the editions are required to enter, but I included the functionality to deal with reprints.
3. If it seems like they glitched out, refresh the page, your entered data should be safe.
4. They are not very fast, so be patient.
5. I have written them in such a way as when I refresh my source data, the templates associated with your personal Google Docs account will be refreshed too. If I add vendors or features (or you find it broken) come back and get a new template. I’ll continue to advance the version numbers.
6. Edit only the YELLOW cells. There isn’t a way for me to protect the formulas in the other cells so I have marked the safe ones in yellow and hid as many of the others as I could.
7. If you’re having any issues I didn’t cover here, please let me know in the comments, I’ll respond as fast as I can.
[iframe https://docs.google.com/embeddedtemplate?id=0AukC5EWiTvOpdHpkY3ljQ2pXRGlkRVd2RURKNnRLUFE 567px 210px]
[iframe https://docs.google.com/embeddedtemplate?id=0AukC5EWiTvOpdGljVTRBeHpXQVpzNUVfaWF6Nnk3SVE 567px 210px]