DIVIDENDDATA.QUOTE
What It Does
Retrieves stock quote data including price, volume, moving averages, and historical prices.
Why It's Useful
Monitor current prices, check moving averages, and pull historical data for analysis.
Syntax
=DIVIDENDDATA.QUOTE(symbol, [metric], [fromDate], [toDate], [showHeaders])
Available Metrics
price, change, volume, priceAvg50, priceAvg200, yearHigh, yearLow, full, history
Examples
=DIVIDENDDATA.QUOTE("AAPL", "price")=DIVIDENDDATA.QUOTE("MSFT", "history", "2024-01-01", "2024-12-31", TRUE)