S&P 500

Returns the S&P 500 index value from FRED economic data. This is the FRED-sourced version used in economic research.

Data Source

Data is sourced from FRED (Federal Reserve Economic Data).

Notes

  • This is the FRED version (may be delayed)
  • For real-time data, use Last("^SPX") or Last("SPY")
  • Useful for economic research and historical analysis

Examples

=StandardAndPoors500()
S&P 500 from FRED
=Last("^SPX")
Real-time S&P 500

When to Use

  • Economic research requiring FRED data
  • Consistent data source with other FRED series
  • Long historical data series
  • Academic research

When NOT to Use

Scenario Use Instead
Real-time price Last("^SPX") or Last("SPY")
Historical close Close_Historical("^SPX", date)
Streaming updates QM_Stream_Last("SPY")

Common Issues & FAQ

Q: Is this real-time? A: No, FRED data may be delayed. Use Last("^SPX") for real-time.

Q: When should I use this? A: When you need consistent FRED-sourced data for economic research.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use S&P 500 and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions