|
Title: Mt. Gox History Excel Macro Post by: tarrant_01 on February 06, 2012, 08:52:27 PM 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! ;D Title: Re: Mt. Gox History Excel VBA Macro Post by: tarrant_01 on February 14, 2012, 04:39:34 PM 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/p63 (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 ;D Title: Re: Mt. Gox History Excel VBA Macro Post by: tarrant_01 on February 15, 2012, 03:43:46 PM 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. Title: Re: Mt. Gox History Excel VBA Macro Post by: marked on February 16, 2012, 05:42:48 PM 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'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 Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: Lord F(r)og on February 16, 2012, 05:54:19 PM another similar project https://bitcointalk.org/index.php?topic=56504
Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: tarrant_01 on February 17, 2012, 03:08:40 AM 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. Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: twa on February 20, 2012, 06:10:51 PM https://bitcointalk.org/index.php?topic=60355.0
I created that not too long ago if it helps. I probably posted it in the wrong section looking back. Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: tarrant_01 on February 20, 2012, 07:21:01 PM 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 ;D!...well only 1 person did but he still hasn't gotten back. Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: marked on February 20, 2012, 10:57:28 PM 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 ;D!...well only 1 person did but he still hasn't gotten back. PM'd about 15mins ago. marked Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: tarrant_01 on February 20, 2012, 11:18:09 PM 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. Title: Re: Mt. Gox History Excel Macro (0.1 BTC to test it : limit 5) Post by: marked on February 20, 2012, 11:55:18 PM 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 Title: Re: Mt. Gox History Excel Macro Post by: tarrant_01 on February 21, 2012, 12:26:04 AM Yea I have it coded to compact similar transactions to make it easier to look at. Is the information correct on the merge sheet?
|