Here's a list of numbers representing cumulative profit of a system (last number = most recent). The position size used to generate this list was a fixed $ amount.

How can Excel be used to determine the optimal position size for the next trade you're thinking of taking? Assume a working capital of 10k.

178.92

1292.04 (big win)

1125.27

1026.14

1187.62

1366.51

1205.78

1368.08

874.41 (big draw down)

1146.2

1578.25

2143.83

1766.16

I'm thinking of a formula something like this:

In cell B3 I have: =if(A2>A1,A3*1.5,0.5*A3) and dragged this down.

Now, not sure of my next move.

## Bookmarks