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.