Real Net Exports
Returns the real (inflation-adjusted) net exports from FRED. Net exports equal exports minus imports, representing the trade balance.
Data Source
Data is sourced from the Bureau of Economic Analysis via FRED, reported quarterly.
Notes
- Negative values indicate a trade deficit
- Positive values indicate a trade surplus
- Key component of GDP calculation
Syntax
=RealNetExports()Examples
Current net exports (trade balance)
When to Use
- Trade balance analysis
- GDP component analysis
- Economic health assessment
- International competitiveness research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Exports only | RealExports() |
| Imports only | RealImports() |
| Nominal trade balance | FRED direct access |
Common Issues & FAQ
Why is the value negative?
A negative value means the US imports more than it exports (trade deficit).
How does this affect GDP?
Net exports is a direct component of GDP; deficits subtract from GDP.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Real Output Per Hour - Nonfarm
- Real Personal Consumption Expenditure
- Real Personal Consumption Expenditures
- Real Personal Consumption Expenditures - Durable Goods
- Real Personal Consumption Expenditures - Nondurable Goods
- Real Personal Consumption Expenditures - Services
- Real Personal Income Excluding Transfer Receipts
- Real Potential Gross Domestic Product
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?