CoinTracking mobile
▾
EnglishEnglish
▾
LightLight
  • DimmedDimmed
  • DarkDark
  • Theme note (?)
    Change your CoinTracking theme:

    - Light: Original CoinTracking theme
    - Dimmed: Reduced brightness
    - Dark: All colors inverted

    Dimmed and Dark are experimental and may not work in old browsers or slow down the page loading speed.

    Please change back to Light, if you have problems with the other themes.
Quicklinks:   Trade Statistics  ·  Trade List  ·  Trade Prices  ·  Current Balance  ·  Daily Balance  ·  Balance by Exchange  ·  Balance by Currency  ·  Fees  ·  Short & Long  ·  (Un)realized Gains  ·  Trade Analysis  ·  Average Purchase Prices

You're seeing a live demo. Register For Free to get started.

arrow

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.
In order to correctly display the values on this page, it is imperative that all data has been entered correctly and completely in CoinTracking. For 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 from the values in the dashboard, because deposits and withdrawals will not be included in gains calculations.
    Enable the "Add Deposits & Withdrawals to remaining amount" checkbox to add them into the gains calculation (not recommended, as it does not make sense to calculate gains from zero cost basis items like deposits or withdrawals).
  • 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 EUR:
    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 EUR, open the "Filter" and click on the corresponding trade type twice.
  • The cost basis seems wrong:
    Please ensure you are using the "Unsold Assets as Cost Basis" setting, because "All Assets as Cost Basis" will calculate with average prices and is not recommended (read more).
    If the cost basis is still off, the transaction values could be wrong. Open the Enter Coins 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.

Prices:
This setting decides at which price your coins will be converted into your selected currency.

Counterpart Prices:
The counterpart price of your trade will be taken.
When you buy 1 BTC for 500 USD, we will convert 500 USD into your selected currency according to the trade price.
This setting is realistic, as it contains the spread and the fee. That's why your "Cost per Unit" will be slightly higher than the "Sell Price per Unit".
Shown in BTC, the above example may result in something like: Buy 1 BTC for 1.02 BTC (assuming 2% spread or fee).
Only if you did a perfect trade, without any spread and fee (what's nearly impossible), both values will be equal.

Transaction Prices:
The transaction price of your trade will be taken.
When you buy 1 BTC for 500 USD, we will convert 1 BTC into your selected currency according to the trade price.
This setting contains only the actual transaction price. Spreads, fees and other additional costs will be ignored. Your "Cost per Unit" will be exactly the same as the "Sell Price per Unit".
Shown in BTC, the above example will result exactly in: Buy 1 BTC for 1 BTC.

Best Prices: (recommended)
The currency with the lowest conversion difference (spread) is used in this order:
1. Fiat currencies (USD, EUR, GBP...)
2. Bitcoins (BTC)
3. Altcoins and commodities (ETH, LTC, XAG...) 		  Cost Basis:
Changes the method for the cost basis calculation
Average of unsold Assets as Cost Basis is recommended. But use it only, if all your purchases and sales are set correctly. More details.


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 absolutely possible, that your BTC gain is negative, but your Fiat gain positive.


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


Add Deposits & Withdrawals to remaining amount:
Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Enable: Includes all deposits and withdrawals into the calculation.
Gains and the cost basis will change as deposits and withdrawals do not have a cost basis.
Filter (16/16)
  • Trade Types (9/9)
  • select all | unselect all
  • Exchanges (6/6)
  • select all | unselect all
  • Groups (1/1)
  • select all | unselect all
  • Period of Time (all)
  • remove date filter
  • Purchase date start:
  • Purchase date end:
  •  
  • Sale date start:
  • Sale date end:
Use the 'half checked' state for Trade Types,
to calculate them with a cost basis of 0 EUR.

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" or "Withdrawal".
  • 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. Realized gain is the amount you've already achieved with a sale, calculated from your purchase price and your sales price.
info
Unrealized Gain / Loss for all Purchases

This table contains all your purchases that match the filter settings.
  • Type: Can be "Buy" or "Deposit".
  • 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 a theoretical 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.

You can find CoinTracking Support on these sites:

Copyright © 2013-2017, CoinTracking