7 Easy Ways to Speed Up Your WordPress Website

08:27:00 0

The benefits of boosting your WordPress website are numerous. Your traffic will grow, and your search engine rankings will improve. Sadly, WordPress doesn't often make it simple to provide users with lightning-fast web pages. The best part is that you can immediately put many of them into practice to enhance the speed of your WordPress website.

how to optimize your wordpress blog speed
With little effort and our guidelines, you can speed up your WordPress site in 2023 and beyond by following the seven tips we've prepared for you! Let's get started.

#1: Select a Credible Hosting Provider

A speedy WordPress website is built on top-notch web hosting. You must pick a hosting company and a package that satisfies your needs for traffic and reliability. Check out the top WordPress hosting providers for 2023 and beyond if you're still debating your options so you can easily decide.

Your site's data will be stored by WordPress hosting. You purchase a package, and a server in the host's data center holds all your stuff. Thanks to the WordPress host, your customers can view, modify, and use the information. Therefore, choose wisely!

#2: Utilize a Light WordPress Theme

WordPress themes with numerous features, animations, gadgets, icons for social media, and other dazzling components are eye-catching. Your web service will undoubtedly take a beating if they are overwhelmed with items and larger web page sizes.

Using a light theme is your best bet in this situation. Choosing one of the WordPress themes is the simplest choice.

#3: Uninstall or Delete Unused Plugins

Since each plugin functions as a tiny piece of software on your site, having several activities in one go might slow download times. A plugin may steal resources and perform meaningless work, even if you aren't utilizing it. It could be time for some cuts.

Begin by turning off any plugins you are confident you won't ever use. Each time you deactivate a plugin, review your website to ensure everything is still functional before deleting it. Then check which plugins affect speed by deactivating each one individually.

#4: Install Top-Notch Plugins

The best WordPress plugins use server resources efficiently. They are always up-to-date, low in code, and won't consume a lot of server space.

Reading suggestion lists is the greatest approach to ensure that your plugins are performance-friendly. Read reviews and feedback for any underperformance concerns before implementing a new plugin, and re-run test procedures after activation to ensure your performance hasn't been dramatically harmed.

#5: Don’t Add Videos Directly to Your WordPress Website

Do not directly add videos to WordPress websites, even though they greatly enrich the material. But the issue with videos is that they typically have enormous file sizes. Alternatively, you post your videos to independent video hosting services like YouTube. After that, you can take the shortcode from whatever third-party video-sharing site you used to post your videos and insert it into your post. This step is a minimum requirement if you intend to include any video on your web pages to maintain a fast WordPress website.

#6: Clean Up Your WordPress Database

Database optimization will keep your database's volume to a minimum and reduce the volume of your backups by removing unnecessary material from your databases. Additionally, it's important to remove spam submissions, phony accounts, outdated versions of your material, and perhaps even undesirable extensions and customizations. Therefore, this will make your database and website folders smaller, speeding up WordPress.

#7: Utilize a CDN

A global network of linked web servers makes up a CDN. The JavaScript, CSS, and jpeg images for your site are stored on every server. The server nearest to the client delivers these data whenever they seek a webpage from your website. With a CDN, your site may be accessed from anywhere worldwide and run equally quickly for all users. On any WordPress website, CDNs are simple to set up and maintain. Your CDN handles all material distribution for you, and your host company probably includes it in your package or charges extra.

Why Should WordPress Website Be Sped up?

The most significant of the numerous valid reasons to speed up WordPress are listed below.

        Search engines give sites with faster load times a higher ranking than those with slow loading speeds. So, if you wish to have a successful site, one of your top goals should be to increase the functionality of your WordPress website

        You must speed up WordPress to retain around 75% of your users engaged

        Online consumers are the most demanding group; they anticipate that the website will load quickly. Therefore, the adage "time is valuable" is especially true if you are managing a retail site on WordPress

See:

Conclusion

One of your top goals should be speed optimization if you manage a WordPress website. Fortunately, we have advice you can utilize to reduce load times and give users the fastest experience. Saving your customers a significant amount of time is worth a little of your time.

How to Setup your GT Bank Internet Banking Account to Transfer FX

15:11:00 0

Do you know you can send foreign currencies (FX) from your GT Bank domiciliary account without visiting any GT Bank branch? Before now, I usually visit Bank branches any time I want to withdraw funds from my domiciliary account. Sometimes, the bank branches tell me they don’t have enough currencies. To stop these frustrating excuses, I started looking for better alternative ways to withdraw funds from my domiciliary account without visiting any bank branch. Luckily, I found a better and stress free alternative, which is to send the foreign currency directly from your domiciliary account to the receiver’s account. You will learn in this guide, how to setup your GT Bank domiciliary account to send foreign currencies (USD, GBP, EUR, etc.), how to transfer foreign currencies from your GT bank domiciliary account to any bank’s domiciliary account.

how to transfer foreign currencies from gt bank domiciliary account via internet banking


Why you Should Setup your GT Bank Domiciliary Account to Transfer Foreign Currencies (Benefits)

There are many reasons and benefits of setting up your domiciliary account to be able send out foreign currencies. One of the benefits is the ease and convenience of making transaction. With this you can now transfer funds at your convenience, without stress. Even in times of emergency (whether in midnights, weekends, etc.), you are covered.

Also, you can send funds to any domiciliary account holder in any part of the world, regardless of the bank.

Lastly, for those who sell their funds to foreign currency exchangers, you get a higher exchange rate when you sell your funds via direct transfer from your domiciliary account.

What is a Domiciliary Account?

Domiciliary account (popularly called Dom Account) is a type of savings or current account which allows you to send and receive foreign currencies from any part of the world. It is specially meant for those who earn in foreign currencies, and business men who use foreign currencies to import and export goods. Domiciliary is simply any type of bank account that runs on foreign currencies.

GT Bank gives you the option to create dollars, pounds and euros domiciliary accounts all at once. While most banks, you can only create one domiciliary account at a time.

See:

How to Setup your GT Bank Domiciliary Account to Send and Receive Foreign Currencies without Visiting any Bank Branch

First, you need to get a hardware token (popularly called hard token). A hardware token is a small (portable) hardware device that generates a 6-digit, time-based code used for authenticating any transaction in your online banking account. Go to any GT bank branch and request for hardware token. You will be charged a one-time fee of 2,700 naira. A form will be given to you. Fill and return it for processing. Below is an image of a hardware token.

how to transfer fx funds from gtbank dorm account: front view of a hardware token

Login to GTWorld app, then use your hardware token ID to link your hardware token to your bank account.

NOTE: Your hardware token ID is a 10-digit number or code located at the back of the hardware token.

how to transfer fx funds from gtbank dorm account: back view of a hardware token

To link your hardware token to your GT Bank account, login to your GTWorld app. From menu, go to Settings. Then tap the Confirm Token link.

how to link your gtbank hardware token to your bank account

Enter your hardware token ID, and tap the Confirm Token button.

input your hardware token id and tap the confirm token button

GTWorld will confirm your hardware token ID and link it to your bank account.

NOTE: Once you have linked your hardware token to your bank account, you need to provide a 6-digit, time-based code from the hard token before any transaction you perform in your online banking account platform will be authenticated, processed and approved.

Next is to activate your hardware token. Open your GTWorld app. Tap the Sign in GTWorld button (but don’t login yet). 

gtworld fx transfer online banking guide

Then tap the Sign up link. 

gtbank online banking sign up guide

Next, tap the Get Online Banking Details (For Existing GTBank Customer) link.

how to retrieve your gtbank online banking login details from gtworld app

Then go to the Token tab and fill in the required details. Input the 6-digit, time-based code from your token hardware (hard token). Finally, tap the Submit button.

how to get your gtbank online banking details from gtworld app


Your username and a new time-based password will be sent to the email address linked to your bank account. Use these details to login to your GTWorld app, and then change your password.

Now go to GT Bank InternetBanking Platform, and login with the updated login details of your GTWorld app.

guide on how to transfer usd eur and gbp from domiciliary account in gtbank  online banking

Congrats! You can now make transfers in your online banking account with your hard token.

NOTE: Before you can make third party transfers to another bank’s account from your GT Bank account via online banking, you need to first add the recipient as a beneficiary using your token device. This is to help secure your third party transactions.

Check:

How to Transfer Foreign Currencies from GTBank Account via Internet Banking

Login to GTBank online banking platform. From the menu, scroll down and tap the FX Transactions. Then select either FX Transfer to any GTBank A/C or FX Transfer to other Banks.

how to transfer foreign currencies from gt bank online banking

Tap the New Request button.

how to make fx transfer request in gtbank online banking platform

Now provide the required transfer detail (account to debit, transfer amount, purpose of transfer, add either a new beneficiary or select from stored beneficiaries, etc.). Answer your secret question. Agree to Terms and Conditions. Then tap the Continue button.

Now provide the time-based, 6-digit code from your hardware token needed to authenticate the transaction.

The recipient will receive the transferred foreign currency once the transaction is authenticated, processed and approved.

Details of GTBank Charges per Transaction for FX Transfers

·         Commission: 0.5% of Transaction Amount.

·         VAT: 7.5% of Commission.

·         Telex: 6,000 naira (or its equivalent in the currency being transferred).

·         Off Shore Charges: For USD - $25; For GBP - £12; For Euro – €20.

NOTE: For third party transfer/payment in USD, BIC/Routing Number is required. All Forex payments to the UAE require “Special Purpose Codes” and IBAN (Internet Banking Account Number). Pounds Sterling transfers require Sort Code (a 6-digit number that identifies the bank). While Euro transfers require IBAN and BIC (also called swift code – an 8 to 11 character code that identifies your country, city, bank, and branch).

Always ensure that your account is funded up to the required amount including the transaction charges, to avoid your transactions being rejected.

Also note that a hardware token is required to complete third party transfers.

gt bank online banking fx transfer charges details and notes

How to Add a Beneficiary to your GT Bank Domiciliary Account via Internet Banking Platform

Login to GTBank online banking platform. From the menu, scroll down and tap the FX Transactions. Then select either FX Transfer to any GTBank A/C or FX Transfer to other Banks.

Tap the New Request button.

In the Sender Details form, scroll down to the Account to Debit for Commission, VAT and Telex section. Tap the New Beneficiary button.

Now provide the needed details of the beneficiary (name, address, nature of business, bank BIC/SWIFT code, bank address, bank account number/IBAN, bank routing number/sort code, etc.

gtbank add new beneficiary form

You can also check the Store Beneficiary Details for Subsequent Transactions box.

See:

Conclusion

You have learnt how to setup your GTB internet banking account to transfer foreign currencies, why you should set up your domiciliary account to send out FX, how to add a new beneficiary to your GTBank internet banking platform, etc. Now enjoy a stress free internet banking in your GT Bank domiciliary account as a foreign currency earner.

Free Crypto DeFi Staking Yield/Rewards Calculator App

14:44:00 0
We have designed a free, simple calculator app to help you calculate your crypto staking total and daily rewards. It is always advisable to first estimate the total rewards from any staking opportunity before committing your coins/tokens.
defi staking rewards calculator

What is DeFi Staking?

Staking is one of the ways to earn passive income from some of your cryptocurrencies. This earning opportunity was created by DeFi (Decentralized Finance). When you stake your coin/token on any staking platform, the coin/token is locked in a smart contract for a specific period of time. Then as an incentive, you will be earning a daily reward, which accumulates until the lock-up/staking period is over. Some other ways to earn passive income from DeFi include: Yield farming, lending, providing liquidity, etc.

How the DeFi Staking Yield/Rewards Calculator App Works

This is a simple spreadsheet calculator app for calculating the total rewards for staking a certain amount of a coin/token for a particular staking/lock-up period in any DeFi staking platform. It also calculates your daily rewards for staking the coin/token. The purpose of creating this app is to help you estimate your expected staking rewards, so that you can weigh it and make appropriate decision.

You will be required to input the following:
  • The name of the coin/token you wish to stake. For example, if you are staking Ether, simply input ETH.
  • Principal amount of the coin/token you wish to stake. For example, if you wish to stake 5 ETH, simply input 5.
  • The Annual Percentage Yield (APY) offered by the staking platform. Assuming the staking platform is offering APY of 250% for ETH, simply input 250.
  • Staking/lock-up period in days. For example, if the lock-up period is 30 days, simply input 30.
Then the staking reward calculator will calculate the following:
  • Your daily reward for the staked coin/token amount.
  • The number of the coin/token you will earn at the end of the lock-up/staking period.
To do another calculation, press the Reset button.


Check:
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.
DeFi staking rewards calculator app

How to Calculate your Staking Rewards Manually 

Formula for calculating your total staking rewards/yield
= (Principal amount of the coin staked x APY x Staking period)/(365 x 100)

Formula for daily staking rewards
= Total staking rewards/Staking period in days

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.

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 and how to set price alert for any coin.

how to manage your crypto portfolio in coingecko app

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. 

how to manage your crypto portfolio in coingecko app

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

how to manage your crypto portfolio in coingecko app

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.
how to manage your crypto portfolio in coingecko app

Then click on Add Coin to Portfolio.
how to manage your crypto portfolio in coingecko app

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.

how to manage your crypto portfolio in coingecko app

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

how to manage your crypto portfolio in coingecko app

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.
how to manage your crypto portfolio in coingecko app


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).
how to manage your crypto portfolio in coingecko app

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

how to manage your crypto portfolio in coingecko app

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

how to manage your crypto portfolio in coingecko app

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

How to SetUp CoinGecko App Price Alert Feature

Search for the coin you wish to add price notification for and then tap on it to see its details on CoinGecko. Tap the + sign at the top right hand side of the page as shown in the screenshot below.

how to manage your crypto portfolio in coingecko app

Select the Add Price Alert option. This prompts the Add Price Alert page.

how to manage your crypto portfolio in coingecko app

Now specify the price at which you want CoinGecko app to alert you. You can specify in percentage or you type the exact alert price. 

Specify the how often you wish to be alerted (once or recurring?). The tap on Save as shown in the screenshot below.

how to manage your crypto portfolio in coingecko app
CoinGecko will alert you through your phone notification once the coin(s) reaches that specified price.

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.

See:

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.

app for converting usdt to btc - crypto calculator

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.


If you are finding it difficult to use the spreadsheet app, you can easily use the web app version: Free Crypto USD to BTC/ETH Converter/Calculator App.

Check:
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.
app for converting usdt to btc - crypto calculator
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.

usd to eth converter 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.


If you are finding it difficult to use the spreadsheet app, you can easily use the web app version: Free Crypto USD to BTC/ETH Converter/Calculator App.

Check:
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.
usd to eth converter 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.

See:

Free Ethereum Trading Pair Profit/Loss Excel Calculator App

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

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

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



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