FII recomendado

Prévia do material em texto

Planilha1
					FIIs							Indicado				Valor Total Ind	R$ 2,000.00
									22-Sep		Valor investido	R$ 1,500.00			Valor Total	R$ 107.19
		Peso %	Titulo	$ Cota	Valor a ser investido	Qtd Cota	P/Alvo	Coluna1	Qnt Comprar	Diferença	R$ - 0	Valor investido	Valor Pós negoci			 
		12.5%	KNCR11	R$ 101.08	R$ - 0	0.00	R$ 101.00	OK		0	0	R$ - 0	R$ - 0			Pós Neg.	R$ 107.19
		9.5%	XPCI11	R$ 83.82	R$ - 0	0.00	R$ 91.00	ok		0	0	R$ - 0	R$ - 0
		7.5%	CPTS11	R$ 8.00	R$ - 0	0.00	R$ 88.00	ok		0	0	R$ - 0	R$ - 0
		5.0%	RBRR11	R$ 85.74	R$ - 0	0.00	R$ 94.00	Ok		0	0	R$ - 0	R$ - 0
		7.5%	MCCI11	R$ 92.42	R$ - 0	0.00	R$ 92.00	OK		0	0	R$ - 0	R$ - 0
			VGIR11	R$ 9.80	R$ - 0	0.00	R$ 9.60	OK		0	0	R$ - 0	R$ - 0
		5.0%	HGRU11	R$ 131.55	R$ - 0	0.00	R$ 136.00	ok		0	0	R$ - 0	R$ - 0
		5.0%	TGAR11	R$ 118.93	R$ - 0	0.00	R$ 163.00	ok		0	0	R$ - 0	R$ - 0
		5.0%	BRCO11	R$ 119.41	R$ - 0	0.00	R$ 119.00	ok		0	0	R$ - 0	R$ - 0
		10.0%	LVBI11	R$ 114.04	R$ - 0	0.00	R$ 122.00	ok		0	0	R$ - 0	R$ - 0
		15.0%	PVBI11	R$ 101.49	R$ - 0	0.00	R$ 106.00	ok		0	0	R$ - 0	R$ - 0
		7.5%	RBRF11	R$ 74.79	R$ - 0	0.00	R$ 80.00	ok		0	0	R$ - 0	R$ - 0
		8.0%	XPML11	R$ 111.60	R$ - 0	0.00	R$ 115.00			0	0	R$ - 0	R$ - 0
		2.5%	TEPP11	R$ 87.94	R$ - 0	0.00	R$ 208.00	ok		0	0	R$ - 0	R$ - 0
			MXRF11	R$ 10.49	R$ - 0	0				0	0	R$ - 0	R$ - 0
												R$ - 0	R$ - 0
												 
					Ações
											Valor investido	Indicado
		60%							22-Sep		R$ - 0	R$ 300.00
		Peso %	Titulo	$ Cota	Valor a ser investido	Qtd Cota	P/Alvo	Coluna1	Qnt Comprar	Diferença	R$ - 0	Valor investido	Valor Pós negoci			Vendido		Qnt	Total
		10.0%	EQTL3F	R$ 32.92	R$ - 0	0.00		OK	0	0	0	R$ - 0	R$ - 0			ASAI3F	R$ 11.94	8	R$ 95.52
		10.0%	CPLE6F	R$ 8.74	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0			RENT3F	R$ 54.81	1	R$ 54.81
		7.5%	PETR4F	R$ 35.58	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0			PETR4F	R$ 35.58	1	R$ 35.58
		10.0%	GMAT3F	R$ 6.24	R$ - 0	0.00		Ok	0	0		R$ - 0	R$ - 0			ITUB4F	R$ 27.95	1	R$ 27.95
		10.0%	MDIA3F	R$ 33.10	R$ - 0	0.00		OK	0	0	0	R$ - 0	R$ - 0	 		RECV3F	R$ 21.72	3	R$ 65.16
		15.0%	ITUB4F	R$ 27.95	R$ - 0	0.00		OK	0	0	0	R$ - 0	R$ - 0			ANIM3F	R$ 3.01	24	R$ 72.24
		10.0%	SBSP3F	R$ 61.05	R$ - 0	0.00		ok	0	0		R$ - 0	R$ - 0
		10.0%	PRIO3F	R$ 48.25	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0
		10.0%	RAIL3F	R$ 23.16	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0		 
		7.5%	VALE3F	R$ 71.20	R$ - 0	0.00	R$ 32.80	ok	0	0		R$ - 0	R$ - 0
		40%			Small Caps							R$ - 0	R$ - 0		 
		Peso %	Titulo	$ Cota	Valor a ser investido	Qtd Cota	P/Alvo	Coluna1	Qnt Comprar	Diferença	R$ - 0	Valor investido	Valor Pós negoci			Vendido		Qnt	Total			 
			ANIM3F		R$ - 0	ERROR:#DIV/0!	R$ 7.10	OK	0	0		R$ - 0	R$ - 0						R$ - 0
		11.10%	CURY3F	R$ 15.66	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0						R$ - 0
		11.10%	ONCO3F	R$ 9.60	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0						R$ - 0
		11.10%	ORVR3	R$ 36.44	R$ - 0	0.00			0	0	0	R$ - 0	R$ - 0						R$ - 0
		11.10%	VULC3F	R$ 20.00	R$ - 0	0.00		Ok	0	0	0	R$ - 0	R$ - 0						R$ - 0
		11.10%	RRRP3F	R$ 33.40	R$ - 0	0.00		ok	0	0		R$ - 0	R$ - 0
		11.10%	TTEN3F	R$ 11.55	R$ - 0	0.00	R$ 16.20	ok	0	0	0	R$ - 0	R$ - 0
		11.20%	STBP3F	R$ 7.68	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0
		11.10%	VIVA3F	R$ 26.74	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0						Venda
		11.10%	KEPL3	R$ 10.08	R$ - 0	0.00		ok	0	0	0	R$ - 0	R$ - 0
												R$ - 0	R$ - 0						R$ 351.26	R$ - 0
												Total	Total
												R$ - 0	R$ - 0		 
											Valor investido	Indicado		 
			Renda Fixa								R$ 107.19	R$ 200.00
			Titulos		Valor a ser investido	Qtd Cota				Compra
			CDB C6 Diario		R$ 107.19						R$ 107.19
			Contas Abril Diario		R$ 104.00
			Contas Abril Diario		R$ 1,029.00
											 
Planilha2
		15,00% Recebíveis KNCR11 COMPRA Kinea Rendimentos 5.661 99 101 98% 10,5% 14,5% 15,00% Recebíveis XPCI11 COMPRA XP Crédito Imobiliário 685 79 92 86% -8,3% 11,0% 7,50% Recebíveis CPTS11 COMPRA Capitânia Securities 2.469 78 89 88% -8,5% 9,0% 5,00% Recebíveis RBRR11 COMPRA RBR High Grade 1.116 83 94 88% -7,2% 13,1% 7,50% Recebíveis MCCI11 COMPRA Mauá Capital Recebíveis 1.468 87 93 94% -3,0% 15,9% 2,50% Recebíveis VGIR11 COMPRA Valora RE 993 10 10 100% 12,6% 13,7% 7,50% Híbrido HGRU11 COMPRA CSHG Renda Urbana 2.186 119 123 97% 13,3% 10,1% 2,50% Híbrido TGAR11 COMPRA TG Ativo Real 1.640 119 133 89% 12,7% 13,1% 5,00% Ativos Logísticos BRCO11 COMPRA Bresco Logística 1.422 96 121 79% 6,2% 8,1% 7,50% Ativos Logísticos LVBI11 COMPRA VBI Logística 1.141 97 115 84% 5,8% 9,3% 10,00% Lajes Corporat. PVBI11 COMPRA VBI Prime Offices 853 85 103 82% 3,3% 8,0% 5,00% Fundo de Fundos RBRF11 COMPRA RBR Alpha 907 66 82 81% 2,3% 11,4% 5,00% Shoppings XPML11 COMPRA XP Malls 2.065 97 101 96% 8,4% 11,1% 5,00% Shoppings HGBS11 COMPRA Hedge Brasil Shopping 1.840 184 222 83% 20,1% 9,1%