Stock, Crypto & Forex Data in Google Sheets
Real-time stock prices, cryptocurrency data, historical OHLCV, and forex rates — directly in your spreadsheet with simple formulas. No API keys needed.
=STOCK_PRICE("AAPL")=CRYPTO_PRICE("BTC") =FOREX_RATE("EUR", "USD")All the financial data you need
Simple formulas that bring market data directly into your spreadsheet. Build portfolios, track crypto, convert currencies.
| Function | Description | Returns |
|---|---|---|
STOCK_PRICEStocks | Current quote data — price, volume, market cap, 52-week range | Single value or key-value table |
STOCK_HISTORYHistory | Historical OHLCV data — daily, weekly, or monthly intervals | Table: Date, Open, High, Low, Close, Volume |
CRYPTO_PRICECrypto | Crypto price + market cap, 24h volume, price change | Key-value table |
FOREX_RATEForex | Exchange rate between any two currencies (150+ supported) | Single number |
Market data made simple
Real-Time Stock Data
Get live prices, volume, market cap, P/E ratio, and 52-week ranges for any publicly traded stock.
Historical OHLCV
Pull daily, weekly, or monthly candlestick data for any date range. Perfect for backtesting and analysis.
Cryptocurrency Prices
Track 10,000+ cryptocurrencies with price, market cap, volume, and 24-hour change data.
Forex Exchange Rates
Live exchange rates for 150+ currencies. Build currency converters right in your spreadsheet.
No API Keys Needed
All data is proxied through our backend using free public APIs. No configuration, no secrets to manage.
Smart Caching
Intelligent caching keeps you within free API limits while ensuring fresh data. 2-5 min for quotes, 24h for history.
Finance functions in action
Real formulas, real data. Copy any formula and use it in your spreadsheet.
=STOCK_PRICE("AAPL")Returns all quote data: price, open, high, low, volume, market cap, 52-week range, and more.
| [0] | symbol | AAPL |
| [1] | name | Apple Inc. |
| [2] | price | 178.72 |
| [3] | previousClose | 177.49 |
| [4] | open | 177.85 |
| [5] | high | 179.12 |
| [6] | low | 177.35 |
| [7] | volume | 58234100 |
=STOCK_PRICE("MSFT", "price")Returns just the current stock price as a single value. Perfect for portfolio tracking.
425.52=STOCK_HISTORY("GOOGL", "2026-01-01", "2026-03-01")Returns a table with Date, Open, High, Low, Close, Volume for each trading day.
| [0] | Date | Open | High | Low | Close | Volume |
| [1] | 2026-01-02 | 185.00 | 186.00 | 184.50 | 185.50 | 50000000 |
| [2] | 2026-01-03 | 186.50 | 187.00 | 185.00 | 186.00 | 45000000 |
| [3] | 2026-01-06 | 184.20 | 185.50 | 183.00 | 184.80 | 48000000 |
=CRYPTO_PRICE("BTC")Returns Bitcoin price with market cap, 24h volume, and price change.
| [0] | symbol | BTC |
| [1] | price | 67250.50 |
| [2] | marketCap | 1320000000000 |
| [3] | volume24h | 35000000000 |
| [4] | change24h | 2.45% |
| [5] | currency | USD |
=CRYPTO_PRICE("ETH", "EUR")Get Ethereum price in Euros. Supports 30+ fiat currencies.
| [0] | symbol | ETH |
| [1] | price | 3245.80 |
| [2] | marketCap | 390000000000 |
| [3] | volume24h | 15000000000 |
| [4] | change24h | -1.23% |
| [5] | currency | EUR |
=FOREX_RATE("EUR", "USD")Returns the current exchange rate. Combine with multiplication for currency conversion.
1.0825Built for finance professionals
Whether you're tracking a personal portfolio or analyzing markets, these functions work for you.
Portfolio Tracker
Build a real-time portfolio dashboard. Track stock positions, calculate P&L, and monitor allocation across assets.
=STOCK_PRICE("AAPL", "price") * B2Crypto Watchlist
Monitor your crypto holdings across multiple coins and currencies. Set up price alerts with conditional formatting.
=CRYPTO_PRICE("BTC")Forex Converter
Build a multi-currency converter. Convert invoice amounts, track international payments, or monitor travel budgets.
=A2 * FOREX_RATE("EUR", "USD")Historical Analysis
Analyze stock performance over time. Calculate returns, moving averages, and volatility from historical data.
=STOCK_HISTORY("TSLA", "2025-01-01", "2026-01-01", "1wk")Frequently Asked Questions
Ready to bring market data into Google Sheets?
Finance functions require Pro plan (1 credit/request).
Pro: 500 finance credits/month. Business: 5,000 credits/month.
No credit card required • Install in 30 seconds • Cancel anytime
