DIVIDENDDATA_SEGMENTS
What It Does
Retrieves revenue segmentation data by product line or geographic region. Shows how a company's revenue is distributed across different business segments or markets.
Why It's Useful
Understanding where a company's revenue comes from is crucial for assessing risk and growth potential. Is Apple too dependent on iPhone? How much of Microsoft's revenue comes from cloud? This function helps you analyze revenue diversification and identify key growth drivers.
Syntax
=DIVIDENDDATA_SEGMENTS(symbol, metric, period, year, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | Yes | - | "products" or "geographic" |
period | No | "annual" | "annual" or "quarter" |
year | No | "" | Specific year filter |
showHeaders | No | FALSE | Include header row |
Segment Types
Metric | Description |
products | Revenue breakdown by product line or business segment |
geographic | Revenue breakdown by geographic region |
Examples
Get Apple's product segments:
=DIVIDENDDATA_SEGMENTS("AAPL", "products", "annual", "2024", TRUE)Output: Table showing iPhone, Services, Mac, iPad, Wearables revenue
Get Microsoft's geographic breakdown:
=DIVIDENDDATA_SEGMENTS("MSFT", "geographic", "annual", "2024", TRUE)Output: Revenue by region (Americas, EMEA, Asia Pacific)
Get quarterly product segments:
=DIVIDENDDATA_SEGMENTS("GOOGL", "products", "quarter")Output: Quarterly revenue by segment
Analyze Amazon's business mix:
=DIVIDENDDATA_SEGMENTS("AMZN", "products", "annual", "2024", TRUE)Output: AWS, Online Stores, Physical Stores, Subscriptions, etc.