Wilshire 5000 Total Market Index
Returns the Wilshire 5000 Total Market Index from FRED. This represents the total value of all US equities.
What This Measures
- Total US stock market value
- Most comprehensive US equity index
- Includes all publicly traded US stocks
Data Source
Data is sourced from FRED (Federal Reserve Economic Data).
Notes
- Broader than S&P 500
- Useful for total market analysis
- May be delayed vs real-time
Syntax
=WilshireIndex()Returns
number
Wilshire 5000 index value
Examples
Wilshire 5000 from FRED
When to Use
- Total market analysis
- Market cap research
- Broad market trends
- Economic research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| S&P 500 only | StandardAndPoors500() or Last("^SPX") |
| Real-time data | Last() functions |
| Individual stocks | Last("SYMBOL") |
Common Issues & FAQ
Why is it called 5000 but has more/fewer stocks?
Originally designed for 5000 stocks; actual count varies with market.
How is this different from S&P 500?
Wilshire 5000 includes all US stocks; S&P 500 is 500 large-cap only.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Average Hourly Earnings - Private
- Average Weekly Hours of Production
- Average Weeks Unemployed
- Bank Reserves
- Building Permits
- Canada - U.S. Foreign Exchange Rate
- Capacity Utilisation - percent
- CBOE Volatility Index
See WilshireIndex used in a complete workbook: Buffett Indicator Dashboard Excel: June 2026 Market Cap to GDP Valuation Tool
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?