Consolidated Edison Inc (ED)
Consolidated Edison, Inc., commonly known as Con Edison (stylized as conEdison) or ConEd, is one of the largest investor-owned energy companies in the United States, with approximately $12 billion in annual revenues as of 2017, and over $48 billion in assets. The company provides a wide range of energy-related products and services to its customers through its subsidiaries.
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 1.49% per annum.
- ED price at the close of November 20, 2024 was $97.88 and was higher than the top border of the primary price channel by $0.72 (0.75%).
- The secondary trend is increasing.
- The growth rate of the secondary trend is 20.78% per annum.
- ED price at the close of November 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 ED 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: March 4, 2022
End date: July 23, 2024
a = 4.4196
b = 0.0000
s = 0.0415
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × 0.0000) – 1
= 1.49%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0415) – 1
= 18.04%
March 4, 2022 calculations
Top border of price channel:
Exp(Y574)
= Exp(a + b × X574 + 2 × s)
= Exp(a + b × 834 + 2 × s)
= Exp(4.4196 + 0.0000 × 834 + 2 × 0.0415)
= Exp(4.5362)
= $93.34
Bottom border of price channel:
Exp(Y574)
= Exp(a + b × X574 – 2 × s)
= Exp(a + b × 834 – 2 × s)
= Exp(4.4196 + 0.0000 × 834 – 2 × 0.0415)
= Exp(4.3704)
= $79.07
July 23, 2024 calculations
Top border of price channel:
Exp(Y1,172)
= Exp(a + b × X1,172 + 2 × s)
= Exp(a + b × 1,706 + 2 × s)
= Exp(4.4196 + 0.0000 × 1,706 + 2 × 0.0415)
= Exp(4.5715)
= $96.69
Bottom border of price channel:
Exp(Y1,172)
= Exp(a + b × X1,172 – 2 × s)
= Exp(a + b × 1,706 – 2 × s)
= Exp(4.4196 + 0.0000 × 1,706 – 2 × 0.0415)
= Exp(4.4056)
= $81.91
Description
- The primary trend is increasing.
- The growth rate of the primary trend is 1.49% per annum.
- ED price at the close of November 20, 2024 was $97.88 and was higher than the top border of the primary price channel by $0.72 (0.75%).
Secondary Trend
Start date: September 26, 2023
End date: November 6, 2024
a = 3.6812
b = 0.0005
s = 0.0351
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × 0.0005) – 1
= 20.78%
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × 0.0351) – 1
= 15.06%
September 26, 2023 calculations
Top border of price channel:
Exp(Y966)
= Exp(a + b × X966 + 2 × s)
= Exp(a + b × 1,405 + 2 × s)
= Exp(3.6812 + 0.0005 × 1,405 + 2 × 0.0351)
= Exp(4.4780)
= $88.06
Bottom border of price channel:
Exp(Y966)
= Exp(a + b × X966 – 2 × s)
= Exp(a + b × 1,405 – 2 × s)
= Exp(3.6812 + 0.0005 × 1,405 – 2 × 0.0351)
= Exp(4.3377)
= $76.53
November 6, 2024 calculations
Top border of price channel:
Exp(Y1,247)
= Exp(a + b × X1,247 + 2 × s)
= Exp(a + b × 1,812 + 2 × s)
= Exp(3.6812 + 0.0005 × 1,812 + 2 × 0.0351)
= Exp(4.6885)
= $108.69
Bottom border of price channel:
Exp(Y1,247)
= Exp(a + b × X1,247 – 2 × s)
= Exp(a + b × 1,812 – 2 × s)
= Exp(3.6812 + 0.0005 × 1,812 – 2 × 0.0351)
= Exp(4.5482)
= $94.46
Description
- The secondary trend is increasing.
- The growth rate of the secondary trend is 20.78% per annum.
- ED price at the close of November 20, 2024 was inside the secondary price channel.