Sherwin-Williams Co (SHW)
Sherwin Williams Company is a Cleveland, Ohio based company in the paint and coating manufacturing industry. The company primarily engages in the manufacture, distribution, and sale of paints, coatings, floorcoverings, and related products to professional, industrial, commercial, and retail customers primarily in North and South America and Europe.
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 46.71% per annum.
- SHW price at the close of May 6, 2024 was $314.99 and was inside the primary price channel.
- The secondary trend is decreasing.
- The decline rate of the secondary trend is 60.94% per annum.
- SHW price at the close of May 6, 2024 was higher than the top border of the secondary price channel by $1.18 (0.38%). This indicates a possible reversal in the secondary trend direction.
- The direction of the secondary trend is opposite to the direction of the primary trend. This indicates a possible reversal in the direction of the primary trend.
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 SHW 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: February 16, 2023
End date: April 15, 2024
a = 3.9077
b = 0.0011
s = 0.0543
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × 0.0011) – 1
= 46.71%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0543) – 1
= 24.27%
February 16, 2023 calculations
Top border of price channel:
Exp(Y953)
= Exp(a + b × X953 + 2 × s)
= Exp(a + b × 1,381 + 2 × s)
= Exp(3.9077 + 0.0011 × 1,381 + 2 × 0.0543)
= Exp(5.4665)
= $236.62
Bottom border of price channel:
Exp(Y953)
= Exp(a + b × X953 – 2 × s)
= Exp(a + b × 1,381 – 2 × s)
= Exp(3.9077 + 0.0011 × 1,381 – 2 × 0.0543)
= Exp(5.2492)
= $190.40
April 15, 2024 calculations
Top border of price channel:
Exp(Y1,243)
= Exp(a + b × X1,243 + 2 × s)
= Exp(a + b × 1,805 + 2 × s)
= Exp(3.9077 + 0.0011 × 1,805 + 2 × 0.0543)
= Exp(5.9117)
= $369.33
Bottom border of price channel:
Exp(Y1,243)
= Exp(a + b × X1,243 – 2 × s)
= Exp(a + b × 1,805 – 2 × s)
= Exp(3.9077 + 0.0011 × 1,805 – 2 × 0.0543)
= Exp(5.6944)
= $297.19
Description
- The primary trend is increasing.
- The growth rate of the primary trend is 46.71% per annum.
- SHW price at the close of May 6, 2024 was $314.99 and was inside the primary price channel.
Secondary Trend
Start date: March 7, 2024
End date: May 3, 2024
a = 10.4083
b = -0.0026
s = 0.0218
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × -0.0026) – 1
= -60.94%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0218) – 1
= 9.10%
March 7, 2024 calculations
Top border of price channel:
Exp(Y1,217)
= Exp(a + b × X1,217 + 2 × s)
= Exp(a + b × 1,766 + 2 × s)
= Exp(10.4083 + -0.0026 × 1,766 + 2 × 0.0218)
= Exp(5.9033)
= $366.26
Bottom border of price channel:
Exp(Y1,217)
= Exp(a + b × X1,217 – 2 × s)
= Exp(a + b × 1,766 – 2 × s)
= Exp(10.4083 + -0.0026 × 1,766 – 2 × 0.0218)
= Exp(5.8163)
= $335.71
May 3, 2024 calculations
Top border of price channel:
Exp(Y1,257)
= Exp(a + b × X1,257 + 2 × s)
= Exp(a + b × 1,823 + 2 × s)
= Exp(10.4083 + -0.0026 × 1,823 + 2 × 0.0218)
= Exp(5.7565)
= $316.25
Bottom border of price channel:
Exp(Y1,257)
= Exp(a + b × X1,257 – 2 × s)
= Exp(a + b × 1,823 – 2 × s)
= Exp(10.4083 + -0.0026 × 1,823 – 2 × 0.0218)
= Exp(5.6695)
= $289.88
Description
- The secondary trend is decreasing.
- The decline rate of the secondary trend is 60.94% per annum.
- SHW price at the close of May 6, 2024 was higher than the top border of the secondary price channel by $1.18 (0.38%). This indicates a possible reversal in the secondary trend direction.