<p>The Adj Close column of <a href="https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC" rel="nofollow noreferrer">Yahoo Finance's historical data section</a> might be what you're looking for. It has the closing price adjusted for both dividends and splits, which could be used to calculate total return between any two dates. Just click Download Data to get it in an Excel readable format.</p>

CC BY-SA 3.0
2017-06-24T14:52:31.720Z
2017-06-24T14:52:31.720Z
C F
<p>Where can I find an excel sheet with total return (that is, with dividend reinvestment) of the S&amp;P 500?</p>

<p>I have only found an online "calculator" (not an excel sheet), or an excel sheet with prices only (not adjusted for dividends).</p>

<data-request><stock-market><financial-markets>
S&P 500 total return excel sheet
user56834
# S&P 500 total return excel sheet

(Asked by: username_0 on 2017-06-23)

Where can I find an excel sheet with total return (that is, with dividend reinvestment) of the S&P 500?

I have only found an online "calculator" (not an excel sheet), or an excel sheet with prices only (not adjusted for dividends).

**Tags:** data-request, stock-market, financial-markets


---

## 1 answers

### Answer by username_1 on 2017-06-24. Score: 1

The Adj Close column of [Yahoo Finance's historical data section](https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC) might be what you're looking for. It has the closing price adjusted for both dividends and splits, which could be used to calculate total return between any two dates. Just click Download Data to get it in an Excel readable format.


---

