[ANN] An Easier Way to Connect Cryptocurrency Services to Spreadsheets

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

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:

Google Sheets
Spreadstreet add-in (can download with the link above, or from within sheet)

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

Markets: Returns a table with elements from each market

Bitfinex

Ticker
Trades
Book
Candles

Bittrex

Markets: Used to get the open and available trading markets at bittrex along with other metadata.

Blockchain

Difficulty: A relative measure of how difficult it is to find a new block.

Stock Twits

Recent Symbol Messages: Return the most recent 30 messages for the symbol

GDAX

Products: Get a list of available currency pairs for trading
Historic Rates: Historic rates for a product. Rates are returned in grouped buckets based on requested granularity.

Cryptonator

Complete Ticker: Returns actual volume-weighted prices, total 24h volume, rate change as well as prices and volumes across all connected exchanges

Cryptocompare

Mining Contracts: Returns all the mining contracts.
Mining Equipment: Used to get all the mining equipment available on the website. It returns an array of mining equipment objects.

CoinMarketCap

Ticker: The ticker is a high level overview of the state of the market. It shows you the current best bid and ask, as well as the last trade price.

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

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:

This is a U.S. based company, and I am a one-man show (for now)
My business location, phone number, and e-mail are all public knowledge as required by the laws of the United States
I am here to provide a valuable service, and something that I hope becomes a treasured tool within the space
The app is on the Google store, and they do a full review of all applications before allowing them to be pushed to the store. While not perfect, you can be reasonably assured they catch most malicious programs
If you are still hesitant, there are a couple of ways to test it without installing on your main computer, such as testing it in a virtual environment first.

Additional Resources

Help documents: https://spreadstreet.io/docs/

Using the built-in “SS” function: https://www.youtube.com/watch?v=gMqqEQ9ArDc

First time install and login: https://youtu.be/aLjtPR4T2bg