CoinTracking mobile

Realized and Unrealized Gains

Current unrealized and realized gain calculation for all your currencies including a coin-grouped summary.

Unrealized gain is the profit/loss you would achieve if you sell all your coins right now. Realized gain is the profit/loss you've already achieved with your sales.


This calculation is for experienced users. Hover over the Info icons on the right for additional information.

In order to correctly display the values on this page, it is imperative that all data has been entered correctly and completely into CoinTracking. If you encounter any problems, please read and follow the FAQs.

What can be done on this page?

  • Check your realized gains (PnL you have achieved so far) and unrealized gains (PnL from unsold assets) for each coin and currency (1st table - open by default)
  • Check your realized gains for each transaction (2nd table - closed by default)
  • Check your unrealized gains for each transaction (3rd table - closed by default)
  • Check the cost basis and the cost for all transactions
  • Use the Gains Calculator
  • Set the calculation settings
    • Prices
    • Method
    • Cost basis
    • Currency
    • Currency filter
    • Filter all entries by type, exchange, group and date
    • Add deposits and withdrawals into the calculation
    • Group all purchases by day
  • Search and sort your entries
  • Export all entries as CSV, Excel or PDF
  • Open additional transaction data by clicking on the 'plus' icon (table 2 and 3 only)

Possible problems and solutions

  • The amount of a coin does not match the value on the dashboard:
    The remaining amount of a coin can deviate in the gains calculation from the values on the dashboard, because deposits and withdrawals are not included.
  • This page is empty or a coin is missing:
    Gains are calculated from the value at purchase and the value at sale. If you do not have sales in your account, no profit will be displayed.
  • Gifts, mined coins and income are not charged with 0 USD:
    All incoming transactions such as gifts, mined coins and other income are calculated by default with the cost basis at the time of the transaction. If you would rather calculate with a cost basis of 0 USD, open the "Filter" and click on the corresponding trade type twice.
  • The cost basis seems wrong:
    If the cost basis is off, the transaction values could be wrong. Open the Transactions page and correct the value of the asset, if necessary (instruction).
  • Warnings for realized gains: It is imperative that all purchases and sales are entered correctly and completely in CoinTracking. If purchased coins are missing, this will lead to warnings and incorrect values for all gains calculations! (read more).
  • Hover the info icon in the upper right corner of each box for more information. Please also read the Gains FAQs if you have issues on this page.
CoinTracking · Chart
info
Filter settings

These filters apply to all three tables.

Method:
Changes the calculation method.
You can find an explanation and examples on the Tax-Report page.



Currency:
Displays all values in either your account currency or in BTC.
We do not just convert the Fiat value into BTC, but we calculate the Bitcoin value of every single transaction.
Because of BTC price changes, it's possible, that your BTC gain is negative, but your Fiat gain positive.



Currency Type:
Select between digital currencies (BTC, ETH...), commodities (Gold, Silver...), Fiat Currencies (USD, EUR...) or all together.
We are recommending "Only digital currencies".



Hide all zero and negative amounts:
Enable, to hide all currencies with an amount less or equal 0 in the summary table.

Group all purchases by day:
Enable, to group all purchases by day. It will also greatly reduce the number of items in your final gains report.

Group all sales by day:
Enable, to group all sales by day. It will also greatly reduce the number of items in your final gains report.

Long term after 10 years for interest generating coins:
In some countries interest generating coins only become tax-free or tax-reduced after 10 years.
Activate if your country has this rule and interest generating coins will extend their period to become long to 10 years. A deposit and a withdrawal with the Trade-Group 'Staking' is necessary to mark the coins and activate the feature as well.

Use depot separation:
By default, CoinTracking uses an overall method across all exchanges/wallets and calculates cost bases purely by date sequence. By activating the depot separation, all exchanges and wallets are treated as separate depots (tax lots).
Please ensure that all your deposits and withdrawals between exchanges/wallets are set completely and correctly in your CoinTracking account when enabling this setting.
This new depot separation automatically recognizes all deposits and withdrawals and assigns them to the respective exchanges/wallets.
  Conversion:
In order to calculate your gain and tax, all your trades that are not in your FIAT currency, must be converted into your FIAT currency at the time of the transaction.
We strongly recommend to use the 'Best Prices' setting.

Best Prices (recommended): will convert in this order:
1. FIAT currencies (USD, EUR, GBP...)
2. Crypto currencies and commodities based on their market cap
Transaction Prices: will convert the 1st part of your trade-pair into FIAT as cost base:
Counterpart Prices: will convert the 2nd part of your trade-pair into FIAT as cost base
Buy Prices: will always convert the buy part of your trade-pair into FIAT:
Sell Prices: will always convert the sell part of your trade-pair into FIAT

Example 1: Buy 1 BTC for 3000 USD (assuming USD is your FIAT currency)
- Best Prices: will use 3000 USD (no conversion here), since USD has a higher priority than BTC
- Transaction Prices: will convert 1 BTC into USD
- Counterpart Prices: will use 3000 USD (no conversion here)
- Buy Prices: will convert 1 BTC into USD
- Sell Prices: will use 3000 USD (no conversion here)

Example 2: Buy 60 ETH for 1 BTC (assuming USD is your FIAT currency)
- Best Prices: will convert 1 BTC into USD (as cost base and proceeds), since BTC has a higher priority than ETH
- Transaction Prices: will convert 60 ETH into USD as the ETH cost base and will convert 1 BTC into USD as the BTC proceeds value
- Counterpart Prices: will convert 1 BTC into USD as the ETH cost base and will convert 60 ETH into USD for the BTC proceeds value
- Buy Prices: will convert 60 ETH to USD (as cost base and proceeds)
- Sell Prices: will convert 1 BTC into USD (as cost base and proceeds)

Example 3: Buy 1 BTC for 60 ETH (assuming USD is your FIAT currency)
- Best Prices: will convert 1 BTC into USD (as cost base and proceeds), since BTC has a higher priority than ETH
- Transaction Prices: will convert 1 BTC into USD as the BTC cost base and will convert 60 ETH into USD as the ETH proceeds value
- Counterpart Prices: will convert 60 ETH into USD as the BTC cost base and will convert 1 BTC into USD as the ETH proceeds value
- Buy Prices: will convert 1 BTC into USD (as cost base and proceeds)
- Sell Prices: will convert 60 ETH into USD (as cost base and proceeds)

Filter active (56/56)
  • Transaction Types (44/44)
  • select all | unselect all | 0 costbase
  • Incoming Transactions
  •  
  • Outgoing Transactions
  •  
  • Exchanges (10/10)
  • select all | unselect all
  • Groups (2/2)
  • select all | unselect all
  • Period of Time (active)
  • remove date filter
  • Start date:
  • Start time:
  • End date:
  • End time:
Use the 'half checked' state for Trade Types,
to calculate them with a cost basis of 0 USD.
Calculating Total Balance...
info
Realized Gain / Loss for all Sales

This table contains all your sales that match the filter settings.
  • Type: Can be "Sell", "Withdrawal" or any outgoing transaction type.
  • Amount: The amount of the currency you have sold.
  • Cur.: The currency of your sale.
  • Cumulated Cost per Unit:(*) The calculated average purchase price per unit from all purchases before this transaction (value of all purchases till this date / amount of all purchases till this date). Should the purchase amount be negative, no change and realized gain will be calculated.
  • Sell Price per Unit:(*) The calculated sell price per unit for this trade at the time of your transaction (sell value / amount).
  • Change: The difference between your sale and the cumulated cost in percent.
  • Cumulated Cost:(*) The calculated purchase value (Cumulated Cost per Unit * Amount).
  • Sell Value:(*) The sell value of this transaction (Sell Price per Unit * Amount).
  • Realized Gain / Loss: The gain or loss you have achieved with this sale (Sell Value - Cumulated Cost).
  • Trade Date: The day and time of your transaction.
Export: You can export this table by clicking on the export buttons.
Column Sorting: Click on a column name to change the sorting. Shift-Click another column to sort multiple columns.
Additional Trade Information: Click on the blue plus on the left of each row, to display additional information.

Prices and values for columns marked with (*), can be changed with the counterpart/transaction filter at the top of the page.

Realized Gain / Loss for all Sales [Show details]

This table contains all your sales with the respective realized gain. It is the amount you've already achieved with your sales, calculated from the difference between your purchase price and sales price.
info
Unrealized Gain / Loss for all Purchases

This table contains all your purchases that match the filter settings.
  • Type: Can be "Buy", "Deposit" or any incoming transaction type.
  • Amount: The amount of the currency you have bought.
  • Cur.: The currency of your purchase.
  • Cost per Unit:(*) The calculated purchase price per unit for this trade at the time of your transaction (Cost / Amount).
  • Current Price per Unit: The current market price for the traded currency.
  • Change: The difference between your price and the current market price in percent.
  • Cost:(*) The total value of your trade at the time of your transaction.
  • Current Value: The current market value of your trade (amount * current price per unit). It's the market value you would get, if you sell the full amount right now.
  • Unrealized Gain / Loss: The gain or loss you would achieve, if you sell your full amount right now (Current Value - Cost).
  • Trade Date: The day and time of your transaction.
Export: You can export this table by clicking on the export buttons.
Column Sorting: Click on a column name to change the sorting. Shift-Click another column to sort multiple columns.
Additional Trade Information: Click on the blue plus on the left of each row, to display additional information.

Prices and values for columns marked with (*), can be changed with the counterpart/transaction filter at the top of the page.

Unrealized Gain / Loss for all Purchases [Show details]

This table contains all purchases with their unrealized gain. It is the difference between your purchase price and today's price. Coins which have already been sold are not taken into account.