Stock Price Trends

Colgate-Palmolive Company (CL)

Colgate-Palmolive Company is an American multinational consumer products company headquartered on Park Avenue in Midtown Manhattan, New York City. It specializes in the production, distribution and provision of household, health care, personal care and veterinary products.

Stock Price Trends

Stock price trends estimated using linear regression.

Key facts

  • The primary trend is increasing.
  • The growth rate of the primary trend is 64.82% per annum.
  • CL price at the close of May 7, 2024 was $94.08 and was inside the primary price channel.
  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 410.25% per annum.
  • CL price at the close of May 7, 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 CL 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: September 22, 2023
End date: April 2, 2024

a = 2.0459

b = 0.0014

s = 0.0142

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0014) – 1
= 64.82%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0142) – 1
= 5.83%

September 22, 2023 calculations

Top border of price channel:

Exp(Y1,102)
= Exp(a + b × X1,102 + 2 × s)
= Exp(a + b × 1,598 + 2 × s)
= Exp(2.0459 + 0.0014 × 1,598 + 2 × 0.0142)
= Exp(4.2618)
= $70.94

Bottom border of price channel:

Exp(Y1,102)
= Exp(a + b × X1,102 – 2 × s)
= Exp(a + b × 1,598 – 2 × s)
= Exp(2.0459 + 0.0014 × 1,598 – 2 × 0.0142)
= Exp(4.2051)
= $67.03

April 2, 2024 calculations

Top border of price channel:

Exp(Y1,233)
= Exp(a + b × X1,233 + 2 × s)
= Exp(a + b × 1,791 + 2 × s)
= Exp(2.0459 + 0.0014 × 1,791 + 2 × 0.0142)
= Exp(4.5260)
= $92.39

Bottom border of price channel:

Exp(Y1,233)
= Exp(a + b × X1,233 – 2 × s)
= Exp(a + b × 1,791 – 2 × s)
= Exp(2.0459 + 0.0014 × 1,791 – 2 × 0.0142)
= Exp(4.4693)
= $87.30

Description

  • The primary trend is increasing.
  • The growth rate of the primary trend is 64.82% per annum.
  • CL price at the close of May 7, 2024 was $94.08 and was inside the primary price channel.

Secondary Trend

Start date: April 15, 2024
End date: May 7, 2024

a = -3.6060

b = 0.0045

s = 0.0052

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0045) – 1
= 410.25%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0052) – 1
= 2.10%

April 15, 2024 calculations

Top border of price channel:

Exp(Y1,242)
= Exp(a + b × X1,242 + 2 × s)
= Exp(a + b × 1,804 + 2 × s)
= Exp(-3.6060 + 0.0045 × 1,804 + 2 × 0.0052)
= Exp(4.4593)
= $86.43

Bottom border of price channel:

Exp(Y1,242)
= Exp(a + b × X1,242 – 2 × s)
= Exp(a + b × 1,804 – 2 × s)
= Exp(-3.6060 + 0.0045 × 1,804 – 2 × 0.0052)
= Exp(4.4385)
= $84.65

May 7, 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(-3.6060 + 0.0045 × 1,826 + 2 × 0.0052)
= Exp(4.5575)
= $95.35

Bottom border of price channel:

Exp(Y1,258)
= Exp(a + b × X1,258 – 2 × s)
= Exp(a + b × 1,826 – 2 × s)
= Exp(-3.6060 + 0.0045 × 1,826 – 2 × 0.0052)
= Exp(4.5368)
= $93.39

Description

  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 410.25% per annum.
  • CL price at the close of May 7, 2024 was inside the secondary price channel.