The Wrath prospecting gold guide! Spreadsheet included to make sure you profit!

Wrath is out, and so is goldmaking season. Today we’re taking a deep look at prospecting, specifically Saronite Ore, and the fabled Saronite Shuffle you can do potentially maximize the value of your gems.

Prospecting basics

The basic idea to make gold with prospecting is to buy ore in large quantities and turn it into gems. By going for large volumes you can be fairly certain your yields are close to the actual average yields, which means you can be certain you will actually make a profit. The gems we get can either be sold raw, cut into socketable gems or used to craft other items that require gems. Some of the items crafted with the uncommon gems can be further optimized by disenchanting them to sell the dust and essences, or use them to craft enchants.

The yields

Luckily wowhead already has the data on average yields. A large portion of profits will usually come from rare red gems, as this is by a very significant margin the most popular gem. This has a 4% chance of appearing per prospect, which means we can get an idea of the variance. If you prospect 100 times, there’s 43% chance you get less than the expected 4 red gems, which would likely hurt your profitability significantly.

Saronite has almost 4 times the rate of rare gems that Cobalt Ore has. This generally means that you will greatly prefer Saronite ore. It saves you time, and it will get you a larger quantity of the most important gems for profit.

A calculator

The most important factor by a very significant margin when doing prospecting is buying at a price where you know you can turn a profit. To figure this out I’ve made a spreadsheet you can use. The TSM API is back so we can get the prices directly into the sheet by following the instructions on the first page. It’ll then calculate the best value combination and compare it with the current value of the ore.

Price expectations

It’s hard to know exactly what price rare gems will stabilize at. I added some rough price guesstimates for gems based on TBC prices, which would put the value of Saronite Ore for prospecting anywhere from 3 to 7 gold. I would be surprised to see the ore at prices significantly above that, as that would lead to some very expensive gems. Of course I could be underestimating how much gold players have. We would have to see average rare gem prices at 200g and average uncommon prices at 10g or more to see the ore value pass 10 gold.

The Saronite shuffle

The full shuffle is a way to increase the value of your uncommon gems. Of course you can sell them cut, loads of players will prefer doing some cheap gems for pre-bis gear or early socketed gear they expect to swap out. You can also sell the raw uncommons, as they are used in JC dailies, so players will always be buying. The last option is to use four of them to craft rings and necklaces. Crystal Chalcedony necklace, Bloodstone Band, Huge Citrine Ring and XX all require one gem and two crystallized earth. They can be disenchanted and will give you infinite dust or lesser cosmic essences. I did this en masse back in the original Wrath. The last two colour uncommons you will have to find another way to dump, there are some transmutes for meta gems than can help, but for the most part I expect these two relatively quickly essentially become vendor trash.

TSM settings

Generally speaking I suggest using hardcoded gold values when selling gems, particularly early on. Prices will vary a lot between realms and change every day, and you want to take a measured approach that you control. For uncommon gems you can try starting at 30 gold normal rice and 100 gold max. The minimum price should be 1 gold, which is w times the vendor price, to ensure you don’t lose your profit due to deposit costs. For rare gems I would start out at 300-500 gold, at least for red gems. The market will quickly stabilize, so eventually your minimum price is the only one that really matters. You can go as low as 2 times vendor price if competition is low enough, but even at 12 hour duration you will lose 15% of the vendor sell price every time an auction expires.

If you want to level up your gold making come join me on Patreon and get access to awesome rewards like Early Access to all my posts. 

Import string: 

DEztVXTXzC8sB33IlmKwlBN66IsO00exOwqYLdFPxm0UsoQnvTQAvEb5sgUC5UKvCjhWLREja(YcFWNfG)cSFeYHcFYh0fF0dCVSh8jDoiiqTnnVN(qUZ8iPelrxlat)JZ8)5)ZWzE2zivgVrRvF)LF31(RRVX5h1CyU6Be0FW9(Nzr)H6UUAASl)wj(P97NMqBeNM2zqEAsGOtc)ccYgjhKCLKUgsgS5q7AnmrTz2UdY9If9s4xuq2i5GK7Xgknd9I9d6KMS70onS5ZmLQBGuD21okzHEDs3(K5RUjFobrqYvsMAizGeQZ0MDf08vg2lqTzuEwKCQX0HFdb5kjIgs6izGKjseKSqYgj0zc6SfgHfgHfgHLdRgouxYlBt1)KxhX40MWxqqwizJKdsUsYrdjDKmqQUKCXEDXEDTyZSUxwaTLVxCqU66dBlw)CT5UazQb)HKos1rYHn7uh2Cx1wEmwyuwW0UGQSBjiDKQZQvkFXH5d7N8AduFJ40Tf9zYBkilKSLKHHiYn2okoQxyUAkRSUPOV68veebjlKCKeukkjtKSf(UAAIxMFO6gGVFGOph(AcYvsqvOK0rYejcsySMySemwcgluWjjmwO4ssOle0fhl2LlhX3onlyqU6Y9dY8I7i60H7jixj5QHKoseKKrORPHKbseKSKKUoR2YSiFAtVSorjEXY6MI(m49fuDKiizHKdsUS5kDBvV)o84e5R(Erz(Pjt71qJNlidKmzZwgXBgL0dkHwSF7Gmrxe(ocYgjhKCpSmULYc8W9nH2RRXVJGQJebjxjbR4sY4jLoTy)a5MmfTwNFxbzIebjlKSrYvsqTHKmqc9JG(rq)iOlwySwySwySwMtFQxE3a10UQV3Wyr7e(9fKfs2i5GKRKS1rQosye2OoyljjzmLGfbsJvdYlRGG5BB(4PemHljcsUsYgBd2nusySWUHscJasTK0rYaj0phmcxSnxmhUyoCL5a(LcssNnRBW(fpJtJPRfK1nWpxiYK)abrqYcjBjzQDmZo680tAguc(qbvhjt2nEwhI)DIKW3xqwizljIg7xDkNnFsBGDUEKGmqQosejzH6SqDwMSR)9p47K(d1Ipwq2i5ijBnKQJKjseKqxSXyDWyHsdjzW(LpZ3A4Kdk4u0NkitKiizHKdsUsc29vsgiH(5IUa1CscDXv6crteRHTMo7LXH8Yj(HEj5bDuxlWllwOWqCaXr9Ub0BrNenI5iz0fn4QRdVrz5(d)LItv7dXvQ(EQNJ2OSD(DP8(u(DO87t57q55u(Hu(yAJYCWBs5FmL7r5Rr5Uu(TO8vO8pHYVaL)akFgk)Hu(cu(JP8pIYVbL)ukFok)ru(fP89PqA6oEXH(5rPjWU5xInxZmVU5aQQRcvF(BQQBSYO0Tk2HhQvgj7(sJELLc66nmoN)FPJAfMYyfTY)C422TsIybztVzV3oiPtAg25h(oWWomD4aSf()Ql))CD(NY)SRd3)ffx(YIlFvXLVU4YDRsq)QeCNQeC)QeStvcYRsWHvjyCvc(3GGlD47K5LhQwS6x(PjfZGNAenlT8BoDbFCvc8QsWAvjWTkb3QkbRuLGp5ytmYFED2tmxO0YV90f8GclzxtSpK6)pEptvE)WcVNO8dotxwOkxE8ZJlFuvUCJQe80NN0mxvU8ONhxUyvUS)ZHlGKBZ)07D5rETHTTw1BNr992bE3D)GXTJ6aRN(bj5NFV2XWMBXrdYp3((Ej(bXRhWshKtzx543Uri8o(HPXDMxV3bt74TsGpw0FyoDuNHqrbSX55zZg1lb(AG)C62ljAtz)ndcy)THW()r57wt7G(E5(HTk2rTv0heeoggulVdd(ATb10MOCUd0l(uVx1xS96O(rjLJ59Hxb)vLB6(Hqs67fpTdJJjpRyS20JvtFmROZ1dgeK3ibExO9gitzn9dq(poaehoAO4rzEDFys9ExEIIcmuMOC(Zpr5cW))dPtu(rWt(eLFmq)eO1Fki4LkgWxmCIYpRCK3ag5GIlnpbUoJbP4MA10NOa2n3eLRuGxfuFnil8V5fmjRxm9uKfd9Y00GODM55BFbZZeLxU4rXOihtu(5Nrg(SRY)8BZMPCfOCbbE96W0oNRyHfM(Zt93Sw99kxgt7gLdgpgUr2Jo)lkIhY4t2Q88XbbXX)oD)dZMk4yfoIwALoeQChC7gEX5dch5n9m7bHnA7LSz469ggf3jKnluSU9IIc)YHfL)LqMU642bWx6x2YokVlmgF9JY7cQrD7L)6l1y9GEGNRcVzyq(IB1Bbvy1SyEFbvTFVZPRQS0DQk7tx1rwzvrclfrQiFLImp70vQP(zKnPgJZozLA0lUOrUP4p1FR63t9n5Ffmx)p2liXRDCqJH7shpfBbZY0SYDeY3vzSCrg4jkVs359cHQQFDywXs77xEZVb(3Rf2OVxuCiBMIfPf7MhKnDhJo38jfTaveXTtHFdhEWwdwcSmlD332lEyqwNP38KTgmDOv26OoT7xEhB2I2354rmVMpBMYwpwaqJ8VgEE26WIbEdVEYIsf2mtBjbRtv2VpuZDKGRjEeFZVRUjkZdHlRPL7hbnFfLx6)9d

5 thoughts on “The Wrath prospecting gold guide! Spreadsheet included to make sure you profit!

  1. I’m really interested in your spreadsheet, but are you able to adjust your scripts to only open that one sheet? The permissions require read and edit access to all my sheets, which I can’t allow ><

  2. Does this only work with a TSM premium subscription or something? I entered my API key and it told me Invalid TSM API key (Internal Server error). Couldn’t get the realms to populate.

  3. Hi mate,

    wonderful guide and spreadsheet. Took me a while to figure it out, but I manage well now.

    Two small pointers, on the spreadsheet under instructions I would not mention to fill in the yellow fields since that also replaces the formulas and messes up the sheet. Sufficient to say fill in the red fields and tick override value if you want to add some manual prices.
    In the same spirit, it would be awesome to have an override best cut field, not so much for the name but just the price. It would help for those values where no proper items are actually listed (some cuts just have the one on sale from a Russian sniper at 3999.99g for example). As well as help people that don’t have the current best cut recipe yet, they could manually enter the value of a recipe they do have and the calculations would still be correct.

    Besides that, amazing work. The shuffle works on my server by just buying up the uncut Chalcedony and make rings to DE. It’s around 200% profit which is absolutely mad actually.

    Thanks again!
    J.

Have a question or a thought? Leave it here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.