Markets Liquidity


Returns a given market liquidity as currently available in its order book. From 25 to 500 basis points, in base and quote currencies, for both ask and bid sides.

Function Syntax



  • All markets for 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.

  • Order book data is cached for 5 minutes.

  • The data is provided by Cryptowatch Public API

Example: Market Liquidity for KRAKEN:XBTUSD

On a new sheet, in cell A1 enter:


A 5×11 table with a header will be returned, showing the market current liquidity.

Kraken order book liquidity