{"id":16573,"date":"2017-12-13T12:27:45","date_gmt":"2017-12-13T17:27:45","guid":{"rendered":"http:\/\/chcollins.com\/100Billion\/?p=16573"},"modified":"2022-08-01T07:42:55","modified_gmt":"2022-08-01T11:42:55","slug":"the-trend-again","status":"publish","type":"post","link":"https:\/\/chcollins.com\/100Billion\/2017\/12\/the-trend-again\/","title":{"rendered":"The Trend, Again"},"content":{"rendered":"<p>I have written two posts about long-term trends in the U.S. stock market, as represented by the S&amp;P 500 price index.\u00a0 My first post, <a href=\"http:\/\/chcollins.com\/100Billion\/2013\/02\/the-trend\/\" target=\"_blank\" rel=\"noopener\">The Trend<\/a>, showed how the index swings above and below its long-term trend but eventually returns to the trendline.\u00a0 My second post, <a href=\"http:\/\/chcollins.com\/100Billion\/2014\/05\/trend-revisited\/\" target=\"_blank\" rel=\"noopener\">The Trend Revisited<\/a>, introduced the sidebar widget I created for the blog which compares the current index to the value predicted by The Trend.<\/p>\n<p>My third post on this subject tries to address a point that always bothered me: why offer information about stock market trends (or any topic for that matter) unless it allows one to act on it?\u00a0 I hope the following analysis makes a contribution toward that end.<\/p>\n<p>My goal is to show whether the amount that the current price is above-or-bel0w-trend says something useful about the return one may expect over the next twelve months and the chance that this return is positive.\u00a0 This is the type of information one might act on.<\/p>\n<p>To get started, I downloaded a list of the monthly closing prices of the S&amp;P 500 index from January 1950 to November 2017.\u00a0 Next, I calculated the amount that each price was above or below the trend and used that to sort the prices into buckets: 50% to 30% below trend, 30% to 10% below trend, 10% below to 10% above, and so on.\u00a0 Finally, for each of the month-end prices, I wrote down how much the price had increased (or decreased) twelve months later.<\/p>\n<p>I present this data in the chart below.\u00a0 Each horizontal bar represents the one-year return for a specific month in the timeframe, using blue bars for positive returns and red bars for negative returns.\u00a0 For example, the lowest red bar at bottom right represents the change (-28.8%) in the S&amp;P 500 index from September 30, 2000 (when the monthly closing price was 99.4% above trend) to September, 30, 2001.<\/p>\n<p><a href=\"http:\/\/chcollins.com\/100Billion\/wp-content\/uploads\/trend3-1a1.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16621 size-full\" src=\"http:\/\/chcollins.com\/100Billion\/wp-content\/uploads\/trend3-1a1.jpg\" alt=\"\" width=\"591\" height=\"534\" srcset=\"https:\/\/chcollins.com\/100Billion\/wp-content\/uploads\/trend3-1a1.jpg 591w, https:\/\/chcollins.com\/100Billion\/wp-content\/uploads\/trend3-1a1-300x271.jpg 300w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/a>You will notice a weak (but noisy) correlation between the amount that the current price is above or below trend and the one-year-later price change.\u00a0 Roughly speaking, the expected one-year-later return decreases by 1% for every 7.25% that the current price is above trend.<\/p>\n<p>Because there were relatively few data points in the uppermost trend buckets, I combined the four highest buckets for this analysis.\u00a0 Here are the results of interest, in tabular form:<\/p>\n<table width=\"448\">\n<tbody>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\" width=\"64\">Above\/Below Trend Range<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\" width=\"64\"><em>n<\/em><\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\" width=\"64\">Average One-Year Return (%)<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\" width=\"64\">Std Dev One-Year Return (%)<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\" width=\"64\">Chance of Positive Return<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">-50% to -30%<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">106<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">15.0<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">15.0<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">84%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">-30% to -10%<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">164<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">13.8<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">14.1<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">84%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">-10% to +10%<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">227<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">\u00a07.9<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">14.8<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">70%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">+10% to +30%<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">167<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">\u00a07.5<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">16.1<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">68%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">+30% and up<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">139<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">\u00a01.0<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">15.2<\/td>\n<td style=\"width: 64px; font-weight: bold; font-family: 'courier new'; font-size: 10pt; border: 1px solid; text-align: center; vertical-align: middle;\">53%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>First take note of the one-year returns.\u00a0 The average one-year-later return is pretty decent, as long as the current price is less than 30% above trend.\u00a0 If the current price is more than 30% above trend, one&#8217;s expected one-year return is close to zero.<\/p>\n<p>But also take note of the standard deviation (uncertainty) of the one-year-later returns.\u00a0 The uncertainty in the return, in every trend range, is about 15 percent.\u00a0 This means that, <a href=\"https:\/\/en.wikipedia.org\/wiki\/Standard_deviation\" target=\"_blank\" rel=\"noopener\">about two-thirds of the time<\/a>, the actual return will be somewhere from 15 percent less to 15 percent more than the average return.\u00a0 This is a large uncertainty for a one-year return: 15 percent represents about two years&#8217; worth of typical returns.<\/p>\n<p>This brings me to the last column, <em>Chance of Positive Return.*<\/em>\u00a0 As these figures show, one has an 84% chance of making money a year later if the current price is 10% or more below the trend.\u00a0 This offers the best opportunity.\u00a0 If the current price is 10% below to 30% above the trend, one still has a 68% chance of making money a year later.\u00a0 But if the current price is 30% or more above trend, the chance of coming out ahead one year later is only 50-50.<\/p>\n<p>[This sentence exists for the sole purpose of allowing your mind to absorb these figures.]<\/p>\n<p>As I said earlier, information is useless if one cannot take action by knowing it.\u00a0 The action one might take based on the amount the S&amp;P 500 index is above (or below) trend would be to sell (or buy) stocks.\u00a0 Based on this analysis, I suggest that one consider selling stocks if the current price is 30% greater than that predicted by the trend, because one&#8217;s chance of coming out ahead a year later is no better than 50-50.<\/p>\n<p>In all other cases, I would suggest holding onto your investments if you can weather the possibility of a negative return.\u00a0 (If you cannot weather that possibility, you should not be investing in the stock market or mutual funds in the first place.)<\/p>\n<p>One last item.\u00a0 You may ask, why did I focus on one-year returns as opposed to some other time period, such as six months or three years?\u00a0 It is because once-a-year is <a href=\"https:\/\/www.investopedia.com\/terms\/r\/rebalancing.asp\" target=\"_blank\" rel=\"noopener\">about the right frequency<\/a> for most people to review their savings and investments and make adjustments.\u00a0 The Trend is only one factor (and a minor one at that) to take into account when reviewing your investments.\u00a0 As the table suggests, The Trend is mostly useful for detecting bubbles and avoiding their collapse.<\/p>\n<p>Today, as I publish this article, the S&amp;P 500 index is about 10% above trend.\u00a0 My analysis suggests this is nothing to get excited about.\u00a0 There is a roughly two-thirds chance that the price one year from now will be somewhere between 7.8% lower and 23.2% higher, with an expected increase of about 7.7% and a 69% chance of making money.<\/p>\n<p>Here is hoping that you will now find The Trend useful, at last.<\/p>\n<p>________________<\/p>\n<h5>* To estimate the chance that the one-year return would be positive (for a given range), I first found the mean and the standard deviation of the return data for that range.\u00a0 Then, using the assumption that the one-year return data would be normally distributed, I calculated the Z-score for the zero-return point and then the fraction of the normal distribution that falls above this Z-score.\u00a0 That fraction of the distribution represents the chance that the one-year return is positive.<\/h5>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have written two posts about long-term trends in the U.S. stock market, as represented by the S&amp;P 500 price index.\u00a0 My first post, The Trend, showed how the index swings above and below its long-term trend but eventually returns &hellip; <a href=\"https:\/\/chcollins.com\/100Billion\/2017\/12\/the-trend-again\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[],"class_list":["post-16573","post","type-post","status-publish","format-standard","hentry","category-finance"],"_links":{"self":[{"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/posts\/16573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/comments?post=16573"}],"version-history":[{"count":64,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/posts\/16573\/revisions"}],"predecessor-version":[{"id":28243,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/posts\/16573\/revisions\/28243"}],"wp:attachment":[{"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/media?parent=16573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/categories?post=16573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chcollins.com\/100Billion\/wp-json\/wp\/v2\/tags?post=16573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}