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

 | Estrategia
 | Dias
 | Capital Inicial | 10000
 | 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.12
 | 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 |  | 9.33 | 2012-01-10 00:00:00 |  |  | 9.56 | 2012-01-13 00:00:00 |  |  |  | 9.07
2 | SAPR4 |  |  |  | 9.7 | 2012-01-24 00:00:00 |  |  | 10.2 | 2012-01-31 00:00:00 |  |  |  | 9.18
3 | SAPR4 |  |  |  | 10.2 | 2012-02-07 00:00:00 |  |  | 10.24 | 2012-02-14 00:00:00 |  |  |  | 9.94
4 | SAPR4 |  |  |  | 10.09 | 2012-02-15 00:00:00 |  |  | 10.05 | 2012-02-29 00:00:00 |  |  |  | 9.83
5 | SAPR4 |  |  |  | 9.89 | 2012-03-01 00:00:00 |  |  | 10.03 | 2012-03-05 00:00:00 |  |  |  | 9.65
6 | SAPR4 |  |  |  | 9.86 | 2012-03-06 00:00:00 |  |  | 10 | 2012-03-08 00:00:00 |  |  |  | 9.39
7 | SAPR4 |  |  |  | 9.5 | 2012-03-14 00:00:00 |  |  | 9.29 | 2012-03-13 00:00:00 |  |  |  | 9.29
8 | SAPR4 |  |  |  | 8.6 | 2012-03-15 00:00:00 |  |  | 8.76 | 2012-03-23 00:00:00 |  |  |  | 8.4
9 | SAPR4 |  |  |  | 8.46 | 2012-03-27 00:00:00 |  |  | 8.22 | 2012-03-28 00:00:00 |  |  |  | 8.22
10 | SAPR4 |  |  |  | 8 | 2012-03-29 00:00:00 |  |  | 7.76 | 2012-03-30 00:00:00 |  |  |  | 7.76
11 | SAPR4 |  |  |  | 8 | 2012-03-30 00:00:00 |  |  | 7.76 | 2012-04-03 00:00:00 |  |  |  | 7.76
12 | SAPR4 |  |  |  | 7.65 | 2012-04-03 00:00:00 |  |  | 7.98 | 2012-04-05 00:00:00 |  |  |  | 7.4
13 | SAPR4 |  |  |  | 7.82 | 2012-04-10 00:00:00 |  |  | 8.01 | 2012-04-11 00:00:00 |  |  |  | 7.54
14 | SAPR4 |  |  |  | 7.7 | 2012-04-17 00:00:00 |  |  | 7.9 | 2012-04-20 00:00:00 |  |  |  | 7.4
15 | SAPR4 |  |  |  | 7.53 | 2012-04-30 00:00:00 |  |  | 7.6 | 2012-05-04 00:00:00 |  |  |  | 6.92
16 | SAPR4 |  |  |  | 6.92 | 2012-05-18 00:00:00 |  |  | 7.1 | 2012-05-28 00:00:00 |  |  |  | 6.44
17 | SAPR4 |  |  |  | 7.01 | 2012-06-04 00:00:00 |  |  | 7.3 | 2012-06-06 00:00:00 |  |  |  | 6.31
18 | SAPR4 |  |  |  | 7.01 | 2012-06-11 00:00:00 |  |  | 7.59 | 2012-06-12 00:00:00 |  |  |  | 6.26
19 | SAPR4 |  |  |  | 7.86 | 2012-06-22 00:00:00 |  |  | 7.53 | 2012-07-02 00:00:00 |  |  |  | 6.91
20 | SAPR4 |  |  |  | 7.55 | 2012-07-17 00:00:00 |  |  | 8 | 2012-07-18 00:00:00 |  |  |  | 6.75
21 | SAPR4 |  |  |  | 8.62 | 2012-08-02 00:00:00 |  |  | 9 | 2012-08-03 00:00:00 |  |  |  | 7.87
22 | SAPR4 |  |  |  | 8.72 | 2012-08-07 00:00:00 |  |  | 8.73 | 2012-08-15 00:00:00 |  |  |  | 7.98
23 | SAPR4 |  |  |  | 8.5 | 2012-08-17 00:00:00 |  |  | 8.8 | 2012-08-20 00:00:00 |  |  |  | 7.87
24 | SAPR4 |  |  |  | 8.51 | 2012-08-22 00:00:00 |  |  | 8.62 | 2012-08-29 00:00:00 |  |  |  | 7.88
25 | SAPR4 |  |  |  | 9.01 | 2012-09-18 00:00:00 |  |  | 9.12 | 2012-09-20 00:00:00 |  |  |  | 8.37
26 | SAPR4 |  |  |  | 9.5 | 2012-10-02 00:00:00 |  |  | 9.66 | 2012-10-03 00:00:00 |  |  |  | 8.87
27 | SAPR4 |  |  |  | 9.67 | 2012-10-18 00:00:00 |  |  | 9.48 | 2012-10-30 00:00:00 |  |  |  | 9.1
28 | SAPR4 |  |  |  | 9.13 | 2012-11-01 00:00:00 |  |  | 9.08 | 2012-11-12 00:00:00 |  |  |  | 8.67
29 | SAPR4 |  |  |  | 9.08 | 2012-11-19 00:00:00 |  |  | 9.2 | 2012-11-22 00:00:00 |  |  |  | 8.63
30 | SAPR4 |  |  |  | 9.54 | 2012-12-13 00:00:00 |  |  | 9.63 | 2012-12-14 00:00:00 |  |  |  | 9.1
31 | SAPR4 |  |  |  | 9.97 | 2013-01-04 00:00:00 |  |  | 9.61 | 2013-01-09 00:00:00 |  |  |  | 9.61
32 | SAPR4 |  |  |  | 9.5 | 2013-01-09 00:00:00 |  |  | 9.9 | 2013-01-11 00:00:00 |  |  |  | 9.18
33 | SAPR4 |  |  |  | 9.51 | 2013-01-15 00:00:00 |  |  | 9.69 | 2013-01-16 00:00:00 |  |  |  | 9.2
34 | SAPR4 |  |  |  | 9.82 | 2013-01-28 00:00:00 |  |  | 10.07 | 2013-01-31 00:00:00 |  |  |  | 9.46
35 | SAPR4 |  |  |  | 9.95 | 2013-02-20 00:00:00 |  |  | 10.06 | 2013-02-21 00:00:00 |  |  |  | 9.41
36 | SAPR4 |  |  |  | 9.91 | 2013-02-22 00:00:00 |  |  | 9.9 | 2013-03-11 00:00:00 |  |  |  | 9.37
37 | SAPR4 |  |  |  | 10 | 2013-03-20 00:00:00 |  |  | 10.01 | 2013-03-28 00:00:00 |  |  |  | 9.6
38 | SAPR4 |  |  |  | 9.7 | 2013-04-02 00:00:00 |  |  | 9.9 | 2013-04-04 00:00:00 |  |  |  | 9.37
39 | SAPR4 |  |  |  | 9.9 | 2013-04-11 00:00:00 |  |  | 9.56 | 2013-04-22 00:00:00 |  |  |  | 9.56
40 | SAPR4 |  |  |  | 9.45 | 2013-04-22 00:00:00 |  |  | 9.69 | 2013-04-24 00:00:00 |  |  |  | 9.09
41 | SAPR4 |  |  |  | 9.82 | 2013-05-08 00:00:00 |  |  | 9.99 | 2013-05-13 00:00:00 |  |  |  | 9.4
42 | SAPR4 |  |  |  | 11.15 | 2013-06-11 00:00:00 |  |  | 11.47 | 2013-06-17 00:00:00 |  |  |  | 10.63
43 | SAPR4 |  |  |  | 11.15 | 2013-06-19 00:00:00 |  |  | 10.54 | 2013-06-25 00:00:00 |  |  |  | 10.54