Linear regression fits a straight line to the selected data using a method called the Sum Of Least Squares.
Improve Your Market Timing
Colin Twiggs' weekly review of the global economy will help you identify market risk and improve your timing.
Join our free Trading Diary mailing list with over 140,000 subscribers.
The Sum Of Least Squares method provides an objective measure for comparing a number of straight lines to find the one that best fits the selected data.
- Plot each data point in a table
- Calculate the distance between each data point and the proposed straight line
- Square the distances (to remove negative values)
- Calculate the sum of the squares
- Repeat steps 2 to 4 for each possible line
- Select the line with the lowest sum of squares (from step 4).
Active or Reactive?
Many investors follow active strategies but end up being reactive, rotating in and out of stocks at the wrong time.
Colin Twiggs' free weekly review of global markets will help you identify market risk and improve your timing.
The table below demonstrates how the sum of squares is calculated for a line where
Price = 20.50 + 0.11 * day n
|Date||n||Closing Price||Price = 20.50 + 0.11*n||Distance||Squared|
The sum of squares is calculated for each possible line and the line with the lowest sum is selected.
Manually calculating the sum of squares for each possible line would be enormously time-consuming. Fortunately there is a quicker way.
The formula for a straight line is
y = a + bx
For our purposes:
- y is the price
- x is the date
- a is the constant (the value when x equals zero)
- b is the slope of the line
The formula for calculating the line of best fit is
b = ( nΣxy - ΣxΣy ) / ( nΣx² - (Σx)² )
a = ( Σy - bΣx ) / n
Where n is the number of data points selected.