The BitX Order Book in a spreadsheet

If you’re looking for a simple way to get the BitX Order Book –the list of all bids and asks on the BitX Exchange– into Google Sheets, we’ve got a simple solution for you.

Order Book

Simply make a copy of this Google spreadsheet and select the appropriate currency pair tab at the bottom of the page.

Deep dive

Interested in knowing how it was done? Most spreadsheets only support ImportHTML, ImportTABLE and ImportXML; none of which will work for our data (JSON).

To get ImportJSON working:

  1. Grab this ImportJSON script (by Chris Keller)
  2. Add it to Google Sheets under Tools > Script editor
  3. Use the following function
    =ImportJSON("https://api.mybitx.com/api/1/orderbook?pair=XBTMYR")
  4. Be sure to select the right currency pair, above is for Malaysian ringgit
  5. Set the appropriate execution times for refreshing the script

If you’re interested in building Bitcoin into your applications, head over to the BitX API.

Werner van Rooyen
Werner heads up Business Development and Growth at BitX. His passions include payments, e-commerce, technology, marketing and design: something that he has been fortunate enough to do on three different continents. Werner has lived and worked in South Africa, the United States, Indonesia, Taiwan and China.