Nothing Special   »   [go: up one dir, main page]

Projekt

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

Close Close Coca-

Date
S&P500 Cola % S&P500 %coca-cola answer
Oct 17, 2023 4373.2 54.07 0.00% 0.00% if market goes up by 1%, coca-c
Oct 16, 2023 4373.2 54.07 1.05% 2.23%
Oct 09, 2023 4327.78 52.89 0.45% -0.47%
Oct 02, 2023 4308.5 53.14 0.48% -5.07%
Sep 25, 2023 4288.05 55.98 -0.74% -2.81%
Sep 18, 2023 4320.06 57.6 -2.93% -0.59%
Sep 11, 2023 4450.32 57.94 -0.16% -0.67%
Sep 04, 2023 4457.49 58.33 -1.29% -1.65%
Aug 28, 2023 4515.77 59.31 2.50% -1.79%
Aug 21, 2023 4405.71 60.39 0.82% -0.92%
Aug 14, 2023 4369.71 60.95 -2.11% -0.36%
f(x) = 0.4799254
Aug 07, 2023 4464.05 61.17 -0.31% 0.76% R² = 0.19651844
Jul 31, 2023 4478.03 60.71 -2.27% -2.83% -6.00% -4.00% -2.00
Jul 24, 2023 4582.23 62.48 1.01% 0.06%
Jul 17, 2023 4536.34 62.44 0.69% 2.53%
Jul 10, 2023 4505.42 60.9 2.42% 1.91%
Jul 03, 2023 4398.95 59.76 -1.16% -0.76%
Jun 26, 2023 4450.38 60.22 2.35% -1.60%
Jun 19, 2023 4348.33 61.2 -1.39% -0.76%
Jun 12, 2023 4409.59 61.67 2.58% 1.98%
Jun 05, 2023 4298.86 60.47 0.39% -1.13%
May 29, 2023 4282.37 61.16 1.83% 1.49%
May 22, 2023 4205.45 60.26 0.32% -4.09%
May 15, 2023 4191.98 62.83 1.65% -2.00%
May 08, 2023 4124.08 64.11 -0.29% 0.14%
May 01, 2023 4136.25 64.02 -0.80% -0.20%
Apr 24, 2023 4169.48 64.15 0.87% 0.16%
Apr 17, 2023 4133.52 64.05 -0.10% 1.59%
Apr 10, 2023 4137.64 63.05 0.79% 0.33%
Apr 03, 2023 4105.02 62.84 -0.10% 1.31%
Mar 27, 2023 4109.31 62.03 3.48% 1.86%
Mar 20, 2023 3970.99 60.9 1.39% 1.47%
Mar 13, 2023 3916.64 60.02 1.43% 1.37%
Mar 06, 2023 3861.59 59.21 -4.55% -0.39%
Feb 27, 2023 4045.64 59.44 1.90% -0.67%
Feb 20, 2023 3970.04 59.84 -2.67% -0.47%
Feb 13, 2023 4079.09 60.12 -0.28% 0.84%
Feb 06, 2023 4090.46 59.62 -1.11% -0.35%
Jan 30, 2023 4136.48 59.83 1.62% -1.09%
Jan 23, 2023 4070.56 60.49 2.47% 0.68%
Jan 16, 2023 3972.61 60.08 -0.66% -2.20%
Jan 09, 2023 3999.09 61.43 2.67% -3.11%
Jan 02, 2023 3895.08 63.4 1.45% -0.33%
Dec 26, 2022 3839.5 63.61 -0.14% -0.33%
Dec 19, 2022 3844.82 63.82 -0.20% 1.71%
Dec 12, 2022 3852.36 62.75 -2.08% -0.62%
Dec 05, 2022 3934.38 63.14 -3.37% -1.88%
Nov 28, 2022 4071.7 64.35 1.13% 2.65%
Nov 21, 2022 4026.12 62.69 1.53% 2.54%
Nov 14, 2022 3965.34 61.14 -0.69% -0.29%
Nov 07, 2022 3992.93 61.32 5.90% 3.48%
Oct 31, 2022 3770.55 59.26 -3.35% -2.47%
Oct 24, 2022 3901.06 60.76 3.95% 8.58%
Oct 17, 2022 3752.75 55.96
beta for me is 0.5
if market goes up by 1%, coca-cola goes up (on average) by 0.5%

%coca-cola y = 0.4799x - 0.0019


R² = 0.1965
10.00%

8.00%

6.00%

4.00%

2.00% x − 0.00190479062406509
f(x) = 0.479925443699434
R² = 0.196518448799335
0.00%
-6.00% -4.00% -2.00% 0.00% 2.00% 4.00% 6.00% 8.00%
-2.00%

-4.00%

-6.00%
Date Open High Low Close* Adj Close** Volume
Oct 17, 2023 4,345.23 4,393.57 4,337.54 4,373.20 4,373.20 2,355,659,000
Oct 16, 2023 4,342.37 4,393.57 4,337.54 4,373.20 4,373.20 7,204,810,000
Oct 09, 2023 4,289.02 4,385.85 4,283.79 4,327.78 4,327.78 14,009,670,000
Oct 02, 2023 4,284.52 4,324.10 4,216.45 4,308.50 4,308.50 19,153,590,000
Sep 25, 2023 4,310.62 4,338.51 4,238.63 4,288.05 4,288.05 18,256,060,000
Sep 18, 2023 4,445.13 4,466.36 4,316.49 4,320.06 4,320.06 17,096,470,000
Sep 11, 2023 4,480.98 4,511.99 4,447.21 4,450.32 4,450.32 20,916,040,000
Sep 04, 2023 4,510.06 4,514.29 4,430.46 4,457.49 4,457.49 13,968,150,000
Aug 28, 2023 4,426.03 4,541.25 4,414.98 4,515.77 4,515.77 16,568,780,000
Aug 21, 2023 4,380.28 4,458.30 4,356.29 4,405.71 4,405.71 18,106,530,000
Aug 14, 2023 4,458.13 4,490.33 4,335.31 4,369.71 4,369.71 19,366,670,000
Aug 07, 2023 4,491.58 4,527.37 4,443.98 4,464.05 4,464.05 19,439,590,000
Jul 31, 2023 4,584.82 4,594.22 4,474.55 4,478.03 4,478.03 21,109,110,000
Jul 24, 2023 4,543.39 4,607.07 4,528.56 4,582.23 4,582.23 20,193,230,000
Jul 17, 2023 4,508.86 4,578.43 4,504.90 4,536.34 4,536.34 19,075,880,000
Jul 10, 2023 4,394.23 4,527.76 4,389.92 4,505.42 4,505.42 18,461,090,000
Jul 03, 2023 4,450.48 4,456.46 4,385.05 4,398.95 4,398.95 12,829,400,000
Jun 26, 2023 4,344.84 4,458.48 4,328.08 4,450.38 4,450.38 18,347,970,000
Jun 19, 2023 4,396.11 4,400.15 4,341.34 4,348.33 4,348.33 17,329,740,000
Jun 12, 2023 4,308.32 4,448.47 4,304.37 4,409.59 4,409.59 23,498,470,000
Jun 05, 2023 4,282.99 4,322.62 4,261.07 4,298.86 4,298.86 19,960,900,000
May 29, 2023 4,226.71 4,290.67 4,166.15 4,282.37 4,282.37 19,055,240,000
May 22, 2023 4,190.78 4,212.87 4,103.98 4,205.45 4,205.45 19,486,220,000
May 15, 2023 4,126.65 4,212.91 4,109.86 4,191.98 4,191.98 19,277,850,000
May 08, 2023 4,136.98 4,154.28 4,098.92 4,124.08 4,124.08 18,795,580,000
May 01, 2023 4,166.79 4,186.92 4,048.28 4,136.25 4,136.25 21,160,370,000
Apr 24, 2023 4,132.07 4,170.06 4,049.35 4,169.48 4,169.48 18,944,960,000
Apr 17, 2023 4,137.17 4,169.48 4,113.86 4,133.52 4,133.52 18,104,210,000
Apr 10, 2023 4,085.20 4,163.19 4,072.55 4,137.64 4,137.64 17,894,880,000
Apr 03, 2023 4,102.20 4,133.13 4,069.84 4,105.02 4,105.02 15,917,210,000
Mar 27, 2023 3,982.93 4,110.75 3,951.53 4,109.31 4,109.31 20,849,370,000
Mar 20, 2023 3,917.47 4,039.49 3,909.16 3,970.99 3,970.99 24,375,960,000
Mar 13, 2023 3,835.12 3,964.46 3,808.86 3,916.64 3,916.64 33,867,970,000
Mar 06, 2023 4,055.15 4,078.49 3,846.32 3,861.59 3,861.59 21,422,390,000
Feb 27, 2023 3,992.36 4,048.29 3,928.16 4,045.64 4,045.64 21,459,460,000
Feb 20, 2023 4,052.35 4,052.35 3,943.08 3,970.04 3,970.04 16,031,550,000
Feb 13, 2023 4,096.62 4,159.77 4,047.95 4,079.09 4,079.09 19,642,940,000
Feb 06, 2023 4,119.57 4,176.54 4,060.79 4,090.46 4,090.46 20,661,640,000
Jan 30, 2023 4,049.27 4,195.44 4,015.55 4,136.48 4,136.48 23,657,120,000
Jan 23, 2023 3,978.14 4,094.21 3,949.06 4,070.56 4,070.56 18,707,010,000
Jan 16, 2023 3,999.28 4,015.39 3,885.54 3,972.61 3,972.61 16,539,130,000
Jan 09, 2023 3,910.82 4,003.95 3,877.29 3,999.09 3,999.09 20,846,120,000
Jan 02, 2023 3,853.29 3,906.19 3,794.33 3,895.08 3,895.08 16,190,230,000
Dec 26, 2022 3,843.34 3,858.19 3,780.78 3,839.50 3,839.50 12,097,370,000
Dec 19, 2022 3,853.79 3,889.82 3,764.49 3,844.82 3,844.82 18,506,410,000
Dec 12, 2022 3,939.29 4,100.96 3,827.91 3,852.36 3,852.36 25,443,390,000
Dec 05, 2022 4,052.02 4,052.45 3,918.39 3,934.38 3,934.38 20,662,410,000
Nov 28, 2022 4,005.36 4,100.51 3,937.65 4,071.70 4,071.70 22,280,580,000
Nov 21, 2022 3,956.23 4,034.02 3,933.34 4,026.12 4,026.12 12,724,860,000
Nov 14, 2022 3,977.97 4,028.84 3,906.54 3,965.34 3,965.34 21,831,700,000
Nov 07, 2022 3,780.71 4,001.48 3,744.22 3,992.93 3,992.93 24,968,840,000
Oct 31, 2022 3,881.85 3,911.79 3,698.15 3,770.55 3,770.55 24,226,300,000
Oct 24, 2022 3,762.01 3,905.42 3,741.65 3,901.06 3,901.06 23,555,090,000
Oct 17, 2022 3,746.26 3,762.79 3,647.42 3,752.75 3,752.75 18,282,180,000
Date Open High Low Close* Adj Close** Volume
Oct 17, 2023 53.31 54.1 53.21 54.07 54.07 16,422,485
Oct 16, 2023 53.02 54.1 52.84 54.07 54.07 29,270,500
Oct 09, 2023 52.96 54.33 52.11 52.89 52.89 91,578,300
Oct 02, 2023 55.91 56.01 51.55 53.14 53.14 97,667,300
Sep 25, 2023 57.4 57.49 55.62 55.98 55.98 62,074,600
Sep 18, 2023 57.98 58.83 57.42 57.6 57.6 70,968,800
Sep 11, 2023 58.4 59 57.75 57.94 57.48 107,703,600
Sep 04, 2023 59.25 59.32 58.01 58.33 57.87 58,339,000
Aug 28, 2023 60.55 60.74 59.12 59.31 58.84 49,812,500
Aug 21, 2023 60.86 60.93 59.98 60.39 59.91 42,394,500
Aug 14, 2023 61.32 61.48 60.37 60.95 60.47 46,691,800
Aug 07, 2023 60.79 61.73 60.62 61.17 60.69 39,196,500
Jul 31, 2023 62.45 62.59 60.62 60.71 60.23 53,312,900
Jul 24, 2023 62.42 63.27 61.39 62.48 61.99 62,058,200
Jul 17, 2023 60.76 62.68 60.41 62.44 61.95 58,479,400
Jul 10, 2023 59.97 61.04 58.84 60.9 60.42 68,593,400
Jul 03, 2023 60.2 61.1 59.73 59.76 59.29 51,580,500
Jun 26, 2023 61.21 61.36 59.77 60.22 59.75 69,977,100
Jun 19, 2023 61.59 62.1 60.98 61.2 60.72 68,217,500
Jun 12, 2023 60.59 62.17 60.02 61.67 60.72 83,713,600
Jun 05, 2023 61 61.44 59.82 60.47 59.54 68,844,400
May 29, 2023 60.09 61.32 59.37 61.16 60.22 103,725,400
May 22, 2023 62.79 62.87 60.11 60.26 59.33 67,112,100
May 15, 2023 64.22 64.25 62.57 62.83 61.86 56,699,800
May 08, 2023 63.81 64.19 62.99 64.11 63.12 44,763,500
May 01, 2023 64.15 64.69 63.27 64.02 63.04 52,100,100
Apr 24, 2023 64.75 64.99 63.11 64.15 63.16 69,013,300
Apr 17, 2023 63.32 64.27 63.14 64.05 63.07 51,895,100
Apr 10, 2023 62.49 63.16 62.02 63.05 62.08 46,276,700
Apr 03, 2023 62.3 63.04 61.86 62.84 61.87 46,167,900
Mar 27, 2023 61.14 62.25 60.95 62.03 61.08 57,455,700
Mar 20, 2023 60.16 61.02 59.72 60.9 59.96 65,569,400
Mar 13, 2023 59.29 60.87 59.24 60.02 58.65 105,552,300
Mar 06, 2023 59.26 60.57 58.99 59.21 57.86 68,742,200
Feb 27, 2023 60.18 60.3 58.37 59.44 58.08 63,067,900
Feb 20, 2023 59.99 60.42 59.39 59.84 58.47 48,646,900
Feb 13, 2023 59.9 60.9 58.95 60.12 58.75 83,221,900
Feb 06, 2023 59.79 60.34 58.88 59.62 58.26 64,201,600
Jan 30, 2023 60.54 61.58 59.23 59.83 58.46 74,863,400
Jan 23, 2023 60.28 61.85 59.8 60.49 59.11 59,954,300
Jan 16, 2023 61.73 62.38 59.4 60.08 58.71 67,139,400
Jan 09, 2023 63.3 63.72 60.59 61.43 60.03 58,293,900
Jan 02, 2023 63.56 63.67 62.08 63.4 61.95 45,373,100
Dec 26, 2022 63.93 64.65 63.17 63.61 62.16 29,299,600
Dec 19, 2022 62.83 64.05 62.47 63.82 62.36 47,747,500
Dec 12, 2022 63.3 64.7 62.33 62.75 61.32 87,840,000
Dec 05, 2022 63.41 63.88 63.09 63.14 61.7 55,453,300
Nov 28, 2022 62.69 64.52 61.75 64.35 62.44 79,315,900
Nov 21, 2022 61.41 62.81 61.2 62.69 60.83 41,874,900
Nov 14, 2022 61.32 61.72 60 61.14 59.32 65,484,500
Nov 07, 2022 59.26 61.45 58.75 61.32 59.5 64,823,400
Oct 31, 2022 60.51 60.57 58.1 59.26 57.5 58,145,000
Oct 24, 2022 56.64 60.91 56.57 60.76 58.95 90,993,000
Oct 17, 2022 56.31 56.78 54.96 55.96 54.3 53,944,600

You might also like