Portafolio de Inversión (Parte 1)

Estudiante:
Sonia Milena Mejía Alvarado

Administración Financiera, Facultad de Ciencias Empresariales, Corporación Universitaria Minuto de

Dios

NRC 53463: Mercado de Capitales

Docente:
Max Antonio Caicedo Guerrero

Diciembre 3, 2023
inuto de
Fecha Indice Valor Hoy Valor Ayer Variacion % Variación Absoluta
6/1/2023 COLCAP 1658.77 1662.42 -0.21955943 -3.65000000000009
6/2/2023 COLCAP 1676.49 1658.77 1.06826142 17.72
6/5/2023 COLCAP 1663.83 1676.49 -0.75514915 -12.6600000000001
6/6/2023 COLCAP 1656.96 1663.83 -0.41290276 -6.86999999999989
6/7/2023 COLCAP 1653.54 1656.96 -0.20640208 -3.42000000000007
6/8/2023 COLCAP 1654.93 1653.54 0.08406207 1.3900000000001
6/9/2023 COLCAP 1651.93 1654.93 -0.18127654 -3
6/13/2023 COLCAP 1653.18 1651.93 0.07566906 1.25
6/14/2023 COLCAP 1648.78 1653.18 -0.26615371 -4.40000000000009
6/15/2023 COLCAP 1647.8 1648.78 -0.05943788 -0.98000000000002
6/16/2023 COLCAP 1656.04 1647.8 0.50006068 8.24000000000001
6/20/2023 COLCAP 1656.37 1656.04 0.01992705 0.329999999999927
6/21/2023 COLCAP 1653.48 1656.37 -0.17447792 -2.88999999999987
6/22/2023 COLCAP 1650.36 1653.48 -0.18869293 -3.12000000000012
6/23/2023 COLCAP 1648.18 1650.36 -0.13209239 -2.17999999999984
6/26/2023 COLCAP 1647.91 1648.18 -0.0163817 -0.26999999999998
6/27/2023 COLCAP 1623.97 1647.91 -1.45274923 -23.9400000000001
6/28/2023 COLCAP 1624.66 1623.97 0.04248846 0.690000000000055
6/29/2023 COLCAP 1633.81 1624.66 0.56319476 9.14999999999986
6/30/2023 COLCAP 1638.15 1633.81 0.26563676 4.34000000000015
7/4/2023 COLCAP 1623.83 1638.15 -0.87415682 -14.3200000000002
7/5/2023 COLCAP 1625.18 1623.83 0.08313678 1.35000000000014
7/6/2023 COLCAP 1643.92 1625.18 1.15310304 18.74
7/7/2023 COLCAP 1656.3 1643.92 0.753078 12.3799999999999
7/10/2023 COLCAP 1653.96 1656.3 -0.14127875 -2.33999999999992
7/11/2023 COLCAP 1654.7 1653.96 0.0447411 0.740000000000009
7/12/2023 COLCAP 1643.17 1654.7 -0.69680304 -11.53
7/13/2023 COLCAP 1645.22 1643.17 0.12475885 2.04999999999995
7/14/2023 COLCAP 1659.54 1645.22 0.87040031 14.3199999999999
7/17/2023 COLCAP 1663.07 1659.54 0.21270954 3.52999999999997
7/18/2023 COLCAP 1664.4 1663.07 0.07997258 1.33000000000015
7/19/2023 COLCAP 1665.39 1664.4 0.05948089 0.990000000000009
7/21/2023 COLCAP 1665.36 1665.39 -0.00180137 -0.0300000000002
7/24/2023 COLCAP 1676.29 1665.36 0.65631455 10.9300000000001
7/25/2023 COLCAP 1669.6 1676.29 -0.39909562 -6.69000000000005
7/26/2023 COLCAP 1631.45 1669.6 -2.28497843 -38.1499999999999
7/27/2023 COLCAP 1622.66 1631.45 -0.53878451 -8.78999999999996
7/28/2023 COLCAP 1612.48 1622.66 -0.62736494 -10.1800000000001
7/31/2023 COLCAP 1589.74 1612.48 -1.41025004 -22.74
8/1/2023 COLCAP 1556.69 1589.74 -2.0789563 -33.05
8/2/2023 COLCAP 1549.61 1556.69 -0.45481116 -7.08000000000015
8/3/2023 COLCAP 1536.48 1549.61 -0.84730996 -13.1299999999999
8/4/2023 COLCAP 1512.61 1536.48 -1.55355097 -23.8700000000001
8/8/2023 COLCAP 1544.53 1512.61 2.11025974 31.9200000000001
8/9/2023 COLCAP 1546.66 1544.53 0.13790602 2.13000000000011
8/10/2023 COLCAP 1502.84 1546.66 -2.83320186 -43.8200000000002
8/11/2023 COLCAP 1344.6 1502.84 -10.5293977 -158.24
8/14/2023 COLCAP 1360.21 1344.6 1.16094005 15.6100000000001
8/15/2023 COLCAP 1295.46 1360.21 -4.76029436 -64.75
8/16/2023 COLCAP 1174.31 1295.46 -9.35189044 -121.15
8/17/2023 COLCAP 1174.31 1174.31 0 0
8/18/2023 COLCAP 997.78 1174.31 -15.0326575 -176.53
Variacion 12 meses Variación Anual Var x Ln
24.4575330132053 -0.2195594374 -0.219801
24.3198149095682 0.8463565164 1.0625958
22.6334991708126 0.0848161114 -0.758015
21.1015611296264 -0.3284368571 -0.413758
20.0296165097524 -0.5341610423 -0.206615
19.5698194455483 -0.4505479962 0.0840268
18.9825552082283 -0.6310078078 -0.181441
18.6606373815676 -0.5558162197 0.0756405
18.3541623297849 -0.82049061 -0.266509
18.432590164877 -0.8794408151 -0.059456
19.017981630277 -0.383777866 0.4988145
18.9109443985785 -0.3639272867 0.0199251
18.1952049408838 -0.5377702385 -0.17463
17.5520321381256 -0.7254484426 -0.188871
17.1814122799534 -0.8565825723 -0.13218
16.315395691578 -0.8728239554 -0.016383
13.9252316779729 -2.312893252 -1.463405
13.5982883273434 -2.2713874953 0.0424794
13.6603012278688 -1.7209850699 0.5616147
13.003138688649 -1.4599198758 0.2652846
12.2196805827189 -2.3213147098 -0.878
11.1591417412775 -2.2401077946 0.0831022
11.4567372232091 -1.1128355048 1.1465055
10.9087378380731 -0.3681380156 0.7502565
11.0860366713681 -0.5088966687 -0.141379
12.4032850805986 -0.4643832485 0.0447311
11.8738808663031 -1.1579504577 -0.699242
12.040152000109 -1.0346362531 0.1246811
12.6081439612412 -0.1732414191 0.8666342
12.9365666827383 0.0390996258 0.2124836
12.7039050914483 0.1191034756 0.0799406
11.8582251954542 0.1786552134 0.0594632
12.3201748173927 0.1768506153 -0.001801
13.4345225205717 0.8343258622 0.6541702
12.9145701455391 0.4319004824 -0.399894
10.3456905356141 -1.8629467884 -2.311489
8.77632831458566 -2.3916940364 -0.540241
6.79524200598722 -3.0040543304 -0.629341
4.59159840784236 -4.3719397023 -1.420289
2.64070577065092 -6.3600052934 -2.100871
2.74088856769676 -6.7858904488 -0.455849
1.39439733394926 -7.5757028909 -0.85092
-0.18081631306299 -9.0115614585 -1.565745
1.8147659854977 -7.0914690631 2.0883021
1.873917310517 -6.9633425969 0.137811
-1.90723600903359 -9.5992589117 -2.874112
-10.5395173684806 -19.1179124408 -11.12601
-9.50093479085302 -18.1789198878 1.1542529
-15.0957864450547 -22.0738441549 -4.877326
-23.4153976587211 -29.36141288 -9.81851
-24.7430146116381 -29.36141288 0
-36.8381738535943 -39.9802697272 -16.29032
 8/22/2023 COLCAP 1000.5 997.78 0.27260518 2.72000000000003
8/23/2023 COLCAP 894.03 1000.5 -10.6416792 -106.47
8/24/2023 COLCAP 899.75 894.03 0.63979955 5.72000000000003
8/25/2023 COLCAP 919.59 899.75 2.20505696 19.84
8/28/2023 COLCAP 923.53 919.59 0.42845181 3.93999999999994
8/29/2023 COLCAP 1046.18 923.53 13.28056478 122.65
8/30/2023 COLCAP 1167.04 1046.18 11.5525053 120.86
8/31/2023 COLCAP 1147.54 1167.04 -1.67089388 -19.5
9/1/2023 COLCAP 1129.18 1147.54 -1.59994422 -18.3599999999999
9/4/2023 COLCAP 1123.85 1129.18 -0.47202394 -5.33000000000015
9/5/2023 COLCAP 1063.03 1123.85 -5.41175423 -60.8199999999999
9/6/2023 COLCAP 1114.43 1063.03 4.83523512 51.4000000000001
9/7/2023 COLCAP 1127.55 1114.43 1.17728345 13.1199999999999
9/8/2023 COLCAP 1160.12 1127.55 2.8885637 32.5699999999999
9/11/2023 COLCAP 1163.43 1160.12 0.28531531 3.31000000000017
9/12/2023 COLCAP 1187.13 1163.43 2.03708001 23.7
9/13/2023 COLCAP 1193.98 1187.13 0.57702189 6.84999999999991
9/14/2023 COLCAP 1211.06 1193.98 1.43050972 17.0799999999999
9/15/2023 COLCAP 1204.01 1211.06 -0.58213465 -7.04999999999995
9/18/2023 COLCAP 1202.54 1204.01 -0.122092 -1.47000000000003
9/19/2023 COLCAP 1192.08 1202.54 -0.86982553 -10.46
9/20/2023 COLCAP 1179.6 1192.08 -1.0469096 -12.48
9/21/2023 COLCAP 1131.29 1179.6 -4.09545608 -48.3099999999999
9/22/2023 COLCAP 1132.78 1131.29 0.13170805 1.49000000000001
9/25/2023 COLCAP 1151.78 1132.78 1.6772895 19
9/26/2023 COLCAP 1122.37 1151.78 -2.55343902 -29.4100000000001
9/27/2023 COLCAP 1116.17 1122.37 -0.5524025 -6.19999999999982
9/28/2023 COLCAP 1145.34 1116.17 2.61340118 29.1699999999998
9/29/2023 COLCAP 1145.89 1145.34 0.04802067 0.550000000000182
10/2/2023 COLCAP 1142.04 1145.89 -0.33598338 -3.85000000000014
10/3/2023 COLCAP 1105.43 1142.04 -3.20566705 -36.6099999999999
10/4/2023 COLCAP 1099.28 1105.43 -0.55634458 -6.15000000000009
10/5/2023 COLCAP 1090.43 1099.28 -0.80507241 -8.84999999999991
10/6/2023 COLCAP 1113.37 1090.43 2.10375723 22.9399999999998
10/9/2023 COLCAP 1110.26 1113.37 -0.27933211 -3.1099999999999
10/10/2023 COLCAP 1104.09 1110.26 -0.55572568 -6.17000000000007
10/11/2023 COLCAP 1089.29 1104.09 -1.34047043 -14.8
10/12/2023 COLCAP 1055.27 1089.29 -3.12313525 -34.02
10/13/2023 COLCAP 1052.23 1055.27 -0.28807793 -3.03999999999996
10/17/2023 COLCAP 1053.75 1052.23 0.1444551 1.51999999999998
10/18/2023 COLCAP 1082.96 1053.75 2.77200474 29.21
10/19/2023 COLCAP 1067.65 1082.96 -1.41371795 -15.3099999999999
10/20/2023 COLCAP 1072.29 1067.65 0.43459935 4.63999999999987
10/23/2023 COLCAP 1066.11 1072.29 -0.57633662 -6.18000000000006
10/24/2023 COLCAP 1057.66 1066.11 -0.79260113 -8.44999999999982
10/25/2023 COLCAP 1072.78 1057.66 1.42957093 15.1199999999999
10/26/2023 COLCAP 1088.42 1072.78 1.45789444 15.6400000000001
10/27/2023 COLCAP 1085.55 1088.42 -0.26368497 -2.87000000000012
10/30/2023 COLCAP 1095.84 1085.55 0.94790659 10.29
10/31/2023
11/1/2023
11/2/2023
11/3/2023
11/7/2023
-36.6659914415213 -39.8166528314 0.2722343
-44.3447026525645 -46.221171545 -11.25158
-44.2433894565938 -45.8770948376 0.6377615
-43.5217599587279 -44.6836539502 2.1810972
-42.1778248048135 -44.4466500643 0.4275366
-34.4987133653479 -37.0688514334 12.469743
-27.3790781752674 -29.7987271567 10.932519
-27.032835669049 -30.9717159321 -1.685011
-28.8813029841158 -32.0761299791 -1.612882
-29.217000264527 -32.3967469111 -0.473141
-32.8004298628232 -36.0552688249 -5.563697
-29.4445745832568 -32.9633907195 4.7219742
-29.113438615903 -32.1741798101 1.1704074
-27.4847952594963 -30.2149877888 2.8476311
-27.2778982766919 -30.0158804634 0.2849091
-26.5548921953785 -28.5902479517 2.0166091
-25.6073322242783 -28.1781980486 0.5753635
-24.5431378779666 -27.1507801879 1.4203745
-23.445557145128 -27.5748607451 -0.583836
-23.9586956109344 -27.6632860528 -0.122167
-24.2792080339958 -28.2924892626 -0.873631
-25.0719362768451 -29.0432020788 -1.052428
-28.1405822233232 -31.9492065783 -4.181682
-28.8088085571714 -31.8595782052 0.1316214
-27.7889932414641 -30.7166660651 1.6633783
-29.8593274464588 -32.4857737515 -2.586605
-30.1411359724613 -32.8587240288 -0.553934
-28.315443592552 -31.1040531273 2.5798354
-27.9486663564683 -31.0709688285 0.0480091
-27.4268574769325 -31.3025589201 -0.336549
-28.9286219444766 -33.5047701543 -3.258174
-29.3240237112474 -33.8747127681 -0.557898
-29.6115314105709 -34.4070692123 -0.808331
-27.480035954822 -33.0271531863 2.0819338
-27.8728781077236 -33.2142298576 -0.279723
-28.7858460506457 -33.5853755368 -0.557276
-29.7404507282086 -34.4756439407 -1.349536
-30.3824357934042 -36.5220582043 -3.172945
-30.2747977284625 -36.7049241467 -0.288494
-29.8225167327095 -36.6134911755 0.1443509
-27.8050731642279 -34.8564141432 2.7342803
-28.8257058098063 -35.7773607151 -1.423806
-27.6818592605582 -35.4982495398 0.4336577
-28.6123703470581 -35.8699967517 -0.578004
-28.9889420785133 -36.3782918877 -0.795759
-27.97282145279 -35.4687744372 1.4194489
-26.4586050094256 -34.5279772861 1.4473693
-25.8189943828671 -34.7006171725 -0.264033
-26.042707124153 -34.0816400187 0.9434421
 11/8/2023
11/9/2023
11/10/2023
11/14/2023
11/15/2023
11/16/2023
11/17/2023
11/20/2023
11/21/2023
11/22/2023
11/23/2023
11/24/2023
11/27/2023
11/28/2023
11/29/2023
11/30/2023
12/1/2023
Nemotecnico fecha Cantidad Volumen Precio Cierre
PFBCOLOM 6/1/2023 627,997.00 16,637,377,020.00 26.87
PFBCOLOM 6/2/2023 579,191.00 16,248,219,430.00 28.18
PFBCOLOM 6/5/2023 271,809.00 7,688,762,770.00 28.35
PFBCOLOM 6/6/2023 876,642.00 25,959,181,390.00 30.38
PFBCOLOM 6/7/2023 660,591.00 20,057,535,370.00 30.42
PFBCOLOM 6/8/2023 186,725.00 5,639,210,630.00 30.19
PFBCOLOM 6/9/2023 352,160.00 10,536,289,420.00 29.95
PFBCOLOM 6/13/2023 382,623.00 11,189,539,310.00 29.07
PFBCOLOM 6/14/2023 127,344.00 3,711,546,030.00 29.1
PFBCOLOM 6/15/2023 372,360.00 10,852,286,680.00 29.08
PFBCOLOM 6/16/2023 1,052,756.00 30,524,250,230.00 28.99
PFBCOLOM 6/20/2023 457,097.00 13,002,270,000.00 28.42
PFBCOLOM 6/21/2023 182,120.00 5,222,287,780.00 28.51
PFBCOLOM 6/22/2023 379,296.00 10,615,564,920.00 27.88
PFBCOLOM 6/23/2023 182,681.00 5,068,759,940.00 27.76
PFBCOLOM 6/26/2023 252,702.00 7,047,060,780.00 28
PFBCOLOM 6/27/2023 544,130.00 14,837,378,440.00 27.3
PFBCOLOM 6/28/2023 182,126.00 4,994,823,540.00 27.6
PFBCOLOM 6/29/2023 399,760.00 11,206,483,410.00 27.73
PFBCOLOM 6/30/2023 617,216.00 17,165,705,710.00 27.99
PFBCOLOM 7/4/2023 55,471.00 1,541,904,650.00 27.83
PFBCOLOM 7/5/2023 1,762,695.00 48,411,653,320.00 27.14
PFBCOLOM 7/6/2023 475,023.00 12,768,294,760.00 27.14
PFBCOLOM 7/7/2023 265,167.00 7,333,712,700.00 27.73
PFBCOLOM 7/10/2023 434,431.00 12,028,164,390.00 27.79
PFBCOLOM 7/11/2023 326,973.00 9,232,279,020.00 28.3
PFBCOLOM 7/12/2023 495,275.00 14,084,240,350.00 28.46
PFBCOLOM 7/13/2023 532,502.00 15,485,440,910.00 29.39
PFBCOLOM 7/14/2023 276,103.00 8,073,605,140.00 29.25
PFBCOLOM 7/17/2023 304,231.00 8,921,798,780.00 29.3
PFBCOLOM 7/18/2023 321,233.00 9,541,265,780.00 29.6
PFBCOLOM 7/19/2023 592,702.00 17,661,571,460.00 29.78
PFBCOLOM 7/21/2023 320,913.00 9,461,015,900.00 29.35
PFBCOLOM 7/24/2023 290,803.00 8,569,888,860.00 29.4
PFBCOLOM 7/25/2023 219,478.00 6,455,254,390.00 29.38
PFBCOLOM 7/26/2023 216,167.00 6,346,671,270.00 29.28
PFBCOLOM 7/27/2023 778,142.00 22,872,466,590.00 29.45
PFBCOLOM 7/28/2023 561,780.00 16,630,581,190.00 29.36
PFBCOLOM 7/31/2023 354,529.00 10,470,216,640.00 1
PFBCOLOM 8/1/2023 968,348.00 29,069,481,750.00 30
PFBCOLOM 8/2/2023 591,585.00 17,398,442,210.00 29.21
PFBCOLOM 8/3/2023 317,800.00 9,458,957,910.00 29.96
PFBCOLOM 8/4/2023 42,190.00 1,261,865,530.00 1
PFBCOLOM 8/8/2023 324,749.00 9,627,773,130.00 29.81
PFBCOLOM 8/9/2023 788,133.00 23,128,764,800.00 29.4
PFBCOLOM 8/10/2023 1,197,657.00 33,607,324,510.00 28.39
PFBCOLOM 8/11/2023 586,594.00 16,407,380,980.00 27.94
PFBCOLOM 8/14/2023 194,544.00 5,476,266,740.00 28.13
PFBCOLOM 8/15/2023 354,075.00 9,813,856,920.00 27.53
PFBCOLOM 8/16/2023 442,265.00 12,412,787,830.00 28.28
PFBCOLOM 8/17/2023 184,812.00 5,193,955,910.00 28.1
PFBCOLOM 8/18/2023 120,063.00 3,353,496,150.00 27.83
Precio Mayor Precio Medio Precio Menor Variacion% Variacion Absoluta Var x Ln
27.1 26.492 25.89 3.51 910 .00
28.43 28.053 27.25 4.88 1.31 4.76
28.59 28.287 27.81 0.6 170 .60
30.52 29.612 28.34 7.16 2.03 6.92
30.71 30.363 30.02 0.13 40 .13
30.5 30.2 29.83 -0.76 -230 -.76
30.12 29.919 29.61 -0.79 -240 -.80
29.92 29.244 28.91 -2.94 -880 -2.98
29.39 29.145 28.84 0.1 30 .10
29.3 29.144 29.08 -0.07 -20 -.07
29.28 28.994 28.6 -0.31 -90 -.31
28.75 28.445 28.16 -1.97 -570 -1.99
29.07 28.674 28.43 0.32 90 .32
28.51 27.987 27.68 -2.21 -630 -2.23
27.9 27.746 27.41 -0.43 -120 -.43
28.05 27.886 27.6 0.86 240 .86
27.52 27.268 26.92 -2.5 -700 -2.53
27.78 27.425 27.24 1.1 300 1.09
28.3 28.033 27.6 0.47 130 .47
28.03 27.811 27.63 0.94 260 .93
27.96 27.796 27.53 -0.57 -160 -.57
27.84 27.464 27.14 -2.48 -690 -2.51
27.14 26.879 26.6 0 0 .00
27.8 27.656 27.17 2.17 590 2.15
28.1 27.687 26.6 0.22 60 .22
28.3 28.235 28.01 1.84 510 1.82
28.58 28.437 28.2 0.57 160 .56
29.39 29.08 28.61 3.27 930 3.22
29.5 29.241 28.9 -0.48 -140 -.48
29.58 29.325 29.15 0.17 50 .17
29.89 29.702 29.36 1.02 300 1.02
30 29.798 29.6 0.61 180 .61
29.93 29.481 29.26 -1.44 -430 -1.45
29.8 29.469 29.26 0.17 50 .17
29.61 29.411 29.29 -0.07 -20 -.07
29.6 29.36 29.28 -0.34 -100 -.34
29.46 29.393 29.05 0.58 170 .58
29.7 29.603 29.36 -0.31 -90 -.31
29.85 29.532 29.37 1.26 370 -337.96
30.14 30.019 29.91 0.2 60 340.12
30.02 29.409 29.1 -2.63 -790 -2.67
30.02 29.763 29.23 2.57 750 2.54
30 29.909 29.69 0.13 40 -339.99
29.97 29.646 29.16 0.17 50 339.48
29.81 29.346 29.13 -1.38 -410 -1.38
29.2 28.06 27.1 -3.44 -1.01 -3.50
28.68 27.97 27.73 -1.59 -450 -1.60
28.33 28.149 28.04 0.68 190 .68
28.13 27.716 27.4 -2.13 -600 -2.16
28.3 28.066 27.57 2.72 750 2.69
28.29 28.104 27.84 -0.64 -180 -.64
28.13 27.931 27.7 -0.96 -270 -.97
 El coeficiente de correlación, es una herramienta
Cifras de análisis en pesos estadística que presenta resultados entre -1 y +1.
MAXIMO 30.42 Cuando está cerca de -1, indica que la correlación es
MINIMO 1.00 inversa; cuando es cercano a 1, hay correlación directa;
cuando se acerca a 0, es indiferente. Los resultados,
Close price 26.33 entre más cercanos a 1 o -1 se encuentran, su nivel de
Desv. Estándar 3.9381585 correlación es más fuerte.
Promedio 27.29 La correlación fuerte, se considera desde -0.7 o 0.7
hasta -1 y 1, respectivamente
Rentabilidad máx y min 2942
Valor absoluto 29.42
Correlación 0.05
Interpretación comportamiento de datos
95% (confianza)= (promedio-(2*S), Promedio + (2*S)

19.41 35.164337
Interpretación. el 95% de la muestra o de los datos podría
estar entre $10,035 y $16,198

Ganancia potencial 31.23

Pérdida potencial 23.35

Beta 1.0308729
Covarianza (Acción-Indice) 11.274815
Varianza Indice 10.937153
enta
y +1. Cifras de análisis en Var Ln
ación es MAXIMO 340.12
ón directa; MINIMO -339.99
ultados,
u nivel de Last RR .11
Desv. Estándar 67.90
7 o 0.7 Promedio -.02

Interpretación comportamiento de datos

95% (confianza)= (promedio-(2*S), Promedio + (2*S)

-135.82 135.78
Interpretación. el 95% de la muestra o de los datos podría
estar entre -%8,48 y %7,83

Ganancia potencial 67.88

Pérdida potencial -67.92
PFBCOLOM 8/22/2023 487,665.00 13,680,099,360.00 27.97
PFBCOLOM 8/23/2023 276,451.00 7,681,560,530.00 27.73
PFBCOLOM 8/24/2023 311,990.00 8,668,011,790.00 27.82
PFBCOLOM 8/25/2023 304,308.00 8,439,715,400.00 27.68
PFBCOLOM 8/28/2023 221,143.00 6,192,411,470.00 28.1
PFBCOLOM 8/29/2023 275,395.00 7,769,558,430.00 28.12
PFBCOLOM 8/30/2023 280,834.00 7,869,887,490.00 27.98
PFBCOLOM 8/31/2023 1,441,109.00 39,257,288,280.00 27.2
PFBCOLOM 9/1/2023 272,273.00 7,402,736,560.00 27.48
PFBCOLOM 9/4/2023 14,081.00 383,956,730.00 27.26
PFBCOLOM 9/5/2023 842,266.00 22,096,850,340.00 25.9
PFBCOLOM 9/6/2023 328,799.00 8,513,967,330.00 25.9
PFBCOLOM 9/7/2023 492,817.00 12,465,260,320.00 25.1
PFBCOLOM 9/8/2023 256,433.00 6,525,022,390.00 25.68
PFBCOLOM 9/11/2023 307,054.00 7,913,265,480.00 25.53
PFBCOLOM 9/12/2023 431,950.00 11,470,888,670.00 26.8
PFBCOLOM 9/13/2023 336,225.00 8,972,128,470.00 26.73
PFBCOLOM 9/14/2023 382,894.00 10,260,860,740.00 27.09
PFBCOLOM 9/15/2023 2,327,700.00 64,600,106,230.00 27.8
PFBCOLOM 9/18/2023 419,316.00 11,524,583,560.00 27.55
PFBCOLOM 9/19/2023 438,213.00 12,080,536,870.00 27.68
PFBCOLOM 9/20/2023 233,912.00 6,429,365,850.00 27.31
PFBCOLOM 9/21/2023 561,341.00 15,002,672,100.00 26.64
PFBCOLOM 9/22/2023 367,017.00 10,032,170,140.00 27.29
PFBCOLOM 9/25/2023 780,204.00 21,349,583,240.00 27.46
PFBCOLOM 9/26/2023 753,451.00 20,113,373,130.00 26.9
PFBCOLOM 9/27/2023 529,444.00 14,170,630,360.00 26.62
PFBCOLOM 9/28/2023 372,007.00 9,972,271,000.00 26.77
PFBCOLOM 9/29/2023 674,486.00 18,259,291,020.00 27.08
PFBCOLOM 10/2/2023 138,067.00 3,745,139,180.00 27.15
PFBCOLOM 10/3/2023 589,387.00 15,866,235,710.00 26.6
PFBCOLOM 10/4/2023 367,389.00 9,810,417,800.00 26.53
PFBCOLOM 10/5/2023 215,761.00 5,738,406,460.00 26.5
PFBCOLOM 10/6/2023 204,410.00 5,497,390,090.00 27.06
PFBCOLOM 10/9/2023 187,890.00 5,096,655,780.00 27.2
PFBCOLOM 10/10/2023 249,190.00 6,763,285,780.00 27.15
PFBCOLOM 10/11/2023 366,383.00 9,930,557,550.00 27.25
PFBCOLOM 10/12/2023 438,295.00 11,805,975,010.00 27
PFBCOLOM 10/13/2023 319,217.00 8,576,501,510.00 26.51
PFBCOLOM 10/17/2023 371,750.00 9,879,754,440.00 26.53
PFBCOLOM 10/18/2023 352,772.00 9,486,240,650.00 26.98
PFBCOLOM 10/19/2023 215,074.00 5,836,986,620.00 27.06
PFBCOLOM 10/20/2023 354,217.00 9,566,688,430.00 26.71
PFBCOLOM 10/23/2023 117,145.00 3,144,697,880.00 26.73
PFBCOLOM 10/24/2023 115,245.00 3,070,056,100.00 26.6
PFBCOLOM 10/25/2023 227,141.00 6,007,526,190.00 26.27
PFBCOLOM 10/26/2023 118,849.00 3,121,722,560.00 26.18
PFBCOLOM 10/27/2023 143,291.00 3,775,668,790.00 26.3
PFBCOLOM 10/30/2023 252,147.00 6,695,096,860.00 26.33
PFBCOLOM 10/31/2023 424,654.00 11,090,674,930.00 26.4
PFBCOLOM 11/1/2023 383,625.00 10,063,106,710.00 26.1
PFBCOLOM 11/2/2023 188,192.00 5,005,884,390.00 26.6
PFBCOLOM 11/3/2023 94,944.00 2,559,461,860.00 26.97
PFBCOLOM 11/7/2023 161,748.00 4,345,185,690.00 26.9
 28.4 28.052 27.77 0.5 140 .50
28.14 27.786 27.61 -0.86 -240 -.86
28.03 27.782 27.55 0.32 90 .32
28 27.734 27.54 -0.5 -140 -.50
28.2 28.001 27.76 1.52 420 1.51
28.3 28.212 28.1 0.07 20 .07
28.38 28.023 27.85 -0.5 -140 -.50
28.16 27.241 27.2 -2.79 -780 -2.83
27.6 27.188 26.79 1.03 280 1.02
27.26 27.267 27.26 -0.8 -220 -.80
27 26.235 25.9 -4.99 -1.36 -5.12
26.01 25.894 25.66 0 0 .00
26.02 25.293 25.07 -3.09 -800 -3.14
25.68 25.445 25.01 2.31 580 2.28
25.9 25.771 25.53 -0.58 -150 -.59
26.8 26.556 25.96 4.97 1.27 4.85
26.84 26.684 26.45 -0.26 -70 -.26
27.09 26.798 26.42 1.35 360 1.34
27.8 27.752 26.8 2.62 710 2.59
27.65 27.484 27.12 -0.9 -250 -.90
27.84 27.567 27.25 0.47 130 .47
28.05 27.486 27.26 -1.34 -370 -1.35
27.2 26.726 26.52 -2.45 -670 -2.48
27.74 27.334 26.64 2.44 650 2.41
27.54 27.364 27.26 0.62 170 .62
27.02 26.695 26.01 -2.04 -560 -2.06
27.28 26.765 26.6 -1.04 -280 -1.05
26.92 26.806 26.62 0.56 150 .56
27.29 27.071 26.78 1.16 310 1.15
27.48 27.125 26.9 0.26 70 .26
27.24 26.919 26.56 -2.03 -550 -2.05
27.05 26.703 26.48 -0.26 -70 -.26
26.79 26.596 26.5 -0.11 -30 -.11
27.1 26.893 26.51 2.11 560 2.09
27.2 27.125 26.82 0.52 140 .52
27.39 27.141 26.89 -0.18 -50 -.18
27.25 27.104 26.77 0.37 100 .37
27.04 26.936 26.8 -0.92 -250 -.92
27.12 26.867 26.51 -1.81 -490 -1.83
26.72 26.576 26.5 0.08 20 .08
27 26.89 26.49 1.7 450 1.68
27.32 27.139 26.83 0.3 80 .30
27.25 27.007 26.71 -1.29 -350 -1.30
27.14 26.844 26.55 0.07 20 .07
26.9 26.639 26.53 -0.49 -130 -.49
26.7 26.448 26.27 -1.24 -330 -1.25
26.49 26.266 26.18 -0.34 -90 -.34
26.6 26.349 26.18 0.46 120 .46
27.2 26.552 26.33 0.11 30 .11
26.41 26.116 25.98 0.27 70 .27
26.81 26.231 26.1 -1.14 -300 -1.14
26.75 26.599 26.2 1.92 500 1.90
27.09 26.957 26.77 1.39 370 1.38
27 26.863 26.67 -0.26 -70 -.26
PFBCOLOM 11/8/2023 218,642.00 5,923,834,440.00 27.14
PFBCOLOM 11/9/2023 264,365.00 7,190,173,240.00 27.02
PFBCOLOM 11/10/2023 182,404.00 4,974,203,400.00 27.28
PFBCOLOM 11/14/2023 288,792.00 7,921,111,740.00 27.44
PFBCOLOM 11/15/2023 592,255.00 16,368,741,220.00 27.72
PFBCOLOM 11/16/2023 482,654.00 13,384,824,080.00 27.74
PFBCOLOM 11/17/2023 502,381.00 14,000,294,280.00 27.78
PFBCOLOM 11/20/2023 151,313.00 4,178,099,780.00 27.52
PFBCOLOM 11/21/2023 307,602.00 8,462,637,200.00 27.6
PFBCOLOM 11/22/2023 608,687.00 16,968,571,520.00 28.32
PFBCOLOM 11/23/2023 41,296.00 1,160,723,440.00 27.96
PFBCOLOM 11/24/2023 116,063.00 3,236,488,860.00 28.18
PFBCOLOM 11/27/2023 289,503.00 8,073,179,840.00 27.98
PFBCOLOM 11/28/2023 231,942.00 6,476,247,960.00 27.8
PFBCOLOM 11/29/2023 439,782.00 12,257,071,560.00 27.9
PFBCOLOM 11/30/2023 976,072.00 27,146,595,080.00 27.8
PFBCOLOM 12/1/2023 515,045.00 14,344,955,140.00 28.08
 27.2 27.093 26.92 0.89 240 .89
27.48 27.197 26.88 -0.44 -120 -.44
27.34 27.27 27.1 0.96 260 .96
27.5 27.428 27.28 0.59 160 .58
27.76 27.638 27.4 1.02 280 1.02
27.88 27.731 27.56 0.07 20 .07
28 27.867 27.74 0.14 40 .14
27.8 27.612 27.52 -0.94 -260 -.94
27.8 27.511 27.28 0.29 80 .29
28.32 27.877 27.26 2.61 720 2.58
28.32 28.107 27.9 -1.27 -360 -1.28
28.2 27.885 27.7 0.79 220 .78
27.98 27.886 27.72 -0.71 -200 -.71
28.1 27.921 27.7 -0.64 -180 -.65
28 27.87 27.8 0.36 100 .36
28.14 27.812 27.62 -0.36 -100 -.36
28.08 27.851 27.54 1.01 280 1.00
Nemotecnico fecha Cantidad Volumen Precio Cierre
ECOPETROL 6/1/2023 1,730,206 3,609,057,522 2.064
ECOPETROL 6/2/2023 2,059,397 4,344,540,283 2.116
ECOPETROL 6/5/2023 1,646,721 3,477,318,636 2.09
ECOPETROL 6/6/2023 2,777,808 5,860,416,576 2.143
ECOPETROL 6/7/2023 2,716,894 5,902,900,473 2.17
ECOPETROL 6/8/2023 3,050,800 6,583,394,889 2.171
ECOPETROL 6/9/2023 2,303,122 5,005,288,709 2.172
ECOPETROL 6/13/2023 1,997,559 4,293,346,722 2.134
ECOPETROL 6/14/2023 1,530,465 3,288,280,782 2.143
ECOPETROL 6/15/2023 2,787,163 6,057,515,618 2.153
ECOPETROL 6/16/2023 9,259,418 20,217,910,461 2.2
ECOPETROL 6/20/2023 5,475,954 11,674,961,161 2.134
ECOPETROL 6/21/2023 4,023,686 8,796,860,974 2.185
ECOPETROL 6/22/2023 2,222,590 4,786,509,636 2.148
ECOPETROL 6/23/2023 2,057,088 4,436,986,548 2.14
ECOPETROL 6/26/2023 1,250,225 2,722,933,321 2.185
ECOPETROL 6/27/2023 2,534,263 5,454,333,204 2.14
ECOPETROL 6/28/2023 1,729,947 3,706,790,924 2.15
ECOPETROL 6/29/2023 3,885,081 8,349,821,279 2.153
ECOPETROL 6/30/2023 2,786,231 5,983,787,352 2.14
ECOPETROL 7/4/2023 242.094 519,289,200 2.137
ECOPETROL 7/5/2023 1,698,983 3,646,274,923 2.137
ECOPETROL 7/6/2023 1,362,332 2,881,934,396 2.13
ECOPETROL 7/7/2023 4,169,861 8,987,570,419 2.16
ECOPETROL 7/10/2023 2,674,017 5,767,546,546 2.157
ECOPETROL 7/11/2023 8,395,624 18,469,171,778 2.214
ECOPETROL 7/12/2023 2,811,015 6,268,065,201 2.236
ECOPETROL 7/13/2023 5,176,500 11,627,668,995 2.236
ECOPETROL 7/14/2023 3,534,854 7,757,476,785 2.167
ECOPETROL 7/17/2023 1,900,688 4,128,301,434 2.166
ECOPETROL 7/18/2023 974.314 2,132,273,964 2.186
ECOPETROL 7/19/2023 3,890,027 8,521,420,452 2.181
ECOPETROL 7/21/2023 2,083,141 4,541,130,134 2.192
ECOPETROL 7/24/2023 4,709,605 10,487,517,436 2.219
ECOPETROL 7/25/2023 10,164,221 22,614,565,331 2.243
ECOPETROL 7/26/2023 3,579,686 7,973,792,483 2.224
ECOPETROL 7/27/2023 2,183,614 4,816,015,118 2.199
ECOPETROL 7/28/2023 2,395,808 5,271,830,158 2.206
ECOPETROL 7/31/2023 3,696,916 8,323,505,678 1
ECOPETROL 8/1/2023 3,332,201 7,641,344,765 2.29
ECOPETROL 8/2/2023 2,962,515 6,698,507,686 2.27
ECOPETROL 8/3/2023 6,699,148 15,577,472,952 2.33
ECOPETROL 8/4/2023 358.096 830,381,861 1
ECOPETROL 8/8/2023 2,835,644 6,613,342,661 2.365
ECOPETROL 8/9/2023 8,513,993 19,303,115,637 2.284
ECOPETROL 8/10/2023 2,157,838 4,900,952,633 2.27
ECOPETROL 8/11/2023 1,510,908 3,464,167,413 2.3
ECOPETROL 8/14/2023 1,327,110 3,016,528,236 2.275
ECOPETROL 8/15/2023 2,308,542 5,262,836,390 2.265
ECOPETROL 8/16/2023 3,670,828 8,424,385,124 2.307
ECOPETROL 8/17/2023 589.643 1,356,279,466 2.297
ECOPETROL 8/18/2023 1,326,201 3,064,661,580 2.33
Precio Mayor Precio Medio Precio Menor Variacion% Variacion Absoluta Var x Ln
2.105 2.085 2.036 1.38 28 .00
2.121 2.109 2.09 2.52 52 2.49
2.168 2.111 2.081 -1.23 -26 -1.24
2.143 2.109 2.049 2.54 53 2.50
2.196 2.172 2.143 1.26 27 1.25
2.18 2.157 2.132 0.05 1 .05
2.198 2.173 2.136 0.05 1 .05
2.188 2.149 2.126 -1.75 -38 -1.77
2.164 2.148 2.132 0.42 9 .42
2.194 2.173 2.153 0.47 10 .47
2.2 2.183 2.14 2.18 47 2.16
2.164 2.132 2.11 -3 -66 -3.05
2.205 2.186 2.16 2.39 51 2.36
2.19 2.153 2.139 -1.69 -37 -1.71
2.178 2.156 2.13 -0.37 -8 -.37
2.185 2.177 2.14 2.1 45 2.08
2.176 2.152 2.14 -2.06 -45 -2.08
2.15 2.142 2.13 0.47 10 .47
2.16 2.149 2.132 0.14 3 .14
2.157 2.147 2.138 -0.6 -13 -.61
2.16 2.144 2.137 -0.14 -3 -.14
2.174 2.146 2.137 0 0 .00
2.136 2.115 2.098 -0.33 -7 -.33
2.16 2.155 2.111 1.41 30 1.40
2.17 2.156 2.148 -0.14 -3 -.14
2.214 2.199 2.165 2.64 57 2.61
2.244 2.229 2.215 0.99 22 .99
2.282 2.246 2.226 0 0 .00
2.26 2.194 2.162 -3.09 -69 -3.13
2.196 2.172 2.155 -0.05 -1 -.05
2.203 2.188 2.165 0.92 20 .92
2.208 2.19 2.174 -0.23 -5 -.23
2.209 2.179 2.17 0.5 11 .50
2.237 2.226 2.206 1.23 27 1.22
2.243 2.224 2.215 1.08 24 1.08
2.236 2.227 2.219 -0.85 -19 -.85
2.225 2.205 2.19 -1.12 -25 -1.13
2.218 2.2 2.184 0.32 7 .32
2.292 2.251 2.207 3.9 86 -79.12
2.312 2.293 2.282 -0.09 -2 82.86
2.3 2.261 2.24 -0.87 -20 -.88
2.338 2.325 2.282 2.64 60 2.61
2.33 2.318 2.303 -0.09 -2 -84.59
2.365 2.332 2.286 3.05 70 86.08
2.325 2.267 2.23 -3.42 -81 -3.48
2.299 2.271 2.25 -0.61 -14 -.61
2.301 2.292 2.279 1.32 30 1.31
2.293 2.273 2.266 -1.09 -25 -1.09
2.309 2.279 2.264 -0.44 -10 -.44
2.307 2.294 2.278 1.85 42 1.84
2.317 2.3 2.288 -0.43 -10 -.43
2.33 2.31 2.27 1.44 33 1.43
 El coeficiente de correlación, es una herramienta
Cifras de análisis en pesos estadística que presenta resultados entre -1 y +1.
MAXIMO 2.65 Cuando está cerca de -1, indica que la correlación es
MINIMO 1.00 inversa; cuando es cercano a 1, hay correlación directa;
cuando se acerca a 0, es indiferente. Los resultados,
Close price 2.40 entre más cercanos a 1 o -1 se encuentran, su nivel de
Desv. Estándar 0.2302358 correlación es más fuerte.
Promedio 2.29 La correlación fuerte, se considera desde -0.7 o 0.7
hasta -1 y 1, respectivamente
Rentabilidad máx y min 164.5
Valor absoluto 1.65
Correlación 0.05
Interpretación comportamiento de datos
95% (confianza)= (promedio-(2*S), Promedio + (2*S)

1.82 2.745937
Interpretación. el 95% de la muestra o de los datos podría
estar entre $10,035 y $16,198

Ganancia potencial 2.52

Pérdida potencial 2.06

Beta 0.2445685
Covarianza (Acción-Indice) 2.674883
Varianza Indice 10.937153
enta
y +1. Cifras de análisis en Var Ln
ación es MAXIMO 86.08
ón directa; MINIMO -84.59
ultados,
u nivel de Last RR -3.08
Desv. Estándar 16.73
7 o 0.7 Promedio .15

Interpretación comportamiento de datos

95% (confianza)= (promedio-(2*S), Promedio + (2*S)

-33.31 33.60
Interpretación. el 95% de la muestra o de los datos podría
estar entre -%8,48 y %7,83

Ganancia potencial 16.87

Pérdida potencial -16.58
ECOPETROL 8/22/2023 2,365,736 5,485,474,990 2.324
ECOPETROL 8/23/2023 1,838,690 4,225,155,509 2.31
ECOPETROL 8/24/2023 4,138,161 9,540,152,917 2.304
ECOPETROL 8/25/2023 7,548,139 17,424,313,577 2.31
ECOPETROL 8/28/2023 5,446,812 12,725,543,037 2.345
ECOPETROL 8/29/2023 5,360,637 12,654,491,411 2.39
ECOPETROL 8/30/2023 4,698,598 11,485,653,173 2.44
ECOPETROL 8/31/2023 8,043,923 19,135,809,244 2.357
ECOPETROL 9/1/2023 988.501 2,369,776,850 2.385
ECOPETROL 9/4/2023 264.509 629,134,504 2.37
ECOPETROL 9/5/2023 3,513,747 8,526,709,472 2.416
ECOPETROL 9/6/2023 4,406,266 10,697,111,307 2.421
ECOPETROL 9/7/2023 3,539,191 8,476,852,707 2.385
ECOPETROL 9/8/2023 3,378,947 8,189,061,061 2.429
ECOPETROL 9/11/2023 2,430,673 5,833,391,011 2.396
ECOPETROL 9/12/2023 5,899,237 14,429,470,193 2.453
ECOPETROL 9/13/2023 2,775,262 6,683,988,766 2.409
ECOPETROL 9/14/2023 4,456,154 10,864,390,069 2.456
ECOPETROL 9/15/2023 8,248,170 20,133,754,096 2.411
ECOPETROL 9/18/2023 2,094,746 5,120,997,058 2.442
ECOPETROL 9/19/2023 5,320,123 13,084,368,616 2.489
ECOPETROL 9/20/2023 7,651,789 19,286,574,246 2.513
ECOPETROL 9/21/2023 6,845,300 17,064,534,452 2.468
ECOPETROL 9/22/2023 12,185,823 28,435,437,230 2.33
ECOPETROL 9/25/2023 9,026,013 21,497,458,181 2.364
ECOPETROL 9/26/2023 15,081,201 34,981,927,398 2.307
ECOPETROL 9/27/2023 13,683,348 32,103,508,005 2.35
ECOPETROL 9/28/2023 6,752,718 15,919,610,188 2.333
ECOPETROL 9/29/2023 5,947,252 14,006,202,998 2.365
ECOPETROL 10/2/2023 7,263,625 16,910,383,232 2.322
ECOPETROL 10/3/2023 3,929,995 9,308,947,058 2.375
ECOPETROL 10/4/2023 6,808,446 15,772,157,853 2.312
ECOPETROL 10/5/2023 2,323,044 5,441,287,002 2.321
ECOPETROL 10/6/2023 5,006,039 11,767,139,423 2.359
ECOPETROL 10/9/2023 9,458,486 23,307,728,423 2.48
ECOPETROL 10/10/2023 1,472,519 3,633,203,822 2.483
ECOPETROL 10/11/2023 4,191,759 10,426,018,057 2.507
ECOPETROL 10/12/2023 8,764,499 22,050,087,797 2.54
ECOPETROL 10/13/2023 6,325,395 16,372,218,128 2.585
ECOPETROL 10/17/2023 1,474,056 3,853,144,289 2.606
ECOPETROL 10/18/2023 3,205,582 8,442,723,684 2.645
ECOPETROL 10/19/2023 5,958,099 15,627,649,929 2.619
ECOPETROL 10/20/2023 7,005,109 18,077,291,049 2.575
ECOPETROL 10/23/2023 2,671,569 6,790,037,927 2.525
ECOPETROL 10/24/2023 2,457,161 6,239,035,861 2.52
ECOPETROL 10/25/2023 1,636,778 4,170,444,822 2.542
ECOPETROL 10/26/2023 3,692,565 9,201,520,646 2.475
ECOPETROL 10/27/2023 1,191,949 2,953,531,964 2.47
ECOPETROL 10/30/2023 2,829,265 6,808,875,599 2.395
ECOPETROL 10/31/2023 5,020,434 12,200,057,741 2.423
ECOPETROL 11/1/2023 6,001,824 14,800,614,899 2.48
ECOPETROL 11/2/2023 1,228,867 3,057,938,272 2.48
ECOPETROL 11/3/2023 2,410,303 5,908,674,837 2.46
ECOPETROL 11/7/2023 7,028,953 16,636,587,244 2.34
2.332 2.318 2.31 -0.26 -6 -.26
2.332 2.297 2.268 -0.6 -14 -.60
2.325 2.305 2.293 -0.26 -6 -.26
2.317 2.308 2.3 0.26 6 .26
2.36 2.336 2.324 1.52 35 1.50
2.39 2.36 2.33 1.92 45 1.90
2.456 2.444 2.394 2.09 50 2.07
2.46 2.378 2.357 -3.4 -83 -3.46
2.411 2.397 2.38 1.19 28 1.18
2.404 2.378 2.36 -0.63 -15 -.63
2.443 2.426 2.4 1.94 46 1.92
2.46 2.427 2.41 0.21 5 .21
2.424 2.395 2.38 -1.49 -36 -1.50
2.44 2.423 2.372 1.84 44 1.83
2.439 2.399 2.393 -1.36 -33 -1.37
2.458 2.445 2.41 2.38 57 2.35
2.421 2.408 2.398 -1.79 -44 -1.81
2.461 2.438 2.415 1.95 47 1.93
2.477 2.441 2.411 -1.83 -45 -1.85
2.465 2.444 2.427 1.29 31 1.28
2.49 2.459 2.437 1.92 47 1.91
2.539 2.52 2.485 0.96 24 .96
2.54 2.492 2.4 -1.79 -45 -1.81
2.4 2.333 2.3 -5.59 -138 -5.75
2.405 2.381 2.32 1.46 34 1.45
2.345 2.319 2.276 -2.41 -57 -2.44
2.365 2.346 2.307 1.86 43 1.85
2.377 2.357 2.333 -0.72 -17 -.73
2.365 2.355 2.336 1.37 32 1.36
2.379 2.328 2.315 -1.82 -43 -1.83
2.397 2.368 2.328 2.28 53 2.26
2.33 2.316 2.309 -2.65 -63 -2.69
2.367 2.342 2.32 0.39 9 .39
2.368 2.35 2.327 1.64 38 1.62
2.481 2.464 2.375 5.13 121 5.00
2.484 2.467 2.435 0.12 3 .12
2.507 2.487 2.46 0.97 24 .96
2.54 2.515 2.492 1.32 33 1.31
2.61 2.588 2.54 1.77 45 1.76
2.632 2.613 2.585 0.81 21 .81
2.645 2.633 2.614 1.5 39 1.49
2.649 2.622 2.59 -0.98 -26 -.99
2.629 2.58 2.57 -1.68 -44 -1.69
2.57 2.541 2.525 -1.94 -50 -1.96
2.56 2.539 2.504 -0.2 -5 -.20
2.552 2.547 2.526 0.87 22 .87
2.52 2.491 2.475 -2.64 -67 -2.67
2.498 2.477 2.452 -0.2 -5 -.20
2.462 2.406 2.378 -3.04 -75 -3.08
2.46 2.43 2.407 1.17 28 1.16
2.48 2.466 2.447 2.35 57 2.33
2.515 2.488 2.48 0 0 .00
2.485 2.451 2.43 -0.81 -20 -.81
2.54 2.366 2.34 -4.88 -120 -5.00
ECOPETROL 11/8/2023 3,140,392 7,366,881,225 2.335
ECOPETROL 11/9/2023 3,248,223 7,737,605,945 2.35
ECOPETROL 11/10/2023 2,714,615 6,376,885,920 2.35
ECOPETROL 11/14/2023 2,136,750 5,069,975,100 2.37
ECOPETROL 11/15/2023 5,642,606 13,490,938,835 2.395
ECOPETROL 11/16/2023 7,083,452 16,942,866,145 2.395
ECOPETROL 11/17/2023 15,778,986 39,344,030,405 2.48
ECOPETROL 11/20/2023 4,925,112 12,411,001,400 2.5
ECOPETROL 11/21/2023 3,394,906 8,582,967,645 2.545
ECOPETROL 11/22/2023 3,351,513 8,371,934,185 2.515
ECOPETROL 11/23/2023 685.504 1,712,892,315 2.5
ECOPETROL 11/24/2023 6,234,950 15,960,861,635 2.575
ECOPETROL 11/27/2023 3,056,721 7,714,781,400 2.52
ECOPETROL 11/28/2023 1,439,171 3,654,464,590 2.54
ECOPETROL 11/29/2023 2,550,560 6,486,911,540 2.535
ECOPETROL 11/30/2023 2,879,024 7,321,363,260 2.52
ECOPETROL 12/1/2023 1,148,199 2,913,586,840 2.545
2.385 2.345 2.325 -0.21 -5 -.21
2.425 2.382 2.35 0.64 15 .64
2.365 2.349 2.32 0 0 .00
2.39 2.372 2.36 0.85 20 .85
2.405 2.39 2.38 1.05 25 1.05
2.405 2.391 2.36 0 0 .00
2.535 2.493 2.42 3.55 85 3.49
2.55 2.519 2.48 0.81 20 .80
2.55 2.528 2.5 1.8 45 1.78
2.52 2.497 2.48 -1.18 -30 -1.19
2.52 2.498 2.48 -0.6 -15 -.60
2.575 2.559 2.52 3 75 2.96
2.545 2.523 2.475 -2.14 -55 -2.16
2.555 2.539 2.52 0.79 20 .79
2.555 2.543 2.535 -0.2 -5 -.20
2.59 2.543 2.51 -0.59 -15 -.59
2.55 2.537 2.53 0.99 25 .99
Nemotecnico fecha Cantidad Volumen Precio Cierre
GEB 6/1/2023 388.28 703,469,214.00 1.83
GEB 6/2/2023 436.713 806,094,014.00 1.84
GEB 6/5/2023 501.96 941,382,127.00 1.879
GEB 6/6/2023 2,210,299 4,172,439,084.00 1.925
GEB 6/7/2023 716.864 1,387,261,768.00 1.95
GEB 6/8/2023 270.698 535,423,282.00 1.98
GEB 6/9/2023 374.44 735,891,998.00 1.986
GEB 6/13/2023 308.115 602,973,651.00 1.97
GEB 6/14/2023 236.368 463,390,075.00 1.95
GEB 6/15/2023 102.69 200,230,351.00 1.968
GEB 6/16/2023 510.777 950,907,450.00 1.839
GEB 6/20/2023 275.424 514,436,445.00 1.879
GEB 6/21/2023 785.621 1,476,750,599.00 1.86
GEB 6/22/2023 89.438 167,035,905.00 1.888
GEB 6/23/2023 228.56 420,533,519.00 1.835
GEB 6/26/2023 374.201 687,098,497.00 1.865
GEB 6/27/2023 505.532 945,172,599.00 1.88
GEB 6/28/2023 116.838 221,658,452.00 1.904
GEB 6/29/2023 652.147 1,211,905,681.00 1.842
GEB 6/30/2023 378.974 692,487,581.00 1.825
GEB 7/4/2023 212.077 382,381,609.00 1.796
GEB 7/5/2023 535.183 972,276,596.00 1.84
GEB 7/6/2023 81.403 147,193,159.00 1.82
GEB 7/7/2023 5,398,235 9,718,378,066.00 1.84
GEB 7/10/2023 100.117 180,575,915.00 1.825
GEB 7/11/2023 1,039,755 1,909,962,427.00 1.868
GEB 7/12/2023 205.747 386,182,904.00 1.889
GEB 7/13/2023 360.342 677,208,192.00 1.88
GEB 7/14/2023 193.999 357,882,631.00 1.836
GEB 7/17/2023 169.532 307,782,355.00 1.809
GEB 7/18/2023 567.801 1,035,176,957.00 1.833
GEB 7/19/2023 1,629,767 2,970,721,139.00 1.822
GEB 7/21/2023 357.963 652,436,244.00 1.829
GEB 7/24/2023 224.616 407,773,954.00 1.829
GEB 7/25/2023 251.235 456,707,353.00 1.807
GEB 7/26/2023 824.438 1,482,585,523.00 1.785
GEB 7/27/2023 793.603 1,420,986,258.00 1.79
GEB 7/28/2023 451.922 804,940,879.00 1.773
GEB 7/31/2023 416.782 732,602,464.00 1
GEB 8/1/2023 420.03 741,443,954.00 30
GEB 8/2/2023 457.106 805,398,826.00 29.21
GEB 8/3/2023 189.272 333,414,530.00 29.96
GEB 8/4/2023 27.564 48,694,929.00 1
GEB 8/8/2023 38.799 68,098,067.00 29.81
GEB 8/9/2023 969.501 1,702,319,766.00 29.4
GEB 8/10/2023 385.066 672,462,568.00 28.39
GEB 8/11/2023 245.219 431,017,026.00 27.94
GEB 8/14/2023 632.993 1,113,675,588.00 28.13
GEB 8/15/2023 319.993 557,519,944.00 27.53
GEB 8/16/2023 587.678 1,036,776,015.00 28.28
GEB 8/17/2023 123.695 219,374,947.00 28.1
GEB 8/18/2023 189.255 333,923,018.00 27.83
Precio Mayor Precio Medio Precio Menor Variacion% Variacion Absoluta Var x Ln
1.85 1.811 1.768 3.39 60 .00
1.85 1.845 1.83 0.55 10 .54
1.893 1.875 1.84 2.12 39 2.10
1.933 1.887 1.769 2.45 46 2.42
1.95 1.935 1.915 1.3 25 1.29
1.98 1.977 1.973 1.54 30 1.53
1.986 1.965 1.949 0.3 6 .30
1.97 1.956 1.945 -0.81 -16 -.81
1.971 1.96 1.923 -1.02 -20 -1.02
1.968 1.949 1.925 0.92 18 .92
1.926 1.861 1.839 -6.55 -129 -6.78
1.886 1.867 1.85 2.18 40 2.15
1.899 1.879 1.86 -1.01 -19 -1.02
1.888 1.867 1.852 1.51 28 1.49
1.886 1.839 1.82 -2.81 -53 -2.85
1.865 1.836 1.826 1.63 30 1.62
1.89 1.869 1.85 0.8 15 .80
1.904 1.897 1.885 1.28 24 1.27
1.88 1.858 1.842 -3.26 -62 -3.31
1.842 1.827 1.817 -0.92 -17 -.93
1.817 1.803 1.796 -1.59 -29 -1.60
1.84 1.816 1.805 2.45 44 2.42
1.82 1.808 1.8 -1.09 -20 -1.09
1.84 1.8 1.774 1.1 20 1.09
1.825 1.803 1.8 -0.82 -15 -.82
1.868 1.836 1.795 2.36 43 2.33
1.889 1.876 1.86 1.12 21 1.12
1.89 1.879 1.88 -0.48 -9 -.48
1.86 1.844 1.822 -2.34 -44 -2.37
1.824 1.815 1.809 -1.47 -27 -1.48
1.833 1.823 1.816 1.33 24 1.32
1.843 1.822 1.815 -0.6 -11 -.60
1.829 1.822 1.818 0.38 7 .38
1.842 1.815 1.802 0 0 .00
1.829 1.817 1.806 -1.2 -22 -1.21
1.807 1.798 1.78 -1.22 -22 -1.22
1.8 1.79 1.789 0.28 5 .28
1.8 1.781 1.765 -0.95 -17 -.95
1.778 1.757 1.737 -1.3 -23 -57.27
1.775 1.765 1.756 -0.28 -5 340.12
1.777 1.761 1.758 0.97 17 -2.67
1.776 1.761 1.755 -1.24 -22 2.54
1.78 1.766 1.755 0 0 -339.99
1.755 1.755 1.754 -0.34 -6 339.48
1.78 1.755 1.74 0.34 6 -1.38
1.76 1.746 1.737 -0.45 -8 -3.50
1.76 1.757 1.752 0.46 8 -1.60
1.76 1.759 1.76 0 .68
1.758 1.742 1.73 -0.11 -2 -2.16
1.778 1.764 1.757 1.14 20 2.69
1.78 1.773 1.753 0.11 2 -.64
1.78 1.764 1.75 -0.62 -11 -.97
 El coeficiente de correlación, es una herramienta
Cifras de análisis en pesos estadística que presenta resultados entre -1 y +1.
MAXIMO 30.00 Cuando está cerca de -1, indica que la correlación es
MINIMO 1.00 inversa; cuando es cercano a 1, hay correlación directa;
cuando se acerca a 0, es indiferente. Los resultados,
Close price 26.33 entre más cercanos a 1 o -1 se encuentran, su nivel de
Desv. Estándar 12.541979 correlación es más fuerte.
Promedio 17.20 La correlación fuerte, se considera desde -0.7 o 0.7
hasta -1 y 1, respectivamente
Rentabilidad máx y min 2900
Valor absoluto 29.00
Correlación 0.04
Interpretación comportamiento de datos
95% (confianza)= (promedio-(2*S), Promedio + (2*S)

-7.88 42.283523
Interpretación. el 95% de la muestra o de los datos podría
estar entre $10,035 y $16,198

Ganancia potencial 29.74

Pérdida potencial 4.66

Beta 0.7541149
Covarianza (Acción-Indice) 8.2478699
Varianza Indice 10.937153
enta
y +1. Cifras de análisis en Var Ln
ación es MAXIMO 340.12
ón directa; MINIMO -339.99
ultados,
u nivel de Last RR .11
Desv. Estándar 59.11
7 o 0.7 Promedio 2.64

Interpretación comportamiento de datos

95% (confianza)= (promedio-(2*S), Promedio + (2*S)

-115.58 120.86
Interpretación. el 95% de la muestra o de los datos podría
estar entre -%8,48 y %7,83

Ganancia potencial 61.75

Pérdida potencial -56.47
GEB 8/22/2023 495.058 864,489,132.00 27.97
GEB 8/23/2023 637.611 1,109,470,984.00 27.73
GEB 8/24/2023 489.664 851,824,670.00 27.82
GEB 8/25/2023 166.996 291,490,818.00 27.68
GEB 8/28/2023 239.763 416,825,102.00 28.1
GEB 8/29/2023 433.119 739,075,832.00 28.12
GEB 8/30/2023 284.095 481,867,297.00 27.98
GEB 8/31/2023 2,157,381 3,497,621,625.00 27.2
GEB 9/1/2023 131.564 217,817,249.00 27.48
GEB 9/4/2023 12.499 20,535,584.00 27.26
GEB 9/5/2023 224.864 364,807,800.00 25.9
GEB 9/6/2023 414.14 667,198,777.00 25.9
GEB 9/7/2023 1,264,743 2,064,611,681.00 25.1
GEB 9/8/2023 247.171 408,216,161.00 25.68
GEB 9/11/2023 82.877 136,857,361.00 25.53
GEB 9/12/2023 440.127 728,801,746.00 26.8
GEB 9/13/2023 2,641,268 4,463,523,938.00 26.73
GEB 9/14/2023 2,156,166 3,643,319,152.00 27.09
GEB 9/15/2023 5,086,238 8,348,523,366.00 27.8
GEB 9/18/2023 865.16 1,419,665,077.00 27.55
GEB 9/19/2023 238.29 389,443,041.00 27.68
GEB 9/20/2023 130.826 214,043,235.00 27.31
GEB 9/21/2023 213.693 347,738,771.00 26.64
GEB 9/22/2023 1,676,746 2,702,834,404.00 27.29
GEB 9/25/2023 87.931 144,436,695.00 27.46
GEB 9/26/2023 490.379 790,514,926.00 26.9
GEB 9/27/2023 766.021 1,279,428,855.00 26.62
GEB 9/28/2023 187.729 319,247,014.00 26.77
GEB 9/29/2023 384.957 665,790,466.00 27.08
GEB 10/2/2023 30.612 51,983,269.00 27.15
GEB 10/3/2023 222.561 363,051,585.00 26.6
GEB 10/4/2023 115.661 189,194,171.00 26.53
GEB 10/5/2023 25.183 41,392,633.00 26.5
GEB 10/6/2023 983.173 1,604,379,469.00 27.06
GEB 10/9/2023 267.045 440,046,012.00 27.2
GEB 10/10/2023 119.888 196,250,494.00 27.15
GEB 10/11/2023 326.766 536,585,999.00 27.25
GEB 10/12/2023 353.675 580,598,780.00 27
GEB 10/13/2023 164.295 270,428,819.00 26.51
GEB 10/17/2023 331.664 545,828,872.00 26.53
GEB 10/18/2023 205.616 339,201,751.00 26.98
GEB 10/19/2023 294.72 484,997,544.00 27.06
GEB 10/20/2023 396.847 664,750,485.00 26.71
GEB 10/23/2023 145.881 244,495,028.00 26.73
GEB 10/24/2023 3,059,528 5,107,929,456.00 26.6
GEB 10/25/2023 137.443 228,230,529.00 26.27
GEB 10/26/2023 301.394 509,827,768.00 26.18
GEB 10/27/2023 181.358 306,369,963.00 26.3
GEB 10/30/2023 242.559 412,870,526.00 26.33
GEB 10/31/2023 3,632,949 6,116,339,789.00 26.4
GEB 11/1/2023 208.756 353,913,843.00 26.1
GEB 11/2/2023 102.171 177,892,055.00 26.6
GEB 11/3/2023 221.077 386,986,051.00 26.97
GEB 11/7/2023 185.949 321,640,072.00 26.9
 1.76 1.746 1.733 -1.07 -19 .50
1.779 1.74 1.666 -1.71 -30 -.86
1.759 1.739 1.72 0 0 .32
1.758 1.745 1.682 2.21 38 -.50
1.74 1.738 1.735 -1.31 -23 1.51
1.728 1.706 1.7 -2.02 -35 .07
1.709 1.696 1.671 -0.53 -9 -.50
1.691 1.621 1.616 -4.44 -75 -2.83
1.674 1.655 1.631 0.93 15 1.02
1.642 -.80
1.635 1.622 1.615 -0.86 -14 -5.12
1.63 1.611 1.57 0.8 13 .00
1.684 1.632 1.6 3.01 49 -3.14
1.668 1.651 1.635 -0.66 -11 2.28
1.67 1.651 1.641 -1.62 -27 -.59
1.684 1.655 1.63 1.16 19 4.85
1.69 1.689 1.679 1.81 30 -.26
1.69 1.689 1.663 0 0 1.34
1.675 1.641 1.64 -2.96 -50 2.59
1.675 1.64 1.64 0 0 -.90
1.65 1.634 1.62 -0.61 -10 .47
1.649 1.636 1.62 -0.61 -10 -1.35
1.646 1.627 1.61 -0.62 -10 -2.48
1.615 1.611 1.601 -0.37 -6 2.41
1.65 1.642 1.625 2.87 46 .62
1.649 1.612 1.6 -3.03 -50 -2.06
1.7 1.67 1.607 6.25 100 -1.05
1.72 1.7 1.674 1.18 20 .56
1.747 1.729 1.689 1.57 27 1.15
1.7 1.698 1.7 -2.69 -47 .26
1.65 1.631 1.61 -5.29 -90 -2.05
1.679 1.635 1.617 2.48 40 -.26
1.622 1.643 1.622 -1.7 -28 -.11
1.659 1.631 1.62 0.25 4 2.09
1.65 1.647 1.632 0.49 8 .52
1.65 1.636 1.63 0.98 16 -.18
1.689 1.642 1.637 -0.73 -12 .37
1.664 1.641 1.637 0.18 3 -.92
1.65 1.646 1.642 0.55 9 -1.83
1.651 1.645 1.633 -1.03 -17 .08
1.651 1.649 1.64 1.04 17 1.68
1.654 1.645 1.635 -0.91 -15 .30
1.68 1.675 1.669 2.14 35 -1.30
1.679 1.675 1.67 0 0 .07
1.689 1.669 1.642 -1.2 -20 -.49
1.661 1.66 1.66 0.67 11 -1.25
1.7 1.691 1.67 1.57 26 -.34
1.697 1.689 1.682 -0.3 -5 .46
1.71 1.702 1.69 1.07 18 .11
1.7 1.683 1.665 -2.06 -35 .27
1.719 1.695 1.66 3.24 54 -1.14
1.75 1.741 1.719 1.8 31 1.90
1.799 1.75 1.735 -0.17 -3 1.38
1.73 1.729 1.728 -1.09 -19 -.26
GEB 11/8/2023 88.386 152,689,855.00 27.14
GEB 11/9/2023 13.793 23,829,135.00 27.02
GEB 11/10/2023 52.475 90,587,340.00 27.28
GEB 11/14/2023 93.084 160,552,645.00 27.44
GEB 11/15/2023 114.17 198,581,505.00 27.72
GEB 11/16/2023 75.221 128,960,060.00 27.74
GEB 11/17/2023 976.067 1,708,744,975.00 27.78
GEB 11/20/2023 803.456 1,448,577,635.00 27.52
GEB 11/21/2023 278.8 507,924,780.00 27.6
GEB 11/22/2023 479.834 887,942,255.00 28.32
GEB 11/23/2023 272.52 500,713,890.00 27.96
GEB 11/24/2023 270.357 501,409,850.00 28.18
GEB 11/27/2023 625.229 1,138,711,420.00 27.98
GEB 11/28/2023 1,879,178 3,420,521,890.00 27.8
GEB 11/29/2023 328.147 604,843,755.00 27.9
GEB 11/30/2023 274.47 517,291,280.00 27.8
GEB 12/1/2023 286.701 547,254,075.00 28.08
1.755 1.727 1.715 -0.87 -15 .89
1.735 1.727 1.735 1.17 20 -.44
1.735 1.726 1.72 -0.29 -5 .96
1.73 1.724 1.72 0 0 .58
1.75 1.739 1.73 0 0 1.02
1.73 1.714 1.705 -1.45 -25 .07
1.78 1.75 1.72 4.4 75 .14
1.825 1.802 1.78 1.12 20 -.94
1.84 1.821 1.8 1.67 30 .29
1.875 1.85 1.83 0 0 2.58
1.875 1.837 1.82 1.09 20 -1.28
1.87 1.854 1.84 0 0 .78
1.84 1.821 1.81 -1.89 -35 -.71
1.83 1.82 1.805 -0.55 -10 -.65
1.865 1.843 1.82 3.32 60 .36
1.9 1.884 1.85 1.88 35 -.36
1.92 1.908 1.875 1.05 20 1.00
Para el caso he escogido las acciones de PFBCOLOMB del grupo Bancolombia, Ecopetrol y GEB (Grupo Energ
Valores de Colombia por el ítem de variuación porcentual, ya que todas estuvieron al alza en el cierre del 1 de di
las acciones escogidas podría invertir su dinero, a sabiendas que el mercado de acciones es bastante volatil, yo
porcentaje de confiabilidad está por encima de las otras dos, además la ganancia potencial es superior a las otra
otras acciones revisadas, lo que hace que el riesgo de pérdida sea menor que si in
, Ecopetrol y GEB (Grupo Energía Bogotá), las escogí de primer momento solo visualizando la página de la Bolsa de
on al alza en el cierre del 1 de diciembre de 2023; ahora bien, si una persona me preguntara puntualmente en cual de
e acciones es bastante volatil, yo le sugeriria que invirtiera en las acciones de GEB (Grupo Energía Bogotá), pues su
a potencial es superior a las otras acciones evaluadas y por parte de la pérdida potencial, está muy por debajo de las
de pérdida sea menor que si invirtiera en las acciones de Bancolombia o de Ecopetrol.