Hello! :)
A few days ago, @bdr90 managed to import coinmarketcap example data to Excel.
Inspired by his work, I recreated it in Google Sheets (Apps).
Not only it is live (thanks to the API), but you can access is from everywhere (thanks to the cloud).
Example data:
What is more, I also integrated Poloniex and Bittrex data and merged them.
In one simple sheet you can see a live, sorted, clean orderbook or the currency pair of your choice (BTC-ETH and USDT-BTC added as an example).
The merged orderbook for BTC-ETH:
You can easily add other orderbooks (for other pairs):
a) Duplicate 3 sheets of already existing pair (tabs at the bottom of the Google Sheets window)
b) Rename them so that they include the name of your chosen pair
d) In each of these sheets edit G1 cells so that it matches the pair name
To use it, just open the sheet and duplicate the file for yourself (File → Make a copy).
I hope it could be a great starting point for your new Google Sheets altcoins dashboard. :)
Do you find it useful? How would you like to use it? What new functionalities or data would you add?
Please leave a comment and let me know what do you think!