Mt. Gox History Excel Macro

[tarrant_01]

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!  

[1713887692]

1713887692

[1713887692]

1713887692

[tarrant_01]

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  

[tarrant_01]

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.

[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'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

[Lord F(r)og]

another similar project https://bitcointalk.org/index.php?topic=56504

[tarrant_01]

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.

[twa]

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.

[tarrant_01]

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.

[marked]

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.

I even offered BTC and still no one wants to look  !...well only 1 person did but he still hasn't gotten back.

PM'd about 15mins ago.


marked

[tarrant_01]

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.

[marked]

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

[tarrant_01]

Yea I have it coded to compact similar transactions to make it easier to look at. Is the information correct on the merge sheet?