Last version published: 01/02/2018 10:58
Publication number: ELQ-19017-2
View all versions & Certificate
Cryptocurrency Portfolio Tracker
Cryptocurrency Portfolio Tracker in Excel that updates prices and produces a pie chart.
Crypto Portfolio Worksheet
This has been used to track a crypto portfolio. It updates the prices via a macro from coinmarketcap.com. It also produces a nice pie chart. Included is a worksheet that tracks the market cap and prices of the top 50 coins from coinmarketcap.com to point out the big movers and the losers over the duration of 24 hours.
1) Enter your holdings and the coin names. Use the naming convention used by www.coinmarketcap.com
2) Choose which ever Base Currency applies to you
3) To update the FX Rate and the prices, run the "Update" macro
To add extra coins, all that is required is insertion of an additional row in the middle of the table. Then you just need to add the details.
Top 50 Market Cap Worksheet
1) To update the prices, run the "Update" macro
2) In order to account for market movements since last run, sort the rank from smallest to largest
3) 24 hour % movement will be highlighted in red if <-5% and in green if >5%
Note: Personal notes in this worksheet are based on some very quick high level research. They are not to be considered facts and use those columns to populate your own thinking / research.
*Orginally shared on cryptocurrencytalk.com*
This business tool includes
1 Cryptocurrency Excel Tracker
Prks21 offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Cryptocurrency Real-time Price Tracker in ExcelReal-time Cryptocurrency price-tracker that is connected to worldcoinindex website that updates the price each minute.calculatorexcelspreadsheetcryptocurrencycryptoprice trackerbitcoinfintechreal time677 remove_red_eye
Cryptocurrency Positions Excel SpreadsheetThis spreadsheet will enable you to track returns on your Cryptocurrency investments.investingspreadsheettrackinggooglecryptocurrencycryptofintechposition1,312 remove_red_eyefreeby Enrique Bay
OKR, PPP and KPI manager Excel Model for small startup teamsThis guide and spreadsheet is to help teams of up to 20 members manage their KPIs, OKRs, & PPPs.performancekpiexcelspreadsheetpppokrtrackingready to usetracker969 remove_red_eye
Inventory and COGS Excel SpreadsheetCreated for the purpose of tracking your Amazon Inventory purchases and Cost of Goods Sold.cogsexcelspreadsheettrackingamazoncost of goods soldinventorybuy and selling2,586 remove_red_eye
Retail Inventory and Sales WorkbookInventory and Sales Excel Template Workbook for Retail.salesexcelspreadsheettrackingretailformulaeworkbookinventoryautomated990 remove_red_eyefreeby Vend
How to Make Your Financial Model Look ProfessionalThis tool provides Before and After examples to show you how you can make your models look professional.modelinginvestorsfundraisingfinancial modelingexcelspreadsheetprofessionalcredibilityappearanceappearance matters176 remove_red_eye
Mobile App / Website - 5 Year Recurring Revenue Excel Model TemplateA financial forecasting excel model template for apps or websites that have recurring paid subscribers.dcfsensitivity analysissaasrecurring revenuetemplateexcelspreadsheetfinancial forecastwebsite startupstartup business modelmobile app742 remove_red_eye$95.00by Jason Varner
Discount Cash Flow Template in ExcelThis is a discounted cash flow (DCF) template with income statement, balance sheet, FCF calculation & FV calculation.valuationcash flowdcfinvestordiscounted cash flowexcelspreadsheetmodellingvaluation methods260 remove_red_eyefreeby Andrew Han
Powerful and Customizable Debt Module Excel ModelPowerful, highly customization and free debt calculations module.debtinterestexcelspreadsheetprincipalscheduleannuityamortizationgrace periodrepayment338 remove_red_eye$19.00by Alex Martyanov
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscriptionecommercetemplateexcelspreadsheetgrowing348 remove_red_eye$299.00by Alexander Jarvis
Any questions on Cryptocurrency Portfolio Tracker?
The user community and author are here to help. Go ahead!