Market Order Book


  • Order book data for all markets on 25 exchanges is available for free.
  • Exchanges include: Bitstamp, BitMEX,, Luno, bitFlyer, Bittrex, Okex, Binance, HitBTC, Bitfinex, CEX.IO, Gemini, Liquid, OKCoin, Huobi, Poloniex, Coinbase Pro, Bisq, Quoine, BitBay, Coinone, CryptoFacilities, Bit-Z, Kraken, Bithumb.
  • Syntax is as simple as =CRYPTOFINANCE("KRAKEN:BTC/USD", "ob")
  • Order book data is cached for 5 minutes.
  • Output is truncated at 100 orders on each side (bids and asks), with a depth of 100.
  • The data is provided by Cryptowatch Public API

Example: Market Order Book for KRAKEN:BTC/USD

On a new sheet, in cell A2 enter:
A 4×100 table with a header will be returned, showing the market current order book.
Pro Tip — Use conditional formatting to reveal buy/sell walls
Kraken order book

Example: Grouping Orders

This will group the bids and asks in thousands.