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?
Topic: MtGox unrealized gains (Read 1235 times)
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!
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!
Jump to: