One method of making gold with jewelcrafting is to craft an icy prism everyday.
The problem though is that the drop rates are so complicated to calculate that you’d need a math degree to pin-point on average the chances of getting a green gem, rare gem and an epic gem.
If you have auctioneer installed, here’s a very simple and fast way to find out if it’s worth your time to make an Icy Prism.
Icy Prism Profit Macro
I stumbled on this post at a gnomes quest that talks about icy prisms. From that site I found the most valuable information was a command script you could input right after you do an /auc getall scan that will return the values of the cost to make an icy prism and the total average value of the gems depending on current prices.
Here’s the icy prism macro: (warning: this macro may need to change after 3.3.3 due to changes in mats required to make an icy prism)
The first time I ran this macro it told me it cost 85g to make and only a 75g return. Then yesterday I checked and it said 65g for mats and 87g return.
Since I was only skill level 441 at the time of using the icy prism the first time I would of made it if there was a negative profit up to -30g since that’s how much it cost me to get a skill point anyways.
A lot of people are not doing their icy prism cooldown because the frozen orb rise in price in patch 3.3.3 from 5g to around 25 gold on mosts server (due to being able to trade frozen orbs 1:1 for lots of valuable trade items) However this macro will valuate your frozen orbs at whatever your servers frozen orb costs are (20-25g) so that you are still making that higher amount back in profit.
Try this out on your auction house and let me know how accurate your results are over the long run, I’ll be updating this macro for patch 3.3.3 when the mat costs to make an icy prism change.
Popularity: 2% [?]
That’s very cool. I had no idea you could access Auctioneer’s data via a macro… that opens up a whole new can of worms for me…
I wonder if you would be able to tie in the gems that you are able to make, and possibly use the market values of those instead of the value of the uncut gems.
.-= Sarama´s last blog ..Ferociously Flipping Flurry Axes =-.
This is missing the epic gems factored in. I think the macro is from before the added epic gems and the chance of getting epic gems from an icy Prism. The new calclualtion macro is as follows:
/run local v,p=AucAdvanced.API.GetMarketValue,print;p(((0.1*v(42225)+2.6*(v(36918)+v(36930)+v(36921)+v(36933)+v(36924)+v(36927))/6+0.68*(v(36931)+v(36934)+v(36919)+v(36928)+v(36922)+v(36925))/6)/10000));p(((v(43102)+3*(v(36923)+v(36926)+v(36932)))/10000))
If I’m reading it right, you gave the epic gems a 68% chance to drop (~11% each), is that right? I was thinking it was more of a 6% drop (~1% each)
Thanks bloodspike! I didn’t realize epic gems were missing from it. I’ll go through this calculation and start using that instead.