Beancounter Export optimised usage

Beancounter Export is a fantastic add-on to track your sales, failed auctions and things you bought out,
yet it still misses a minor feature that probably will be implemented by default in the near future.
That feature is; Filters.

Filters in Excel allows you to display only that info which you wish to see.
In the AuctionsSuccess sheet you can see the ItemName column, but it displays all your items and not per market or whatever you'd like to see them.
This is where the filter kicks in, to apply a filter, you'll have to select the whole column, example shown below:

After which you go to the Data Tab -> Filter;

Once the filter is applied, you see a drop-down menu button next to ItemName, click that button and go to the "Text Filter" -> "Contains" option.
Let's say you want to track your glyphs sold ( so you can adjust your craft amounts or decide which not to craft etc), this is what you will insert into the new window:

Both "Glyph" & "Glyph of" will be usable terms, but it's just a habit of mine to type "Glyph of".
If you look at the first ItemName column I posted, it was disordered, this is what mine looks like after applying the Text Filter:

As you can see, it lists the most sold glyphs( a lot more if I would scroll down of course). This information is very handy to us whom have the Inscription profession, we can increase the amount or frequency of which we craft these hot selling items and filter out the good & bad selling ones, maximizing our profit, minimizing the time and effort we put into it.

Applying filters like these can be used for different sheets & columns of course, a few other possible filters could be:
- sorting on faction if you play the AH on both factions.
- sort on character name.
- sort on buyer (see if someone tries to buy you out often or not).

That's all I could think of right now, but the sky is the limit if you are able to use this well.

Analyse your markets, watch your wares closely and improve your AH strategies.
That's all for today, any questions regarding this or anything else, feel free to e-mail them to me or post them in the comment section.

Keep your copper coin rolling!

Organisation Continued

Yesterday's post was about keeping track of our inventory, today's post will be about keeping track of your Auctions.

There are a few add-ons that are used by most of the Auctioneers, to mention a few; Auctioneer, Auctionator, Quick Auctions 3 and possibly a lot others.
Yet to see what auctions were successful or not, we will be a bit more dependant on Auctioneer's Beancounter.
The major downside of this mod inside Auctioneer was, the data was only easy to view in-game, Beancounter Exporter changes this.
It's an Excel spreadsheet which converts Beancounter data into readable data for you, displaying items sold, at what price, sold by which of your characters, how much etc, just everything.

This was the utility a lot of us were waiting for and with this, we can filter out the bad selling items and mail those to one of our bank alts to put those for 48h auctions and look every few days if it sold or not.
If we create a plan at the hand of the results of beancounter, we can maximize our profits and analyse the market, weekends (show sales after the weekend, last 2-3 days), midweek (check on Friday's for the last 5 days ), etc.
Once we get used to this and create our own pattern, we can improve our AH game, increase our profits and spend less time doing so.

Examples how to:
- create separate groups in QA3 for the same category of items, ie; glyphs, gems, certain materials and so forth.
- adjust and optimise your bulk mailing add-ons to send only the items you want to sell quick/dump to bank alt.
- change our days, time, frequency in which we buy, sell & trade items.

All-in-all, maximizing profits has become easier by one step.

I hope you enjoyed today's post, keep your copper coins rolling!

QA, Auctioneer and ...!?

In the recent posts from Markco & Gevlon they questioned and analysed the usefulness of Quick Auctions 3 and Auctioneer and why not to use either or when to use either or both of these add-ons.

However both of the discussions are focussed on selling your ware, I'd like to pinpoint out the importance of being able to buy things in bulk, when you want to sell things in bulk yourself (one needs a stock to craft any of the selling products).
When it comes to buying, I feel that another add-on is left out when it comes to this, mainly for buying and quick cancelling your supply on the auction house.
Whenever I'm stocking up on a specific product, I use Auctionator to do the bulk buying, it's buying feature is a lot nicer than Auctioneer (it's confirmation window is annoying till no extend and for me it's too slow).

Auctionator has this really neat future to create Shopping Lists, similar to default AH "Browse"-tab, but it displays items you'd like to watch to buy at any price and how much stacks at that price.
For example I created an "Eternals" shopping list to have quick access to Fire, Earth, Shadow, Water, Air & Life.
I recently bought 337 stacks of Adder's Tongue to mill, it took me a few clicks and no annoying confirmation window asking if I really wanted to buy it for each item/stack, as you would need to do in the Auctioneer Search tool.

It's selling feature is something I haven't used often yet, I have to be honest that I still am too used to Auctioneer's Appraiser or simply posting bulks of items (glyphs, enchanting scrolls and other items I sell in bulk) with QA3.
Once I'm more aware of it's usefulness, I will certainly make a post about it, as there are people on wowecon's Hall of Fame who merely used Auctionator and a few other addons(mail, item tracking etc) to reach the gold cap(several times).

The "More..." tab is really nice, you have all your auctions listed there alphabetically, once you click one of your auctions, it'll display the query, how much and which of those are yours.
If you're not on top (lowest price) you can choose to cancel the auction (cancels all of that item in 1 click), I love this feature for my best selling items or top selling glyphs, so I'm not reposting all 440 glyphs when I use the cancel option from QA3.
You can also check for undercuts of all your auctions instead of doing it manually for each item.
That's all for Auctionator, it's a small and handy add-on, but it should be used more.

I leave the QA3 vs Auctioneer discussion to the more experienced and gold-capped bloggers, Markco, Gevlon and who else feels to voice his/her opinion about it.
In my case, it's all about preferences and I mix the usage of both, neither is wrong if it is capable of producing more gold than your starting amount.
Use QA3 & Auctioneer both, next to, obviously, Auctionator!

Go ahead and try Auctionator out and keep your copper coins rolling!
Auctionator link: http://wow.curse.com/downloads/wow-addons/details/auctionator.aspx