DIVIDENDDATA_COMMODITIES
What It Does
Retrieves commodities data including current prices and historical data for oil, gold, silver, natural gas, and many other commodities.
Why It's Useful
Commodity prices affect many dividend-paying stocks — energy companies depend on oil prices, miners on metal prices, and utilities on natural gas. Track these prices alongside your portfolio to understand sector dynamics and spot opportunities.
Syntax
=DIVIDENDDATA_COMMODITIES(symbol, metric, fromDate, toDate, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | No* | - | Commodity symbol (required except for "list") |
metric | Yes | - | "list", "price", "fullquote", or "history" |
fromDate | No | - | Start date for history |
toDate | No | - | End date for history |
showHeaders | No | TRUE | Include headers for tables |
Available Commodity Symbols
Symbol | Commodity |
CLUSD | Crude Oil (WTI) |
BZUSD | Brent Crude Oil |
GCUSD | Gold |
SIUSD | Silver |
NGUSD | Natural Gas |
HGUSD | Copper |
PLUSD | Platinum |
PAUSD | Palladium |
ZCUSX | Corn |
ZSUSX | Soybeans |
KEUSX | Wheat |
KCUSX | Coffee |
Examples
Get current oil price:
=DIVIDENDDATA_COMMODITIES("CLUSD", "price")Output: Current crude oil price
Get gold price:
=DIVIDENDDATA_COMMODITIES("GCUSD", "price")Output: Current gold price (e.g., 2045.30)
Get historical oil prices for 2024:
=DIVIDENDDATA_COMMODITIES("CLUSD", "history", "2024-01-01", "2024-12-31", TRUE)Output: Daily oil price history
List all available commodities:
=DIVIDENDDATA_COMMODITIES(, "list", , , TRUE)
Output: Table of all commodity symbols and names