Bitcoin Arbitrage Visualization with Google Sheets

If you have access to international bitcoin exchanges, you might be able to take advantage of bitcoin arbitrage opportunities. Google Sheets has a great Scripts features that allows you to program requests to APIs in Javascript and I will show you how to store all of that data in Google Sheets and even receive email alerts at a predefined threshold.

We’ll be using Coinbase and Indodax as our two exchanges with arbitrage between USD and IDR.

First let’s create a function to fetch data from Coinbase:

Next let’s build our function to fetch data from Indodax:

Lastly, let’s get currency exchange data from USD to IDR:

Above we merely fetch exchange data and read the data that we fetched from Coinbase and Indodax and run some simple calculations to determine what the spread is. We added a 5% threshold to send an email alert when arbitrage opportunities exist.

Now all that remains is to create triggers for the functions to run at the intervals you want.

And as you can see in the image below, we have opportunities for arbitrage between 3-6% every few weeks.

BTCUSD, BTCIDR, BTCUSDIDR, USDIDR and MAX SPREAD

Related Posts

Connecting Google Sheets With Quickbooks Google Sheets is a great tool to interactively work with an assortment of APIs to work as an intermediary database for experiments or small scale data...
Google Apps Script to Extract Emails If you have a generic email that is being sent to you regularly and you happen to be a gmail user, you can easily extract that data into a spreadsheet...
Using Node.js and OpenCV to Count Colonies on a Pe... If you're looking for a relatively simple way to automate routine tasks that involve extracting information from images, using computer vision librari...
 

David Chun

I'm a full stack developer that builds tools for marketing and managing ecommerce shops. I occasionally consult for startups. If you've got an interesting project, reach out.

 

Leave a Reply

Your email address will not be published. Required fields are marked *