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.
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
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 ><
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.
nevermind got it working had to just start over again
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.
For me the sheet isn’t working anymore. When running the script, I’m getting an error message that the TSM api isn’t available
Exception: Address unavailable: https://pricing-api.tradeskillmaster.com/ah/361
Can this be fixed?