DIVIDENDDATA_QUOTE
What It Does
Retrieves stock quote data including current price, price changes, volume, moving averages, 52-week high/low, and historical prices.
Why It's Useful
Real-time and historical price data is essential for any investment spreadsheet. Use this function to monitor current prices, check if stocks are trading above or below their moving averages, or pull historical data for charting and analysis.
Syntax
=DIVIDENDDATA_QUOTE(symbol, metric, fromDate, toDate, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | No | "price" | The quote metric to retrieve |
fromDate | No | - | Start date for history ("YYYY-MM-DD") |
toDate | No | - | End date for history |
showHeaders | No | TRUE | Include headers for tables |
Available Metrics
Metric | Description |
price | Current stock price |
change | Price change (dollars) |
volume | Trading volume |
priceAvg50 | 50-day moving average |
priceAvg200 | 200-day moving average |
yearHigh | 52-week high |
yearLow | 52-week low |
full | All quote data points in a table |
history | Historical price data |
Examples
Get current price:
=DIVIDENDDATA_QUOTE("AAPL", "price")Output: Current stock price
Get 50-day moving average:
=DIVIDENDDATA_QUOTE("MSFT", "priceAvg50")Output: 50-day moving average price
Get 52-week high:
=DIVIDENDDATA_QUOTE("GOOGL", "yearHigh")Output: 52-week high price
Get historical prices for 2024:
=DIVIDENDDATA_QUOTE("MSFT", "history", "2024-01-01", "2024-12-31", TRUE)Output: Historical price table with Date, Open, High, Low, Close, Volume
Get full quote data:
=DIVIDENDDATA_QUOTE("AAPL", "full", , , TRUE)Output: Table with all quote metrics