Spreadsheet: https://docs.google.com/spreadsheets/d/1sAV5DEWN-Cr-U9HFMVBUPLCH5Fu6dSMaruGkPY6he7E/edit?usp=sharing
I have been working on figuring out if prospecting is profitable, and I just finished my mists Prospecting sheet to help figure that out!
The sheet
This is based on the sheets I made in Cataclysm and Wrath and uses the TSM API to get pricing data. You can also override any prices. To use the API the sheet requires you to authorize a script that will need access to modify the sheet. Alternatively you can manually fill in the slots.
Setting it up
First you make a copy to your own goole drive, then you can get pricing data for your realm. Pick the region or click populate regions if there are no regions, then you need to click populate realms before you can choose your realm. Then you go the pricing data sheet and click the populate data button. This will require your TSM API key, which you can find on your TSM account page at the bottom on the website. After all that you are ready to rumble.
My realm
As we can see on my realm the profit is very good. 60% profit margin for prospecting Ghost Iron even without processing the gems further is incredibly good, and with cuts you are making a ton of gold. You can see my inventory value from last night after doing one batch of 1000 Ghost Iron, which cost me about 3200 gold to buy and gave med 7000 gold worth of cut gems, alongside serpent’s eyes which I used to craft rings and necklaces.


Using your gems
Hopefully you have at least one OK recipe for each gem color by now. For the rare gems you want to sell them in the best cuts you can. You may want to craft some of the 450 crafted items as well, but mostly the cuts are the best way of moving them at scale.
Uncommon options
For the uncommon gems you have 3 main options. You can cut them and sell them, you can shuffle them into dust with enchanting or you can transmute them into rare gems. The last one will likely only be profitable for red and orange gems, which would force you into cutting the rest of your uncommons as shuffles require 3 colours. Personally I would lean towards the shuffle as it requires less inventory space. If you cut gems a large portion of the value will be in the perfect procs (which has a 10 % chance in Mists), which is accounted for in the spreadsheet in the best cut column. For many gems most of the uncommon cut value will be from the perfect procs with the base uncommon gems selling for 1-3 gold.
Raid is out
The first raid is out now which should help gem sales as they are usually a little slow before players get into the raid. With the market already being very profitable this is looking really good right now.
What should we do if we keep getting “Script function populateRegions could not be found” when trying to populate the lists?
Nvm, needed to run it in a different browser apparently.
Currently TSM is not generating API’s for newer accounts? Any advice how we can fix this or just wait?