Spreadsheet: 277674d1384386813-investment-max-drawdown-1-cell-formula-without-vba-c-pia-de-planilha
Sheet: SUPR4

 | Estrategia
 | Dias
 | Capital Inicial | 100000
 | Lucro/Prejuízo
 | Retorno
 | [NAME] tenho agora
 | Taxa de Acerto
 | PayOff (PO) / WinLoss
 | [NAME]
 | Profit Factor
 | Recovery Factor
 | [NAME]
 | [NAME]
 | Drawdown %
 | Drawdown $
 | [NAME]
 | Kelly
 | Quantidada a operar |  | 0.5
 | [NAME] | [NAME]
 | [NAME] | 15
 | Corretagem Variável
 | Se variável, quanto? | 0.005
 | Taxas | 2
 | Risco Fixo | sim
 | Valor Risco Fixo | 0.1
 | Bet it All
 | Quantidade de Trades
 | Trades Vencedores |  | Trades Perdedores
 | Ganhos |  | Perdas
 | % Ganhos |  | % Perdas
 | Média Ganho/Carteira |  | Média Perdas/Carteira
 | Ganho Melhor Trade |  | Perda Pior Trade
 | Média de dias de Trades Positivos |  | Média de dias de Trades Negativos
 | Média de dias de Operação
Trade Nº | Ativo | Status | L/S | [NAME] | Preço de Entrada | Data da Compra | Financeiro * | [NAME] | Preço de Saída | Data de Saída | Financeiro ** | Gain/Loss |  | StopLoss | StopGain | Risc p/ Acao | [NAME] | % Gain/Loss | $ Cumulative | % Cumulative
1 | SAPR4 |  | Long |  | 5 | 2012-01-10 00:00:00 |  |  | 5.11 | 2012-01-31 00:00:00 |  |  |  | 4.84
2 |  |  |  |  | 6.65 | 2012-01-24 00:00:00 |  |  | 6.43 | 2012-01-13 00:00:00 |  |  |  | 6.43
3 |  |  |  |  | 6.35 | 2012-01-30 00:00:00 |  |  | 6.53 | 2012-01-31 00:00:00 |  |  |  | 5.9
4 |  |  |  |  | 7.39 | 2012-02-07 00:00:00 |  |  | 6.93 | 2012-02-14 00:00:00 |  |  |  | 6.93
5 |  |  |  |  | 7.29 | 2012-02-15 00:00:00 |  |  | 7.23 | 2012-02-29 00:00:00 |  |  |  | 6.92
6 |  |  |  |  | 6.72 | 2012-03-01 00:00:00 |  |  | 6.86 | 2012-03-05 00:00:00 |  |  |  | 5.56
7 |  |  |  |  | 7.28 | 2012-03-06 00:00:00 |  |  | 7.34 | 2012-03-08 00:00:00 |  |  |  | 6.84
8 |  |  |  |  | 7.4 | 2012-03-14 00:00:00 |  |  | 7.44 | 2012-03-13 00:00:00 |  |  |  | 6.91
9 |  |  |  |  | 7.28 | 2012-03-14 00:00:00 |  |  | 7.4 | 2012-03-15 00:00:00 |  |  |  | 6.8
10 |  |  |  |  | 7.36 | 2012-03-15 00:00:00 |  |  | 7.43 | 2012-03-23 00:00:00 |  |  |  | 6.88
11 |  |  |  |  | 7.25 | 2012-03-23 00:00:00 |  |  | 7.43 | 2012-03-26 00:00:00 |  |  |  | 6.8
12 |  |  |  |  | 7.49 | 2012-03-27 00:00:00 |  |  | 7.65 | 2012-03-28 00:00:00 |  |  |  | 7.09
13 |  |  |  |  | 7.45 | 2012-03-29 00:00:00 |  |  | 7.51 | 2012-03-30 00:00:00 |  |  |  | 7.08
14 |  |  |  |  | 7.46 | 2012-03-30 00:00:00 |  |  | 7.94 | 2012-04-03 00:00:00 |  |  |  | 7.07
15 |  |  |  |  | 8.33 | 2012-04-03 00:00:00 |  |  | 8.89 | 2012-04-05 00:00:00 |  |  |  | 8.12
16 |  |  |  |  | 8.37 | 2012-04-10 00:00:00 |  |  | 8.52 | 2012-04-11 00:00:00 |  |  |  | 8.12
17 |  |  |  |  | 8.42 | 2012-04-17 00:00:00 |  |  | 8.57 | 2012-04-20 00:00:00 |  |  |  | 7.83
18 |  |  |  |  | 7.66 | 2012-04-19 00:00:00 |  |  | 8.2 | 2012-05-02 00:00:00 |  |  |  | 7.38
19 |  |  |  |  | 8.17 | 2012-04-30 00:00:00 |  |  | 8.42 | 2012-05-04 00:00:00 |  |  |  | 7.41
20 |  |  |  |  | 8.47 | 2012-05-09 00:00:00 |  |  | 8.58 | 2012-05-21 00:00:00 |  |  |  | 7.67
21 |  |  |  |  | 8.44 | 2012-05-18 00:00:00 |  |  | 8.52 | 2012-05-28 00:00:00 |  |  |  | 8.12
22 |  |  |  |  | 8.42 | 2012-05-23 00:00:00 |  |  | 8.48 | 2012-05-31 00:00:00 |  |  |  | 8.11
23 |  |  |  |  | 8.5 | 2012-06-04 00:00:00 |  |  | 8.65 | 2012-06-06 00:00:00 |  |  |  | 8.11
24 |  |  |  |  | 8.35 | 2012-06-11 00:00:00 |  |  | 8.61 | 2012-06-12 00:00:00 |  |  |  | 8.19
25 |  |  |  |  | 8.48 | 2012-06-18 00:00:00 |  |  | 8.71 | 2012-06-20 00:00:00 |  |  |  | 7.59
26 |  |  |  |  | 9.72 | 2012-06-22 00:00:00 |  |  | 9.83 | 2012-07-02 00:00:00 |  |  |  | 9.5
27 |  |  |  |  | 9.74 | 2012-07-02 00:00:00 |  |  | 10 | 2012-07-03 00:00:00 |  |  |  | 9.53
28 |  |  |  |  | 9.7 | 2012-07-04 00:00:00 |  |  | 9.49 | 2012-07-11 00:00:00 |  |  |  | 9.49
29 |  |  |  |  | 9.65 | 2012-07-12 00:00:00 |  |  | 9.93 | 2012-07-13 00:00:00 |  |  |  | 9.43
30 |  |  |  |  | 9.7 | 2012-07-16 00:00:00 |  |  | 9.85 | 2012-07-17 00:00:00 |  |  |  | 9.46
31 |  |  |  |  | 9.63 | 2012-07-17 00:00:00 |  |  | 9.4 | 2012-07-18 00:00:00 |  |  |  | 9.4
32 |  |  |  |  | 9.51 | 2012-07-25 00:00:00 |  |  | 9.28 | 2012-07-27 00:00:00 |  |  |  | 9.28
33 |  |  |  |  | 9.26 | 2012-07-31 00:00:00 |  |  | 8.79 | 2012-08-03 00:00:00 |  |  |  | 8.79
34 |  |  |  |  | 8.89 | 2012-08-02 00:00:00 |  |  | 8.67 | 2012-08-06 00:00:00 |  |  |  | 8.67
35 |  |  |  |  | 7.89 | 2012-08-07 00:00:00 |  |  | 7.93 | 2012-08-10 00:00:00 |  |  |  | 7.68
36 |  |  |  |  | 7.73 | 2012-08-09 00:00:00 |  |  | 7.26 | 2012-08-15 00:00:00 |  |  |  | 7.26
37 |  |  |  |  | 7.19 | 2012-08-17 00:00:00 |  |  | 7.68 | 2012-08-20 00:00:00 |  |  |  | 6.72
38 |  |  |  |  | 7.56 | 2012-08-21 00:00:00 |  |  | 7.44 | 2012-08-22 00:00:00 |  |  |  | 6.96
39 |  |  |  |  | 7.06 | 2012-08-22 00:00:00 |  |  | 7.16 | 2012-08-29 00:00:00 |  |  |  | 6.39
40 |  |  |  |  | 7 | 2012-08-27 00:00:00 |  |  | 7.07 | 2012-09-04 00:00:00 |  |  |  | 6.33
41 |  |  |  |  | 8.2 | 2012-09-10 00:00:00 |  |  | 8.5 | 2012-09-11 00:00:00 |  |  |  | 7.47
42 |  |  |  |  | 8.3 | 2012-09-12 00:00:00 |  |  | 7.55 | 2012-09-20 00:00:00 |  |  |  | 7.55
43 |  |  |  |  | 9.33 | 2012-09-18 00:00:00 |  |  | 9.56 | 2012-09-28 00:00:00 |  |  |  | 9.07
44 |  |  |  |  | 9.7 | 2012-10-02 00:00:00 |  |  | 10.2 | 2012-10-03 00:00:00 |  |  |  | 9.18
45 |  |  |  |  | 10.2 | 2012-10-09 00:00:00 |  |  | 10.24 | 2012-10-15 00:00:00 |  |  |  | 9.94
46 |  |  |  |  | 10.09 | 2012-10-18 00:00:00 |  |  | 10.05 | 2012-10-30 00:00:00 |  |  |  | 9.83
47 |  |  |  |  | 9.89 | 2012-10-23 00:00:00 |  |  | 10.03 | 2012-10-30 00:00:00 |  |  |  | 9.65
48 |  |  |  |  | 9.86 | 2012-11-06 00:00:00 |  |  | 10 | 2012-11-12 00:00:00 |  |  |  | 9.39
49 |  |  |  |  | 9.5 | 2012-11-14 00:00:00 |  |  | 9.29 | 2012-11-23 00:00:00 |  |  |  | 9.29
50 |  |  |  |  | 8.6 | 2012-11-30 00:00:00 |  |  | 8.76 | 2012-12-05 00:00:00 |  |  |  | 8.4
51 |  |  |  |  | 8.46 | 2012-12-11 00:00:00 |  |  | 8.22 | 2012-12-18 00:00:00 |  |  |  | 8.22
52 |  |  |  |  | 8 | 2012-12-26 00:00:00 |  |  | 7.76 | 2012-12-27 00:00:00 |  |  |  | 7.76
53 |  |  |  |  | 8 | 2013-01-21 00:00:00 |  |  | 7.76 | 2013-01-22 00:00:00 |  |  |  | 7.76
54 |  |  |  |  | 7.65 | 2013-01-29 00:00:00 |  |  | 7.98 | 2013-01-30 00:00:00 |  |  |  | 7.4
55 |  |  |  |  | 7.82 | 2013-02-04 00:00:00 |  |  | 8.01 | 2013-02-07 00:00:00 |  |  |  | 7.54
56 |  |  |  |  | 7.7 | 2013-02-07 00:00:00 |  |  | 7.9 | 2013-02-08 00:00:00 |  |  |  | 7.4
57 |  |  |  |  | 7.53 | 2013-02-14 00:00:00 |  |  | 7.6 | 2013-02-18 00:00:00 |  |  |  | 6.92
58 |  |  |  |  | 6.92 | 2013-02-19 00:00:00 |  |  | 7.1 | 2013-02-25 00:00:00 |  |  |  | 6.44
59 |  |  |  |  | 7.01 | 2013-02-25 00:00:00 |  |  | 7.3 | 2013-02-26 00:00:00 |  |  |  | 6.31
60 |  |  |  |  | 7.01 | 2013-02-26 00:00:00 |  |  | 7.59 | 2013-02-28 00:00:00 |  |  |  | 6.26
61 |  |  |  |  | 7.86 | 2013-03-04 00:00:00 |  |  | 7.53 | 2013-03-11 00:00:00 |  |  |  | 6.91
62 |  |  |  |  | 7.55 | 2013-03-12 00:00:00 |  |  | 8 | 2013-03-14 00:00:00 |  |  |  | 6.75
63 |  |  |  |  | 8.62 | 2013-03-20 00:00:00 |  |  | 9 | 2013-03-22 00:00:00 |  |  |  | 7.87
64 |  |  |  |  | 8.72 | 2013-03-26 00:00:00 |  |  | 8.73 | 2013-03-27 00:00:00 |  |  |  | 7.98
65 |  |  |  |  | 8.5 | 2013-04-04 00:00:00 |  |  | 8.8 | 2013-04-22 00:00:00 |  |  |  | 7.87
66 |  |  |  |  | 8.51 | 2013-04-24 00:00:00 |  |  | 8.62 | 2013-04-29 00:00:00 |  |  |  | 7.88
67 |  |  |  |  | 9.01 | 2013-05-07 00:00:00 |  |  | 9.12 | 2013-05-10 00:00:00 |  |  |  | 8.37
68 |  |  |  |  | 9.5 | 2013-06-05 00:00:00 |  |  | 9.66 | 2013-06-07 00:00:00 |  |  |  | 8.87
69 |  |  |  |  | 9.67 | 2013-06-18 00:00:00 |  |  | 9.48 | 2013-06-21 00:00:00 |  |  |  | 9.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.63
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.61
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.46
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.41
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.37
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.37
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.09
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.63
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.54