if you want to get historical SP500 earnings from SP for the last 30 years, click on the link below
https://www.spglobal.com/spdji/en/do...0-eps-est.xlsx
Clicking should autodownload an excel workbook, with the SP500 earnings, and other great data, plus the current earnings forecast for the next 4+ quarters. .
good luck to us