Hello! :)
import coinmarketcap example data to Excel.A few days ago, @bdr90 managed to
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
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!
Hey that's an interesting post. I'll follow your account to see how you doing :). Please follow me
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!
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
Welcome to steemit. followed n upvoted
Ś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 ;)
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ć.
Welcome and Thank You for being with us!! Following your Blog now
Welcome to steemit !! Enjoy this beautiful world! Followed. Follow me back 😘
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!
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
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!