Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

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 2.88% per annum.
  • PG price at the close of April 25, 2024 was $162.55 and was inside the primary price channel.
  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 11.64% per annum.
  • PG price at the close of April 25, 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 PG 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: July 23, 2021
End date: January 24, 2024

a = 4.8531

b = 0.0001

s = 0.0524

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0001) – 1
= 2.88%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0524) – 1
= 23.33%

July 23, 2021 calculations

Top border of price channel:

Exp(Y565)
= Exp(a + b × X565 + 2 × s)
= Exp(a + b × 819 + 2 × s)
= Exp(4.8531 + 0.0001 × 819 + 2 × 0.0524)
= Exp(5.0217)
= $151.67

Bottom border of price channel:

Exp(Y565)
= Exp(a + b × X565 – 2 × s)
= Exp(a + b × 819 – 2 × s)
= Exp(4.8531 + 0.0001 × 819 – 2 × 0.0524)
= Exp(4.8120)
= $122.98

January 24, 2024 calculations

Top border of price channel:

Exp(Y1,194)
= Exp(a + b × X1,194 + 2 × s)
= Exp(a + b × 1,734 + 2 × s)
= Exp(4.8531 + 0.0001 × 1,734 + 2 × 0.0524)
= Exp(5.0930)
= $162.88

Bottom border of price channel:

Exp(Y1,194)
= Exp(a + b × X1,194 – 2 × s)
= Exp(a + b × 1,734 – 2 × s)
= Exp(4.8531 + 0.0001 × 1,734 – 2 × 0.0524)
= Exp(4.8833)
= $132.06

Description

  • The primary trend is increasing.
  • The growth rate of the primary trend is 2.88% per annum.
  • PG price at the close of April 25, 2024 was $162.55 and was inside the primary price channel.

Secondary Trend

Start date: August 26, 2022
End date: April 25, 2024

a = 4.5146

b = 0.0003

s = 0.0403

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0003) – 1
= 11.64%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0403) – 1
= 17.51%

August 26, 2022 calculations

Top border of price channel:

Exp(Y841)
= Exp(a + b × X841 + 2 × s)
= Exp(a + b × 1,218 + 2 × s)
= Exp(4.5146 + 0.0003 × 1,218 + 2 × 0.0403)
= Exp(4.9625)
= $142.95

Bottom border of price channel:

Exp(Y841)
= Exp(a + b × X841 – 2 × s)
= Exp(a + b × 1,218 – 2 × s)
= Exp(4.5146 + 0.0003 × 1,218 – 2 × 0.0403)
= Exp(4.8012)
= $121.65

April 25, 2024 calculations

Top border of price channel:

Exp(Y1,258)
= Exp(a + b × X1,258 + 2 × s)
= Exp(a + b × 1,826 + 2 × s)
= Exp(4.5146 + 0.0003 × 1,826 + 2 × 0.0403)
= Exp(5.1459)
= $171.72

Bottom border of price channel:

Exp(Y1,258)
= Exp(a + b × X1,258 – 2 × s)
= Exp(a + b × 1,826 – 2 × s)
= Exp(4.5146 + 0.0003 × 1,826 – 2 × 0.0403)
= Exp(4.9845)
= $146.13

Description

  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 11.64% per annum.
  • PG price at the close of April 25, 2024 was inside the secondary price channel.
Stock Price Trends
  • Discover a new approach to trend analysis.
  • Check the power of mathematical statistics.
  • Price channels have never been so accurately estimated.

Check out PG and 1,499 other stocks on our new website