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.

свернуть