• Last trades data for all markets on 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.

  • Syntax is as simple as =CRYPTOFINANCE("KRAKEN:BTC/USD", "last_trades")

  • The last 1,000 trades will be returned and cached for 5 minutes.

  • The data is provided by the Cryptowatch Public API

Example: Market Order Book for KRAKEN:XBTUSD

On a new sheet, in cell A1 enter:


A 4×1000 table with a header will be returned, showing the market last trades.

Pro Tip Use conditional formating to reveal large orders.