Cryptocurrency Portfolio Dashboard – Microsoft Excel – Data Live COINMARKETCAP & COINGECKO Website #criptocurrency #cripto
Download Template: https://www.eloquens.com/tool/qAaBIjLr/engineering/cryptocurrency-excel-templates/cryptocurrency-portfolio-dashboard-in-microsoft-excel-data-live-from-coinmarketcap-website
Cryptocurrency Portfolio Dashboard in Microsoft Excel – Data Live from COINMARKETCAP Website (Improved & Advanced) Version 2.3 | SEP 2021
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
Features in Version 2.0 (May2021):
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
Data Type Stocks | BTC | ETH | BNB | DOGE
Data Type Stocks | #BTC | #ETH | #BNB | #DOGE
Cryptocurrency Portfolio Dashboard in Microsoft Excel – Data Live from COINMARKETCAP & COINGECKO Website (New Version)