var_açoes.xlsx

	A	B	C	D	F	G	H	I	J	K	L	M	N	O	P
1				Estudo de Caso 2: Retorno de Ativos Financeiros
2	Bases de Dados:	https://br.financas.yahoo.com
3					Base Transposta
4	Base Original
5	Data	Acao	Empresa	Preço_de_Fechamento	Data	Arezzo&Co	B3	Klabin	Localiza	Lojas Americanas	Multiplan	Petrobras	Rede Atacadao	SulAmerica	Vale
6	8/27/2021	PETR4.SA	Petrobras	28,49	8/27/2021	92,39	13,94	26,72	58,30	5,95	21,48	28,49	18,75	29,58	100,69
7	8/27/2021	LAME4.SA	Lojas Americanas	5,95	8/26/2021	91,32	13,66	26,37	55,96	5,95	21,07	27,49	18,45	29,28	98,23
8	8/27/2021	VALE3.SA	Vale	100,69	8/25/2021	92,63	13,99	26,67	57,53	5,81	21,80	27,73	18,89	30,00	99,50
9	8/27/2021	CRFB3.SA	Rede Atacadao	18,75	8/24/2021	91,74	13,90	25,67	57,05	5,87	21,93	27,58	18,87	30,26	99,71
10	8/27/2021	MULT3.SA	Multiplan	21,48	8/23/2021	90,25	13,65	25,17	56,43	5,25	21,26	27,02	18,80	29,32	96,20
11	8/27/2021	KLBN11.SA	Klabin	26,72	8/20/2021	90,40	14,20	24,61	58,73	5,59	21,70	26,60	19,21	29,65	97,55
12	8/27/2021	RENT3.SA	Localiza	58,30	8/19/2021	89,20	14,18	23,90	58,14	5,61	21,51	26,64	18,88	28,50	97,51
13	8/27/2021	ARZZ3.SA	Arezzo&Co	92,39	8/18/2021	87,80	13,54	24,22	55,21	5,41	21,32	26,79	18,10	28,20	103,41
14	8/27/2021	SULA11.SA	SulAmerica	29,58	8/17/2021	87,58	13,82	25,19	54,60	5,41	21,59	27,03	18,11	28,40	107,00
15	8/27/2021	B3SA3.SA	B3	13,94	8/16/2021	89,70	13,98	25,33	56,10	5,63	22,09	28,64	18,56	29,00	108,80
16	8/26/2021	PETR4.SA	Petrobras	27,49	8/13/2021	91,44	14,64	25,21	57,45	5,97	22,48	29,35	18,84	29,68	108,30
17	8/26/2021	LAME4.SA	Lojas Americanas	5,95	8/12/2021	92,78	13,89	24,64	58,07	6,57	22,56	29,10	18,95	29,02	109,20
18	8/26/2021	VALE3.SA	Vale	98,23	8/11/2021	91,98	15,05	24,93	57,39	6,45	23,01	28,67	18,97	28,23	109,27
19	8/26/2021	CRFB3.SA	Rede Atacadao	18,45	8/10/2021	92,10	15,51	25,08	57,43	6,42	23,09	28,28	18,83	28,50	110,06
20	8/26/2021	MULT3.SA	Multiplan	21,07	8/9/2021	92,90	15,77	25,11	58,60	6,60	23,56	28,19	18,95	29,07	109,01
21	8/26/2021	KLBN11.SA	Klabin	26,37	8/6/2021	93,60	15,90	24,44	58,25	6,72	23,20	28,39	19,15	29,15	109,70
22	8/26/2021	RENT3.SA	Localiza	55,96	8/5/2021	92,00	15,71	24,70	58,50	6,72	23,23	28,35	18,86	28,98	109,08
23	8/26/2021	ARZZ3.SA	Arezzo&Co	91,32	8/4/2021	91,79	15,94	25,00	59,16	6,84	23,51	26,28	19,06	29,03	112,52
24	8/26/2021	SULA11.SA	SulAmerica	29,28	8/3/2021	92,03	16,01	24,49	61,11	7,03	23,80	26,85	19,12	29,80	112,64
25	8/26/2021	B3SA3.SA	B3	13,66	8/2/2021	92,08	15,62	24,40	61,17	7,27	24,02	26,41	18,87	30,69	108,93
26	8/25/2021	PETR4.SA	Petrobras	27,73	7/30/2021	90,52	15,25	24,61	62,15	7,09	23,35	26,91	18,99	30,09	108,76
27	8/25/2021	LAME4.SA	Lojas Americanas	5,81	7/29/2021	92,55	15,81	25,19	67,09	7,40	24,16	27,81	19,24	30,79	115,57
28	8/25/2021	VALE3.SA	Vale	99,50	7/28/2021	93,34	15,84	25,33	66,14	7,47	22,93	27,71	19,54	31,11	117,30
29	8/25/2021	CRFB3.SA	Rede Atacadao	18,89	7/27/2021	93,86	16,10	25,42	66,81	7,46	22,96	27,15	19,80	30,95	114,18
30	8/25/2021	MULT3.SA	Multiplan	21,80	7/26/2021	96,27	16,41	25,93	68,02	7,62	23,63	27,47	19,88	31,71	116,60
31	8/25/2021	KLBN11.SA	Klabin	26,67	7/23/2021	97,73	16,35	25,65	68,32	7,82	23,71	26,74	19,71	31,66	114,12
32	8/25/2021	RENT3.SA	Localiza	57,53	7/22/2021	98,12	16,50	25,77	68,30	7,84	24,27	26,90	20,00	31,72	114,70
33	8/25/2021	ARZZ3.SA	Arezzo&Co	92,63	7/21/2021	96,81	16,35	25,59	66,81	7,90	24,26	26,96	20,07	32,03	114,40
34	8/25/2021	SULA11.SA	SulAmerica	30,00	7/20/2021	97,23	16,42	26,00	67,50	8,33	24,35	26,59	20,19	32,27	113,10
35	8/25/2021	B3SA3.SA	B3	13,99	7/19/2021	98,16	16,41	25,68	67,25	7,90	23,90	26,24	20,28	31,94	112,16
36	8/24/2021	PETR4.SA	Petrobras	27,58	7/16/2021	99,57	16,59	26,00	67,70	8,66	24,17	26,68	20,65	32,22	113,40
37	8/24/2021	LAME4.SA	Lojas Americanas	5,87	7/15/2021	100,81	17,00	26,29	68,71	8,53	24,45	27,08	20,67	32,93	115,48
38	8/24/2021	VALE3.SA	Vale	99,71	7/14/2021	99,46	17,12	26,70	68,58	8,75	24,94	27,67	20,97	33,88	115,12
39	8/24/2021	CRFB3.SA	Rede Atacadao	18,87	7/13/2021	97,13	16,95	27,09	66,17	8,85	24,48	27,90	20,69	33,74	115,75
40	8/24/2021	MULT3.SA	Multiplan	21,93	7/12/2021	96,62	16,71	27,15	66,11	8,67	23,80	27,73	20,55	33,20	115,07
41	8/24/2021	KLBN11.SA	Klabin	25,67	7/8/2021	96,04	16,15	27,00	65,51	8,52	23,06	27,49	20,77	32,37	113,66
42	8/24/2021	RENT3.SA	Localiza	57,05	7/7/2021	96,47	16,27	27,23	66,35	8,58	23,03	28,05	20,90	33,69	114,10
43	8/24/2021	ARZZ3.SA	Arezzo&Co	91,74	7/6/2021	95,81	15,92	26,69	62,94	8,49	22,90	27,67	20,64	33,14	113,77
44	8/24/2021	SULA11.SA	SulAmerica	30,26	7/5/2021	96,05	16,11	26,93	64,11	21,11	23,40	28,85	21,01	33,60	113,17
45	8/24/2021	B3SA3.SA	B3	13,90	7/2/2021	95,42	16,42	26,71	64,46	21,37	23,15	29,18	21,32	34,11	113,58
46	8/23/2021	PETR4.SA	Petrobras	27,02	7/1/2021	93,51	16,32	26,49	62,50	21,09	22,77	29,06	20,90	34,23	111,28
47	8/23/2021	LAME4.SA	Lojas Americanas	5,25	6/30/2021	94,50	16,82	26,34	64,00	21,58	23,50	29,43	21,00	34,66	113,25
48	8/23/2021	VALE3.SA	Vale	96,20	6/29/2021	95,08	17,04	26,39	64,53	22,22	23,07	29,18	21,15	35,42	112,51
49	8/23/2021	CRFB3.SA	Rede Atacadao	18,80	6/28/2021	94,95	16,99	26,36	64,25	22,35	23,72	29,05	21,42	35,04	110,60
50	8/23/2021	MULT3.SA	Multiplan	21,26	6/25/2021	92,79	16,69	25,86	63,60	21,94	24,04	29,10	21,39	34,60	112,40
51	8/23/2021	KLBN11.SA	Klabin	25,17	6/24/2021	94,30	16,99	26,37	64,50	22,38	25,18	29,65	21,63	35,99	111,03
52	8/23/2021	RENT3.SA	Localiza	56,43	6/23/2021	93,71	17,02	25,85	64,00	21,42	25,05	29,30	21,28	35,52	113,07
53	8/23/2021	ARZZ3.SA	Arezzo&Co	90,25	6/22/2021	95,00	16,99	26,30	63,00	21,76	25,30	29,10	21,47	35,95	111,40
54	8/23/2021	SULA11.SA	SulAmerica	29,32	6/21/2021	95,93	17,07	26,15	63,22	22,10	25,99	28,95	21,65	36,03	110,11
55	8/23/2021	B3SA3.SA	B3	13,65	6/18/2021	94,27	17,38	25,67	62,81	21,75	25,76	28,32	22,16	36,00	109,09
56	8/20/2021	PETR4.SA	Petrobras	26,60	6/17/2021	92,63	17,17	25,25	62,58	22,14	25,68	28,13	21,88	36,19	105,90
57	8/20/2021	LAME4.SA	Lojas Americanas	5,59	6/16/2021	91,38	16,91	25,39	64,12	22,28	25,94	29,14	22,08	36,47	108,15
58	8/20/2021	VALE3.SA	Vale	97,55	6/15/2021	91,35	16,67	25,60	64,40	22,74	26,26	29,03	22,45	35,33	111,50
59	8/20/2021	CRFB3.SA	Rede Atacadao	19,21	6/14/2021	92,19	16,32	25,65	64,56	22,67	26,63	28,75	22,60	33,70	113,72
60	8/20/2021	MULT3.SA	Multiplan	21,70	6/11/2021	88,20	16,13	26,00	64,04	22,36	25,75	28,57	22,65	33,87	114,34
61	8/20/2021	KLBN11.SA	Klabin	24,61	6/10/2021	88,11	16,00	25,80	65,40	22,53	26,56	28,68	23,59	34,45	111,83
62	8/20/2021	RENT3.SA	Localiza	58,73	6/9/2021	88,36	16,40	25,68	65,54	22,30	26,42	28,66	22,85	33,90	112,20
63	8/20/2021	ARZZ3.SA	Arezzo&Co	90,40	6/8/2021	87,60	16,33	25,26	66,72	22,18	27,18	28,66	22,84	33,58	109,92
64	8/20/2021	SULA11.SA	SulAmerica	29,65	6/7/2021	85,51	17,29	25,99	67,00	21,81	27,74	28,29	23,03	33,82	111,80
65	8/20/2021	B3SA3.SA	B3	14,20	6/4/2021	85,80	17,24	25,32	66,65	21,15	27,51	28,50	22,80	33,73	112,90
66	8/19/2021	PETR4.SA	Petrobras	26,64	6/2/2021	87,35	17,01	25,33	64,73	21,32	26,25	27,87	22,83	33,71	114,80
67	8/19/2021	LAME4.SA	Lojas Americanas	5,61	6/1/2021	88,30	17,70	25,79	64,16	21,40	25,96	27,29	22,41	34,96	113,20
68	8/19/2021	VALE3.SA	Vale	97,51	5/31/2021	88,63	17,54	26,35	62,65	19,89	25,66	26,87	22,40	34,70	114,78
69	8/19/2021	CRFB3.SA	Rede Atacadao	18,88	5/28/2021	89,03	17,48	26,19	61,94	20,05	25,59	26,99	21,91	34,68	111,59
70	8/19/2021	MULT3.SA	Multiplan	21,51	5/27/2021	87,51	16,98	26,78	61,74	19,38	25,38	25,91	21,65	33,90	110,99
71	8/19/2021	KLBN11.SA	Klabin	23,90	5/26/2021	86,10	17,10	25,96	63,40	19,30	25,22	26,09	21,50	32,80	110,20
72	8/19/2021	RENT3.SA	Localiza	58,14	5/25/2021	85,82	17,00	25,98	63,20	19,70	24,98	25,84	21,42	32,09	107,05
73	8/19/2021	ARZZ3.SA	Arezzo&Co	89,20	5/24/2021	85,76	17,45	26,07	64,25	19,48	24,62	26,39	21,70	32,00	109,78
74	8/19/2021	SULA11.SA	SulAmerica	28,50	5/21/2021	84,84	17,35	26,00	62,88	18,46	24,52	25,95	21,20	31,63	109,40
75	8/19/2021	B3SA3.SA	B3	14,18	5/20/2021	84,71	17,25	26,16	62,47	18,82	25,11	25,93	20,68	32,02	111,11
76	8/18/2021	PETR4.SA	Petrobras	26,79	5/19/2021	84,80	17,22	26,80	59,76	19,06	24,57	26,15	20,44	31,80	112,25
77	8/18/2021	LAME4.SA	Lojas Americanas	5,41	5/18/2021	85,00	17,30	26,75	61,00	19,52	24,42	26,35	20,49	31,99	114,60
78	8/18/2021	VALE3.SA	Vale	103,41	5/17/2021	85,46	17,58	26,96	59,92	19,54	24,60	26,66	20,30	32,82	113,46
79	8/18/2021	CRFB3.SA	Rede Atacadao	18,10	5/14/2021	83,84	17,85	26,90	58,79	19,44	24,21	26,30	20,57	33,24	110,56
80	8/18/2021	MULT3.SA	Multiplan	21,32	5/13/2021	81,18	17,25	27,30	58,79	19,43	23,70	24,99	20,72	33,07	112,49
81	8/18/2021	KLBN11.SA	Klabin	24,22	5/12/2021	80,40	17,17	27,69	58,30	19,34	23,27	24,78	20,38	33,00	114,33
82	8/18/2021	RENT3.SA	Localiza	55,21	5/11/2021	82,00	17,62	28,30	62,84	19,60	24,83	25,15	21,50	34,58	118,72
83	8/18/2021	ARZZ3.SA	Arezzo&Co	87,80	5/10/2021	81,68	17,77	28,02	62,95	19,69	25,04	24,70	21,38	33,91	114,69
84	8/18/2021	SULA11.SA	SulAmerica	28,20	5/7/2021	81,09	17,78	27,90	63,21	20,50	24,82	24,38	21,49	34,59	115,45
85	8/18/2021	B3SA3.SA	B3	13,54	5/6/2021	80,00	16,93	27,85	61,77	20,45	23,81	23,50	21,10	33,83	115,05
86	8/17/2021	PETR4.SA	Petrobras	27,03	5/5/2021	79,45	17,17	27,89	61,60	20,91	23,67	23,83	21,65	33,95	110,71
87	8/17/2021	LAME4.SA	Lojas Americanas	5,41	5/4/2021	76,00	16,89	27,38	62,74	21,00	23,65	22,89	21,13	32,92	110,10
88	8/17/2021	VALE3.SA	Vale	107,00	5/3/2021	75,62	17,16	27,53	64,11	20,95	24,00	23,43	21,27	33,15	108,46
89	8/17/2021	CRFB3.SA	Rede Atacadao	18,11	4/30/2021	75,65	17,17	27,88	64,30	20,86	23,03	23,62	21,72	32,56	109,02
90	8/17/2021	MULT3.SA	Multiplan	21,59	4/29/2021	76,17	17,52	28,20	63,37	21,46	23,43	23,62	22,18	33,39	111,95
91	8/17/2021	KLBN11.SA	Klabin	25,19	4/28/2021	76,82	17,87	28,20	63,12	22,63	23,95	23,94	21,91	32,91	111,92
92	8/17/2021	RENT3.SA	Localiza	54,60	4/27/2021	76,47	17,65	29,28	61,04	21,83	23,63	23,10	21,74	32,65	110,12
93	8/17/2021	ARZZ3.SA	Arezzo&Co	87,58	4/26/2021	76,91	17,67	28,97	61,92	22,35	24,00	23,78	22,09	33,40	108,57
94	8/17/2021	SULA11.SA	SulAmerica	28,40	4/23/2021	79,50	17,91	29,13	61,70	22,80	23,57	23,69	22,59	33,24	107,99
95	8/17/2021	B3SA3.SA	B3	13,82	4/22/2021	78,92	17,78	29,30	60,87	22,12	23,10	23,71	22,21	32,13	106,23
96	8/16/2021	PETR4.SA	Petrobras	28,64	4/20/2021	78,83	17,91	30,09	61,78	22,85	23,93	23,82	22,93	32,65	106,16
97	8/16/2021	LAME4.SA	Lojas Americanas	5,63	4/19/2021	78,56	18,12	29,84	62,44	23,35	23,92	24,28	22,20	32,50	107,73
98	8/16/2021	VALE3.SA	Vale	108,80	4/16/2021	79,58	18,47	29,53	64,18	23,60	23,85	22,95	23,19	32,28	108,67
99	8/16/2021	CRFB3.SA	Rede Atacadao	18,56	4/15/2021	80,95	18,19	30,05	63,60	23,26	23,72	23,09	23,03	31,96	108,21
100	8/16/2021	MULT3.SA	Multiplan	22,09	4/14/2021	74,71	18,34	29,70	63,65	23,31	23,28	24,35	22,71	32,60	107,00