%
set con = server.CreateObject("ADODB.Connection")
con.Open(Application("ConnString"))
set rs = Server.CreateObject("ADODB.Recordset")
'ano_abertura = Year(Date())
ano_abertura = 2015
if ano_abertura = 2013 then
sSQL = "select * from CD_12_focus.FundoFundos where Data between '06-01-2013' and '12-01-2013' order by Data"
'response.write sSQL
Rs.Open sSQL, con
rsArray = Rs.GetRows()
rs.Close
sSQL = "select sum(FundoFundos),sum(Ibovespa),sum(Performance) from FundoFundos where Data between '06-01-2013' and '12-01-2013'"
'response.write sSQL
Rs.Open sSQL, con
rsAcum = Rs.GetRows()
rs.Close
elseif ano_abertura = 2014 then
sSQL = "select * from CD_12_focus.FundoFundos where Data between '01-01-2014' and '12-01-2014' order by Data"
'response.write sSQL
Rs.Open sSQL, con
rsArray = Rs.GetRows()
rs.Close
sSQL = "select sum(FundoFundos),sum(Ibovespa),sum(Performance) from FundoFundos where Data between '01-01-2014' and '12-01-2014'"
'response.write sSQL
Rs.Open sSQL, con
rsAcum = Rs.GetRows()
rs.Close
elseif ano_abertura = 2015 then
sSQL = "select * from CD_12_focus.FundoFundos where Data between '01-01-2015' and '12-01-2015' order by Data"
'response.write sSQL
Rs.Open sSQL, con
rsArray = Rs.GetRows()
rs.Close
sSQL = "select ((select TOP 1 FDOFUNDO from BancoFundos where Data between '2015-01-01' and '2015-12-31' order by Data DESC)/(select TOP 1 FDOFUNDO from BancoFundos where Data between '2014-01-01' and '2014-12-31' order by Data DESC)-1)*100 AS FDOFUNDO,((select TOP 1 CDI from BancoFundos where Data between '2015-01-01' and '2015-12-31' order by Data DESC)/(select TOP 1 CDI from BancoFundos where Data between '2014-01-01' and '2014-12-31' order by Data DESC)-1)*100 AS CDI,(select (select ((select TOP 1 FDOFUNDO from BancoFundos where Data between '2015-01-01' and '2015-12-31' order by Data DESC)/(select TOP 1 FDOFUNDO from BancoFundos where Data between '2014-01-01' and '2014-12-31' order by Data DESC)-1)*100 AS FDOFUNDO)-(((select TOP 1 CDI from BancoFundos where Data between '2015-01-01' and '2015-12-31' order by Data DESC)/(select TOP 1 CDI from BancoFundos where Data between '2014-01-01' and '2014-12-31' order by Data DESC)-1)*100)) AS Performance"
'response.write sSQL
Rs.Open sSQL, con
rsAcum = Rs.GetRows()
rs.Close
elseif ano_abertura = 2016 then
sSQL = "select * from CD_12_focus.FundoFundos where Data between '01-01-2016' and '12-01-2016' order by Data"
'response.write sSQL
Rs.Open sSQL, con
rsArray = Rs.GetRows()
rs.Close
sSQL = "select sum(FundoFundos),sum(Ibovespa),sum(Performance) from FundoFundos where Data between '01-01-2016' and '12-01-2016'"
'response.write sSQL
Rs.Open sSQL, con
rsAcum = Rs.GetRows()
rs.Close
else ano_abertura = 2017
sSQL = "select * from CD_12_focus.FundoFundos where Data between '01-01-2017' and '12-01-2017' order by Data"
'response.write sSQL
Rs.Open sSQL, con
rsArray = Rs.GetRows()
rs.Close
sSQL = "select ((select FDOFUNDO from BancoFundos where Data = DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1))/(select TOP 1 FDOFUNDO from BancoFundos where Data between '2016-01-01' and '2016-12-31' order by Data DESC)-1)*100 AS FDOFUNDO,((select CDI from BancoFundos where Data = DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1))/(select TOP 1 CDI from BancoFundos where Data between '2016-01-01' and '2016-12-31' order by Data DESC)-1)*100 AS CDI,(select (select ((select FDOFUNDO from BancoFundos where Data = DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1))/(select TOP 1 FDOFUNDO from BancoFundos where Data between '2016-01-01' and '2016-12-31' order by Data DESC)-1)*100 AS FDOFUNDO)-(((select CDI from BancoFundos where Data = DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1))/(select TOP 1 CDI from BancoFundos where Data between '2016-01-01' and '2016-12-31' order by Data DESC)-1)*100)) AS Performance"
'response.write sSQL
Rs.Open sSQL, con
rsAcum = Rs.GetRows()
rs.Close
end if
set rs = Nothing
set con = Nothing
%>
Focus Fundo de Fundos
|
Mês |
Fundo |
CDI |
Benchmark |
|
<%For i = 0 to UBound(rsArray, 2)%>
|
<%=rsArray(1,i)%> |
<%=rsArray(2,i)%>% |
<%=rsArray(3,i)%>% |
<%=rsArray(4,i)%>% |
|
<%Next%>
|
Acumulado |
<%=AcertaNumero_Traco(rsAcum(0,0),3,"%")%> |
<%=AcertaNumero_Traco(rsAcum(1,0),3,"%")%> |
<%=AcertaNumero_Traco(rsAcum(2,0),3,"%")%> |
|
- Objetivo
Proporcionar aos seus cotistas rentabilidade através de aplicação de seus recursos em carteira diversificada, formada, em sua maior parte, por cotas de fundos de investimento multimercados, visando superar a variação do benchmark (CDI).
- Política de Investimento
O FUNDO aplicará seus recursos em, no mínimo 95% em cotas de Fundos de Investimento e cotas de Fundos de Investimentos em Cotas, de quaisquer das classes previstas nas regulamentações em vigor, e no máximo 5% em depósitos a vista ou aplicados em títulos Públicos Federais, títulos de renda fixa de emissão de instituição financeira ou operações compromissadas, de acordo com a regulamentação específica do Conselho Monetário Nacional – CMN.
- Público Alvo
Investidores que desejam auferir rentabilidade superior à variação do CDI.
ANBIMA
Como Investir