The color scales conditional formatting option is a nice way to look at lots of numerical data and learn where there are concentrations of positive stock returns vs negative stock losses.
You can download this worksheet from [ Ссылка ] and the historical stock data is from [ Ссылка ]
We're comparing the year-by-year, 5-year rolling average, and 10-year rolling average returns of the S&P 500. This will help us feel confident that if we invest for 10+ years in the stock market, it's reasonable that we won't lose money.
![](https://s2.save4k.ru/pic/LZDxHcMLfXo/mqdefault.jpg)