Now that we are the full swing of Extended I thought it was time to add it to the Buy List data mix. I would like think that eventually we’ll be able to use some of the data from the Buy Lists as predictors of what cards and decks are going to be hot and I am continuing to work toward that goal. (I’ll need some programming muscle and better computers to pull that off but that’s another topic).

In an effort to make sure that my underpowered notebook can process the new spreadsheets I have segregated the Standard calculations from the Extended ones. This means a little bit more work for presentation, but it also means that I can maintain them separately. There should be no overlap in cards between the two formats and there are separate master lists for each. I've recombined many of them to display the results, but some of them have remained separate.

I would like to thank TCGPlayer for their retail price coalition, Magic Traders for their eBay data, as well as Cool Stuff Inc, Troll and Toad, Starcity Games, Channel Fireball, Card Haus Games, Altereality Games, Strike Zone, MTG Mint Card, ABU Games and of course Kelly Reid’s Dragons Den Online for their online buy lists.

First up, we have our Top 30 lists. I have combined this one into a single Top 60 covering both Standard and Extended. I can however move them back into separate lists if it is preferred.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=9&output=html&widget=false 567px 600px]

Jace, the Mid Sculptor is still sculpting the minds of players it seems. Until it rotates, Jace TMS can’t really mathematically hit more than about $140 or so for a mid-level sell price but I wouldn’t be surprised to see him average above $100 for the next 3 years. Holding an average buy price of almost $70 is a really good indication and justification of his sell price. If stores are willing to sell at less than 30% margin on such an expensive card then the demand isn’t dropping. The Standard cards Primeval Titan and Vengevine round out the top three with Thoughtseize and Mutavault from Extended completing the top five. With buy prices of up to $25 and $20 for each of those Extended cards it might be time to dust off the playsets and sell them off to fund your other decks. There are quite a few decks that they fit into though so hanging on to them until later in the season also might make sense.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHBQUVVmRUdEbFpuaE14Zk5rYmhGUkE&single=true&gid=3&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=3&output=html&widget=false 567px 600px]

Our Standard Mythic list is pretty well populated. It seems that almost all of them are sought by some if not all the online stores being tracked. The notable exception to this being that at the time of writing MTG Mint Card isn’t interested in Scars of Mirrodin. Some of the sets in Extended don’t have Mythics so we are left with a list of the sets that rotated back in October. The slimmest margin for retailers seems to be that of Nicol Bolas Planeswalker. To look at these magins I’m bringing back the Womby List except this time I'm running the numbers against not only eBay prices, but also a cross section of online stores as well.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=11&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=13&output=html&widget=false 567px 600px]

The First list gives us a ranking by percentage delta of those cards which are on Buy Lists for a price that is higher than the average eBay price and the second is the same but based on Store pricing. I’m not suggesting that you could necessarily go out on eBay and buy up all these cards and send them off to stores for a profit. In some cases you certainly could, especially if you get a good enough deal on eBay, but it might not be possible since you have to take shipping into account as well. This list should however be a good guide for cards to either trade for or have thrown in on trades that can make you a quick buck or two. Be smart about it, but there is a lot of usable information here. There are quite a few cards selling on eBay for prices lower than some of the buy lists. Liege of the Tangle tops out the list with a 71% delta, though at the time or writing there are a total of 25 cards that are cheaper on eBay then the high buy prices within this Mythic list alone. On the store side Jenara, Asura of War is the only card of note meets this criteria. In fact the Stores lists plays out like a listing of dead cards in a trade binder to me. We might as well cash them in!

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHBQUVVmRUdEbFpuaE14Zk5rYmhGUkE&single=true&gid=5&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=5&output=html&widget=false 567px 600px]

Here we have the full list of Standard and Extended Rares in alpha order by set. If you want to look something up, this is the place.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=14&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=15&output=html&widget=false 567px 600px]

Once more we have some Womby Lists, eBay and Stores. These Womby lists are a bit more useful though. There are a ton of rares that can be picked up cheaply and sold off to online retailers, even from the Stores lists. Cards like Blood Tribute and Cruel Ultimatum can be purchased low enough from some stores that selling to others might be profitable. There are in fact 23 cards at the time of writing that were less at some stores then other stores Buy Lists. There are a lot more Rares to calculate then there are Mythics so I’m not pulling them all in, but there are certainly enough on this list to be useful.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHBQUVVmRUdEbFpuaE14Zk5rYmhGUkE&single=true&gid=7&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=7&output=html&widget=false 567px 600px]

Above are the complete Uncommon lists.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=17&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=18&output=html&widget=false 567px 600px]

I’m pretty surprised that there aren’t more Uncommons than Rares that are above the threshold, but we’ll be able to watch and see how that might change over time.

Just for the sake of being thorough here are the commons in alphabetical order by set.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHBQUVVmRUdEbFpuaE14Zk5rYmhGUkE&single=true&gid=8&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=8&output=html&widget=false 567px 600px]

And here are the Common Womby Lists.

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=24&output=html&widget=false 567px 600px]

[iframe https://spreadsheets.google.com/pub?key=0AukC5EWiTvOpdHlrdUpHbnZYeWZFb1NReXo1ODROa0E&single=true&gid=25&output=html&widget=false 567px 600px]

Preordain seems like a really god card to sell of if you have some extras, but the same is true with quite a few of the commons that are being picked up right now since three of them are being acquired for over $0.50.

That about does it for this week. If you guys have anything in mind that you'd like to see or a different way to arrange the data, let me know.

Magic Analyist
Chris McNutt
Level 1 Judge
@fatecreatr on Twitter