DIVIDENDDATA_CRYPTO
What It Does
Retrieves cryptocurrency data including current prices and historical data for Bitcoin, Ethereum, and other major cryptocurrencies.
Why It's Useful
Even as a dividend investor, tracking crypto can be valuable — especially with crypto-related stocks like Coinbase or MicroStrategy. Monitor crypto prices alongside your equity positions in one spreadsheet.
Syntax
=DIVIDENDDATA_CRYPTO(symbol, metric, fromDate, toDate, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | No* | - | Crypto symbol (required except for "list") |
metric | Yes | - | "list", "price", "fullquote", or "history" |
fromDate | No | - | Start date for history ("YYYY-MM-DD") |
toDate | No | - | End date for history |
showHeaders | No | TRUE | Include headers for tables |
Available Symbols
BTCUSD (Bitcoin), ETHUSD (Ethereum), BNBUSD (Binance Coin), XRPUSD (Ripple), ADAUSD (Cardano), SOLUSD (Solana), DOGEUSD (Dogecoin), LINKUSD (Chainlink)
Examples
Get Bitcoin price:
=DIVIDENDDATA_CRYPTO("BTCUSD", "price")Output: Current Bitcoin price
Get historical Ethereum prices:
=DIVIDENDDATA_CRYPTO("ETHUSD", "history", "2024-01-01", "2024-12-31", TRUE)Output: Daily ETH price history
List all cryptos:
=DIVIDENDDATA_CRYPTO(, "list", , , TRUE)
Output: Table of all crypto symbols