Validating Market Regimes Across Six Tickers This is the second post in a multi-part series on tracking six tickers across multiple decades with different buy-sell models. The first post in the series illustrates how to collect historical prices with the GOOGLEFINANCE function in Google Sheets for six tickers and transfer the historical prices to a SQL Server database in order to achieve downstream modeling and analysis objectives. The six tickers for the post series are CAT, JPM, LLY, MSFT, NVDA, and SHW. The first post in the series includes a brief section describing the company for each ticker. This second post segments that same price history into a sequence of eras and assigns each one a regime: expansion, contraction, or shock. Driven by favorable market, economic, or societal conditions, an expansion era consistently generates higher prices at its close than at its beginning. Contraction or shock eras should end with lower prices than when they start beca...
