Tuesday, 27 November 2012

Consortium Project update November 2012

1,261,169 gold for the month. Not only did we beat our previous PB (personal best) but we smashed the 1 million gold goal I set at the beginning of this expansion.
Kinda scared now as I don’t have a long term goal in the works, and as I’ve said before, I need goals to stay motivated.

So what changed? We had been doing 600k ish then boom, 1.26 million. I attribute the jump to a few things.
  1. Blizz released 2 more LFR’s this month, along with the raids instances.
  2. More people hitting 90 and the ease to get into and complete heroics.
  3. More guilds starting to raid.
  4. Daily Quest Rep rewards from VP. Yes there are still people grinding out rep, can you believe it. I sure can.
  5. Duping of Blood Spirits, means access to crafted gear is much easier.
Sales of Enchants, Gems, and Belt Buckles went through the roof. 952,630g profit from this alone.
190,000g sales from DM cards.
118,539g profit from Glyphs.
Our Routine
  • We buy as much Ghost Iron Ore & Green Tea Leaf as we can up to 1.75g each (35g a stack) on Caelestrasz
  • Prospect the Ore and make Ornate Rings & Shadowfire Pendants.
  • The Blue procs from the above, we try and sell on the AH, otherwise we DE along with the greens.
  • DE’d mats used for enchants.
  • Craft 15x Profitable enchants.
  • Wild Jade, Imperial Amethyst & Vermilion Onyx used for Primal Diamonds.
  • Cut the following Primals x10.
    Agile Primal Diamond
    Austere Primal Diamond
    Burning Primal Diamond
    Ember Primal Diamond
    Reverberating Primal Diamond
    Revitalizing Primal Diamond
  • Keep an eye on the price of Serpent’s Eye, the below DE into Ethereal shards. We can sometimes pick up Serpent’s Eyes for 5g each.
  • Make the 450 Ilvl Jewellery which is profitable x4-5 of each
    Band of Blood
    Heart of the Earth
    Lionsfall Ring
    Lord's SignetRoguestone Shadowband
    Golembreaker Amulet
    Reflection of the Sea
    Skymage Circle
    Tiger Opal Pendant
    Widow Chain
  • Cut gems with highest prices first x20.
    Bold Primordial Ruby
    Delicate Primordial Ruby
    Brilliant Primordial Ruby

    Fractured Sun's Radiance
    Quick Sun's Radiance
    Mystic Sun's Radiance
    Smooth Sun's Radiance

    Adept Vermilion Onyx
    Artful Vermilion Onyx
    Deadly Vermilion Onyx
    Deft Vermilion Onyx
    Fierce Vermilion Onyx
    Fine Vermilion Onyx
    Lucent Vermilion Onyx
    Potent Vermilion Onyx
    Reckless Vermilion Onyx
    Resplendent Vermilion Onyx
    Skillful Vermilion Onyx
    Willful Vermilion Onyx

    Puissant Wild Jade
    Zen Wild Jade
    Balanced Wild Jade
    Misty Wild Jade
    Lightning WIld Jade
    Piercing WIld Jade
    Sensei's WIld Jade
    Vivid WIld Jade

    Energized WIld Jade
    Etched Imperial Amethyst
    Glinting Imperial Amethyst
    Purified Imperial Amethyst
    Shifting Imperial Amethyst
    Veiled Imperial Amethyst
    Guardian's Imperial Amethyst
    Defender's Imperial Amethyst

    Rigid River's Heart
    Solid River's Heart
    Sparkling River's Heart
  • Buy Sha Crystals when cheap for the Rep Enchants if you can craft them.
  • Buy Living Steel when cheap and get BS Guildy to make into Buckles.
  • Mill Herbs and turn into Shoulder enchants if you have a Scribe.
    Greater Crane Wing Inscription
    Greater Ox Horn Inscription
    Greater Tiger Claw Inscription
    Greater Tiger Fang Inscription

  • Don’t be scared to move items to the opposite faction if prices are being tanked. As an experiment when I was looking into Arbitrage opportunities, I was moving Belt Buckles from Alliance to Horde and made 200g a pop.
  • Use the remote Auction House during the day if you have access to a computer.
  • Setup notifications on Wowuction.com or TSM Desktop App (link Below) to alert you to cheap mats.
  • Don’t be scared to buyout other peoples auctions to reset the price. We regularly do this with Primal Diamonds, Belt Buckles and Shoulder Enchants, when prices get tanked to sub cost prices or near to.
  • No 1 rule, in an undercutting war, try to always be the last man standing. Never let emotions drive you, always undercut by 1c (small amount) only, down to your break even point. If you drop the item value by 10-15g the only person you're hurting is yourself. If your competition posts more items or can stay on longer, it doesn’t matter, while you are on line be the aggressor. Make your competition work for every gold. Don’t stay up till 3am trying to win an undercutting war, walk away and get up fresh for a new round the next day. Persistence and repetition is the key. Learn to post and raid at the same time. 2 screens = win
  • You will need the following bags 2x Illusionary Bags, 1x Luxuious Silk Gem Bag, 1x Outherworldly Bag for the toon running Enchants, Gems & Buckles. We use the the Royal Scribe Satchels for Glyphs.
  • Addons TSM, Auctionator, TSM Desktop App.
  • Though I hate doing Dailys, theres some I do every day. Tilers Rep, get it to revered and you can then plant Songbell seeds which turn into mote of Harmony when harvested. I’m doing this on 3 toons per day. Get your rep to Exalted and you can have 16 farms. Spirits of Harmony (SoH) can be exchanged for 3x Golden Lotus which is used by Alchemists to transmute gems, this is good for making up missing gems for Primal Diamonds, unless they are cheaper on the AH.
  • Although we do sell Leather Leg enchants, getting SoH is time consuming. I’ve tried to stay away from crafting anything that requires SoH. This is not to say that Crafted items are unprofitable, but more so, that getting the mats for them is a time sink.
  • Use your professional cool downs every day.

There are a lot of bloggers out there, some offer different ideas for gold making every day, some focus on 1 profession and are authorities in that area.
Twichie Enterprises is the main reason I provide monthly updates as I've always liked reading their blog, and the idea of giving readers an overall financial perspective, appeals to me.
This blog will never be a place for cutting edge ideas as I read other peoples blogs for those. It will however focus on the Shuffle and the how a team of 3 go about it.

Sunday, 18 November 2012


This is going to be the new project that the Consortium team trials. We’re going to buy off one Auction house to sell on the other. The minimum we intend to make is 35% mark-up excluding AH fees, but this % may need to be a little flexible.

The neutral auction house is where this may grind to a halt. If we get a camper/sniper then we won’t be able to transfer items between factions, so the whole project becomes pointless until they leave.

The minimum an item can be sold for on the Neutral AH is 2 copper to minimise the 15% commission the neutral AH charges.

The Plan
We’re going to setup a toon on the Alliance & Horde side with 1,000 gold each, they will buy cheap items off the Alliance AH to sell on Horde side. We’ll transfer the items across, to our Horde toon and sell them. We will then buy cheap Horde items and transfer them back to Alliance for re-sale. We will then do the same again but investing profits.

The Rules
No crafting, we buy from the AH or Consortium Project (better the gold stays in our pockets than competitors) at Auction House prices for resale.

Let’s say we purchased 1000g of items on Alliance, send to neutral AH, transfer to Horde, Sell on Horde +35%, we lose 5% to AH fees but should have 1300gish for re-investment, purchase goods, send to neutral AH, transfer to Alliance, Sell on Alliance. Should have 1690gish for re-investment.
The Problem

By trips I mean the gold/goods go from Alliance to Horde to Alliance again.

So after 14 trips we'll have 1.5 Million gold, right!  Nope, after 9 trips it’s going to be hard to find enough items on the either Horde or Alliance side to send back and forth for resale. It's going to slow down substantially at this point, but mathematically it looks impressive.
I will setup the toons during the week and commence the project when the new month for the Consortium Project starts.
The Tools
I’ve setup a spreadsheet on google docs if anyone wants to try this out on their own realm. Please report any errors you find.

How it works
1. Download the spreadsheet from the link above and open it.

2. Import data from the Undermine Journal for both factions.
Goto TUJ ->Pick your Realm & faction -> Site -> Market API -> Click CSV.
Copy/Paste to relevant tabs (Alliance & Horde) over the existing/old data.
3. Set % markup you want to achieve on the Arbitrage spreadsheet. A2
4. If you buying on Alliance to sell on Horde, use the drop down box and set the Alliance Column F & J to True (deselect False) or for Horde G & K.
5. Pick what you want to buyout and look at Col L for Alliance (M Horde) for Max price to pay based on % markup.
In the above example Ethereal Shards can be bought on Alliance for 51.25g (Col B) the market average on Horde (Col I) is 75.19g, however current price is 105.75g (Col C)
Max price to pay for Shards is 55.7g (Col L) based on lowest value in Col C or G. Just remeber to reset the filters when you want to swap to the other faction.
You can add items, just put the item name in CoL A, then copy existing data from Col B to K and paste on the same row as the new item. I'm assuming some basic Excel knowledge here.
Living Steel Belt Buckles would be one item to add.

Let me know what you think.

Sunday, 11 November 2012

Gold is not motivating

There are many players in WoW who struggle to keep a few thousand gold, I was one of those people once. I would go to raids with just enough gold to cover repair bills, having just spent most of what I had on Gems and Enchants. It frustrated me, not because I had no gold, but that I didn’t have the knowledge to make gold, and the only avenue left was doing Dailys, which I hated.

I resolved to find a way to make gold. I became a Glypher and soon the gold started rolling in (back when I though 3k a day was a lot). I set myself a goal to make 1 million gold. It took a long time to achieve my goal, mainly because I now had the resources to purchase what I wanted. When a new Tier of gear came out, I would purchase the latest BoE gear. Spending 30k on a trinket wasn’t an issue, so for every two steps forward, I took one back.

At the beginning of Cata I had hit the previous Gold Cap on a few toons and decided to make the push for 1 million gold. By half way through the first tier of Cata I achieved it. But what happened next was unexpected. I couldn’t bring myself to play WoW, I had lost all enthusiasm for the game. Raiding was something I had always loved doing, but even that was empty for me. I decided to take a break from the game.

Four months later I came back to WoW but my intention was to only play PvP. I still did not have the enthusiasm I once had. I changed from Horde to Alliance and started running BG’s. I also got back into making gold. This is about the same time I started reading Critical Goblin’s blog.
What I saw there was a project which I could replicate on Caelestrasz. My motivation was not to make gold, but to see what effect my actions had on my competitors.

The Alliance Glyph market was dominated by 3-4 players at the time, so for the next 3 months all I did was post glyphs walls. 2x @ 15g, 2x @ 20g and 2x @ 25g for 48 hrs.

Prior to me entering the market, glyphs sold at 100gish each, so I wasn’t popular, as I received helpful advice as to how to raise glyph prices from competitors. By the end of 3 months, one consistent competitor remained in business, who seemed more than happy to play the 15g glyph game.

What did I learn from this project……most people realised that they are working for nothing/couldn’t compete and took a break from the glyph market. The one remaining glypher, has a herber and despite the fact that selling herbs would be more profitable, they had the mindset of “I will control this market” and “I will not leave”. The most important lesson for me, was that having a Project/goal is motivating, not the gold, I got my enthusiasm back for WoW.

As I said in last month Consortium Update, one of my goals is to reach 1,000,000 gold profit in a month. Based on our profit to date this month I can see that this goal will be achieved very soon, maybe even this month. I need a new Project/Goal and I’m open to ideas. Furthermore I’m feeling evil so the more mischievous the goal the better. Tung needs your Ideas now before he looses his motivation.