How to Manage your Crypto Portfolio with CoinGecko App

05:42:00 0

Imagine having bought hundreds of crypto coins in different exchange apps. Sometimes, logging into each of these exchanges to check the performance of these cryptocurrencies you bought might be very stressful. But there are some special crypto portfolio trackers that can help you monitor the performance of all your crypto trades easily. CoinGecko app has a powerful crypto portfolio tracker you can use for free. You will learn how to use CoinGecko app to easily track your crypto portfolio from your smartphone or PC.

CoinGecko is one best free crypto research tools you can use to perform fundamental analysis before buying any cryptocurrencies. You can also learn about DeFi, yield farms, markets, Crypto news, Coin price updates, Crypto price to fiat currencies calculator, etc.

How to Use CoinGecko App Crypto Portfolio Tracker to Manage your Trades

First, you need to download the latest CoinGecko app from Google play store on your phone. You can get it at https://gcko.io/coingecko-android. Install the app and launch it on your phone.

Next, click the More tab and then click on Sign Up / Sign In. Login by clicking on Sign In if you already have an account with CoinGecko or you click on Create Account to create new account. 

After creating a new account, you will be required to login to the email account you used for the registration, click a verification link to verify your CoinGecko account. After that, your CoinGecko account is ready for use!

Now click on Portfolio tab to start building your favourite coin list. 

Watchlist vs. Portfolio


When you click on the Portfolio tab in your CoinGecko app, you will see two sub-tabs: Watchlist and Portfolio. The 2 tabs contain all the coins you mark as favourite. As the name implies, the Watchlist sub-tab is where you see the current price of the coin, 24H performance and the current market cap. But you cannot add a transaction under the Watchlist sub-tab.

But it is under the Portfolio sub-tab that you can add or record the transactions (buy, sell and transfer) you have carried out for any coin under your portfolio. In other words, the balance you see at the top of the Portfolio sub-tab is your real crypto portfolio if you add all the transaction you carried out in all the coins under your portfolio.

In summary, the Watchlist sub-tab of CoinGecko app is just like the front-end of a webpage while the Portfolio sub-tab is the back-end where you have many setup options.

See:

How to Add a Coin to your Portfolio

There are ways to add coins to your CoinGecko app portfolio:

Method 1: Search the Coin from the Market Tab

This method becomes handy if you just came across a new coin that interest you and wish to watch the coin's performance for some time before investing in it. With this method, you add the coin to the CoinGecko app watchlist.

To Add a Coin to your Watchlist: Under the Market tab, type the coin name in the search bar.

CoinGecko will load the details of the coins. You will see 4 basic tabs: 
  • Price Chart: This is where you see details like: contract address, market cap, trading volume, available and total supply, etc.
  • Exchanges: Here you will see all the exchanges where the coin can be purchased, with their available trading pairs and trading volume.
  • Portfolio: Clicking the Add to Portfolio link under this tab adds the coin to your portfolio list so that you can start tracking its performance. 
  • Info: Here, you will find the link to the official website of the coin project, blockchain/supply link, social media links, etc.
NOTE: You can add the coin to your portfolio by clicking the + sign at the right top corner of the page.

Then click on Add Coin to Portfolio.

Method 2: Search the Coin from the Portfolio Tab

To add a coin to your portfolio using this method: From the Portfolio tab, click the + symbol at the top right corner of the page and then type the coin name in the search box that appears.

Once the coin appears in the search result, click on it. 

Congrats! You have successfully added a coin to your CoinGecko app favourite list. Do this for all the coins you wish to track their performance.

Check:

How to Add the Transaction Details for your Portfolio in CoinGecko App

After adding coins to your portfolio, next is to add the transactions details (buy, sell and transfer) for each of the coins in your portfolio so that the tracker will help you calculate the percentage Profit and Loss (PnL) and the balance. With this, you will know the coins that are performing well and by what percentage.

Under the Portfolio sub-tab, click on Add at the right hand side of each coin in your portfolio.


There are 3 types of transactions you can setup for each coin in your portfolio:

  • Buy: For adding completed buy transactions.
  • Sell: For adding completed sell transactions.
  • Transfer: For recording transfer (in and out) transactions. For example, if you bought a certain amount of a coin in a particular exchange platform and wish to move a percentage to another exchange.
Choose the correct tab that suits the transaction you carried out for the coin in any exchange app. For example, if you initially bought 20 ETH and then sold 15 ETH, you need to add both the buy details for the 20 ETH (indicate the unit cost price in USD, the quantity and the date) and then the sell details for the 15 ETH (include the unit selling price in USD, the quantity and the date) under the Portfolio sub-tab, so that CoinGecko app can properly track your portfolio balance (5 ETH).

Click the Fees & Notes link to add the description for the transaction (under the Notes field) and the transfer fee (under the Fees field).

Once you are done, click on Submit. Confirm the submission by clicking on Save.

NOTE: You only add transaction details for the coins you have actually bought or sold in any exchange. If you added the coin(s) to your portfolio just to study its movement pattern then don't add any transaction detail for the coin(s).

Do you wish 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 discover cryptocurrencies with powerful potentials, how to calculate profits for other crypto trading pairs like BTC, ETH, NEO, BNB, KCS, USDT, etc.

Conclusion

You have learnt how to use CoinGecko app to track your crypto trading portfolio. There are other popular crypto portfolio tracking apps like Blockfolio, Delta, CoinTracking, Coin Market Manager, Kubera, CryptoCompare, Altrady CoinStats, etc. Each of these apps has its pros and cons. Weigh them and choose the one that suits you most. I love CoinGecko app portfolio tracker because it is very simple and easy to use. Blockfolio is another crypto portfolio management app I love.

Comment your questions and suggestions below. Click a share button to share this tutorial article with your social media friends. Enjoy!

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