TWI
Senior member
- Messages
- 2,559
- Likes
- 269
As a rule I use a Fixed Ratio money management but I have never really felt I have had a good handle on the optimum delta value. How have others dealt with this?
What I have used for a long time is a spreadsheet that works as follows:
In column A: put consecutive numbers going down to represent the progression of increasing lots as you advance.
In B: put the starting account equity in the first cell, then calculate the different fixed ratio levels needed to reach the increasing lots in column A,[(number contracts^2 - number of contracts)/2*delta] . Best to use a blank cell somewhere to put the delta value so that you can adjust it later.
In C: put the margin cost of owning the lots in A
In D: subtract C(Margin Cost) from B (Equity)
In E: put the maximum draw-down (conservative) per lot times A(number of lots)
In F: subtract E(draw-down) from D(Equity - Margin Cost)
20 or so rows should be enough. Adjust the delta to find one that doesn't cause any number in F to turn negative. The smallest of these is the delta to use (assuming that your draw-down is reasonable).
Would be interested to hear of any insights and experience others have had over time with their money management techniques and how fixed ratio may be improved upon.
What I have used for a long time is a spreadsheet that works as follows:
In column A: put consecutive numbers going down to represent the progression of increasing lots as you advance.
In B: put the starting account equity in the first cell, then calculate the different fixed ratio levels needed to reach the increasing lots in column A,[(number contracts^2 - number of contracts)/2*delta] . Best to use a blank cell somewhere to put the delta value so that you can adjust it later.
In C: put the margin cost of owning the lots in A
In D: subtract C(Margin Cost) from B (Equity)
In E: put the maximum draw-down (conservative) per lot times A(number of lots)
In F: subtract E(draw-down) from D(Equity - Margin Cost)
20 or so rows should be enough. Adjust the delta to find one that doesn't cause any number in F to turn negative. The smallest of these is the delta to use (assuming that your draw-down is reasonable).
Would be interested to hear of any insights and experience others have had over time with their money management techniques and how fixed ratio may be improved upon.
Last edited: