Markets Liquidity

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

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

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:
1
=CRYPTOFINANCE("KRAKEN:BTC/USD", "liquidity")
Copied!
A 5×11 table with a header will be returned, showing the market current liquidity.
Kraken order book liquidity
Last modified 6mo ago