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
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
On a new sheet, in cell
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