There are hundreds (if not thousands) of cryptocurrencies that are bought and sold every day. Microsoft has only paid to receive data for the handful of major cryptocurrencies traded around the world. The currently available cryptocurrencies in Excel include:
-
Bitcoin (BTC)
-
Bitcoin Cash (BCH)
-
Litecoin (LTC)
-
Ripple (XRP)
-
Ethereum (ETH)
- Free Excel Cryptocurrency Portfolio Tracker Spreadsheet Download
- What to Look for in a Crypto Portfolio Tracker
- 1. Safety and Security
- 2. A Clean and Clear Layout
- 3. A Wide Range of Available Coins and Exchanges
- Benefits of Using Cryptocurrency Portfolio Tracker
- Does CoinMarketCap.com List All Cryptocurrencies?
- How Big Is the Global Coin Market?
- What Is an Altcoin?
- What Is an ICO?
- What Is a Stablecoin?
- What Are In-game Tokens?
Free Excel Cryptocurrency Portfolio Tracker Spreadsheet Download
We have attached a finalized copy of our homemade free-to-use cryptocurrency portfolio tracker spreadsheet which you can download using the button below.
You will need to download the cryptosheets addon. If you have not done so already.
If you like our work and would like to support us by learning, then we suggest trying a FREE trial in one of Skillshares Online courses:
- Learn how to invest in cryptocurrency on Skillshare
- Learn how to program with Excel / use Excel for analysis on Skillshare
You can also download free cryptocurrency templates on cryptosheets by following these steps:
- Click on cryptosheets
- Click on Templates
- Click on Load Templates
What to Look for in a Crypto Portfolio Tracker
Unfortunately, not every crypto portfolio tracker is equally useful and secure. Though every portfolio tracker will offer its own individual niche to appeal to a certain segment of traders, every choice you consider should have at least these 3 basic features.
1. Safety and Security
The decentralized nature of the blockchain makes Bitcoin and other cryptocurrencies exceptionally difficult to track and trace. It’s also very difficult to determine who owns which wallet — and once a cryptocurrency transaction has been initiated, it’s virtually impossible to get that money back.
This makes it especially important to choose a tracker that places an increased emphasis on security. Because many cryptocurrency portfolio trackers link with an exchange or your bank account, it’s crucial to protect your coins and your money. A single hack or data leak can leave your wallet vulnerable, so look for security features like two-factor authentication and multi-layer encryption.
2. A Clean and Clear Layout
The purpose of having a portfolio is to quickly view all of your assets and see how the value of your portfolio changes. A good portfolio tracker shows you the total value of your portfolio on its front page or with 1 or 2 clicks.
Your tracker should be simple to operate and understand, and you shouldn’t struggle to find the value of each individual coin in your portfolio. Look for a tracker with a crisp, clean layout that you enjoy looking at and using. This will save you time, stress and eye strain when using your portfolio tracker.
3. A Wide Range of Available Coins and Exchanges
A portfolio tracker should be a one-stop shop for all of your coins. Look for a cryptocurrency portfolio tracker that offers connectivity with all of the coins and all the exchanges you’re on.
If you search for a combination tracker and exchange, take a look at the platform’s coin offerings before you decide to sign up for an account. This will allow you to trade all of the coins you want without working with multiple exchanges and memorizing passwords.
Benefits of Using Cryptocurrency Portfolio Tracker
- Allows you to instantly browse and get a pulse of the entire crypto market
- Generates real-time reports on the loss or profit you make
- Connects to your exchange accounts and wallets to give you real-time balances for all your cryptocurrencies
- Helps you to easily manage your diverse crypto investment portfolios in one place, saving you time and effort
- Gives you instant price alerts on crypto market movements
- Allows you to track your investment performance, price, and charts
- And much more
Does CoinMarketCap.com List All Cryptocurrencies?
No, we do not list all cryptocurrencies at CoinMarketCap. As a company and team, we are very aware that not all coins and projects have good intentions. While we cannot guarantee to exclude them all, we have a vetting process that each coin goes through before it is listed on the site. If we suspect that a coin or project is a scam, it does not get listed.
How Big Is the Global Coin Market?
At the time of writing, we estimate that there are around 8,000 coins, tokens and projects in the global coin market. As mentioned above, we have a due diligence process that we apply to new coins before they are listed. This process controls how many of the cryptocurrencies from the global market are represented on our site.
What Is an Altcoin?
The very first cryptocurrency was Bitcoin. Since it is open source, it is possible for other people to use the majority of the code, make a few changes and then launch their own separate currency. Many people have done exactly this. Some of these coins are very similar to Bitcoin, with just one or two amended features (such as Litecoin), while others are very different, with varying models of security, issuance and governance. However, they all share the same moniker — every coin issued after Bitcoin is considered to be an altcoin.
What Is an ICO?
ICO stands for initial coin offering. Many of the smaller projects in the crypto space — and a few of the largest ones — raised money from private investors around the world in the crypto equivalent of a crowdfunding campaign. Investors would send funds — usually in the form of Bitcoin — to the project and receive coin or tokens in return. Most ICOs happened in 2017 and early 2018 and used Ethereum as a platform of operation via the ERC-20 standard. In 2018, the United States Securities and Exchange Commission (SEC) clarified their rules relating to fundraising for assets, which made it much harder for new cryptocurrency projects to issue their own tokens in this way. Since the appearance of the SEC guidance and the organization’s heightened interest in regulating ICOs for U.S. citizens, the number of ICOs has been reduced substantially.
What Is a Stablecoin?
Price volatility has long been one of the features of the cryptocurrency market. When asset prices move quickly in either direction and the market itself is relatively thin, it can sometimes be difficult to conduct transactions as might be needed. To overcome this problem, a new type of cryptocurrency tied in value to existing currencies — ranging from the U.S. dollar, other fiats or even other cryptocurrencies — arose. These new cryptocurrency are known as stablecoins, and they can be used for a multitude of purposes due to their stability.
What Are In-game Tokens?
Play-to-earn (P2E) games, also known as GameFi, has emerged as an extremely popular category in the crypto space. It combines non-fungible tokens (NFT), in-game crypto tokens, decentralized finance (DeFi) elements and sometimes even metaverse applications. Players have an opportunity to generate revenue by giving their time (and sometimes capital) and playing these games.
One of the biggest winners is Axie Infinity — a Pokémon-inspired game where players collect Axies (NFTs of digital pets), breed and battle them against other players to earn Smooth Love Potion (SLP) — the in-game reward token. This game was extremely popular in developing countries like The Philippines, due to the decent income they can earn. Players in the Philippines can check the price of SLP to PHP today directly on CoinMarketCap.
