Shuffling Ore in Mists of Pandaria

One of my favorite gold-making routines in Cataclysm was shuffling ore. Even if you consider yourself to be an average gold-maker in World of Warcraft, I’m sure you’ve heard of the ore shuffle. In Mists of Pandaria, the ore shuffle has returned, but with high volatility. However, there are tools out there for you to use to help you decide on whether or not it’s worth your while to participate in this gold-making scheme.

The basics of ore shuffling has been covered many times over on the Internet. If you are still not familiar with how it works, you basically use your Jewelcrafter to prospect various types of ore, and perform certain tasks with the prospected materials to turn a profit. These tasks can be as simple as crafting a rare gem, or constructing an item for disenchanting or selling on the auction house.

The Golden Crusade released an excellent guide that includes a spreadsheet that will help you determine whether or not it is profitable for you to shuffle your ore. The instructions are detailed enough, but you’ll need to create an account with the Undermine Journal before you can access the market data for the particular realm you are trying to retrieve data for.

One point to note: the market data that you download and import into the Excel spreadsheet is not used to calculate your profit. It is only there as a reference for you so that you can determine what amount you are comfortable paying for the various types of ore.

So guides on the Internet are great and all, but what about reality? The Golden Crusade outlined sample results when using 100 stacks of Ghost Iron Ore at 200 gold a stack. At a cost of 20K gold, a profit of 4.3K gold was made. Sounds awesome, right? Yeah! However, instead of using the spreadsheet to speculate and calculate, I’ll be using actual values from the Earthen Ring (US) Horde market.

Here are the prices I paid for the ore using actual cost and market prices:

PRICE QTY PPI DATE
115 20 5.75 10/8/2012
115 20 5.75 10/8/2012
115 20 5.75 10/8/2012
115 20 5.75 10/8/2012
115 20 5.75 10/8/2012
109 20 5.45 10/8/2012
109 20 5.45 10/8/2012
109 20 5.45 10/8/2012
109 20 5.45 10/8/2012
109 20 5.45 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012
110 20 5.5 10/8/2012

This works out to a total of 25 stacks (500 ore) at a total cost of 2,770 gold (at 5.54 gold per ore). The Undermine Journal reported a market price of 5.95 per ore on October 8, 2012. So, in theory, I already made 205 gold based on buying the ore below market price. If I used the spreadsheet, though, I have a potential profit of 5,771 gold. Hooray! Wait, what? That’s not how it works? Okay.

So now it’s time to prospect! I will report back on my ore prospecting yields this week and break down the actual materials gained from the ore and compare them to the spreadsheet.


2 Comments

Leave a Reply