0% found this document useful (0 votes)
74 views9 pages

Stock Market Performance Data

The document contains daily stock price data from January 2016 to September 2019. It includes the open, high, low, close and adjusted close prices. It also includes volume and return figures. The average daily return was 0.26% with a standard deviation of 4%. Returns ranged from -0.37% to 0.66% over the period.

Uploaded by

Paul Anton Valle
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
74 views9 pages

Stock Market Performance Data

The document contains daily stock price data from January 2016 to September 2019. It includes the open, high, low, close and adjusted close prices. It also includes volume and return figures. The average daily return was 0.26% with a standard deviation of 4%. Returns ranged from -0.37% to 0.66% over the period.

Uploaded by

Paul Anton Valle
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Date Open High Low Close Adj Close

Sep-19 9.00 10.97 8.88 10.76 10.76


Aug-19 10.89 11.07 8.58 9.19 9.19
Jul-19 11.39 12.07 10.60 11.06 11.01
Jun-19 9.74 11.79 9.66 11.61 11.56
May-19 12.19 12.25 9.47 9.71 9.67
Apr-19 13.16 14.68 12.15 12.31 12.21
Mar-19 12.98 13.20 11.78 12.89 12.78
Feb-19 11.56 13.86 11.40 12.90 12.79
Jan-19 10.01 12.65 9.84 11.64 11.49
Dec-18 12.45 12.67 9.60 10.31 10.18
Nov-18 11.86 12.69 10.71 11.94 11.79
Oct-18 13.81 14.28 10.59 11.65 11.46
Sep-18 13.63 14.90 12.18 13.92 13.69
Aug-18 16.12 16.16 13.28 14.05 13.82
Jul-18 17.02 18.14 15.06 16.50 16.19
Jun-18 17.17 18.38 15.46 17.26 16.93
May-18 15.12 17.78 14.64 16.90 16.58
Apr-18 17.57 19.70 15.12 15.21 14.88
Mar-18 18.75 19.24 16.51 17.57 17.19
Feb-18 19.45 19.74 16.64 18.60 18.19
Jan-18 19.05 20.25 18.85 19.50 19.08
Dec-17 13.94 19.45 13.81 18.96 18.55
Nov-17 14.40 14.98 13.22 13.92 13.62
Oct-17 13.98 15.59 13.84 13.98 13.68
Sep-17 14.93 15.38 13.65 14.04 13.73
Aug-17 14.60 15.75 13.82 14.78 14.46
Jul-17 12.08 15.27 11.71 14.62 14.30
Jun-17 11.47 12.61 11.05 12.01 11.75
May-17 12.78 12.89 11.06 11.49 11.24
Apr-17 13.50 13.83 12.03 12.75 12.47
Mar-17 13.78 14.00 11.91 13.36 13.07
Feb-17 16.63 16.89 13.16 13.40 13.11
Jan-17 13.49 17.06 13.41 16.65 16.29
Dec-16 15.50 16.08 13.13 13.19 12.90
Nov-16 11.31 16.42 10.50 15.35 15.02
Oct-16 10.98 11.20 9.24 11.18 10.94
Sep-16 10.32 11.14 9.43 10.86 10.62
Aug-16 13.01 13.04 10.18 10.29 10.07
Jul-16 11.04 13.59 10.27 12.96 12.68
Jun-16 11.08 11.93 9.82 11.14 10.90
May-16 14.03 14.04 10.22 11.08 10.84
Apr-16 9.92 14.06 8.76 14.00 13.70
Mar-16 7.84 11.45 7.26 10.34 10.11
Feb-16 4.50 7.97 4.26 7.63 7.46
Jan-16 6.60 6.76 3.52 4.60 4.50
Dec-15 8.25 8.41 6.08 6.77 6.62
Nov-15 11.79 12.75 7.94 8.18 8.00
Oct-15 9.91 14.20 9.51 11.77 11.47
Sep-15 10.11 12.59 8.62 9.69 9.44
Aug-15 11.64 11.87 7.76 10.64 10.37
Jul-15 18.58 18.84 11.16 11.75 11.34
Jun-15 19.75 21.17 18.51 18.62 17.97
May-15 23.38 23.97 19.65 19.65 18.96
Apr-15 19.10 23.66 18.11 23.27 22.40
Mar-15 21.63 21.63 17.02 18.95 18.24
Feb-15 16.98 21.90 16.81 21.63 20.82
Jan-15 23.35 23.72 16.43 16.81 15.96
Dec-14 26.71 26.89 20.94 23.36 22.18
Nov-14 28.70 29.92 26.64 26.85 25.49
Oct-14 32.80 32.91 27.72 28.50 26.79
Volume Rentabilidad Date Rentabilidad
199133400 0.17 Sep-19 0.17 observaciones 59
437031100 -0.17 Aug-19 -0.17 E(rentabilidad) 0.0026
395411400 -0.05 Jul-19 -0.05 Volatilidad 4%
400146900 0.20 Jun-19 0.20 desv. Standart 20%
437577700 -0.21 May-19 -0.21
458115100 -0.04 Apr-19 -0.04
320020700 0.00 Mar-19 0.00 -50% 0.07409805
420315900 0.11 Feb-19 0.11 -45% 0.1387381
603680700 0.13 Jan-19 0.13 -40% 0.2432597
405348700 -0.14 Dec-18 -0.14 -35% 0.39942021
360494100 0.03 Nov-18 0.03 -30% 0.61415128
527457500 -0.16 Oct-18 -0.16 -25% 0.88431324
385041200 -0.01 Sep-18 -0.01 -20% 1.19240103
363649000 -0.15 Aug-18 -0.15 -15% 1.50564993
401101000 -0.04 Jul-18 -0.04 -10% 1.78037349
320049900 0.02 Jun-18 0.02 -5% 1.97144053
349400300 0.11 May-18 0.11 0% 2.04428616
415140100 -0.13 Apr-18 -0.13 5% 1.9851126
311626700 -0.06 Mar-18 -0.06 10% 1.80515314
430674800 -0.05 Feb-18 -0.05 15% 1.53719302
443938000 0.03 Jan-18 0.03 20% 1.22582424
398760600 0.36 Dec-17 0.36 25% 0.91540537
289164600 0.00 Nov-17 0.00 30% 0.64015354
382385300 0.00 Oct-17 0.00 35% 0.41921836
354232900 -0.05 Sep-17 -0.05 40% 0.25708805
445536000 0.01 Aug-17 0.01 45% 0.14764167
420379900 0.22 Jul-17 0.22 50% 0.07940017
397533700 0.05 Jun-17 0.05
421127100 -0.10 May-17 -0.10
407473400 -0.05 Apr-17 -0.05
GRAFICO 1
521005300 0.00 Mar-17 0.00 2.5
610530800 -0.20 Feb-17 -0.20
625039900 0.26 Jan-17 0.26 2
564510800 -0.14 Dec-16 -0.14
878387000 0.37 Nov-16 0.37 1.5
587835500 0.03 Oct-16 0.03
651154600 0.06 Sep-16 0.06 1
583415200 -0.21 Aug-16 -0.21
715205100 0.16 Jul-16 0.16 0.5
837498400 0.01 Jun-16 0.01
941417800 -0.21 May-16 -0.21
0
1036278000 0.35 Apr-16 0.35 -60% -40% -20% 0%
1159746200 0.36 Mar-16 0.36
1142944100 0.66 Feb-16 0.66
Rentabilida
0.80

0.60
1379036500 -0.32 Jan-16 -0.32 Rentabilida
1067020000 -0.17 Dec-15 -0.17
0.80
666121500 -0.30 Nov-15 -0.30
752401300 0.21 Oct-15 0.21 0.60
952140800 -0.09 Sep-15 -0.09
0.40
904754800 -0.09 Aug-15 -0.09
629486900 -0.37 Jul-15 -0.37 0.20
324089500 -0.05 Jun-15 -0.05
307318200 -0.15 May-15 -0.15 0.00
Nov-14 May-15 Nov-15 May-16 Nov-16 May-1
421356100 0.23 Apr-15 0.23 -0.20
445081400 -0.12 Mar-15 -0.12
370228000 0.30 Feb-15 0.30 -0.40
456617300 -0.28 Jan-15 -0.28
-0.60
374111300 -0.13 Dec-14 -0.13
236039600 -0.05 Nov-14 -0.05
330241200
0.00499968
GRAFICO 2
0.01018086
0.01953834
1.2
0.03537008
0.06046219
1
0.09771727
0.14953446
0.8
0.21704983
0.29945835
0.6
0.39368691
0.49462009
0.4
0.59590075
0.69110584
0.2
0.77494267
0.84410195
0
0.89754692 -60% -40% -20% 0% 20% 40% 60%
0.93623735 Col umn O
0.96247594
0.97914524
0.98906573
0.99459652

GRAFICO 1
2.5

1.5

0.5

0
-20% 0% 20% 40% 60%

Rentabilidad
Rentabilidad

v-15 May-16 Nov-16 May-17 Nov-17 May-18 Nov-18 May-19


40% 60%

You might also like