Primera Parte Rentabilidad - Volatilidad - Beta

Descargar como xls, pdf o txt
Descargar como xls, pdf o txt
Está en la página 1de 5

Nemotecnico fecha Cantidad Volumen Precio Cierre

ECOPETROL 10/02/2021 00:00:00 5,506,776.00 12,044,922,165.00 2,195.00


ECOPETROL 11/02/2021 00:00:00 4,313,112.00 9,287,334,208.00 2,140.00
ECOPETROL 12/02/2021 00:00:00 5,864,980.00 12,591,028,322.00 2,150.00
ECOPETROL 15/02/2021 00:00:00 1,318,624.00 2,887,449,968.00 2,190.00
ECOPETROL 16/02/2021 00:00:00 8,810,049.00 19,471,908,073.00 2,210.00
ECOPETROL 17/02/2021 00:00:00 13,240,489.00 29,073,602,347.00 2,200.00
ECOPETROL 18/02/2021 00:00:00 15,456,250.00 33,675,251,732.00 2,156.00
ECOPETROL 19/02/2021 00:00:00 18,141,689.00 39,236,427,355.00 2,165.00
ECOPETROL 22/02/2021 00:00:00 18,274,283.00 40,043,852,069.00 2,233.00
ECOPETROL 23/02/2021 00:00:00 12,504,238.00 28,400,523,550.00 2,291.00
ECOPETROL 24/02/2021 00:00:00 11,899,639.00 27,403,767,025.00 2,309.00
ECOPETROL 25/02/2021 00:00:00 11,391,994.00 26,280,712,229.00 2,280.00
ECOPETROL 26/02/2021 00:00:00 8,797,301.00 19,669,345,524.00 2,250.00
ECOPETROL 01/03/2021 00:00:00 4,622,065.00 10,482,677,281.00 2,246.00
ECOPETROL 02/03/2021 00:00:00 4,334,480.00 9,774,469,167.00 2,245.00
ECOPETROL 03/03/2021 00:00:00 12,689,731.00 28,781,593,626.00 2,255.00
ECOPETROL 04/03/2021 00:00:00 17,902,729.00 41,162,249,671.00 2,279.00
ECOPETROL 05/03/2021 00:00:00 29,177,519.00 69,223,177,728.00 2,400.00
ECOPETROL 08/03/2021 00:00:00 7,693,085.00 18,122,048,025.00 2,347.00
ECOPETROL 09/03/2021 00:00:00 10,445,352.00 24,270,292,016.00 2,339.00
ECOPETROL 10/03/2021 00:00:00 5,881,588.00 13,822,329,133.00 2,373.00
Precio Mayor Precio Medio Precio Menor Variacion% Variacion Absoluta
2,200.00 2,187.29 2,176.00 -.36 -8.00
2,180.00 2,153.28 2,138.00 -2.51 -55.00
2,162.00 2,146.82 2,120.00 .47 10.00
2,200.00 2,189.74 2,169.00 1.86 40.00
2,219.00 2,210.19 2,189.00 .91 20.00
2,224.00 2,195.81 2,181.00 -.45 -10.00
2,213.00 2,178.75 2,156.00 -2.00 -44.00
2,172.00 2,162.78 2,146.00 .42 9.00
2,242.00 2,191.27 2,155.00 3.14 68.00
2,305.00 2,271.27 2,200.00 2.60 58.00
2,325.00 2,302.91 2,260.00 .79 18.00
2,349.00 2,306.95 2,280.00 -1.26 -29.00
2,260.00 2,235.84 2,200.00 -1.32 -30.00
2,293.00 2,267.96 2,246.00 -.18 -4.00
2,275.00 2,255.05 2,240.00 -.04 -1.00
2,283.00 2,268.10 2,254.00 .45 10.00
2,335.00 2,299.22 2,249.00 1.06 24.00
2,420.00 2,372.48 2,300.00 5.31 121.00
2,420.00 2,355.63 2,335.00 -2.21 -53.00
2,347.00 2,323.55 2,310.00 -.34 -8.00
2,379.00 2,350.10 2,310.00 1.45 34.00
PORTAFOLIO DE ACCIONES - PRECIOS DEL MERCADO
FECHA ECOPETROL NUTRESA ISA BCOLOMBIA
10/02/2021 00:00:00 2,195.00 24,400.00 23,400.00 31,510.00
11/02/2021 00:00:00 2,140.00 24,380.00 23,400.00 31,060.00
12/02/2021 00:00:00 2,150.00 24,000.00 23,680.00 30,850.00
15/02/2021 00:00:00 2,190.00 23,890.00 23,500.00 30,900.00
16/02/2021 00:00:00 2,210.00 23,420.00 23,200.00 30,900.00
17/02/2021 00:00:00 2,200.00 23,750.00 23,200.00 31,200.00
18/02/2021 00:00:00 2,156.00 23,650.00 23,100.00 30,890.00
19/02/2021 00:00:00 2,165.00 23,950.00 23,000.00 31,100.00
22/02/2021 00:00:00 2,233.00 23,800.00 22,970.00 31,000.00
23/02/2021 00:00:00 2,291.00 23,700.00 22,620.00 31,050.00
24/02/2021 00:00:00 2,309.00 23,600.00 23,600.00 31,800.00
25/02/2021 00:00:00 2,280.00 23,490.00 22,820.00 30,000.00
26/02/2021 00:00:00 2,250.00 23,690.00 23,800.00 31,400.00
01/03/2021 00:00:00 2,246.00 23,580.00 23,630.00 30,710.00
02/03/2021 00:00:00 2,245.00 23,400.00 23,680.00 30,450.00
03/03/2021 00:00:00 2,255.00 23,470.00 23,600.00 30,300.00
04/03/2021 00:00:00 2,279.00 23,280.00 23,110.00 30,380.00
05/03/2021 00:00:00 2,400.00 23,170.00 23,600.00 30,000.00
08/03/2021 00:00:00 2,347.00 23,350.00 23,520.00 29,750.00
09/03/2021 00:00:00 2,339.00 23,400.00 23,700.00 30,170.00
10/03/2021 00:00:00 2,373.00 23,500.00 23,800.00 30,140.00

Distribucion 30% 20% 10% 20%


Monetaria $ 120,000,000 $ 80,000,000 $ 40,000,000 $ 80,000,000
Capital $ 400,000,000

Precios ECOPETROL NUTRESA ISA BBOGOTA


MIN $ 2,140 $ 23,170 $ 22,620 $ 29,750
MAX $ 2,400 $ 24,400 $ 23,800 $ 31,800
INDICE MATRIZ DE LA RENTABILIDAD PORTAFOLIO OSC
GRUPOSURA ICOLCAP FECHA ECOPETROL
23,560.00 1,370 05/02/2021 00:00:00
23,300.00 1,383 08/02/2021 00:00:00 -2.51%
23,300.00 1,380 09/02/2021 00:00:00 0.47%
23,310.00 1,374 10/02/2021 00:00:00 1.86%
23,180.00 1,368 11/02/2021 00:00:00 0.91%
23,150.00 1,366 12/02/2021 00:00:00 -0.45%
23,150.00 1,369 15/02/2021 00:00:00 -2.00%
22,860.00 1,363 16/02/2021 00:00:00 0.42%
22,800.00 1,366 17/02/2021 00:00:00 3.14%
22,780.00 1,354 18/02/2021 00:00:00 2.60%
23,290.00 1,353 19/02/2021 00:00:00 0.79%
22,020.00 1,352 22/02/2021 00:00:00 -1.26%
23,670.00 1,355 23/02/2021 00:00:00 -1.32%
23,060.00 1,371 24/02/2021 00:00:00 -0.18%
23,000.00 1,336 25/02/2021 00:00:00 -0.04%
22,850.00 1,359 26/02/2021 00:00:00 0.45%
22,700.00 1,356 01/03/2021 00:00:00 1.06%
22,400.00 1,350 02/03/2021 00:00:00 5.31%
22,280.00 1,347 03/03/2021 00:00:00 -2.21%
22,390.00 1,337 04/03/2021 00:00:00 -0.34%
22,500.00 1,345 05/03/2021 00:00:00 1.45%
ECOPETROL
20% 100% Rendimiento 0.41%
$ 80,000,000 $ 400,000,000 Varianza 0.000363
Riesgo Volatilidad 1.91%
Covarianza -0.0000294
Riesgo BETA -0.4
GARGOS
$ 22,020 0.3 - 0.5 Bajo
$ 23,670 0.6 - 1.0 Medio
>1.1 Alto
RENTABILIDAD PORTAFOLIO OSCAR CORTES INDICE
NUTRESA ISA BCOLOMBIAGRUPOSURA

-0.08% 0.00% -1.43% -1.10% 0.94%


-1.56% 1.20% -0.68% 0.00% -0.22%
-0.46% -0.76% 0.16% 0.04% -0.44%
-1.97% -1.28% 0.00% -0.56% -0.47%
1.41% 0.00% 0.97% -0.13% -0.13%
-0.42% -0.43% -0.99% 0.00% 0.25%
1.27% -0.43% 0.68% -1.25% -0.45%
-0.63% -0.13% -0.32% -0.26% 0.23%
-0.42% -1.52% 0.16% -0.09% -0.92%
-0.42% 4.33% 2.42% 2.24% -0.08%
-0.47% -3.31% -5.66% -5.45% -0.03%
0.85% 4.29% 4.67% 7.49% 0.22%
-0.46% -0.71% -2.20% -2.58% 1.14%
-0.76% 0.21% -0.85% -0.26% -2.55%
0.30% -0.34% -0.49% -0.65% 1.77%
-0.81% -2.08% 0.26% -0.66% -0.28%
-0.47% 2.12% -1.25% -1.32% -0.42%
0.78% -0.34% -0.83% -0.54% -0.21%
0.21% 0.77% 1.41% 0.49% -0.75%
0.43% 0.42% -0.10% 0.49% 0.57%
NUTRESA ISA BBOGOTA GARGOS ICOLCAP
-0.18% 0.10% -0.20% -0.20%
0.000073 0.000340 0.000389 0.000544 0.00008
0.86% 1.84% 1.97% 2.33%
0.0000148 0.0000024 -0.0000164 -0.0000081
0.2 0.0 -0.21 -0.1

También podría gustarte