MtGox unrealized gains

[optimator]

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!

[1714823365]

1714823365

[1714823365]

1714823365

[optimator]

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?