Cryptocurrency Portfolio Dashboard in Microsoft Excel - Top 250 Coins - Data Live from COINGECKO Website (New Version) JAN 2022

Updates in NEW & Improved Version - Jan 2022

1. Top 250 Crypto Coins directly from CoinGecko website via POWER QUERY

2. Improved Visualizations

3. Quick Update within 30 seconds

4. Compatible for Microsoft Windows Users with Microsoft Excel Desktop Version having Power Query.

Features in Version 2.3 (3 SEP 2021):

1. Currency Translation Feature Added in Dashboard (Drop Down List)

2. New Visualizations Added

3. Top 3 & Bottom 3 Daily ROI

4. Crypto Currencies prices successfully updates from CoinMarketCap & CoinGecko Website. User needs to make sure that Excel also have POWER QUERY available to fetch live prices. (Only TOP 100 Coins will fetch in this version)

Features in Version 2.2 (July 2021):

1. Bug from the website of COINMARKETCAP for prices is resolved.

2. COINGECKO website prices worksheet is also added

3. Improved Dashboard Layout

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
Accounting & Dashboard for ETSY Sellers in Microsoft Excel
Accounting & Dashboard for ETSY Sellers in Microsoft ExcelA simple, beautiful, and easy to read design.The layout is not cluttered…
Premium Editable Graphic Resources for POWERPOINT Presentation Templates
Premium Editable Graphic Resources for POWERPOINT Presentation TemplatesYou can easily resize these resources without losing quality. To change the color,…
KPI Dashboard in Microsoft Excel
KPI Dashboard in Microsoft ExcelFinancial Metrics     Cash Flow     Expenditure     Profit %     Revenue     Revenue % -…
Monthly Planner Template in Microsoft Excel
Monthly Planner Template in Microsoft Excel
Calendar Template & Daily Planner in Microsoft Excel
Calendar Template & Daily Planner in Microsoft ExcelCalendar template – features:- One page, 12 month calendar view- Daily calendar with…
Financial KPI Visualization Dashboard in Microsoft Excel
Financial KPI Visualization Dashboard in Microsoft Excel
See All