Domestic Sales (Historical)
Returns the revenue from the company's home country market. For US-listed companies, this typically represents United States sales.
Understanding the Metric
Domestic sales indicate:
- Home market strength
- US market share (for US companies)
- Core market revenue
- Domestic economic exposure
Combined with foreign sales, this shows the geographic revenue split.
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker (e.g., AAPL, MSFT) |
| Year | Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1) |
| Quarter | Optional: 1, 2, 3, or 4 (default: 1) |
| TTM | Optional: "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last reported quarter |
| lq-1 | Quarter before last |
| ly | Last fiscal year |
| ly-1 | Year before last |
| lt | Last trailing twelve months |
| lt-1 | Prior trailing twelve months |
Syntax
=hf_Domestic_sales(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year (e.g., 2023) or period code (lq, lq-1, ly, ly-1, lt, lt-1)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Domestic/home country sales revenue (in currency units)
Examples
=hf_Domestic_sales("AAPL", 2023, 4)=hf_Domestic_sales("MSFT", "ly")=hf_Domestic_sales("WMT", 2023, , "TTM")=hf_Domestic_sales(A1, B1, C1)=hf_Domestic_sales("HD", "lq")When to Use
- Analyzing home market performance
- Understanding US market reliance
- Comparing domestic vs international growth
- Evaluating geographic concentration risk
- Building revenue breakdown models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need international sales | hf_Foreign_sales() |
| Need total revenue | hf_Revenue() |
| Need state-level breakdown | Not available in standard data |
| Need real-time sales | This is historical data only |
Common Issues & FAQ
What's considered "domestic" for a US company?
For US-listed companies, domestic typically means United States sales. For foreign companies listed in the US (ADRs), domestic refers to their home country.
Why doesn't domestic + foreign = total revenue?
They should approximately equal total revenue. Differences may arise from unallocated corporate revenue, intercompany eliminations, or different reporting standards.
How do I calculate domestic revenue percentage?
Domestic % = hf_Domestic_sales() / (hf_Domestic_sales() + hf_Foreign_sales()) * 100. High percentages indicate domestic market dependency.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Earnings Before Interest and Taxes - EBIT in USD (Historical)
- Earnings Before Tax (Historical)
- Earnings from Equity Interest (Historical)
- Earnings Indicator (Historical)
- Earnings Per Basic Share (Historical)
- Earnings per Basic Share USD (Historical)
- Earnings Per Diluted Share (Historical)
- Earnings Per Share Indicator (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today