The Luno order book in a spreadsheet

Team Luno
Back to blog

1 minute read

If you're a trader, looking for a simple way to get the Luno order book —the list of all bids and asks on the Luno Exchange— into Google Sheets or Excel, we've got a simple solution for you.


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
  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 Luno API.

Avatar Team Luno

Team Luno

On our way to the moon, we write about all things crypto. And don’t forget we’re humans too. Our blog conveys the views of Luno and the many unique opinions and characters within our team. We’ll never provide you with financial advice, and we urge you to conduct your own research before purchasing or trading any cryptocurrencies. It’s a brave new world out there, and the market can be volatile at times, so never trade with funds you can’t afford to lose. Want to let us know how much you love our blog? Tweet us @LunoGlobal.

It’s never too late to get started

Buy, store and learn about cryptocurrency today

Desktop Icon Apple App Store Logo Google Play Store Logo