Stock Price Trends
Stock price trends estimated using linear regression.
Paying user area
Try for free
Microsoft Corp. pages available for free this week:
- Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Liquidity Ratios
- Analysis of Reportable Segments
- Enterprise Value (EV)
- Enterprise Value to FCFF (EV/FCFF)
- Present Value of Free Cash Flow to Equity (FCFE)
- Operating Profit Margin since 2005
- Total Asset Turnover since 2005
- Price to Sales (P/S) since 2005
- Analysis of Debt
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Microsoft Corp. for $24.99.
This is a one-time payment. There is no automatic renewal.
We accept:
Summary
Key facts
- The primary trend is increasing.
- The growth rate of the primary trend is 48.45% per annum.
- MSFT price at the close of December 20, 2024 was $436.60 and was lower than the bottom border of the primary price channel by $58.21 (11.76%). This indicates a possible reversal in the primary trend direction.
- The secondary trend is increasing.
- The growth rate of the secondary trend is 6.08% per annum.
- MSFT price at the close of December 20, 2024 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:
End date:
a =
b =
s =
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × ) – 1
=
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × ) – 1
=
September 13, 2022 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
July 23, 2024 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
Description
- The primary trend is increasing.
- The growth rate of the primary trend is 48.45% per annum.
- MSFT price at the close of December 20, 2024 was $436.60 and was lower than the bottom border of the primary price channel by $58.21 (11.76%). This indicates a possible reversal in the primary trend direction.
Secondary Trend
Start date:
End date:
a =
b =
s =
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × ) – 1
=
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × ) – 1
=
January 18, 2024 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
December 20, 2024 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
Description
- The secondary trend is increasing.
- The growth rate of the secondary trend is 6.08% per annum.
- MSFT price at the close of December 20, 2024 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