Bitcoin Forum
December 09, 2016, 02:23:28 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Mt. Gox History Excel Macro  (Read 1942 times)
tarrant_01
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 06, 2012, 08:52:27 PM
 #1

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!  Grin

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
1481250208
Hero Member
*
Offline Offline

Posts: 1481250208

View Profile Personal Message (Offline)

Ignore
1481250208
Reply with quote  #2

1481250208
Report to moderator
1481250208
Hero Member
*
Offline Offline

Posts: 1481250208

View Profile Personal Message (Offline)

Ignore
1481250208
Reply with quote  #2

1481250208
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1481250208
Hero Member
*
Offline Offline

Posts: 1481250208

View Profile Personal Message (Offline)

Ignore
1481250208
Reply with quote  #2

1481250208
Report to moderator
tarrant_01
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 14, 2012, 04:39:34 PM
 #2

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  Grin

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
tarrant_01
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 15, 2012, 03:43:46 PM
 #3

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.

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
marked
Full Member
***
Offline Offline

Activity: 168



View Profile
February 16, 2012, 05:42:48 PM
 #4

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
Donator
Sr. Member
*
Offline Offline

Activity: 477



View Profile
February 16, 2012, 05:54:19 PM
 #5

another similar project https://bitcointalk.org/index.php?topic=56504
tarrant_01
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 17, 2012, 03:08:40 AM
 #6

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.

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
twa
Full Member
***
Offline Offline

Activity: 140

Tipsters Championship www.DirectBet.eu/Competition


View Profile
February 20, 2012, 06:10:51 PM
 #7

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
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 20, 2012, 07:21:01 PM
 #8

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  Grin!...well only 1 person did but he still hasn't gotten back.

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
marked
Full Member
***
Offline Offline

Activity: 168



View Profile
February 20, 2012, 10:57:28 PM
 #9

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  Grin!...well only 1 person did but he still hasn't gotten back.

PM'd about 15mins ago.


marked
tarrant_01
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 20, 2012, 11:18:09 PM
 #10

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.

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
marked
Full Member
***
Offline Offline

Activity: 168



View Profile
February 20, 2012, 11:55:18 PM
 #11


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
Hero Member
*****
Offline Offline

Activity: 546



View Profile
February 21, 2012, 12:26:04 AM
 #12

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

1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!