Stock Price Trends
Stock price trends estimated using linear regression.
Summary
Key facts
- The primary trend is increasing.
- The growth rate of the primary trend is 39.18% per annum.
- MSFT price at the close of December 1, 2025 was $486.74 and was lower than the bottom border of the primary price channel by $110.23 (18.46%). This indicates a possible reversal in the primary trend direction.
- The secondary trend is increasing.
- The growth rate of the secondary trend is 19.25% per annum.
- MSFT price at the close of December 1, 2025 was inside the secondary price channel.
Linear Regression Model
Model equation:
Yi = α + β × Xi + εi
Top border of price channel:
Exp(Yi) = Exp(a + b × Xi + 2 × s)
Bottom border of price channel:
Exp(Yi) = Exp(a + b × Xi – 2 × s)
where:
i - observation number
Yi - natural logarithm of MSFT price
Xi - time index, 1 day interval
σ - standard deviation of εi
a - estimator of α
b - estimator of β
s - estimator of σ
Exp() - calculates the exponent of e
Primary Trend
Start date: June 10, 2022
End date: August 1, 2024
a = 4.8885
b = 0.0009
s = 0.0749
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × 0.0009) – 1
= 39.18%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0749) – 1
= 34.92%
June 10, 2022 calculations
Top border of price channel:
Exp(Y383)
= Exp(a + b × X383 + 2 × s)
= Exp(a + b × 555 + 2 × s)
= Exp(4.8885 + 0.0009 × 555 + 2 × 0.0749)
= Exp(5.5410)
= $254.93
Bottom border of price channel:
Exp(Y383)
= Exp(a + b × X383 – 2 × s)
= Exp(a + b × 555 – 2 × s)
= Exp(4.8885 + 0.0009 × 555 – 2 × 0.0749)
= Exp(5.2415)
= $188.95
August 1, 2024 calculations
Top border of price channel:
Exp(Y920)
= Exp(a + b × X920 + 2 × s)
= Exp(a + b × 1,338 + 2 × s)
= Exp(4.8885 + 0.0009 × 1,338 + 2 × 0.0749)
= Exp(6.2503)
= $518.15
Bottom border of price channel:
Exp(Y920)
= Exp(a + b × X920 – 2 × s)
= Exp(a + b × 1,338 – 2 × s)
= Exp(4.8885 + 0.0009 × 1,338 – 2 × 0.0749)
= Exp(5.9507)
= $384.03
Description
- The primary trend is increasing.
- The growth rate of the primary trend is 39.18% per annum.
- MSFT price at the close of December 1, 2025 was $486.74 and was lower than the bottom border of the primary price channel by $110.23 (18.46%). This indicates a possible reversal in the primary trend direction.
Secondary Trend
Start date: April 27, 2023
End date: December 1, 2025
a = 5.3527
b = 0.0005
s = 0.0718
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × 0.0005) – 1
= 19.25%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0718) – 1
= 33.29%
April 27, 2023 calculations
Top border of price channel:
Exp(Y603)
= Exp(a + b × X603 + 2 × s)
= Exp(a + b × 876 + 2 × s)
= Exp(5.3527 + 0.0005 × 876 + 2 × 0.0718)
= Exp(5.9189)
= $372.01
Bottom border of price channel:
Exp(Y603)
= Exp(a + b × X603 – 2 × s)
= Exp(a + b × 876 – 2 × s)
= Exp(5.3527 + 0.0005 × 876 – 2 × 0.0718)
= Exp(5.6315)
= $279.09
December 1, 2025 calculations
Top border of price channel:
Exp(Y1,254)
= Exp(a + b × X1,254 + 2 × s)
= Exp(a + b × 1,825 + 2 × s)
= Exp(5.3527 + 0.0005 × 1,825 + 2 × 0.0718)
= Exp(6.3767)
= $587.96
Bottom border of price channel:
Exp(Y1,254)
= Exp(a + b × X1,254 – 2 × s)
= Exp(a + b × 1,825 – 2 × s)
= Exp(5.3527 + 0.0005 × 1,825 – 2 × 0.0718)
= Exp(6.0893)
= $441.10
Description
- The secondary trend is increasing.
- The growth rate of the secondary trend is 19.25% per annum.
- MSFT price at the close of December 1, 2025 was inside the secondary price channel.
- Discover a new approach to trend analysis.
- Check the power of mathematical statistics.
- Price channels have never been so accurately estimated.
Check out MSFT and 1,499 other stocks on our new website