Stock Price Trends

Etsy Inc (ETSY)

Etsy, Inc. is an American e-commerce company focused on handmade or vintage items and craft supplies. These items fall under a wide range of categories, including jewelry, bags, clothing, home decor and furniture, toys, art, as well as craft supplies and tools.

Stock Price Trends

Stock price trends estimated using linear regression.

Key facts

  • The primary trend is decreasing.
  • The decline rate of the primary trend is 31.89% per annum.
  • ETSY price at the close of July 26, 2024 was $62.27 and was inside the primary price channel.
  • The secondary trend is decreasing.
  • The decline rate of the secondary trend is 13.62% per annum.
  • ETSY price at the close of July 26, 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 ETSY 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: December 16, 2020
End date: July 26, 2024

a = 5.9755

b = -0.0011

s = 0.2029

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × -0.0011) – 1
= -31.89%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.2029) – 1
= 125.19%

December 16, 2020 calculations

Top border of price channel:

Exp(Y351)
= Exp(a + b × X351 + 2 × s)
= Exp(a + b × 506 + 2 × s)
= Exp(5.9755 + -0.0011 × 506 + 2 × 0.2029)
= Exp(5.8490)
= $346.89

Bottom border of price channel:

Exp(Y351)
= Exp(a + b × X351 – 2 × s)
= Exp(a + b × 506 – 2 × s)
= Exp(5.9755 + -0.0011 × 506 – 2 × 0.2029)
= Exp(5.0372)
= $154.04

July 26, 2024 calculations

Top border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 + 2 × s)
= Exp(a + b × 1,824 + 2 × s)
= Exp(5.9755 + -0.0011 × 1,824 + 2 × 0.2029)
= Exp(4.4623)
= $86.69

Bottom border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 – 2 × s)
= Exp(a + b × 1,824 – 2 × s)
= Exp(5.9755 + -0.0011 × 1,824 – 2 × 0.2029)
= Exp(3.6505)
= $38.50

Description

  • The primary trend is decreasing.
  • The decline rate of the primary trend is 31.89% per annum.
  • ETSY price at the close of July 26, 2024 was $62.27 and was inside the primary price channel.

Secondary Trend

Start date: August 15, 2023
End date: July 26, 2024

a = 4.8820

b = -0.0004

s = 0.0881

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × -0.0004) – 1
= -13.62%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0881) – 1
= 42.24%

August 15, 2023 calculations

Top border of price channel:

Exp(Y1,019)
= Exp(a + b × X1,019 + 2 × s)
= Exp(a + b × 1,478 + 2 × s)
= Exp(4.8820 + -0.0004 × 1,478 + 2 × 0.0881)
= Exp(4.4654)
= $86.95

Bottom border of price channel:

Exp(Y1,019)
= Exp(a + b × X1,019 – 2 × s)
= Exp(a + b × 1,478 – 2 × s)
= Exp(4.8820 + -0.0004 × 1,478 – 2 × 0.0881)
= Exp(4.1130)
= $61.13

July 26, 2024 calculations

Top border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 + 2 × s)
= Exp(a + b × 1,824 + 2 × s)
= Exp(4.8820 + -0.0004 × 1,824 + 2 × 0.0881)
= Exp(4.3266)
= $75.69

Bottom border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 – 2 × s)
= Exp(a + b × 1,824 – 2 × s)
= Exp(4.8820 + -0.0004 × 1,824 – 2 × 0.0881)
= Exp(3.9742)
= $53.21

Description

  • The secondary trend is decreasing.
  • The decline rate of the secondary trend is 13.62% per annum.
  • ETSY price at the close of July 26, 2024 was inside the secondary price channel.