I'd like to be able to access historical total (market) return data with the end goal of creating a rolling return histogram of various asset allocations.

However, it looks like the GoogleFinance functions can only access share prices, not dividends. For this data to be useful to me, I would like to include the effects of reinvesting the dividends. I don't know of what use historical data is without any indication of dividend returns.

Is there a way to include dividends in a Google docs spreadsheet? Or even better, is there an online tool that will already show histograms (or show some variance metric) for various distributions?

I'd like to be able to access historical total (market) return data from a Google Sheet with the end goal of creating a self-updating rolling return histogram of various asset allocations.

However, it looks like the GoogleFinance functions in Google Sheets can only access share prices, not dividends. For this data to be useful to me, I would like to include the effects of reinvesting the dividends. I don't know of what use historical data is without any indication of dividend returns.

Is there a way to include dividends in a Google docs spreadsheet? Or even better, is there an online tool that will already show histograms (or show some variance metric) for various distributions?