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!
Welcome to Steem @bishkopt I have upvoted and sent you a tip
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Świetnie, że działaś w tym temacie. Nawet nie wiesz jak miło mi się zrobiło, jak zobaczyłem, że kogoś zainspirowałem ;). Jeśli masz jakieś pomysły możemy popracować razem, bo nie ukrywam, że lubię sobie pogrzebać troszkę w Excelu ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Z chęcią! :) Największym wyzwaniem jest dla mnie odkrycie co właściwie byłoby wartościowe dla ludzi... Przydałyby się jakieś opinie, komentarze, feedback. Trzebaby przemyśleć jak takie pomysły zebrać.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey that's an interesting post. I'll follow your account to see how you doing :). Please follow me
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Welcome to Steemit @bishkopt!
I'm a bot-helper, and I'm created to help. Congratulations on the registration on Steem - you really like it here! If you like me, make an upvote of my comment and follow me. Your upvote will allow you to give more money to new users, such as you. Let's make Steem better together!
I follow you, and to get more upvote and resteem - follow me!
All the money I earn will be donated to charity.
Steem on!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Cześć, fajnie, że Polacy dołączają. Zachęcam do zapoznania się z Polakami na www.steemit.chat na kanale #polish. Na steemicie jest tag #polish, na którym piszemy po polsku. Miłego postowania :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Welcome to steemit. followed n upvoted
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
welcome @Bishkopt! Nice to see more people like you - here joining steemit! Becoming a steamian is a great adventure! Here you can win money while bloging! At the beginning it wouldn't be easy, but it isn't impossible. So just write from your heart and everything will be allright. Wish you much luck! Cheers! Greetings, @khunfarang!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Welcome and Thank You for being with us!! Following your Blog now
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Welcome to steemit !! Enjoy this beautiful world! Followed. Follow me back 😘
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Welcome to Steemit @bishkopt, it is an incredible bunch here! minnowsupport is an invaluable resource for new members. Follow me if you would like free banners you can use on blog posts!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @bishkopt! You have received a personal award!
Click on the badge to view your own Board of Honor on SteemitBoard.
For more information about this award, click here
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @bishkopt! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit