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.
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.
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.
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.
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.
Let me know what you think.