DIVIDENDDATA_FUND
What It Does
Retrieves data for ETFs and mutual funds including holdings, expense ratios, assets under management, sector allocations, and country weightings.
Why It's Useful
ETFs are popular for dividend investors — funds like SCHD, VYM, and DGRO provide instant diversification. This function lets you analyze ETF holdings, compare expense ratios, and understand sector exposures without visiting multiple websites.
Syntax
=DIVIDENDDATA_FUND(symbol, metric, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Fund ticker symbol (e.g., "SPY") |
metric | No | - | Fund metric to retrieve |
showHeaders | No | FALSE | Include headers for tables |
Available Metrics
Metric | Description |
etfcompany | ETF provider/company |
expenseratio | Expense ratio |
assetsundermanagement | Total AUM |
holdings | Top holdings (table) |
nav | Net asset value |
navcurrency | NAV currency |
holdingscount | Number of holdings |
countryweighting | Country allocation (table) |
sectorslist | Sector breakdown (table) |
description | Fund description |
assetclass | Asset class |
inceptiondate | Inception date |
Examples
Get expense ratio:
=DIVIDENDDATA_FUND("SPY", "expenseratio")Output: 0.0009 (0.09%)
Get SCHD expense ratio:
=DIVIDENDDATA_FUND("SCHD", "expenseratio")Output: 0.0006 (0.06%)
Get top holdings:
=DIVIDENDDATA_FUND("VTI", "holdings", TRUE)Output: Table with top holdings, weights, and share counts
Get assets under management:
=DIVIDENDDATA_FUND("SPY", "assetsundermanagement")Output: Total AUM in dollars
Get sector breakdown:
=DIVIDENDDATA_FUND("QQQ", "sectorslist", TRUE)Output: Table with sector names and weights