Out of curiosity, I was thinking if Excel could forecast the stock market. We know Excel’s Forecast is a function of making predictions by using the historical data and analyzing trends. Can the S&P 500 historical data shed some light on the future? Maybe or maybe not. I would like…
Category: S&P500
S&P 500 V.S. U.S. Dollar Index Forecast: A Reversal?
The 2-year chart below compares the S&P 500 index to the US Dollar index, and one thing is clear: when one goes up, the other goes down-except that one followed the other between 1/31/2020 and 3/9/2020. The USD and the S&P 500 generally move in opposite directions. S&P 500 stocks are…
S&P 500 Projection – 4063
Yesterday, I did a February projection on the S&P 500 – between 3862, a 4% gain from the January close, and 3899, a 5% gain from the January close. Today, the index hit the high of 3894 before it closed at 3886. The 5% projection is based on the historical…
S&P 500 Analysis and Forecast February 2021 – 3862.80 to 3899.95
Based on the monthly statistics since 2010, S&P 500 typically closes within +5% / – 5% of the previous month close. S&P 500 closed at 3714.23 in January. Therefore, the projected February targets would land on 3682.80, a 4% gain, or 3899.95, a 5% gain. This does not mean the…