Simple Crypto filters

in #crypto7 years ago (edited)

Coinmarketcap.com is, for many people interested in crypto land, the first site that’s checked each day. It’s used to see the state of the crypto nation when one considers price, traded volume and market capitalisation.

With more and more “alts” coming onto the market, it’s becoming a rather unwieldy list. At the time of writing there were nearly 1100 coins, tokens or assets listed.

In an attempt to see the wood for the trees, I’ve created the following spreadsheet

It’s a simple screen scrape from coinmarketcap.com with some spreadsheet filters applied. Unless you change them, it will only display those coins where the following is true:

  • Traded volume in last 24 hours ≥$1,000,000
  • Market capitalisation ≥$5,000,000

These numbers are fairly arbitary, and it’s by no means steeped in any signifciant analysis. It’s simply there to show me coins that may have some merit in them and warrant further investigation. You can easily change the filters yourself, of course.

There are two tabs:

  1. Currencies — Mineable or pre-mined crypto currencies
  2. Tokens

The price changes are colour coded as per below to try and catch the eye onto ones that have exhibited moves that may make them more interesting.

Screen Shot 2017-08-27 at 21.36.43.jpg

I’ve noticed the sheet doesn’t always automatically refresh based on traded volume and so I will re-initiate this by selecting the down arrow on column G and hitting “OK”.

Sort:  

Hi ,
Thanks for the great content

Congratulations @cassius-gray! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

Award for the number of upvotes received

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!

Thank you! A really helpful tool to help deepen the broad stroke perspective. You rock ;)

Cool. It's not perfect by any means but thank you for the kind words.

Very nice and fast to get what I want at a glance!