Bitcoin Forum
May 13, 2024, 05:54:09 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: MtGox unrealized gains  (Read 1217 times)
optimator (OP)
Sr. Member
****
Offline Offline

Activity: 351
Merit: 250



View Profile WWW
April 15, 2013, 05:20:05 PM
 #1

Hello,

I'm trying to create a spreadsheet using my MtGox trade history data that will show both my realized and unrealized gains ( or losses) both in BTC and USD

Has anyone created such a spreadsheet?

Cheers!

1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
The network tries to produce one block per 10 minutes. It does this by automatically adjusting how difficult it is to produce blocks.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
1715579649
Hero Member
*
Offline Offline

Posts: 1715579649

View Profile Personal Message (Offline)

Ignore
1715579649
Reply with quote  #2

1715579649
Report to moderator
optimator (OP)
Sr. Member
****
Offline Offline

Activity: 351
Merit: 250



View Profile WWW
April 16, 2013, 05:33:44 PM
 #2

Bump!

I can make the spreadsheet and share the resulting template, but I'm missing some fundamental knowledge on how to proceed.

For example, is unrealized gains a weighted average of the buy price - sales price? Or would you match up the sale in a FIFO queue type approach?

If I transfer in BTC does that BTC have a cost basis? What is it? Do I need to track where the xfer-in BTC came from to determine the basis? (e.g. mining = 0 basis, BTC purchased on btc-e = whatever I paid, etc??)

Anyone care to help tackle this with me?

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!