Yesterday, I wrote an introduction on how to use The Undermine Journal‘s IQY data source for your gold-making strategies in World of Warcraft. Today, I’ll walk you through a scenario where I calculate the price point for Mists of Pandaria Darkmoon Faire cards.
Previously, I worked through the various calculations to determine a conservative herb milling-to-Darkmoon Faire card crafting rate. I figured that it takes about 212 MoP-level herbs to craft a single card. If you are buying herbs at or under market prices, you can then set your price for a potential, substantial profit when you list your card.
Create a Master Market Pricing File
To get started, generate an IQY file from the Undermine Journal and open it using Microsoft Excel. You will be prompted with a security notice, and it is your responsibility to understand what this means and allow/enable the security exception if you wish to proceed.
You should now have a new Excel workbook with a single worksheet that is populated with WoW auction house market price data. This will be your master market price data for all of your other workbooks. Now, save this workbook to your computer.
You will need to update this file manually in order to retrieve current market pricing, but if you link to it properly (as you’ll see below), then all of your other spreadsheet calculations will use current market prices instead of you having to search for them one at a time and enter them as static values.
How to Use the Master Market Pricing File in Your Formulas
Next, create a new Excel workbook, and type in an item name into a cell. The name must match the actual item name found in the game, or the search will fail. In another cell within the same row of the item name, type the following formula:
=VLOOKUP(<item name cell>, ‘[<pricing workbook file name>]<pricing workbook file name’s worksheet name>’!$F:$G, 2, FALSE)/10000
In my DMF Card calculator, my formula looks like this:
=VLOOKUP(A2, ‘[The Undermine Journal – H-Earthen Ring.xlsx]H-Earthen Ring’!$F:$G, 2, FALSE)/10000
For me, this returns a match for the item name in cell A2 when searching my pricing workbook, “The Undermine Journal – H-Earthen Ring.xlsx,” where my worksheet name is “H-Earthen Ring.” Columns F and G should represent the item names and market prices as returned by the IQY.
Sample Use to Determine Cost of Creating a Darkmoon Card of Mists
I multiply the market price value of each herb by 212 (135 for Fool’s cap) to determine the minimum price I should sell a card for given the current market price. Theoretically, I’m buying herbs below market price, so this value should already indicate a small profit.
Here’s an example of what my table looks like given the current market prices of herbs:
|HERB||M PRICE||MILL VAL||TOTAL||COST|
|Green Tea Leaf||2.42||2.42||212||512.85|
The “MILL VAL” column is used to determine the milling value of Fool’s Cap when comparing the ink yield rate against the other herbs.
As you can see, it takes a decent investment just to make a single card. You also have to factor in the Scribe’s time to mill the herb, craft the inks, and diligence to make their Scroll of Wisdom each day.
You can use this method for just about every profession that makes use of raw materials to help you determine what you should sell your crafted item for at minimum. If you’re not someone that is interested in crafting, this can still be useful to you to determine whether or not an item is above or below cost.
If you’re like me, then you’re handsome, famous, and play World of Warcraft. If you’re not like me, then you hate spreadsheets. Don’t worry, I’m here to help you. Now, let’s take a stroll to the forbidden, seedy land of Microsoft Excel and Web Query Files.
The Undermine Journal (UJ) is a great resource for data mining market prices and the economy in World of Warcraft. You can search for an item at a time, or use their canned reports to find various types of deals. One of the many hidden gems UJ has to offer is the availability of market data as a data source. I had been using the CSV format of their market price data, but recently switched to IQY.
IQY is a Web Query File that is nothing more than a text file that includes a data source address for a Web Service or API. The IQY file is then recognized by Microsoft Excel and data returned from the service call is displayed in a worksheet.
Here’s how to generate an IQY file for Excel:
- Register an account on The Undermine Journal. You will not have access to the IQY data source unless you are logged in
- On the User Controls page, find the “Market Data XML and CSV” section, choose a realm, and click on “Excel Data Source” to access your IQY file
- Save and open the IQY file in Excel
Now that you have your data, you can start mining the market locally. While you could certainly use this to simply look up item values for buying and selling, this data is extremely useful for crafting. In my next post, I’ll describe how this process applies to my crafting of Darkmoon Faire cards, and formulas you can use to query the data.
Hunters have an abundance of loot to choose from while preparing for end-game raiding. With Mists of Pandaria, Hunters once again are forced to make some tough decisions.
For Gloves, Marksman Hunters will be looking at auctioneers and Leatherworkers for assistance. The BoE, crafted pair of Raven Lord’s Gloves will be a Marksman Hunter’s best-in-slot. The only downside is the Leatherworking pattern comes from Mogu’shan Vaults. So, as a Hunter, you can check the auction house for this item. Good luck to you with that as there are very few available if at all, and prices will be outrageous until more players enter MV.
In the meantime, start working on your August Celestials reputation. A cool 1,750 Valor points will grant you access to the Sentinel Commander’s Gauntlets. Quests from the Dread Wastes will be kind to Hunters as well. The level 89 Wind-Reaver Handwraps will be your best option as you enter heroics and embark on the reputation grind. You’ll get a decent break from Shado-Pan, who will offer you the level 90 Brushcutter’s Gloves at only Honored status.
|Raven Lord’s Gloves||90||Crafted||Leatherworking||6,973|
|Sentinel Commander’s Gauntlets||90||The August Celestials||Revered – 1,750 Valor||5,649|
|Brushcutter’s Gloves||90||Shado-Pan||Honored – 1,750 Justice||4,463|
|Hopecrusher Gauntlets||90||Sha of Doubt||Temple of the Jade Serpent (Heroic)||4,354|
|Contender’s Dragonscale Gloves||90||Crafted||3,745|
|Wind-Reaver Handwraps||89||Rending Daggers (Quest)||Dread Wastes||3,652|
|Archer’s Precision Grips||90||Commander Vo’jak||Siege of Niuzao Temple (Heroic)||3,591|
|Gauntlets of Bloody Judgment||90||Unto Dust Thou Shalt Return (Quest)||Scarlet Monastery||3,347|
|Wind-Reaver Gauntlets||89||Nope (Quest)||Dread Wastes||3,253|
|Osul Peak Gauntlets||88||The Endless Swarm (Quest)||Townlong Steppes||3,062|
An online friend of mine asked me how many herbs are needed to make a single Darkmoon Card of Mists in World of Warcraft. I guessed and said 400, but that seemed like too many. I figured I would crack open a spreadsheet and solve this riddle with some conservative math and a good Scotch.
Let’s face it: math is hard. Instead, we can simplify things by generalizing that the milling rate for a Mists of Pandaria herb works out to be about 1:1 in terms of stacks to Starlight Ink “value.” What I mean is, on average, if you mill a stack of herbs, you are most likely going to yield enough Shadow Pigment and Misty Pigment to craft and/or trade for one Starlight Ink. This is more or less a fair way to figure out how much herb you need to gather or buy in order to craft a card.
|HERB||SHADOW||MISTY||STACKS FOR CARD||TOTAL FOR CARD|
|Green Tea Leaf||10||1||10.6||212|
There are a couple of additional points, though. Fool’s Cap has a slightly higher ink yield than the other herbs. This can make a difference as to what herbs you want to use to mill if you tend to buy your herbs. Scribes also need to use one of their Scrolls of Wisdom to create the card. The scroll consumes three Ink of Dreams, so, technically, you will need eleven stacks of herb in total to craft a single Darkmoon Card of Mists.
Let’s go back to Fool’s Cap for a second. To be more precise, it takes 36% fewer Fool’s Cap to make a single card when compared to the other herbs found around Pandaria. Basically, when you’re trying to decide which herbs to purchase from the auction house to make your card, use the following logic:
- Find the lowest price of Green Tea Leaf, Rain Poppy, Silkweed, and Snow Lily.
- Find the price of Fool’s Cap and subtract 36% from the price.
- Buy up all the herbs in #1 starting with the lowest price as long as that price is below the value derived from #2.
If the price generated from #2 is less than any of the herbs listed in #1, then, don’t be a fool and buy Fool’s Cap. See, that wasn’t so difficult. Now go out and make a killing buying herbs cheap, milling, and selling cards while the Darkmoon Faire card prices are outrageous.
Pet Battles are fun. I can’t explain it. You can’t explain it. It’s fine, let’s move on. If you are into battling pets, especially those out in the wild, you’ll want to install the addon Battle Pet – Quality Notifier for World of Warcraft. Here is the official description of this addon from Curse:
Simply displays some information about the wild pet in your chat window.
Enough said, right? When you’re out flying around in the old world taking screenshots of your various transmog gear and how it looks in different light and environments, you can… What’s that? You don’t… fly around and… Yeah, I know, who would do that.
If you are out gearing up for your Mists of Pandaria raid, and you come across a pet that you might consider battling when nobody is looking, this addon will display the pet quality in your chat window. It will also tell you whether or not you own the pet, so you can consider whether or not you want to capture it.
As simple and awesome as this addon is, it will become obsolete with patch 5.1. Blizzard has already announced that tooltips will be added to the game that display additional information about battle pets out in the wild, while engaged in battle, and when viewing your pet journal. Until the patch drops, enjoy this enhancement to your battle pet UI.
Remember the Nightslayer Shoulder Pads? The “boob shoulders?” Yeah. Well, Rogue fashion has come along way since then. Take Mists of Pandaria, for example, and the Silentleaf Armor. Much cooler, right? I mean it looks like you have knives on your gear, making you ready to slice and dice anyone that decides to go for a ride on your shoulders.
If you want to get your Rogue’s shoulder slot taken care of for raiding, you’re going to want to start working on your Golden Lotus faction. The good news is, Wowhead has a very nice guide to gaining reputation with this faction. Your focus will be achieving revered status and spending 1,750 Valor Points on the Imperion Spaulders. These will serve as your pre-raid best-in-slot item and show your fellow raiders that you mean business.
For a new Rogue entering your mid-80s, you may want to farm the auction house for the Mantle of Bestial Force. This bind-on-equip item only requires level 81, but the stats on it will serve you well when you reforge Mastery into Expertise. When you hit the Dread Wastes and ding 89, pick up the Ghost Fox Spaulders and use them while running heroics. This rare item is a reward from a quest chain that begins with Mazu’s Breath from Deck Boss Arie.
|Imperion Spaulders||90||Golden Lotus||Revered – 1,750 Valor||4,489|
|Doubtridden Shoulderguards||90||Temple of the Jade Serpent (Heroic)||Sha of Doubt||3,924|
|Fizzy Spaulders||90||Stormstout Brewery (Heroic)||Yan-Zhu the Uncasked||3,653|
|Ghost Fox Spaulders||89||The Mariner’s Revenge (Quest)||Dread Wastes||3,117|
|Contender’s Leather Shoulders||90||Crafted||2,835|
|Steppebeast Spaulders||88||Mists’ Opportunity (Quest)||Townlong Steppes||2,595|
|Steppebeast Pauldrons||88||Fire Assault (Quest)||Townlong Steppes||2,465|
|Mantle of Bestial Force||81||World Drop BoE||2,241|
|Silentleaf Spaulders||87||A Funeral (Quest)||Kun-Lai Summit||2,172|