Time Series Analysis

1. Time Series Analysis

2. Time-Series • Numerical data obtained at regulartime intervals • The time intervals can be annually, quarterly, monthly, daily, hourly, etc.

3. Time-Series Components Trend Cyclical Time-Series Seasonal Random

4. Inherent in the collection of data taken over time is some form of random variation. “Moving Average or Smoothing ” is a technique used for reducing of or canceling the effect due to random variation. “Smoothing” data removes random variation and shows trends and cyclic components

5. Random or Irregular Component • Nonsystematic, random, fluctuations • Due to random variations of • Nature • Accidents • Short duration and non-repeating

6. Trend Component • Overallupward or downward movement • Data taken over a period of years Upward trend Sales Time

7. Cyclical Component • Upward or downward swings • May vary in length • Usually lasts 2 - 10 years 1 Cycle Sales

8. Seasonal Component • Upward or downward swings • Regular patterns • Observed within 1 year Sales Winter Summer Winter Spring Fall Time (Monthly or Quarterly)

9. Taking averages is the simplest way to smooth data.Moving averages smooth out a data series and make it easier to identify the direction of the trend. Because past price data is used to form moving averages, they are considered lagging, or trend following, indicators. Moving averages will not predict a change in trend, but rather follow behind the current trend. Therefore, they are best suited for trend identification and trend following purposes, not for prediction.

10. A manager of a warehouse wants to know how much a typical supplier delivers in 1000 dollar units. He/she takes a sample of 12 suppliers, at random, obtaining the following results:

14. The estimator with the smallestMSE is the best. It can be shown mathematically that the estimator that minimizes the MSE for a set of random data is the mean.

15. Next we will examine the mean to see how well it predicts net income over time?The next table gives the income before taxes of APC manufacturer between 1985 and 1994.

17. Because of the limitations of the simple average we use Moving A verages which are developed based on an average of weighted observations. MA tends tosmooth out short-term irregularity in the data series. They are useful if the data series remains fairly steady over time.

18. Moving average depends on the span (period). If span is 6 months for monthly data then, the month’s predicted value is the average of the most recent 6 months. The average of Jan thru June will be used to predict July. The longer the span the better the smoothing.

19. Moving averages are one of the most popular and easy to use tools available to the technical analyst. They smooth a data series and make it easier to spot trends, something that is especially helpful in volatile markets.

20. Example of Quarterly Retail Sales with Seasonal Components

21. Example of Quarterly Retail Sales with Seasonal Components Removed

22. Multiplicative Time-Series Model • Used primarily for forecasting • Observed value in time series is the product of components • For annual data: • For quarterly or monthly data: Ti= Trend Ci= Cyclical Ii= Irregular Si= Seasonal

23. The moving-average method provides an efficient mechanism for obtaining a value forforecasting stationary time series. The method is effective when there is random demand and no seasonal fluctuations in the data. It is a popular technique for short-run forecasting by business forecasters.

24. Moving averages come in various forms, but their underlying purpose remains the same: to help technical traders track the trends of financial assets by smoothing out the day-to-day price fluctuations, or noise. By identifying trends, moving averages allow traders to make those trends work in their favor and increase the number of winning trades.

25. Moving Averages (continued) • Example: Three-year moving average • First average: • Second average:

26. Moving Average Example Mohammed is a building contractor who has constructed 24 single-family homes over a six-year period. Provide Mohammed with a three-year Moving Average Graph. Year Units Moving Ave 1994 2 NA 1995 5 3 1996 2 3 1997 2 3.67 1998 7 5 1999 6 NA

28. Moving Average Example Solution Year Response Moving Ave 1994 2 NA 1995 5 3 1996 2 3 1997 2 3.67 1998 7 5 1999 6 NA Sales L = 3 8 6 4 2 0 94 95 96 97 98 99 No MA for the first and last (L-1)/2 years

30. This simple illustration highlights the fact that all moving averages are lagging indicators and will always be "behind" the price of stock. If the close prices were rising, the SMA would most likely be below. Because moving averages are lagging indicators, they fit in the category of trend following indicators. When prices are trending, moving averages work well. However, when prices are not trending, moving averages can give misleading signals.

31. In order to reduce the lag in simple moving averages, technicians often use exponential moving averages (also called exponentially weighted moving averages). EMA's reduce the lag by applying more weight to recent prices relative to older prices.

32. Exponential Smoothing • Weighted moving average Most recent observation weighted most • Used for smoothing and short term forecasting • Weights are: • Subjectively chosen • Ranges from 0 to 1

33. Exponential Weight: Example Year Response Smoothing Value, Ei Forecast (W = .2, (1-W)=.8)1994 2 2 NA 1995 5 (.2)(5) + (.8)(2) = 2.6 2 1996 2 (.2)(2) + (.8)(2.6) = 2.48 2.6 1997 2 (.2)(2) + (.8)(2.48) = 2.384 2.48 1998 7 (.2)(7) + (.8)(2.384) = 3.307 2.384 1999 6 (.2)(6) + (.8)(3.307) = 3.846 3.307

34. Exponential Weight: Example Graph Sales 8 6 4 2 0 Data Smoothed 94 95 96 97 98 99 Year

35. Exponential Smoothing in Excel • Use tools | data analysis | exponential smoothing • The damping factor is (1-W ) • Excel spreadsheet for the Exponential

38. Trend-Following Indicator Moving averages smooth out a data series and make it easier to identify the direction of the trend. Because past price data is used to form moving averages, they are considered lagging, or trend following, indicators. Moving averages will not predict a change in trend, but rather follow behind the current trend. Therefore, they are best suited for trend identification and trend following purposes, not for prediction.

39. When to Use Because moving averages follow the trend, they work best when a security is trending and are ineffective when a security moves in a trading range. With this in mind, investors and traders should first identify securities that display some trending characteristics before attempting to analyze with moving averages.

40. In its simplest form, a security's price can be doing only one of three things: trending up, trending down or trading in a range. An uptrend is established when a security forms a series of higher highs and higher lows. A downtrend is established when a security forms a series of lower lows and lower highs. A trading range is established if a security cannot establish an uptrend or downtrend.

41. Moving Averages • Moving averages are used to smooth out short-term fluctuations, thus highlighting longer-term trends or cycles. • moving average levels are interpreted as support in a rising market, or resistance in a falling market. One of the most-common and best-known trading strategies is this: "Buy at the support level and sell at the resistance level." • Typically, upward momentum is confirmed when a short-term average (e.g.15-day) crosses above a longer-term average (e.g. 50-day). Downward momentum is confirmed when a short-term average crosses below a long-term average • If current prices (15-day SMA) are moving above longer term prices (50-day SMA), these are indicative of buying momentum. The reverse would be indicative of selling momentum.

42. Resistance Level "Resistance Level" is just the opposite. Here, the strategy is to short sell the stock near the resistance level, monitor it closely, and buy it to cut loss if it breaks meaningfully higher than the resistance level. If the resistance level indeed prevents the stock price from going up and it starts to bounce back down,

43. The support level Imagine on a given day, a stock is traded very heavily at a certain price level. Also imagine that many traders remember this price level because they bought or sold the stock at this level. Next, suppose that the stock price first moves up away from this level and, later on, the stock price trades back again to the earlier level. Traders who previously bought the stock and sold it for a profit would likely buy it again at this level. Those who previously sold the stock at this level and missed the recent run-up would have a chance to buy it back. Such buying activities usually slow down the drop and may reverse the momentum.We can then say that the stock price has hit some "support level," by which we suppose that it most likely will not quickly drop through it.

44. The Least Squares Linear Trend Model Year Coded X Sales (Y) 95 0 2 96 1 5 97 2 2 98 3 2 99 4 7 00 5 6

46. The Least Squares Linear Trend Model (continued) Excel Output Projected to year 2001

47. The Quadratic Trend Model Year Coded X Sales (Y) 95 0 2 96 1 5 97 2 2 98 3 2 99 4 7 00 5 6

50. The Quadratic Trend Model (continued) Excel Output Projected to year 2001