Live Crypto & Stock Prices for Google Sheets: =CRYPTO() =STOCK() =FX() =FUNDING() + Portfolio Tracker

Live market data in Google Sheets with simple formulas: no API keys, no add-on subscription, no monthly fee.

FUNCTIONS

• =CRYPTO("BTC"): price, 24h/7d change, market cap, volume, rank, ATH, in USD, EUR, KRW and more

• =CRYPTOHIST("SOL",90): daily closes for charts (up to 365 days)

• =FUNDING("BTC","apr"): perp funding rate and open interest from Hyperliquid, OKX or Binance

• =FX("USD","KRW"): currency conversion for 160+ currencies

• =STOCK("AAPL","changepct"): stocks, ETFs, indices and global tickers (005930.KS, 7203.T, VOO, ^GSPC)

• Pass a whole range, e.g. =CRYPTO(A2:A50), and it fetches every row in one request

WHAT'S INSIDE

• Code.gs: paste it once via Extensions → Apps Script (3-minute setup, PDF guide included)

• Template workbook with Prices, Portfolio tracker (live value, P&L, 24h change, allocation), Funding and History tabs

• "📈 Live Prices" menu: refresh now, 15-minute auto-refresh, one-click "Build template tabs", data-source test

• Smart caching keeps big sheets fast and inside free API limits; automatic fallbacks if a source is busy

DATA SOURCES

CoinGecko (fallback Coinbase), Hyperliquid, OKX, Binance futures, open.er-api.com (fallback ECB), Yahoo Finance. All free and public. Quotes may be delayed. Binance futures often blocks Google's US servers; use Hyperliquid or OKX instead, as the guide explains.

Works in Google Sheets (free Google account). Custom functions do not run in Excel.

Already own our Portfolio Tracker & Rebalancer? Live Prices fills its price column automatically.

Instant download (ZIP: Code.gs, template .xlsx, PDF guide). Personal / single-business license. Not financial advice.