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()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.
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?