Bitcoin Forum
May 11, 2024, 09:21:13 PM *
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!

1715462473
Hero Member
*
Offline Offline

Posts: 1715462473

View Profile Personal Message (Offline)

Ignore
1715462473
Reply with quote  #2

1715462473
Report to moderator
1715462473
Hero Member
*
Offline Offline

Posts: 1715462473

View Profile Personal Message (Offline)

Ignore
1715462473
Reply with quote  #2

1715462473
Report to moderator
1715462473
Hero Member
*
Offline Offline

Posts: 1715462473

View Profile Personal Message (Offline)

Ignore
1715462473
Reply with quote  #2

1715462473
Report to moderator
It is a common myth that Bitcoin is ruled by a majority of miners. This is not true. Bitcoin miners "vote" on the ordering of transactions, but that's all they do. They can't vote to change the network rules.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1715462473
Hero Member
*
Offline Offline

Posts: 1715462473

View Profile Personal Message (Offline)

Ignore
1715462473
Reply with quote  #2

1715462473
Report to moderator
1715462473
Hero Member
*
Offline Offline

Posts: 1715462473

View Profile Personal Message (Offline)

Ignore
1715462473
Reply with quote  #2

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