Overview

Cryptocurrency Portfolio Dashboard in Microsoft Excel - Data Live from COINMARKETCAP Website (Improved & Advanced) May 2021

Instructions: https://youtu.be/fYzKnLA2VNE
Watch the above video


Features in Version 2.0 (May 2021):
1. Importing Real-Time Data from https://coinmarketcap.com/ into the Excel Power Query & Transformed.
2. One-Click REFRESH and Cryptocurrency prices updates in Dashboard & Datasheet.
3. More lines added in the Dashboard for Cryptocurrency Portfolio
4. Much improved visualization (TREEMAP), Dynamic Bar & Column Chart.
5. Historical Daily Data Sheet added so that user can maintain their past record for further analytics.
6. User can add BUY/SELL columns in Historical sheet and apply SUMIFS for further analysis.
7. KPI's Total ROI %, 24H% Change, Daily ROI, Current Crypto Value & More...

#cryptocurrency​ #cryptocurrencypakistan​ #bitcoin​ #ethereum​ #elonmusk​ #Dogecoin​ #doge​ #DogeToTheMoon​ #SpaceX

A cryptocurrency is a digital or virtual currency that is secured by cryptography, which makes it nearly impossible to counterfeit or double-spend. Many cryptocurrencies are decentralized networks based on blockchain technology—a distributed ledger enforced by a disparate network of computers. A defining feature of cryptocurrencies is that they are generally not issued by any central authority, rendering them theoretically immune to government interference or manipulation.

Understanding Cryptocurrencies
Cryptocurrencies are systems that allow for secure payments online which are denominated in terms of virtual "tokens," which are represented by ledger entries internal to the system. "Crypto" refers to the various encryption algorithms and cryptographic techniques that safeguard these entries, such as elliptical curve encryption, public-private key pairs, and hashing functions.

A cryptocurrency, cryptocurrency or crypto is a digital asset designed to work as a medium of exchange wherein individual coin ownership records are stored in a ledger existing in a form of the computerized database using strong cryptography to secure transaction records, to control the creation of additional coins, and to verify the transfer of coin ownership.

Reviews Add a review
No reviews yet

More From Rahim Zulfiqar Ali

Browse our top rated business templates. See All
Gantt Chart in Microsoft Excel
144
4
 Gantt Chart in Microsoft ExcelMany people have never heard of a Gantt chart. Simply put, a Gantt chart is a bar…
Human Resource (HR) Headcount Analytical Dashboard in POWER BI
441
0
Human Resource (HR) Headcount Analytical Dashboard in POWER BIVideo: https://youtu.be/jVPFEEjCdvkPower BI is a business analytics service by Microsoft. It aims to…
Financial Model for Startup in Microsoft Excel | Entrepreneurship
908
167
Financial Model for Startup | EntrepreneurshipNUMBERS THAT EXPLAIN YOUR STARTUP’S POTENTIALThis template includes the following worksheets:1. Capital Structure and Details2.…
Advanced Sales & Marketing Dashboard in Microsoft Excel
542
0
Advanced Sales & Marketing Dashboard in Microsoft ExcelKey features:Usually fits on one pageDisplays key trends, comparisons, and data graphically or…
Financial Model - Microsoft Excel - Based on 5 Years Projections (Standard Model for Everyone)
541
0
Financial Model - Microsoft Excel - Based on 5 Years Projections (Standard Model for Everyone)This template contains the following worksheets:1.…
Advanced Sales Analytical Dashboard in Microsoft POWER BI (DAX)
470
0
Advanced Sales Analytical Dashboard in Microsoft POWER BI using DAX This Sales Analytical Dashboard is filled with DAX and Visualizations…
See All