ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ETH TRADING PAIR PROFIT/LOSS CALCULATOR
2
Type the Coin Name (eg. NULS, OMG, ADA)ADA
3
4
For First Buy
5
Type the Unit Price you Bought the Coin (in ETH)0.000150000
6
Type the Number of Units of the Coin you Bought100.00
7
This is your First Investment Capital (in ETH)0.015000000
8
9
For Second Buy (Optional)
10
Type the Unit Price you Bought the Coin (in ETH)0.000120000
11
Type the Number of Units of the Coin you Bought100.00
12
This is your Second Investment Capital (in ETH)0.012000000
13
14
For Third Buy (Optional)
15
Type the Unit Price you Bought the Coin (in ETH)0.000100000
16
Type the Number of Units of the Coin you Bought100.00
17
This is your Third Investment Capital (in ETH)0.010000000
18
19
Your Total Investment Capital (in ETH) is0.037000000
20
Your Cumulative Average Unit Price (in ETH) is0.000123333
21
The Total Number of Units of the Coin you Bought is300.00
22
23
Type the Capital Pull Out Percentage Profit Level (eg. type 50 for 50%)100.00%
24
Type the Extra Percentage Profit you also Wish to Pull Out (eg. type 10 for 10%)10.00%
25
This is the Number of Units to Sell to Recover your Capital (plus the specified profit)
165.00
26
This is the Selling Price to Sell the Coin (in ETH)0.000246667
27
This is the Number of Units of the Coin that will Remain (Your Pure Profit)135.00
28
Type your Maximum Percentage Loss to Tolerate (eg. 5 for 5% or 10 for 10%)5.00%
29
This is the Unit Price Value that will Trigger your Stoploss (in ETH)0.000117167
30
31
NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: https://www.amazon.com/dp/B08MR33PX3 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 ETH, NEO, BNB, KCS, USDT, etc.

NOTE:
1,000,000,000 Gwei = 1 ETH
1 Gwei = 1/(1,000,000,000) ETH = 10^(-9) ETH = 0.0000000001 ETH

***CALCULATOR DESCRIPTION***

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.

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.

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 more.

You can see a step by step guide on how to use this calculator at https://www.microsofttut.com/2020/12/eth-trading-profit-loss-calculator-excel.html
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100