Overview

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

=CRYPTOFINANCE("KRAKEN:BTC/USD", "liquidity")

Specifics

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

  • 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:

=CRYPTOFINANCE("KRAKEN:BTC/USD", "liquidity")

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

Kraken order book liquidity