I wanted to share with you guys an addon I’ve been playing around with a bit that exports your World of Warcraft beancounter sales data to excel. This is a little more advanced than the average player may want for their efforts, since beancounter already has a tab in game where you can type in items, sort etc.. I like to mess around with my data in excel because there are many more things you can do with it in the long run.
Exporting Data to Excel
Go download the addon Bag Export via wowinterface. Enable it at your character screen and then in game type /bage success This will parse all your successful auctions on that character and show a text field come up with it all highlighted sperated by commas, just ctrl + copy this data. This is your beancounter sales forever from that character.
Now you can paste this into excel, and repeat this step for each alt you have, the process takes only a minute to do per character.
Formatting Beancounter Data in Excel
When you look at this data it is a little messy, the first field is the item # which you don’t really need since the item name is right beside it. However the prices are all in copper amounts and the date is in Unix format which doesn’t help us at all
Convert Copper to Gold
To display the copper as a gold amount just right click on the first cell and format cell. In the custom option under category type in 0″.”0000;-0″.”00;0″.”00 This will now show all numbers in gold amount. 180000 would = 18.0000
Convert Unix Time to Normal Date
That last field stores the data in unix time, example: 1266456030 really means February 18, 2010 who woulda thought?? That unix time is based on the time after the date 1/1/1970 so insert this formula in the cells to the right. =CELL/(60*60*24)+”1/1/1970″ Cell being a reference to where the Unix time numbers are (J2 or whatever) Copy and paste this all the way down so it converts all the numbers into date, left side being the Unix time and right side being the formula time. Make sure after this is done that you go into format cells > date to now show it in whichever date formation you want (02/18/2010 or February 18, 2010)
?Example of My Sales Data
Here’s what it should look like after you have it all finished (click to enlarge)
(click to enlarge)
This was only done on my flipping character (and data for March 11 isn’t complete since it just took the data from this morning) but you can see all the flips I’ve done in the last 2 days, I’ve been doing a lot of Jewelcrafting flipping to experiment with snatch and what could be bought and sold. Someone listed 3 of the Parrot cages for 3g and I already sold 2 for 140g average.
and there you have it, you’ll now have all your sales for every character in an excel sheet that you can manipulate and look at for patterns or do other fun stuff with. One thing I was thinking that would be useful, since you can do /bage complete which will give you all the items you’ve bought with that character. You can have 1 sheet being all your sales data and another sheet with all the buying data and you can do some calculations to find out your profit margins on flips, which items sell for the most, graphs of your best selling days, graph of days you find your materials at the cheapest. 
Popularity: 2% [?]
Brilliant!
I was using Wow Sales Report (http://sites.google.com/site/wowsalesreports/) until recently but it does not seem to work with the latest versions of Beancounter. Also, it does not seem to be updated any more.
yea I gave that a try a few weeks ago but the file it’s supposed to produce never ended up being created on my desktop.
Super. I am astonished from how much info you got on this site. I mean this last post is just excellent. Now i can start a multinational company on my server, haha.
Thanks
lol, it is pretty hard to compete against a player that utilizes all these tools against the average player not in the know.
Get an error:
Error occured in: Global
Count: 1
Message: ..\AddOns\BagExport\BagExport.lua line 257:
attempt to concatenate local ‘n’ (a nil value)
when using /bage success or /bage failed. /bage complete just gives headers, no data. The bag # exports work.
Same error as IAN, doesn’t work for me
This is some really great info. I’ve always wanted to be able to pull this kind of info, and it worked great. I’m using Excel 2003 though and the formulas don’t seem to work for me as far as converting copper to gold and changing the date. I’ll have to do some more research to see how I can accomplish this. Other than that a really handy addon.
BagExport looks to be an abandoned project right now. It hasn’t been updated in over 6 months, so I don’t think there’s any chance of it working again. I wrote an addon inspired by it, using a similar cut-and-paste interface, and removing the features that don’t pertain to BeanCounter. It’s called Brew http://wow.curse.com/downloads/wow-addons/details/brew.aspx
It’s a beta right now, but it works roughly the same way as BagExport did. Check it out and let me know what you think.
Thanks JT, I downloaded it and checking it out now.
Looks promising, no need to do all this formating as the date is already in day/month/year format. I may make a post on this addon.
Awesome! It’s just cool to know that people are using it. Let me know if you have any questions or feedback/feature requests. Most of my design decisions in Brew have been based around simplification. I decided to do the formatting ahead of time because I hate doing it in Excel. I figured that I probably wasn’t the only one. I intend to throw in a few format configurations in Brew’s settings later on, but I’m currently swamped with work. My main target right now is making it faster, which the next release is going to improve. That should be coming around in a few days.