Wow Auctioneer database parser II

Wanna break down your auction house scans? Would you like a spreadsheet to search in for current prices? Wanna research items maybe you should be selling? Well there is a website for you!

Wow Auctioneer database parser II is a website that will take your auction house data and convert it to a CSV file that you can open up in excel. You will need to get the latest version of auctioneer and Auc-db installed to run a scan and have a database file to export. This export allows you to view the latest auction house data from your most recent scan.

I like using this to quickly lookup prices for various items, especially if I'm farming or I'm away from the auction house. You can also use it to quickly compare faction prices on the same realm. Run a scan on horde, export, then jump over to alliance and do the same. Compare the prices and see what items you can faction trade to sell on the other side for higher profit. (This will require two accounts)

Let me know what you think!

Export BeanCounter Data To Excel

After doing some more research I've found someone who has created an excel workbook that uses macros to export your BeanCounter data. This is a little bit more advanced method than I'm used to sharing with my readers but if you're interested in breaking down your BeanCounter data and drilling down in the data then this is for you. I wanted to see if there was something else available since WoW Sales Report is no longer being updated and it does not work with newer auctioneer data.

The Download & Install

You can download the file from curse gaming, BeanCounter Export. You will need Office 2007 and macros must be installed. If you need to enable macros go to File -> Excel Options -> Trust Center -> Trust Center Settings. I have not tested this file in OpenOffice but I'm sure it will work in the newest version.

It doesn't matter where you put the file, your desktop or my docs will be fine. Double click on the file and edit the settings on the first page of the workbook then press ALT + F8 to run the macro. A popup box will ask if you want to run Readfile, click run. A box will pop up and ask you for the path, enter this path name but edit it for your account name c:\program files\World of warcraft\Wtf\Account\"Account Name"\saved variables\beancounter.lua . It will say done, click ok.

Changing Options

You should now be able to look at your auction house transactions based upon the settings you selected. The currency data is a bit messy but we can fix this by selecting columns E through K then right click on any column then click Format Cells. Go to Custom then copy past this, 0"."0000;-0"."00;0"."00. This will change the format to gold so it's easier to read.

By using the top menu buttons you can sort the data any which way you want. This export is great because it allows you to see sales patterns, what items are your hottest sellers, and what classes you might be tailoring too.

Curious Finds with Inscription

It's amazing what you find out while looking at your sales. By looking at my sales history from inscription I can tell what characters are being leveled the most on my realm. It's odd but you can see which class glyphs you sell the most and the ones that you sell the least.

On my realm there must be a ton of players leveling warlocks because glyphs for that class are my biggest seller. I find sales for death knights and warriors to be high as well. I think that the death knight sales are fairly obvious since they are so easy to level up. On the other side of the spectrum I see mage, shaman, and hunter glyphs sold the least.

I began thinking about how I could use this data or if I could further analyse it. How could this data help me? Could I apply this data to focus on other professions? I think that this explained to me why I sold more Iron-Bound Tomes than Faces of Doom off hands. Could there be things that might be more in demand for a blacksmith than usual at this time?

Questions for Comments

I wanted to put this in your minds and see what you all thought. What do you infer from this data? Would you think about crafting more of a certain item based of this information?

Image from remnantsofchaos.com