Free Excel App for Converting USD or USDT to ETH - Crypto Calculator

11:02:00 0

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to ETH. The calculator also shows you the current equivalence of 1 ETH in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Ethereum value when you open the app.

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

How to Use the USD or USDT to ETH Calculator App (Spreadsheet Template)

All you need to do is to enter the amount (in USD) you wish to convert to ETH. The app will convert the amount you entered and show you the equivalence in BTC. Optionally, if you wish to transfer the fund from one exchange to another after converting from USD to ETH, this app can help you calculate the total Gwei value to enter when withdrawing the fund from any exchange, including the transfer charge. All you need to do is to type the ETH transfer fee of the exchange app (usually between 0.005 ETH to 0.007 ETH). Once you enter the value, the app will add it to the initial converted USD amount you entered. With this, all you need to do is to copy the total value and enter it when withdrawing the fund from any exchange platform.

To do another calculation, press the Reset button.


NOTE: 
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.

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.

See:

Free Excel App for Converting USD or USDT to BTC - Crypto Calculator

11:02:00 0

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to BTC. The calculator also shows you the current equivalence of 1 BTC in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Bitcoin value when you open the app.

How to Use the USD or USDT to BTC Calculator App (Spreadsheet Template)

All you need to do is to enter the amount (in USD) you wish to convert to BTC. The app will convert the amount you entered and show you the equivalence in BTC. Optionally, if you wish to transfer the fund from one exchange to another after converting from USD to BTC, this app can help you calculate the total satoshi value to enter when withdrawing the fund from any exchange, including the transfer charge. All you need to do is to type the BTC transfer fee of the exchange app (usually between 0.0005 BTC to 0.0007 BTC). Once you enter the value, the app will add it to the initial converted USD amount you entered. With this, all you need to do is to copy the total value and enter it when withdrawing the fund from any exchange platform.

To do another calculation, press the Reset button.


NOTE: 
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.
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 ETH, NEO, BNB, KCS, USDT, etc.

Remember:
1 Satoshi = 0.00000001 BTC = 10^(-8) BTC

See:

Free Ethereum Trading Pair Profit/Loss Excel Calculator App

11:01:00 0
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.

NOTE: 
1,000,000,000 Gwei = 1 ETH
1 Gwei = 1/(1,000,000,000) ETH = 10^(-9) ETH = 0.0000000001 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.

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


NOTE: 
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.
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.

How to Password Protect & Decrypt Word Documents Offline & Online

12:06:00 0
In order to prevent unauthorized access to your personal or office documents, you need to protect it with a password. For some other reasons, you might also want to remove password from a previously protected MS word files. You will learn how to password protect a word document and how to unlock any word document offline in this tutorial article. You will also learn how to restrict editing access on a word document and how to remove the restriction. Finally, I will reveal some free online tools for locking and unlocking a word document, and how to use these tools. For illustration, I used Microsoft Word 2013. But you can use any other version like 2010, 2013, 2016, 2020 upwards.

How to Password Protect MS Word File Offline

First open the word document you wish to protect with MS Word app.

Now click the File menu. Select the Info option.

Click the drop down arrow near Protect Document menu. Next, select Encrypt with Password as shown below.

Enter the document open password. Re-enter the password to confirm it and then click OK.


Microsoft Word will now indicate that the file has been protected. To view the content of the word file, you need to enter the password. Now click on Save to save the changes you made to the file.

Learn how to password protect PDF filesboth online and offline for free.

How to Restrict Editing in Word Document

You can control the types of editing others can make in your file by setting up the restrict editing in Microsoft word.

To setup restricting access:

Click File menu > Info option.

Select Restrict Access from the Protect Document menu as shown below.

You have 3 steps to follow: Formatting restrictions, Editing restrictions (with optional Exception) and Start Enforcement.

  • For Formatting restrictions: Check the "Limit formatting to a selection of styles" check box. You can click the Settings link to edit the allowed styles.
  • For Editing restriction: Check the "Allow only this type of editing in the document" check box. Then click the drop down menu to select the editing types to allow. No changes (Read only) is the default.
    You can also use the optional Exceptions section to specify parts of the document and users who are allowed to edit them freely. If you wish to allow everyone, then check the Everyone check box and then specify all regions they can edit by clicking the drop down arrow to the right of the check box. If you want only specific users to be able to edit these selected parts freely, click the More users link.
  • For Start enforcement: When you are ready to apply the changes to the document click on the Yes, Start Enforcing Protection button.

This prompts the Start Enforcing Protection dialog box as shown below.


You have two protection methods: Password and Authentication. You can use any protection method that suits you. Then click OK.

  • For the Password method: you need to enter a new restrict access password and confirm it. It must be different from the document open password you set earlier. Note that the document will not be encrypted. So malicious users can edit the file and remove the password with an online password unlock tool.
  • For the User authentication method: Users must pass the authentication before they can have access to the restrict access settings. Note that authenticated users can also remove the document protection. But the document will be encrypted and Restricted Access will be enabled.

Also note that you must sign in to your Microsoft office account in order to activate the User authentication method. But you can use the Password method without signing to your Microsoft account.

Save the word document to effect these changes you made.

See:

How to Decrypt a Protected Word Document Offline

To remove the password of a protected word document offline, you must provide the document. After which you will be allowed to decrypt the word file.

First, open the word document you wish to unlock with MS Word app.

You will be requested to type in the document open password before you can view the content of the document. Type the password and click OK as shown below.

Now to remove the document open password, click the File menu. Select the Info option.

Click the drop down arrow near Protect Document menu and select Encrypt with Password.

The Encrypt Document dialog box pops up with the document open password in the Password field. Delete those password and click OK.

MS Word has permanently removed the password. Save the word document to effect these changes.

How to Remove Editing Restriction in a Word Document

You might remove a document open password and also discover that you cannot edit the content of the word document. This is because the word document is set to restrict editing in some part or all parts of the document. In order to edit such a document, you need provide the Restrict Editing password or remove the password completely.

To deactivate Restrict Editing in a Word file:

Open the word document with MS word. If the file is locked with a document open password, follow the above guide for unlocking a password protected word document to unlock it.

If all editing access were restricted for the document, it will open in read only mode.

To enable editing, click on the View menu and then select Edit Document as shown below.

The document will now open fully, showing all the menus and MS Word features.

Now when you try to edit the document, MS Word will notify you that the document is restricted from unintentional editing.

To remove the restriction, click the Stop Protection button as shown below.

Microsoft Word will remove the editing restrictions. Now save the word document to effect these changes.

Learn how to remove password from any PDF file online and offline for free.

How to Use any Word Document Password Unlock Tool

  1. Upload the word file you wish to unlock to the server of the website.
  2. Most tools will ask you to provide the document open password. Type it.
  3. If editing access was also restricted in the document, you will be asked to provide the remove restriction password.
  4. The tool will start the decryption process. Once it is successful, you can download the decrypted version of the word document.

NOTE: For offline word document unlock tools, you don’t need to upload the word document first. It does the decryption offline.

Free Online and Offline Word Document Password Recovery Tools

Here are some free online and offline tools you can use to unlock any word document and also remove editing restriction.

  • Aspose Free Online Documents Unlocker: Unlock word documents, allows you to save to any desired format (PDF, JPG, HTML, etc.) and removes password in multiple files.
  • Passper for Word: Recovers the document open password and also removes the editing restriction password.
  • GuaWord: MS Word command-line password removal utility.
  • PassFab for Word: Password recovery tool for protected MS Word documents.

How to Use Online Tools for Locking any Document

Here is a general guide for using any online tool for password protecting any document.

  1. Upload the document you wish to password protect to the server of the website.
  2. You will be asked to provide and confirm the document open password.
  3. If you wish to restrict editing access, you will also provide another password for this.
  4. Then the tool will encrypt the document and ask you to download it. 
  5. Download it and try to open it. You will be required to provide the document open password to access the content of the file. If editing was also restricted, you be asked to provide the remove editing restriction password.

Check:

Conclusion

You have learnt how to password protect any word document both online and offline. Also, you learnt how to remove password from any locked word document both online and offline. I also revealed free tools for locking and unlocking word documents online. Feel free to use any method that suits you most.

Drop your questions in the comment section below. Click Here to subscribe to our blog to get notified via email when we drop new tutorial articles and videos. Share this article with your social media friends by clicking a share button below. Enjoy!

How to Calculate Mean (Average), Median & Mode in Excel

09:04:00 0
In numerical data analysis, there are 3 main measures of central tendency you need. These are: Average (Mean), Median and Mode. They are all standard measures of central location, but each of them is used in different instances to measure a central point. In this article you will learn how to calculate the mean, mode and median of a set of numerical data or grouped data in Microsoft Excel. I used Microsoft Office Excel 2013 for illustration, but you can use any other version, like 2010, 2016, etc.

How to Calculate Average in Excel

Average is also known as Arithmetic mean. It is the most popular of the 3 measures of central tendencies. To calculate the mean of a group of numbers, you simply add them up and then divide the total by count of these numbers. 

For instance, to calculate the mean of these numbers: {10, 20, 30, 40, 50}; Add them up and then divide the total by 5.

This is a manual way to calculate mean. But there are built in functions in MS Excel that can help you calculate mean faster.

Depending on your need, Excel has different built in Average functions. 
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
I will explain each of these functions.

Excel AVERAGE Function

Use this average function if you want to calculate the average of a set of numbers in cells.

The syntax is:

=AVERAGE(number1, [number2], …) or AVERAGE(cell references or cell range)

Note that in the first syntax, the first argument (number1) is required, while the subsequent ones are optional. You can include up to 255 arguments.

Examples of cell references are A2, B2, C3, etc. Examples of cell range is A2:A5, B2:B5, C2:C5, etc.
From the workers' details in the above screenshot, to calculate the average salary of all the worker, type the following formula:

=AVERAGE(D2:D11) then press Enter key. It will return $1,385 in the cell.

NOTE:
  • When using the AVERAGE function, cells containing zero values are counted, while blank cells are not counted. 
  • Also, cells containing text string and boolean values are neglected. But if you type boolean values directly into the AVERAGE, they are counted. The boolean value - TRUE is equal to 1, while the boolean value - False is equal to 0. Example, the formula =AVERAGE(TRUE, FALSE) will returns 0.5. This is the average of 1 and 0.
See: 

Excel AVERAGEA Funtion

Use this average function If the cells contain different types of data like number, text and boolean values (true and false).

The syntax is:

=AVERAGEA(value1, [value2], …)

Where value1, value2, … are values, arrays, cell references or ranges that you want to calculate the average. The first argument is required, while the other (up to 255) arguments are optional.

When using the AVERAGEA formula, the following should be noted:
  • Empty cells are ignored.
  • Text values returned by other formulas, including empty string are evaluated as 0.
  • Boolean value TRUE is evaluated as 1, while boolean value FALSE is evaluated as 0.
For example, the formula =AVERAGEA(5,FALSE) returns 2.5, which is the average of 5 and 0. The formula =AVERAGEA(5,TRUE) returns 3, which is the average of 5 and 1.

NOTE:
If you do not want the Boolean values and text strings to be included in your calculations, use the Excel AVERAGE function.

Excel AVERAGEIF Function

To find the average of a set of numbers based on a single criterion, use this average function.

The syntax is:

AVERAGEIF(range, criteria, [average_range]) then press Enter key.

Where:
  • Range is the range of cells where the given criteria will be tested.
  • Criteria is the condition used to determine which cells to include when calculating the average. The criteria can be supplied in the form of a number, logical expression, text value, or cell reference. For example, 2, ">2", "cat", or B2.
  • Average_range (Optional) is the cells you actually want to calculate their average. If omitted, Excel will calculate an average of the values in the range argument.
For example, if we want to calculate the average of only the male workers in the above screenshot, type the following formula:

=AVERAGEIF(B2:B11, "male", D2:D11) then press Enter key.

It will return $1,440.

AVERAGEIFS

To find the average of a set of numbers based on more than one criterion, use this average function. This function is the plural form of AVERAGEIF.

The syntax is:

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Where:
  • Average_range is the range of cells that you want to average.
  • Criteria_range1, criteria_range2, … are the ranges where the specified criteria will be tested. It accepts up 127 arguments. Criteria_range1 is required, while the subsequent ones are optional.
  • Criteria1, criteria2, … are the criteria that tells Excel which cells to include when calculating the average. You can supply the criteria in the form of a number, logical expression, text value, or cell reference. Criteria1 is required, subsequent criteria are optional.
For example, to calculate the average salary of female workers who are married, type the following formula:

=AVERAGEIFS(D2:D11, B2:B11, "female", C2:C11, "married") then press the Enter key.

The formula returns $1,600.

You can learn more about excel average functions here.

Check:

How to Calculate Median in Excel

Median is simply the middle value in a group of numbers when they are arranged in ascending or descending order. 

For example, the median of the following set of numbers: {1, 2, 2, 3, 4, 4, 5} is 3.

Finding the median of an odd number of values in a group is easier. But for even number of values, the medain is the average of the two middle values.

For example, to calculate the medain of these set of values: {1, 2, 2, 3, 4, 4, 5, 5}; you take the average of the 4th and 5th values in the data set. 
That is,  (3+4)/2 = 3.5

The syntax for median function is Excel is:

=MEDIAN(number1, [number2], …) then press the Enter key.

Where:
Number1, number2, … are numeric values you wish to find their median and can be up to 225 arguments. These can be numbers, dates, named ranges, arrays, or references to cells containing numbers. Number1 is required, while the subsequent numbers are optional.

The following are worth noting for Excel median calculation:
  • Cells with zero value are included in calculation.
  • Empty cells and cells containing text and boolean values are not included in calculation.
  • If you type the boolean values directly as arguments in the MEDIAN function, they are counted. The boolean TRUE value is evaluated as 1, while the boolean FALSE value is evaluated as 0. For example, the formula =MEDIAN(TRUE,FALSE,5,6,7) returns 5, which is the median of the numbers {1, 0, 5, 6, 7}.
From the above screenshot of the workers' detail, to calculate the median of the workers' salaries, type the following formula:

=MEDIAN(D2:D11) then press the Enter key.

The formula will return $1,350.
To confirm the answer, you can sort the data in the cells which you wish to find their median either in ascending or descending order. Since number of our data set was even (10), Excel returned the average of the 5th and 6th data (i.e. $1,300 and $1,400) which is equal to $1,350.
You can learn more about calculating median in excel here.

See:

How to Calculate Mode in Excel

Mode is the value in a data set that has the highest frequency or occurrence. You don't need to perform any calculation to find the mode of a data set. All you need to do is to count the number of times each value occurs in the data set.

For example, the mode of the set of values {1, 2, 2, 3, 3, 4, 4, 4} is 4.

The syntax for mode function is Excel is:

=MODE(range) or =MODE(number1, [number2], ...)
 then press Enter key.

Where:
  • Range or number1, [number2], ... is the range of cells or data set you wish to find their mode.
For the workers' details in the above screenshot, to find the mode of the workers' salary, type the following formula:

=MODE(D2:D11) then press the Enter key.

The formula will return #N/A error because all the values in the cell range occurred only once. So there is no mode.

NOTE:
If Excel discovers that there are two or more modes in your data set, the Excel MODE function will return the lowest mode.

Conclusion

You have learnt how to calculate mean (average), median and mode in any version of Microsoft Excel. You also learnt how to calculate these measures of central tendencies manually in this article. Feel free to apply these tips in any data set of your choice.

Help your social media friends to discover this amazing Excel tutorial by clicking a share button below.

Drop your comments below. Also click Here to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites. 

Free Bitcoin Trading Profit/Loss MS Excel Calculator for Crypto Traders

10:52:00 0
This is a simple bitcoin trading profit/loss calculator app 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 in Microsoft Excel. 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. You will also learn how to manually calculate the Satoshi value that will yield any percentage profit/loss in this article.

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

One of the recommended crypto trading practices is to calculate percentage profit or the unit price of the coin in Satoshi (or in BTC) that will give you a certain percentage profit. Since crypto trading is highly volatile and price of coins can move either up or down, you also need to calculate the highest percentage loss that you can tolerate in that trade, above which you quit the trade (say 5 or 10%). For long term trades, you might not want to sell all your bags at a particular profit level. You might decide to calculate the number of units of the coin to sell in order to recover your investment capital, alongside a little profit. Then you allow the rest to ride. Once you have got all these parameters, you now go ahead to set a sell order in your exchange app.

NOTE: This bitcoin trading 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 using the cumulative average formula (i.e. Your Total Investment Capital divided by Total Units of the Coin bought) before using this calculator. You also need to calculate the total number of units of the coin you bought.

This calculator also works only for BTC trade pairs. For example, ETH/BTC, XRP/BTC, NEO/BTC, ZEC/BTC, etc.

Here is a simple challenge you can solve with this calculator: 
Assuming you first bought 100 units of a coin, say Akropolis (AKRO) at 150 satoshi (0.00000150 BTC). Then the price came down further to 120 satoshi (0.00000120 BTC), you bought another 100 units. Also the price tanked further to 100 satoshi (0.00000100 BTC), you bought another 100 units, how do you know the number of units of this coin to sell in order to extract your 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 (e.g. AKRO)
  • Unit entry price (in BTC) 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). If you bought the coin only at a particular price, use only the For First Buy section.
  • Capital pull out percentage profit level (e.g. 100%). Long term traders always pull out out their capital after the price of a coin has risen to a certain percentage. If you wish to pull out your capital after the price of the coin has doubled, then you enter 100 for 100%.
  • Extra percentage profit to pull out alongside your total investment capital (e.g.10%)
  • Maximum Percentage Loss to Tolerate (e.g. 5%). Beyond this percentage loss, your stop loss will trigger.
The bitcoin calculator will calculate the following: 
  • Total Investment Capital (in BTC)
  • Cumulative Average Unit Price (in BTC)
  • Total Number of Units of the Coin you Bought
  • Number of units of the coin to sell in order to recover your capital plus the specified extra capital. 
  • Selling Price to Sell the Coin (in BTC) in order to meet your target.
  • Number of units of the coin that will remain after you have pulled out your capital plus some profits. 
  • Unit price of the coin at a particular percentage loss (in BTC). This is to help you know the value to use when setting stop loss in your exchange app. Once the price of the coin goes beyond this price, your stop loss should trigger. You sell off the coin and bear the loss.
See:
Below is the screenshot of the excel calculator with the solution to the above challenge (the units are in Satochi).
From the screenshot, if you sell 165 units of the of the coin, you will recover your total investment capital plus 10% extra profit. 

Then you will 135 units of the coin left in your bag.

At 5% loss, the unit price of the coin will be 117.17 Satoshi = 0.0000017717 BTC.

NOTE: The calculator app was recently updated so that the units are now in BTC. See the screenshot below.
If you are a long term bitcoin trader, you will appreciate this bitcoin trading calculator. 

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

Crypto trading calculator sheet contains the profit/loss calculator. 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. 

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.

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


NOTE: 
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.

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 ETH, NEO, BNB, KCS, USDT, etc. both manually and with Excel spreadsheet.

How to Calculate Crypto Trading Profit/Loss Manually

Make sure you note down your entry price for any coin you buy. You may also need to know your total investment capital. Once you know these 2 parameters, you can calculate the unit price that will yield any percentage profit manually.

I will show you two ways to calculate your crypto trading profit manually. One is through financial mathematics concept, while the other is a shortcut.

Method 1: Financial Mathematics Concept

From the knowledge of financial mathematics;
Unit Profit = Unit Selling price - Unit Cost price

In crypto trading, your unit cost price is your entry price, while your unit selling price is any price at which you wish to sell your cryptocurrency. Also note that if the value is negative, it means you sold at a loss.

Percentage Profit = (Unit Selling price - Unit Cost price) / 100

Total Investment Capital = Unit Cost Price * Number of Units bought; Note that the trading fee is assumed negligible here.

The Unit Selling Price that will yield any percentage profit is calculated as:
Entry Price + (Desired Percentage Profit * Entry Price)

Example: If you bought 100 units of a crypto coin at 150 Satoshi, at what Satoshi value will you sell it to make 20% profit?

Solution

Entry price = Unit cost price = 150 Satoshi
Desired percentage profit = 20% = 0.2

Total Investment Capital = Entry price * Number of unit bought
150 Satoshi *100 Units = 15,000 Satoshi

Unit selling price that will yield 20% profit
= 150 + (0.2 * 150) = 150 + 30 = 180 Satoshi

So if you sell the 100 units of the coin at a unit selling price of 180 Satoshi, you will make 20% profit.

NOTE: 
1 Satoshi = 0.00000001 BTC
Therefore 180 Satoshi = 180 * 0.00000001 BTC = 0.00000180 BTC

See:

Method 2: Crypto Profit/Loss Calculation Shortcut

If you find the first method a bit cumbersome, here is an easier way to calculate percentage profit/loss in crypto trading.

For the above example, we can calculate the unit selling price that will yield 20% profit using this shortcut:
1.2 * 150 = 180 Satoshi or 0.00000180 BTC

The same applies for any other percentage profit.
  • For 10% Profit: Multiply your entry price by 1.1
  • For 30% Profit: Multiply your entry price by 1.3
  • For 50% Profit: Multiply your entry price by 1.5
  • For 100% Profit: Multiply your entry price by 2
  • For 200% Profit: Multiply your entry price by 3
  • For 900% Profit: Multiply your entry price by 10
  • For 1000% Profit: Multiply your entry price by 11 ....etc.

Crypto Trading Percentage Loss Calculation Shortcut

Here, you want to know the unit price of the coin after a certain percentage loss.This will help you know the Satoshi value to use when setting your stop loss in your exchange app.

For example, if you bought a coin at a unit price of 120 Satoshi and the price tanked by 5%, the unit price of the coin after the 5% loss is:

(100% - 5%) * 120 Satoshi =  95% * 120 Satoshi = 0.95 * 120 Satoshi
= 114 Satoshi = 0.00000114 BTC

You can use the same concept for any other percentage loss.
  • After 10% Loss: The Unit price of the coin will be (100% - 10%) * Unit entry price in Satoshi
  • After 30% Loss: The Unit price of the coin will be (100% - 30%) * Unit entry price in Satoshi
  • After 50% Loss: The Unit price of the coin will be (100% - 50%) * Unit entry price in Satoshi
Check:

Conclusion

Knowing how to calculate your profit or loss in cryptocurrency trading is very essential. It will help you manage your portfolio and also know when to exit a trade; either for profit or loss. I shared how you can use our simple MS Excel Bitcoin trading calculator to calculate your crypto profit/loss. I also shared how you can calculate your trading profit/loss manually without any calculator.

If you wish to learn how to trade cryptocurrencies and make money, grab this book: How to Make Money from Crypto Trading & Investing for Beginners

Always trade on a secure exchange platform to avoid losing your capital. Here are some secure exchange platforms for crptocurrency trading.

I know you have learnt a new thing from this article. Share this article with your social media friends by clicking any of the share buttons below. 

Drop your comments below. Also click Here to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites. 

7 Best WordPress Blog and eCommerce Themes to Download

13:08:00 0
A site theme has a lot of impact. It determines to a large extent, whether search engines and the site's visitors will be impressed with its structure. That is why you need to carefully select a search engine optimized theme for your blog and eCommerce site. I have taken time to select these amazing WordPress themes that are affordable and will help your blog grow faster. Some are free while others are premium.

Before concluding on buying a WordPress theme, there are things you really need to check. Some of them are:
  • How mobile-friendly and responsive is the theme?
  • Is it a multipurpose theme? Or does it suit your site niche?
  • How easy is it to customize the theme?
  • Is the theme fee a one-time-fee or is it renewed every year?
  • Does it give you access to premium support? (for premium themes)
  • Is the price costly with respect to its features.
  • Does it implement Schema data structure?
  • What is the theme's over-all SEO rating?
I have considered the above tips when selecting these recommended themes from trusted theme sites.

Recommended WordPress Blog and Magazine Themes

News Paper


The best selling WordPress theme at Theme Forest! You will find a theme for any category of blog you want to build. Some popular niches are: Black Pro. Gossip Pro, Life News, Gossip Pro, Video News, Sports Pro, Fitness Blog, Beauty Pro, Food blog, Lifestyle blog, Crypto News, Product review, etc. Most popular blogs use News Paper themes because it is search engine optimized and loads very fast, even with a slow internet connection. You can easily import anthing you want and then customize them on the front end. There are more than 800 premium layouts to use.

The theme costs $59. Feel free to check out these themes.

See: 

Digiqole


Another simple and easy to use news magazine WordPress theme from Theme Forest. It has about 12 unique demos with different colours and designs to suit various blogging niches. The theme comes with drag and drop elementor builder. This makes it easy to setup and customize the theme even without any knowledge of coding. The theme costs only $33. See the various demos of Digiqole theme.

Theme Forest has tons of affordable search engine optimized WordPress themes. Some of them are Pixwell, ReHub, GutenVerse, Soledad, etc. Check them out.
Check: 

GoodPress Pro


An amazing WordPress theme from Happy Themes site. GoodPress Pro has to navigation bars, 5 slots for featured posts. The theme also allows you to display your recent articles in your home page category by category. It has a very light weight and optimized for search engines, visitors and for monetization. There are 3 footer sections where you can add widgets. It costs only $39 (one-time fee). You can check it out.

Video Host Pro


A recommended video, TV and multimedia blog theme from Happy Themes. It has a very light weight with a dark customizable backgound, giving it a matured look. You have many ways to customize your home page. Also, some categories of videos can be featured in the slider. It gives you room to add banner ads in between articles or videos. The footer also has 3 customizable sections. See full demo.

Happy Themes site is known for affordable themes that are search engine optimized. Check other recommended blog themes from this site.

Recommended eCommerce Themes for WordPress Sites

FlatSome



The best selling WooCommerce and business them from Theme Forest. Specially made for web designers and freelancers. There are unlimited options and also allows you to create any category of shop or business website without coding. It has more than 15 demos for online shop and 6 demos for other online businesses. The price goes for $59 only. Check the theme demos.

See: How To Fill And Submit The US Adsense Tax Form For Non-US Citizens

KartPul



If you want another cheaper WooCommerce theme that serves multipurpose. It has child theme support, very easy to customize; Ajax cart, wishlist, compare and quick view; revolution slider and full WooCommerce support, etc. The theme has 10 pre-designed demos for different categories of eCommerce sites. All these features with just $36. See all the demos.

There are other recommended WooCommerce themes from Theme Forest for any category of online store and business. You can check them.

e-Commerce



A simple, conversion optimized theme for any type of online shop with WooCommerce support from Templatic website. It is highly customizable and mobile friendly. You can create a blog section while still selling your product. The price is $59 for single site license. Check the demo.

See Why You Should Learn Microsoft Excel, Access & PowerPoint

Site to Download Free WordPress Blog and eCommerce Themes

Mystery themes site has amazing free and premium blog and WooCommerce themes. Some of their popular free themes are: News Portal, Scholarship, Editorial, Shopay, Mismo, Foodie Diary, Online Mart, Easy Shop, EDigital Market, etc. Check out their themes.

Read: 

Conclusion

I advise you to buy themes from trusted websites with secure payment gateways. This is to ensure that your payment details are not vulnerable to hacking. I carefully selected these theme sites where you can buy and download these WordPress themes for blogging and eCommerce. Feel free to purchase from any of them.

Drop your comments below. Also click Here to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites. Also share this article with your social media friends. Enjoy!