How to do one thing with crypto data
A guide explains how this industry works. These are narrower and more immediate: one task, the two to six products here that do it, and the part nobody tells you — the rate limit, the candle that is not the candle you think, the export missing the field you needed.
How to see new DEX pairs as they launch
New pools by page, API or WebSocket on Solana and EVM chains — what each feed returns, how far back it goes, and why a new pair says nothing about the token.
Next to Charting6 approachesUpdated
How to get the price of a DEX pair
A pool quote is one number from one contract at one size. Four ways to read it, and why the figure you get back is not a price anyone could have traded.
Next to On-chain5 approachesUpdated
How to get token unlock data
Unlock calendars on a page, in CSV or by API — which fields each returns, how far back, at what price — and how to check one event against its source.
Next to Fundamentals5 approachesUpdated
How to paper-trade a bot before funding it
Three ways to run a crypto bot on live prices without money — its own dry run, an exchange demo, a hosted paper account — and what each fill model assumes.
Next to Bots6 approachesUpdated
How to stream live trades from several exchanges
One process, several venues' trade websockets, one record shape and reconnects that do not lose prints silently. Which library or feed to use, and what breaks.
Next to Market Data6 approachesUpdated
How to track a wallet and get an alert when it moves
Wallet alerts from a tracker, a labelled platform or your own poller. What each one calls a label, how fast it fires, and where the free tier stops.
Next to On-chain6 approachesUpdated
How to backfill tick-level trade history
Years of individual prints and book updates, some from venues that no longer trade. Where the tape is sold, what a year of it weighs, what you may do with it.
Next to Market Data5 approachesUpdated
How to place an order on several exchanges from one codebase
One order method over many venues — which library or service to use, and what the unified call hides about precision, order flags, rate limits and fills.
Next to Bots5 approachesUpdated
How to track one portfolio across several exchanges and a wallet
Connecting three exchanges and a wallet takes ten minutes. A total that matches what you own means knowing what each balance call leaves out.
Next to Terminals4 approachesUpdated
How to reconcile a token's supply and market cap
Two sources, two market caps, one token. The second factor is a judgement about which tokens count, and every vendor publishes a different one.
Next to Market Data5 approachesUpdated
How to get Hyperliquid positions and trade history as data
Hyperliquid serves any address's positions and fills to anyone, without a key. The catch is that its history endpoints stop at your 10,000 most recent fills.
Next to Terminals4 approachesUpdated
How to send a chart alert to a trading bot
A TradingView alert can POST to a bot that places the order. What the webhook costs, what it does not promise, and where the secret ends up.
Next to Charting5 approachesUpdated
How to get spot bitcoin ETF flows as data
No issuer publishes a daily flow. It is derived from shares outstanding and NAV, a day late, on each fund's own clock, and two aggregators can disagree.
Next to Fundamentals3 approachesUpdated
How to make a crypto backtest charge fees and funding
Four engines, four ways to charge maker and taker fees and perpetual funding — and the settings each one falls back to when you give it nothing.
Next to Backtesting4 approachesUpdated
How to get crypto prices into Google Sheets or Excel
An official add-on, a keyless CSV, or a script of your own. Why a Google Sheet shares its rate limit with strangers, and what a daily price is dated.
Next to Market Data4 approachesUpdated
How to map a ticker to exactly one coin
A ticker names a dozen tokens. Resolving one to a single asset across CoinGecko, CoinMarketCap, CCXT and the chains, and what a rename does to the table.
Next to Market Data5 approachesUpdated
How to query a blockchain with SQL
SQL over a decoded copy of the chain, not over the chain. Four ways to run the query, and the five things that make the first one cost more than you planned.
Next to On-chain4 approachesUpdated
How to export your exchange trade history
Getting the file is the easy half. What the exchange hands over is a ledger in its own terms, and a tax report needs a cost basis it never recorded.
Next to Terminals4 approachesUpdated
How to get a crypto implied volatility surface
IV, greeks and skew for BTC and ETH options — where the free marks come from, what a fitted surface costs, and why two vendors never quote the same number.
Next to Market Data6 approachesUpdated
How to get funding rates and open interest
Both numbers are free from the venue and one call away from an aggregator. But no two exchanges quote them in the same units or on the same clock.
Next to Market Data5 approachesUpdated
How to pull OHLCV candles from a crypto exchange
One library covers 104 venues, the venue's own endpoint is free and unkeyed, and the two disagree about what a one-minute candle is. Which to use, and when.
Next to Market Data5 approachesUpdated
How to watch liquidations on perpetual venues
A forced-liquidation feed is throttled at the exchange, so every total built on it is a floor. Four ways to read one, and what the print actually is.
Next to Market Data5 approachesUpdated