Cryptofinance
Open CryptowatchCreate AccountPricingContact Us
Search…
Getting Started
Best Practices in Google Sheets
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Things to Know
Advanced Usage and Tips in Google Sheets
Blockchain Data
Bitcoin and Cryptocurrency Network Data in Google Sheets
Markets Data
Cryptowatch Data
Exchanges Data
Trade Data
Historical Data
All-Time-Highs
Market Macro Data
Return on Investment Data
Order Books Data
Markets Liquidity
Market Order Book
Supported Exchanges
AltCoinTrader
Binance
Binance Jersey
Binance US
Bitbank
BitcoinTrade
Bitfinex
Bitflyer
Bitforex
BitHumb
Bitmax
Bitmex
Bitso
Bitstamp
Bittrex
Bitzeus
BTCMarkets
Coinbase
Coinbase Pro (ex-GDAX)
Coineal
Digifinex
Gate.io
Gemini
HitBTC
HuoBi
HuoBi Pro
Ice3x
IDAX
IDEX
Kraken
Kucoin
LocalBitcoins
Luno
Lykke
Mercado
Okex
Poloniex
QTrade
Trade Ogre
Upbit
VALR
Yobit
Disclaimer & Privacy
Risk Disclaimer
Privacy Statement
Terms of Service
Powered By GitBook
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
Markets Data - Previous
Return on Investment Data
Next - Order Books Data
Market Order Book
Last modified 6mo ago
Copy link
Contents
Overview
Function Syntax
Specifics
Example: Market Liquidity for KRAKEN:XBTUSD