DIVIDENDDATA_PROFILE
What It Does
Retrieves company profile information including market cap, sector, industry, CEO, description, employee count, and more.
Why It's Useful
When researching a stock, you need quick access to basic company information. This function helps you understand what a company does, what sector it operates in, how big it is, and other fundamental details — all without leaving your spreadsheet.
Syntax
=DIVIDENDDATA_PROFILE(symbol, metric, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol |
metric | No | - | Specific profile metric or "full" |
showHeaders | No | FALSE | Include headers for "full" |
Available Metrics
Metric | Description |
symbol | Stock symbol |
price | Current price |
marketcap | Market capitalization |
beta | Beta coefficient |
lastdividend | Last dividend |
volume / averagevolume | Volume metrics |
companyname | Company name |
description | Business description |
ceo | CEO name |
sector | Sector |
industry | Industry |
exchange | Exchange |
country | Country |
website | Company website |
fulltimeemployees | Employee count |
ipodate | IPO date |
isetf / isfund / isadr | Type flags |
full | Complete profile table |
Examples
Get market cap:
=DIVIDENDDATA_PROFILE("MSFT", "marketcap")Output: Market capitalization (e.g., 2850000000000)
Get sector:
=DIVIDENDDATA_PROFILE("XOM", "sector")Output: "Energy"
Get employee count:
=DIVIDENDDATA_PROFILE("WMT", "fulltimeemployees")Output: 2100000
Get full company profile:
=DIVIDENDDATA_PROFILE("AAPL", "full", TRUE)Output: Complete profile table with all metrics
Check if ETF:
=DIVIDENDDATA_PROFILE("SPY", "isetf")Output: TRUE or FALSE