SP500-PE-RATIO — Daily CSV Download (S&P 500 P/E Ratio)
The trailing price-to-earnings ratio divides the S&P 500 price by reported earnings over the past 12 months. Unlike the CAPE, it responds to short-term earnings swings — making it useful for cycle timing but misleading during recessions when depressed earnings inflate the ratio. The two metrics are complementary: use the P/E for cyclical context, the CAPE for structural valuation.
Dataset: S&P 500 Trailing P/E Ratio (1871–2026) · Updated 2026-05-01
Macro Takeaway
This indicator is a key component of the macro-financial monitoring framework. Its current level relative to its historical distribution — captured in the percentile and z-score above — provides immediate context for whether conditions are historically normal, stretched, or compressed.
Cross-referencing with the CAPE ratio and the earnings yield helps situate this indicator within the broader macro regime.
Dataset Overview
| Indicator | S&P 500 Trailing P/E Ratio (1871–2026) |
|---|---|
| Geography | United States |
| Frequency | Monthly |
| Period | 1871–2026 |
| Variables | date, pe_ratio |
| Format | CSV, Excel (XLSX) |
| Sources | Robert Shiller, Yale University (ie_data.xls) — Open academic data |
| Last updated | — |
Dataset Variables
The CSV and Excel files contain the following columns.
| Column | Type | Description |
|---|---|---|
date | Date (YYYY-MM-DD) | Observation date |
pe_ratio | Float | Trailing 12-month price-to-earnings ratio |
Column names match the CSV headers exactly.
Download the Complete Dataset
The full dataset is available in CSV and Excel formats.
Direct CSV Access — Eco3min Structured Dataset
https://eco3min.fr/dataset/sp500-pe-ratio.csv
This URL returns the complete dataset in CSV format. It can be used directly in pandas, R, curl, or any data tool.
Using the Dataset in Python
import pandas as pd url = "https://eco3min.fr/dataset/sp500-pe-ratio.csv" df = pd.read_csv(url, parse_dates=["date"]) print(df.head()) print(df.describe())
Using the Dataset in R
library(readr) url <- "https://eco3min.fr/dataset/sp500-pe-ratio.csv" df <- read_csv(url) head(df) summary(df)
Both examples load the dataset directly from the URL — no download or API key required.
Methodology
S&P 500 price divided by trailing 12-month reported earnings. Source: Shiller dataset.
This dataset is updated automatically via the Eco3min data pipeline.
Historical Regimes
Historical regime analysis for this dataset will be added in a future update. The key stats block above provides immediate context for the current reading relative to the full historical distribution.
Related Macroeconomic Datasets
- S&P 500 CAPE Ratio — Smoothed 10-year valuation
- S&P 500 Earnings Yield — Inverse of P/E
Macroeconomic Dataset Hub
This dataset is part of the Eco3min macro-financial data repository.
Explore the Eco3min Dataset Hub
Sources
- Robert Shiller, Yale University (ie_data.xls) — Open academic data
Dataset Reference
Last updated — 16 May 2026
Disclaimer – Financial Information: The analyses, commentary, and content published on eco3min.fr are provided for informational and educational purposes only. They do not constitute investment advice or a solicitation to buy or sell financial instruments. Past performance is not indicative of future results. All investment decisions involve risk and are the sole responsibility of the reader.