Dow Jones Industrial Average (DJIA)
Returns the Dow Jones Industrial Average, a price-weighted index of 30 large U.S. blue-chip companies.
Data Source
S&P Dow Jones Indices via FRED.
Usage Notes
- No parameters required
- Returns index value
- For real-time quotes, use
Last("^DJI") - Price-weighted index (unlike S&P 500 which is market-cap weighted)
DJIA Composition
The DJIA includes 30 large U.S. companies across various sectors:
- Technology (Apple, Microsoft)
- Financial (Goldman Sachs, JPMorgan)
- Healthcare (Johnson & Johnson, UnitedHealth)
- Consumer (Nike, McDonald's)
- Industrial (Boeing, Caterpillar)
Index Characteristics
| Feature | DJIA | S&P 500 |
|---|---|---|
| Components | 30 stocks | 500 stocks |
| Weighting | Price-weighted | Market-cap weighted |
| Coverage | Blue chips | Broader market |
Syntax
=DJIA()When to Use
- Tracking blue-chip stock performance
- Market sentiment analysis
- Historical market comparison
- Building market dashboards
When NOT to Use
Common Issues & FAQ
How do I get real-time DJIA?
Use =Last("^DJI") for real-time Dow Jones quotes.
Why is DJIA different from S&P 500?
DJIA is price-weighted (30 stocks), while S&P 500 is market-cap weighted (500 stocks). S&P 500 is considered more representative of the overall market.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
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?