Title: [ANN] An Easier Way to Connect Cryptocurrency Services to Spreadsheets Post by: spreadstreet on October 18, 2017, 03:15:07 PM https://i.imgur.com/RpllvHR.png
TL;DR: I created an easier way for non-programmers to access their favorite Bitcoin and cryptocurrency services within Google Sheets. You can find it here: https://chrome.google.com/webstore/detail/spreadstreet/fghpmppcbabgnpekploacbjijhppnkpp?authuser=0 (https://chrome.google.com/webstore/detail/spreadstreet/fghpmppcbabgnpekploacbjijhppnkpp?authuser=0) Hey all, I know some users of cryptocurrencies prefer to use spreadsheets (including myself) so I created a Google Sheets add-in that pulls certain API endpoints from popular Bitcoin and cryptocurrency services. I never had the time to develop software engineering skills, but the tool allows regular joes like myself to harness the power of APIs. Requirements:
Installing Step 1: Download the Google Sheets add-in Step 2: Open any Google Sheet Step 3: In Google Sheets top toolbar, click the Add-ons tab. Open the Spreadstreet add-on and click “Open”. Services and endpoints included: Bitcoin Charts
Bitfinex
Bittrex
Blockchain
Stock Twits
GDAX
Cryptonator
Cryptocompare
CoinMarketCap
Hoping this is something that is useful to the group, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here or to my inbox. Full disclosure I have set the add-in to be a 14-day free trial, and $15 a month after. I am currently exploring ways to make the service free, such as: Sponsored connections: Free connections that anybody can use where the service pays me to host them on the add-in Community submitted connectors Rate-limited free plan (currently do not have development talent to implement) I am in no way affiliated with any of the services listed, except for the actual add-in itself. I just happen to find the services very valuable. Helpful template to get you started I created a sheet that has some initial instructions, as well as a setup for Bitfinex. It brings in candles data, and recent tweets related to the symbol of your choosing. You can find that sheet here (File -> Make a copy): https://docs.google.com/spreadsheets/d/1P5WkVIk-e8jhVMS7TaptSKI83c1Ut5crLM1r8CUFUXc/copy#gid=0 (https://docs.google.com/spreadsheets/d/1P5WkVIk-e8jhVMS7TaptSKI83c1Ut5crLM1r8CUFUXc/copy#gid=0) A note on security: Our industry is rife with corruption. I know the hesitation involved with installing something that is script-based, like a Google Sheets add-in. I am here to help ease those fears with a couple of facts:
Additional Resources Help documents: https://spreadstreet.io/docs/ (https://spreadstreet.io/docs/) Using the built-in “SS” function: https://www.youtube.com/watch?v=gMqqEQ9ArDc (https://www.youtube.com/watch?v=gMqqEQ9ArDc) First time install and login: https://youtu.be/aLjtPR4T2bg (https://youtu.be/aLjtPR4T2bg) |