menu

Insider: Organization and Tracking Specs

Are you a Quiet Speculation member?

If not, now is a perfect time to join up! Our powerful tools, breaking-news analysis, and exclusive Discord channel will make sure you stay up to date and ahead of the curve.

Welcome back, readers!

This week's article will focus on the subject of organization, specifically in regards to your specs. As someone who previously evaluated cards and purchased them (and then let them sit in a box or binder) until one day I noticed they'd gone up, I wasn't always so organized. Even just a year or so ago, prices kept jumping up so there wasn't always a noticeable cost to my apathy. However, with the recent shifts in the MTG finance marketplace I'm realizing now that cards can actually go down in value even without a reprint.

I know if you'd read this a year ago, you'd think I was crazy. A rampant run of speculation in preparation for what was expected to be a major boon this past summer caused prices to balloon out of control, and likely push potential Modern players out of the market.

But that's a different matter--the point is, we've all seen that the market can only take so much, and in order to maximize our profits we need to be on top of everything. It's time consuming to keep on top of the constant metagame shifts in multiple formats, and time is a variable that is always limited so proper organization of our specs is critical to reducing inefficiencies.

Tracking Your "Stocks"

I often try to mention the similarities between MTG finance and the stock market and that's because I believe that a lot of strategies and concepts can be shared between the two (though to be fair a lot more of these have been well documented and discussed with regards to the stock market). That being said, I looked for a good "stock tracking" spreadsheet to use as a skeleton for my MTG spec tracking. If you want a "blank copy" you can find it here.

MTG Stock Portfolio - blank

Here's the sheet that shows all my MTG purchases through November of last year (I wanted to display it in tabular form, but unfortunately there was simply too much information and our screen size is limited).

MTG Stock Portfolio - 8/18/14

As you can see I'm only averaging 11.5% gains (which isn't terrible), but I have a lot of "red choices". It is important to note that several of the red options are repeats. It's also important to keep in mind the biggest outliers (most of the temples and the Dictate of Erebos's) were meant as longer-term holds and the expected time to sell hasn't hit yet--the temples are for after RTR block rotates out and the Dictates are a 2-3 year investment.

However, that isn't to excuse my choice to purchase them when I did, especially the Dictates. I got excited watching people get blown out by them in Limited and realized that Mono-Black Devotion style decks were currently the best option for the competitive player, so if the Dictate found a home it would likely jump to $4-5 each. Unfortunately, for me, this didn't occur and their price has dropped dramatically since prerelease times.

Consider this a lesson in patience, with very few exceptions--pre-ordering is a bad idea and even then the cost of waiting is rarely that bad. My biggest hits were Slaughter Pact and Hurkyl's Recall, both of which I purchased right after returning from GP Richmond (the first Modern GP of the year) where dealers were out of both cards and people were constantly asking me for them.

This is just another example of patience paying off, as these cards didn't really start to take off immediately. There was a week or two when you could have picked them up cheaply (and in Hurkyl's case, it just had a nice steady incline).

slaughter pact stock

hurkyl's recall stock

Now back to the spreadsheet. Most of the columns are pretty self explanatory, though I do want to highlight the "card profit" column. This refers to a "price from my door to your door" concept, meaning seller fees and shipping should always be factored in. Now to explain the equations (I'm assuming you did in fact download the sheet).

Total Cost = (Quantity * Cost per Item) + Purchase Fees [This represents the total cost to acquire the cards]

Market Value = (Current Value * Quantity) [This represents the current value of the cards if you were able to sell them for TCG Mid cash in person (i.e. no fees)

Market Value At Sale = (Value At Sale * Quantity) - Sales Fees [This represents the total amount of money youĀ receivedĀ selling the cards, however not the profit]

Gains/Losses ($) = ((Market Value at Sale (if Cell N# is not 0 else Market Value) - (Total Cost)) [This represents your actual gains or losses, actual or theoretical (if you were able to sell the cards at market value with no fees)]

Gains/Losses (%) = This is the Gains/Losses number above but in percentage form (as that's often a good way to normalize your data).Ā 

You certainly don't have to use this spreadsheet, but I'm finding it helpful in tracking myself. I will be saving a copy and updating the Current Values in each cell every week to track my progress. I did get the basics of this sheet from microsoft (http://office.microsoft.com/en-us/templates/stock-investment-performance-tracker-TC001023352.aspx), but had to add some columns and change the equations around.

Understanding Your Gains and Losses

Like reviewing your play mistakes during a match, it's just as important to review your mistakes speculating. As I mentioned, I missed hard on the Dictate of Erebos's (averaging nearly a 40% loss) and I did well on Slaughter Pacts. What is critical to keep in mind though is that we're not all going to hit 100% of the time. What I really like about this spreadsheet is the "Difference" calculation, which lets you know the total value of your assets currently compared to what you paid for them.

Again, as previously mentioned I'm sitting at +11.5% which for about a nine month time span isn't terrible, though it is misleading as I haven't sold many of my assets--assuming I could do so at current market value and with no fees is quite a stretch. It's far more likely that if I were to sell out of my cards I'd be very much in the red.

Luckily, you can only lose money invested when you sell your investments (a lesson my father taught me at a young age). While my Dictate's didn't pan out, I still think my reasoning was sound. It does seem like a card that can easily break the mirror, there's just no room for it in the current environment.

I pre-ordered the "souls" of M15, primarily because they were all relatively cheap and with the exception of Soul of Theros they have not dropped a lot. This investment was more of a calculated risk. I do rarely pre-order as it's shown time and time again to be a money-losing proposition; however, if any of these cheap mythics did break out in the upcoming PT, they would likely quadruple or more in price (and thus push me into the green). I also didn't buy any M15 boxes and wanted to build my quirky decks for Standard, and the souls seemed like cards you can build around.

You'll also notice that with the exception of Dictate of Erebos, I don't order a lot of any one specific card (usually). This keeps my portfolio diversified, preventing me from taking devastating losses when one doesn't pan out (again..usually). However, this conservative approach also means I don't make a ton of money when one does hit.

My "MTG investment philosophy" is not tied to paying rent/travel/food/insurance/etc. I do it simply because I enjoy it, and because unlike stocks, I feel I have a pretty good grasp of MTG and I'm much more excited to discuss this subject than normal stock investments.

Quick Flips

While I understand the allure of "quick flips" (like Goblin Rabblemaster from the last Pro Tour), my problem is I don't have a quick out for any cards--no online or brick-and-mortar store front. Thus, a card could go from $1 to $4 in a three day time span, but if the buylists for each card don't adjust quickly (and they usually don't) you can be left with a lot of the "theoretical" profits mentioned above, but no real money.

The highest buylist on Goblin Rabblemaster right now is $1.50. Unless you found a seller with a large quantity in stock when they were under $1, you likely paid almost that per copy when you factor in shipping costs. This is the danger behind the "bulk to $4' cards and one of the reasons you don't see any of those buys on my chart.

Reprints

I also want to emphasize that my reasoning behind Dictate of Erebos was partially blinded by Standard potential and comparison to Grave Pact.Ā The latter, despite six printings, is a $10 card and Dictate is pretty equivalent, if not slightly better due to a less restrictive mana cost and flash.

I also assumed that because it had a plane-specific character in its name that it would have a lower likelihood of being reprinted, however, with M15's release we saw both a new Avacyn and a new Ob Nixilis, both of which were characters specific to their own planes.

With this change in core set design philosophy, I am becoming more weary of long-term specs as my previous analysis regarding reprints shows a typical 27% drop in value when a card is reprinted. This will likely increase with the increase in print run sizes (after all if there are more of the original printings around then another mass reprint requires a substantial increase in demand for the value not to plummet).

6 thoughts on “Insider: Organization and Tracking Specs

  1. “With this change in core set design philosophy, I am becoming more weary of long-term specs ”

    It is NOT a change. Core sets have ALWAYS had plane-specific cards. Most were reprints, but even ignoring those, we’ve had plane-specific cards for YEARS at this point:

    M14 had Into the Wilds (Zendikar), and anything “Thune” or “Xathrid” and all the slivers are all set on Shandalar, specifically. M13 had odric, krenko, and so on – characters from particular planes. Even M11’s Elixir of Immortality had Baron Sengir in the flavor text.

    (Also, “wary”)

    1. Fair points, but Krenko/Odric etc. weren’t characters we previously had cards for (like Avacyn and Ob-Nixilis), so most players wouldn’t know any of that (only the ones who read the literature), whereas, a lot more players recognize the characters that had previously been different cards.

  2. Thanks for sharing that document; it’s the meat of the article. I wanted to point some things out: The price you picked the cards up at was in cash, the gain/loss you show are if you are able to sell the cards without paying any fees. Once you factor fees in, or the price you would have to settle for to buylist the cards, your 11.5% gain most likely turns into a loss, or maybe somewhere around a break even.

    I know a lot of these haven’t reached the time where they are expected to pay off yet. Maybe revisit this in October. I do notice a lot of cards you picked up at or near release, and that seems like a violation of the rule that 95% + cards go down after release. The odds are so stacked against making gains on cards when they come out that I generally wait at least a month or 2 before I even attempt to pick up anything from a new set for speculative purposes. I would have to be very sure of myself to go in on a card when it comes out.

    I know it’s old hat, but I like seing explanations as to why each card was being speculated on.

    Also, how do you feel about Temple of Mystery as a spec with the Clash pack version out.

    1. Thanks for the reply. I did repeatedly mention that the gains/loss were a bit off because of that “Itā€™s far more likely that if I were to sell out of my cards Iā€™d be very much in the red.”

      I did pick up quite a few near release and I agree that 95% of the time that’s a no/no (and these picks were no exception). I did state in the Understanding your Gains/Losses section that I pre-ordered the Soul’s because they were cheap mythics and while there was a liklihood that most would drop, if one did break out, it would likely cover and beat the “red” from the others. This obviously did not occur, however, I felt there was potential and I took the risk. The same can be said of Dictate of Erebos (which I mentioned above the Slaughter Pact/Hurkyl’s Recall charts) that I felt it had the potential to be a star (given it added 2 devotion to black, serves as a card that turns all opposing removal spells into 2 for 1’s (unless they have no creatures) and that Grave Pact’s price of $10 meant that it had solid long term potential. I quite honestly figured the floor on it was probably $1.50 (due to it’s casual appeal) and was simply off on that.

      As for Temple of Mystery, it’s printing in the clash pack will obviously affect potential gains in the future, but as you can see compared to what I paid for them it’s reprinting hasn’t lost me actual money (potential money almost assuredly, but it’s impossible to calculate that).

      I plan on playing a more active roll in my cash purchases moving forward so I will definitely be revisiting this spreadsheet in future articles.

      1. Fair enough, thanks for the explanation. I’m also on the Dictate of Erebos plan, I just didn’t consider it for standard. I haven’t picked up many copies yet; I try to pick up cards with a buylist on magictraders.com, but I haven’t had too many nibbles on Dictate of Erebos. I may have to buy a chunk off TCGplayer to get into enough of them. The enemy color temples stand to be in the highest demand since enemy color pairs show up more than allied color pairs in the new wedges, so I’m trying to pick up as many of those as possible. For some strange reason, people have been reluctant to sell the Temples of Mystery even though I’m offering a good price on them. I may just have to buy those on TCGplayer as well.

        Your pickups of M15 souls could pay off big if they do hit considering how cheap they are right now. I think it just depends a lot on how the metagame shapes after rotation. I’m personally allocating my funds into other cards, but they don’t offer as big of a gain if they do hit.

        1. I definitely understand your position. I too try to pick up temples in trade whenever I can, but it appears people have learned their lessons on rare standard lands and are weary of trading them off. That purchase was me finally saying “I want to accumulate a stockpile and people aren’t selling to me…and they happened to be on sale”. One of the mind sets I’ve had to get over is the “trying to buy ONLY when the prices are lowest”, while you never want to overpay for anything, if you have a strong feeling that a card will be $5-8 and the current price is $2.50 it’s ok to buy them then even if they drop to $2, your end goal is the same. Your profit margin is slightly lower, but still very good.

Join the conversation

Want Prices?

Browse thousands of prices with the first and most comprehensive MTG Finance tool around.


Trader Tools lists both buylist and retail prices for every MTG card, going back a decade.

Quiet Speculation