Magic the Gathering, played with real cards, can be a very expensive hobby: If you want to buy cards for a new deck, you often have to wait some months to get all cards you need.
If you already own other cards which fit in your deck, you may also want to play them instead until you can afford the more expensive cards.
The last deck I was excited about was Bant Spirits. A great modern deck which is quite fast but has also some control elements in it.
I already owned some cards but so many were missing to finally play it.
So I began to create a list: which cards I own, how many are still missing and how much I have to pay for them...
But getting the price for every card was quite annoying: Querying magickartenmarkt.de just to find out an actual price for a card and typing it into the sheet.
So I started to create a Macro to accomplish this annoying task automatically. I think this Excel sheet became quite useful. That's why I want to share it with you.
myDeckWishlist helps you to keep your missing cards tracked. myDeckWishlist
You can get it here: Downloadhttps://github.com/miriamxyra/myDeckWishlist
Since myDeckWishlist is macro based, you have to enable macros before you can use it. Enable Macros for this document
Be careful when enabling macros in documents from the internet! Only do this if you trust the source. If you are able to read programming languages always check the code before enabling macros.
The Excel sheet has two sheets: Deck List and Cost Overview. You only enter data in the Deck List sheet. Cost Overview is generated automatically. The Excel sheets in myDeckWishlist
You have to fill out four columns for each card:
- No#: how many cards will be needed in this Deck
- Name: what's the name of the card
- Type: what kind of type is this card (the type is needed for the Cost Overview pivot table)
- How many I already got: speaks for itself, I suppose...
On the right side you can choose if you want to query the prices for your mainboard or sideboard only - or for both.
When you click on "Calculate MKM prices" the prices for the table(s) of your choice will be queried and the table(s) will be filled out with the minimum price for each card.
This process takes a bit time because it queries the MKM for every card to get the actual prices.
While the prices are being fetched you see in the bottom left corner which card is queried.
When all prices are fetched the Application bar shows the status "ready".
In the cost overview sheet you can easily see where the most expensive card types are. Cost Overview
When you query MKM market with the button on the Deck List page, these pivot tables will be refreshed automatically. If you make other changes without querying prices, you can refresh them with the Refresh Pivot Tables Button, too.
If you like myDeckWishlist and you want to support me, feel free to donate here: Donate and ShareDonate
You may also share it with your friends and comment miriamxyra.com. It's not perfect yet, so if you have any suggestions for improvement, let me know.