Free Ethereum Trading Pair Profit/Loss Excel Calculator App

This is a simple calculator to help you know the number of units of a coin you bought that you should sell at a particular price level in order to pull out your investment capital plus a little extra percentage profit. It will also help you calculate the unit price of the coin after a certain percentage loss, so as to help you know the unit price value to use as your stop-loss.
ethereum trading pair profit loss calculator app
The calculator assumes you didn't buy at more than three (3) price levels. If you bought at more than three price levels, then you need to calculate the average unit price and the total number of units of the coin bought before using this calculator. 

This calculator also works only for ETH trade pairs. For example, NULS/ETH, OMG/ETH, ADA/ETH, ZEC/ETH, etc.

1,000,000,000 Gwei = 1 ETH
1 Gwei = 1/(1,000,000,000) ETH = 10^(-9) ETH = 0.000000001 ETH

How to Use the Ethereum Trading Pair Profit/Loss Excel Calculator Spreadsheet Template

Here is a simple challenge you can solve with this calculator: 

Assuming you first bought 100 units of a coin, say Cardano (ADA) at 0.000150000 ETH (150,000 Gwei). Then the price came down further to 0.000120000 ETH (120,000 Gwei), you bought another 100 units. Also the price tanked further to 0.000100000 ETH (100,000 Gwei), you bought another 100 units, how do you know the number of units of this coin to sell in order to extract your investment capital plus 10% profit after the price of the coin has doubled? Also, what will be the unit price of the coin at 5% loss?

The parameters you need to enter are: 
  • Coin name (eg. ADA)
  • Unit price of the coin and the Number of units of the coin bought at each buy level (first buy, second buy and third buy, as the case may be) 
  • Capital pull out percentage (eg. 100%) 
  • Extra percentage profit to pull out alongside your investment capital (eg. 10%) 
  • Maximum percentage loss tolerance (eg. 5%). 
The calculator will calculate the number of units to sell in order to recover your capital plus the specified extra capital. It will also show you the number of units that will remain after you have pulled out your capital plus some profits. The calculator will also show you the selling price (in ETH) to sell the coin in order to meet your target. 

Also, it will also calculate the unit price of the coin at a particular percentage loss. This is to help you know the value to use when setting stop loss in your exchange app. If you are a long term Ethereum pair trader, you will appreciate this calculator. 

The excel workbook has two sheets: Crypto trading calculator and Crypto trading records.

The Crypto trading calculator sheet contains the profit/loss calculator. While the Crypto trading records sheet is where you can record the important details of each of your trade. Make sure you save the spreadsheet after entering a new record in that sheet before closing the excel app. If you wish to use the calculator to calculate the percentage profit/loss of another coin, simply click the Reset button and then enter the required parameters.

Ignore any error display in some cells while entering the parameters. Once you provide all the required parameters, the errors will disappear.

Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.
ethereum trading pair profit loss calculator app
NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like BTC, NEO, BNB, KCS, USDT, etc.

1 comment:

  1. Great stuff. The calculator details was very effective.