• Order book data for all markets on 25 exchanges is available for free.

  • Exchanges include: Bitstamp, BitMEX, Gate.io, 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:XBTUSD

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 formating to reveal buy/sell walls

Kraken order book