Cryptocurrency Portfolio Tracker
Originally published: 25/01/2018 13:29
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 It also produces a nice pie chart. Included is a worksheet that tracks the market cap and prices of the top 50 coins from 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
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.

password= crypto123

*Orginally shared on*

This Best Practice includes
1 Cryptocurrency Excel Tracker

Prks21 offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Gus Tebon(last updated: 22/06/2021 17:42)
  • Scotty Chainsaw(last updated: 14/02/2021 05:19)
  • Mike Wilson III(last updated: 12/01/2021 08:20)
    Runtime error
    Runtime error
  • Eric Barnes(last updated: 10/12/2020 17:50)

People using this Best Practice also downloaded


Any questions on Cryptocurrency Portfolio Tracker?

The user community and author are here to help. Go ahead!

3.8 / 5 (4 votes)

please wait...