Cryptofinance
Open Cryptowatch
Create Account
Pricing
Contact Us
Search…
Getting Started
Pricing
Markets Data
Cryptowatch Data
Trade Data
Historical Data
Historical OHLCV
All-Time-Highs
Market Macro Data
Return on Investment Data
Exchange Data
Exchange Data
Batch Formula
Supported Exchanges
Cryptowatch Portfolio Data
Holdings
Trades
Orders
Order Books Data
Markets Liquidity
Market Order Book
Blockchain Data
Bitcoin and Cryptocurrency Network Data in Google Sheets
Advanced
Best Practices in Google Sheets
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Advanced Usage and Tips in Google Sheets
Things to Know
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:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "last_trades")
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
7mo ago
Copy link
Outline
Overview
Example: Last trades for KRAKEN:BTC/USD