Topic: Mt. Gox History Excel Macro (Read 2177 times)
Yea I have it coded to compact similar transactions to make it easier to look at. Is the information correct on the merge sheet?
think i may have found a bug. the mtgox code and a btc deposit have combined from two transactions into one, is that supposed to happen?
history_BTC
1 20/02/2012 22:26 deposit 12... 0.0075 0.0075
2 20/02/2012 23:43 deposit Redeemed code: MTGOX-BTC 1 1.0075
merged_USDBTC
Index Date Type BTC Traded At Price Value USD Balance BTC Balance Fee Info Transaction ID
1 20/02/2012 deposit 1.0075 1.00750000 12...
marked
I don't think the currency sheet really matter. Mine just happens to be USD, it'll all transfer the same if the non-btc currency data is pasted onto the USD sheet.
Thanks for the input. Check PM for MTGox code. I don't have any money in my wallet atm.
Thanks for the input. Check PM for MTGox code. I don't have any money in my wallet atm.
I went through the USD history first and then combined all the similar transaction id's into one line on a new tab. I intended to pull in the other two csv files eventually but for now copy/paste seemed easy enough. It seems like your file got more attention than mine did.
I've given you details as to how to do file import. I'll have a look at twa's spreadsheet to see if it's similar. I really need more history to help review both, and most of my trades aren't in USD in mtgox.
Quote
I even offered BTC and still no one wants to look 
!...well only 1 person did but he still hasn't gotten back.
!...well only 1 person did but he still hasn't gotten back.PM'd about 15mins ago.
marked
Cool thanks! I'll look into it when I get home. Dropbox is blocked at work.
I didn't use arrays like you said you did. I went through the USD history first and then combined all the similar transaction id's into one line on a new tab. I intended to pull in the other two csv files eventually but for now copy/paste seemed easy enough. It seems like your file got more attention than mine did. I even offered BTC and still no one wants to look!...well only 1 person did but he still hasn't gotten back.
I didn't use arrays like you said you did. I went through the USD history first and then combined all the similar transaction id's into one line on a new tab. I intended to pull in the other two csv files eventually but for now copy/paste seemed easy enough. It seems like your file got more attention than mine did. I even offered BTC and still no one wants to look
!...well only 1 person did but he still hasn't gotten back. 
https://bitcointalksearch.org/topic/mtgox-personal-trade-history-aggregator-calc-your-account-profitability-etc-60355
I created that not too long ago if it helps. I probably posted it in the wrong section looking back.
I created that not too long ago if it helps. I probably posted it in the wrong section looking back.
Ah thankyou for that link. That sounds like what I want to do except through excel! And thank you marked for downloading it. Look forward to hearing about your experience with it.
Edit: Updated the above link. I've made some changes to the code. It wasn't properly marking deposits/withdraws as +/- changes.
Edit: Updated the above link. I've made some changes to the code. It wasn't properly marking deposits/withdraws as +/- changes.
another similar project https://bitcointalksearch.org/topic/btcreporter-analyze-your-mtgox-trading-logs-56504
Ok, 0.1 BTC to 5 people to test it out and let me know what they think?
I assure you it's not uploading your transaction history to some server I promise. The code is all there to be seen.
I assure you it's not uploading your transaction history to some server I promise. The code is all there to be seen.
I've downloaded it take a look at, but don't have any mtgox transactions yet. As such I can't really say too much yet. I'll come back to this when I do though.
marked
Ok, 0.1 BTC to 5 people to test it out and let me know what they think?
I assure you it's not uploading your transaction history to some server I promise. The code is all there to be seen.
I assure you it's not uploading your transaction history to some server I promise. The code is all there to be seen.
I've finished the macro. Just curious if anyone wants to take a look at it. I'm no accounting expert at all and kinda scratching my head a bit at how to tell if I've made anything at all doing trading.
Let me know what you think and if anything needs to be adjusted. Also keep in mind I can only work with the trading conditions that I have personally experienced. For instance, I've never done a USD withdraw so I dont know how that will work with the coding. It should, but you never know. There is code in there for the yubikey atleast!
Link: http://fyels.com/fhP
Link: http://fyels.com/p63
Also, I know my programming skills aren't on par with 99% of the projects in here so forgive the simplistic nature of the coding
Let me know what you think and if anything needs to be adjusted. Also keep in mind I can only work with the trading conditions that I have personally experienced. For instance, I've never done a USD withdraw so I dont know how that will work with the coding. It should, but you never know. There is code in there for the yubikey atleast!
Link: http://fyels.com/p63
Also, I know my programming skills aren't on par with 99% of the projects in here so forgive the simplistic nature of the coding
I started working on a macro today in excel to go through both the USD history and the BTC history and combine each associated transaction into one line so it shows USD Balance, BTC Balance, and the fee all in their own columns on one row(along with the other data). I'm doing it because I'd like to then see how my short "day-trading" experience went. If others are wanting to use it, I don't mind uploading it somewhere after I'm done. I'm trying to code it so it's easy for others to do and use. Right now it's mostly a logical headache. I'm done for today and will get back to it some more tomorrow.
I'm mostly interested if others would want to use something like this or if it's already been done perhaps(that would be great).
Thanks!
I'm mostly interested if others would want to use something like this or if it's already been done perhaps(that would be great).
Thanks!
Jump to: