Bitcoin Forum
July 19, 2019, 03:51:38 PM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: MtGox unrealized gains  (Read 1139 times)
optimator
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!

1563551498
Hero Member
*
Offline Offline

Posts: 1563551498

View Profile Personal Message (Offline)

Ignore
1563551498
Reply with quote  #2

1563551498
Report to moderator
1563551498
Hero Member
*
Offline Offline

Posts: 1563551498

View Profile Personal Message (Offline)

Ignore
1563551498
Reply with quote  #2

1563551498
Report to moderator
1563551498
Hero Member
*
Offline Offline

Posts: 1563551498

View Profile Personal Message (Offline)

Ignore
1563551498
Reply with quote  #2

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

Posts: 1563551498

View Profile Personal Message (Offline)

Ignore
1563551498
Reply with quote  #2

1563551498
Report to moderator
1563551498
Hero Member
*
Offline Offline

Posts: 1563551498

View Profile Personal Message (Offline)

Ignore
1563551498
Reply with quote  #2

1563551498
Report to moderator
optimator
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:  

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!