Ok, I've added a few stats that get added at the end of all of the data.
General: USD Deposited, USD Withdrawn, BTC Deposited, BTC Withdrawn
More revealing information: Gains/Losses, Average G/L, Average G/L %, Avg Buy Price, Avg Sell Price. Formulas in this section change with the filters so seeing monthly/daily gains is possible.
Good sale prices are marked green and bad ones marked red.
sounds good.
Marked, you seem to only ever be the one interested in this. If you want to, perhaps we could work together to get this to be useful. I wouldn't mind seeing it go multi-currency multi-exchange. I would be even nicer to see it grab the data itself rather than having to get the csv files itself.
I have some scripts that pull and reformat the json data to csv, but they are a bit brutal, and not really json compliant, as I rely on an order in the ticker.
I have perl/python in both active* and cygwin versions, so should be able to rewrite them, and match if you have or use external processing using another language.
Not sure if there is a powershell json library that can interact with excel?
I will upload it when I get home. I have a few things to sort out with it before it's ready for distribution.
I use btc-e, mtgox, bitcoinica (as an exchange), vircurex, intersango, cryptoxchange in that order of use. I have started to look at bitfloor, and probably have one or two others registered (oh, yes, the german btcde one can't think of the domain offhand, it is a market matcher?).
btc-e is an absolute nightmare txn history, and there is no current csv download.
bitcoinica pull from ledger, no download, c&p
vircurex should be a simple cut and paste of the history, but I'll need to check the multi-currency status
intersango from api?
cryptoxchange
marked
