DIVIDENDDATA_KPIS
What It Does
Retrieves key performance indicators (KPIs) and operational metrics from Fiscal.ai. These are company-specific metrics not found in standard financial statements — like subscriber counts, user metrics, and operational data.
Why It's Useful
Standard financial statements don't tell the whole story. For companies like Netflix (subscribers), Microsoft (Azure growth), or Spotify (MAU), operational KPIs drive the business. This function gives you access to these advanced metrics for deeper analysis.
Syntax
=DIVIDENDDATA_KPIS(ticker, period, year, showHeaders)
Parameters
Parameter | Required | Default | Description |
ticker | Yes | - | Stock ticker symbol |
period | No | "annual" | "annual" or "quarterly" |
year | No | "" | Optional year filter |
showHeaders | No | TRUE | Include header row |
KPI Types (varies by company)
Streaming: Subscriber counts, ARPU, churn rates
Tech: Cloud revenue, user counts, engagement metrics
Retail: Same-store sales, store counts, e-commerce mix
Telecom: Subscriber adds, ARPU, churn
Banks: NIM, loan growth, deposit growth
Examples
Get Microsoft's KPIs (Azure, Office 365, etc.):
=DIVIDENDDATA_KPIS("MSFT", "annual", "2024", TRUE)Output: Operational KPIs specific to Microsoft
Get Netflix subscriber metrics:
=DIVIDENDDATA_KPIS("NFLX", "quarterly", , TRUE)Output: Subscriber counts, ARPU, and streaming metrics
Track Apple's services growth:
=DIVIDENDDATA_KPIS("AAPL", "quarterly")Output: Services revenue, install base, and other KPIs
Analyze Spotify's user metrics:
=DIVIDENDDATA_KPIS("SPOT", "quarterly", , TRUE)Output: MAU, premium subscribers, ARPU