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
Trade Data
Historical Data
Historical OHLCV
All-Time-Highs
Market Macro Data
Return on Investment Data
Order Books Data
Markets Liquidity
Market Order Book
Exchange Data
Exchange Data
Supported Exchanges
Disclaimer & Privacy
Risk Disclaimer
Privacy Statement
Terms of Service
Powered By GitBook
Trade Data

Overview

  • 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: Last trades for KRAKEN:BTC/USD

On a new sheet, in cell A1 enter:
1
=CRYPTOFINANCE("KRAKEN:BTC/USD", "last_trades")
Copied!
A 4×1000 table with a header will be returned, showing the market last trades.
Pro Tip — Use conditional formatting to reveal large orders.
Markets Data - Previous
Cryptowatch Data
Next - Markets Data
Historical Data
Last modified 4mo ago
Copy link
Contents
Overview
Example: Last trades for KRAKEN:BTC/USD