Fixed Ratio Example

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 10

Jones - p.

83

This spreadsheet reproduces and extends a table on p. 83 of the Ryan Jones book. The only
purpose of this is to confirm the spreadsheet formulas against this table from the Jones book.

Current Required account


position size Delta balance
1 $5,000 $10,000
2 $5,000 $15,000
3 $5,000 $25,000
4 $5,000 $40,000
5 $5,000 $60,000
6 $5,000 $85,000
7 $5,000 $115,000
8 $5,000 $150,000
9 $5,000 $190,000
10 $5,000 $235,000
11 $5,000 $285,000
12 $5,000 $340,000
13 $5,000 $400,000
14 $5,000 $465,000
15 $5,000 $535,000
16 $5,000 $610,000
17 $5,000 $690,000
18 $5,000 $775,000
19 $5,000 $865,000
20 $5,000 $960,000
21 $5,000 $1,060,000
22 $5,000 $1,165,000
23 $5,000 $1,275,000
24 $5,000 $1,390,000
25 $5,000 $1,510,000
26 $5,000 $1,635,000
27 $5,000 $1,765,000
28 $5,000 $1,900,000
29 $5,000 $2,040,000
30 $5,000 $2,185,000
31 $5,000 $2,335,000
32 $5,000 $2,490,000
33 $5,000 $2,650,000
34 $5,000 $2,815,000
35 $5,000 $2,985,000
36 $5,000 $3,160,000
37 $5,000 $3,340,000
38 $5,000 $3,525,000
39 $5,000 $3,715,000

Page 1
Jones - p. 83

40 $5,000 $3,910,000
41 $5,000 $4,110,000
42 $5,000 $4,315,000
43 $5,000 $4,525,000
44 $5,000 $4,740,000
45 $5,000 $4,960,000
46 $5,000 $5,185,000
47 $5,000 $5,415,000
48 $5,000 $5,650,000
49 $5,000 $5,890,000
50 $5,000 $6,135,000
51 $5,000 $6,385,000
52 $5,000 $6,640,000
53 $5,000 $6,900,000
54 $5,000 $7,165,000
55 $5,000 $7,435,000
56 $5,000 $7,710,000
57 $5,000 $7,990,000
58 $5,000 $8,275,000
59 $5,000 $8,565,000
60 $5,000 $8,860,000
61 $5,000 $9,160,000
62 $5,000 $9,465,000
63 $5,000 $9,775,000
64 $5,000 $10,090,000
65 $5,000 $10,410,000
66 $5,000 $10,735,000
67 $5,000 $11,065,000
68 $5,000 $11,400,000
69 $5,000 $11,740,000
70 $5,000 $12,085,000
71 $5,000 $12,435,000
72 $5,000 $12,790,000
73 $5,000 $13,150,000
74 $5,000 $13,515,000
75 $5,000 $13,885,000
76 $5,000 $14,260,000
77 $5,000 $14,640,000
78 $5,000 $15,025,000
79 $5,000 $15,415,000
80 $5,000 $15,810,000
81 $5,000 $16,210,000
82 $5,000 $16,615,000
83 $5,000 $17,025,000

Page 2
Jones - p. 83

84 $5,000 $17,440,000
85 $5,000 $17,860,000
86 $5,000 $18,285,000
87 $5,000 $18,715,000
88 $5,000 $19,150,000
89 $5,000 $19,590,000
90 $5,000 $20,035,000
91 $5,000 $20,485,000
92 $5,000 $20,940,000
93 $5,000 $21,400,000
94 $5,000 $21,865,000
95 $5,000 $22,335,000
96 $5,000 $22,810,000
97 $5,000 $23,290,000
98 $5,000 $23,775,000
99 $5,000 $24,265,000
100 $5,000 $24,760,000
101 $5,000

Page 3
$30K Account, $10K Delta

This is the main spreadsheet. These are the numbers shown on the web page.

Initial $30K account, Delta = $10K


% of account
Current Required % of account risked on $1,500
position account for adding 1 risk per contract
size Delta balance more contract trade Comments:
1 $10,000 $30,000 5.00%
2 $10,000 $40,000 33.33% 7.50% peak 7.50% risk at transition to 2 contracts
3 $10,000 $60,000 50.00% 7.50%
4 $10,000 $90,000 50.00% 6.67%
5 $10,000 $130,000 44.44% 5.77%
6 $10,000 $180,000 38.46% 5.00% risking 5.00% when account is $180K
7 $10,000 $240,000 33.33% 4.38%
8 $10,000 $310,000 29.17% 3.87%
9 $10,000 $390,000 25.81% 3.46%
10 $10,000 $480,000 23.08% 3.13% risking 3.13% when account is $480K
11 $10,000 $580,000 20.83% 2.84%
12 $10,000 $690,000 18.97% 2.61%
13 $10,000 $810,000 17.39% 2.41%
14 $10,000 $940,000 16.05% 2.23%
15 $10,000 $1,080,000 14.89% 2.08% risking 2.08% when account moves above $1M
16 $10,000 $1,230,000 13.89% 1.95%
17 $10,000 $1,390,000 13.01% 1.83% From $1M to $50M risk continues to decline.
18 $10,000 $1,560,000 12.23% 1.73% Suggestion: Switch to 2% fixed fractional when
19 $10,000 $1,740,000 11.54% 1.64% initial $30K account reaches $1M.
20 $10,000 $1,930,000 10.92% 1.55%
21 $10,000 $2,130,000 10.36% 1.48%
22 $10,000 $2,340,000 9.86% 1.41%
23 $10,000 $2,560,000 9.40% 1.35%
24 $10,000 $2,790,000 8.98% 1.29%
25 $10,000 $3,030,000 8.60% 1.24%
26 $10,000 $3,280,000 8.25% 1.19%
27 $10,000 $3,540,000 7.93% 1.14%
28 $10,000 $3,810,000 7.63% 1.10%
29 $10,000 $4,090,000 7.35% 1.06%
30 $10,000 $4,380,000 7.09% 1.03%
31 $10,000 $4,680,000 6.85% 0.99%
32 $10,000 $4,990,000 6.62% 0.96%
33 $10,000 $5,310,000 6.41% 0.93%
34 $10,000 $5,640,000 6.21% 0.90%
35 $10,000 $5,980,000 6.03% 0.88%
36 $10,000 $6,330,000 5.85% 0.85%
37 $10,000 $6,690,000 5.69% 0.83%

Page 4
$30K Account, $10K Delta

38 $10,000 $7,060,000 5.53% 0.81%


39 $10,000 $7,440,000 5.38% 0.79%
40 $10,000 $7,830,000 5.24% 0.77%
41 $10,000 $8,230,000 5.11% 0.75%
42 $10,000 $8,640,000 4.98% 0.73%
43 $10,000 $9,060,000 4.86% 0.71%
44 $10,000 $9,490,000 4.75% 0.70%
45 $10,000 $9,930,000 4.64% 0.68%
46 $10,000 $10,380,000 4.53% 0.66%
47 $10,000 $10,840,000 4.43% 0.65%
48 $10,000 $11,310,000 4.34% 0.64%
49 $10,000 $11,790,000 4.24% 0.62%
50 $10,000 $12,280,000 4.16% 0.61%
51 $10,000 $12,780,000 4.07% 0.60%
52 $10,000 $13,290,000 3.99% 0.59%
53 $10,000 $13,810,000 3.91% 0.58%
54 $10,000 $14,340,000 3.84% 0.56%
55 $10,000 $14,880,000 3.77% 0.55%
56 $10,000 $15,430,000 3.70% 0.54%
57 $10,000 $15,990,000 3.63% 0.53%
58 $10,000 $16,560,000 3.56% 0.53%
59 $10,000 $17,140,000 3.50% 0.52%
60 $10,000 $17,730,000 3.44% 0.51%
61 $10,000 $18,330,000 3.38% 0.50%
62 $10,000 $18,940,000 3.33% 0.49%
63 $10,000 $19,560,000 3.27% 0.48%
64 $10,000 $20,190,000 3.22% 0.48%
65 $10,000 $20,830,000 3.17% 0.47%
66 $10,000 $21,480,000 3.12% 0.46%
67 $10,000 $22,140,000 3.07% 0.45%
68 $10,000 $22,810,000 3.03% 0.45%
69 $10,000 $23,490,000 2.98% 0.44%
70 $10,000 $24,180,000 2.94% 0.43%
71 $10,000 $24,880,000 2.89% 0.43%
72 $10,000 $25,590,000 2.85% 0.42%
73 $10,000 $26,310,000 2.81% 0.42%
74 $10,000 $27,040,000 2.77% 0.41%
75 $10,000 $27,780,000 2.74% 0.40%
76 $10,000 $28,530,000 2.70% 0.40%
77 $10,000 $29,290,000 2.66% 0.39%
78 $10,000 $30,060,000 2.63% 0.39%
79 $10,000 $30,840,000 2.59% 0.38%
80 $10,000 $31,630,000 2.56% 0.38%
81 $10,000 $32,430,000 2.53% 0.37%

Page 5
$30K Account, $10K Delta

82 $10,000 $33,240,000 2.50% 0.37%


83 $10,000 $34,060,000 2.47% 0.37%
84 $10,000 $34,890,000 2.44% 0.36%
85 $10,000 $35,730,000 2.41% 0.36%
86 $10,000 $36,580,000 2.38% 0.35%
87 $10,000 $37,440,000 2.35% 0.35%
88 $10,000 $38,310,000 2.32% 0.34%
89 $10,000 $39,190,000 2.30% 0.34%
90 $10,000 $40,080,000 2.27% 0.34%
91 $10,000 $40,980,000 2.25% 0.33%
92 $10,000 $41,890,000 2.22% 0.33%
93 $10,000 $42,810,000 2.20% 0.33%
94 $10,000 $43,740,000 2.17% 0.32%
95 $10,000 $44,680,000 2.15% 0.32%
96 $10,000 $45,630,000 2.13% 0.32%
97 $10,000 $46,590,000 2.10% 0.31%
98 $10,000 $47,560,000 2.08% 0.31%
99 $10,000 $48,540,000 2.06% 0.31%
100 $10,000 $49,530,000 2.04% 0.30%
101 $10,000 $50,530,000

Page 6
$30K Account, $10K Delta

ansition to 2 contracts

account is $180K

account is $480K

account moves above $1M

sk continues to decline.
o 2% fixed fractional when
eaches $1M.

Page 7
$30K Account, $30K Delta

The goal of this spreadsheet to limit peak risk to 5%.


This requires a Delta of $30K, which causes growth to be slower than 5% fixed fractional, but it still
has an advantage over 5% fixed fractional if the desire is to reduce risk as the account increases.

However, the 5% max risk numbers play out better by increasing starting account
size (see the $45K Account, $15K Delta worksheet).

Initial $30K Account, Delta = $30K


% of account
risked on
Current Required % of account $1,500 risk
position account for adding 1 per contract
size Delta balance more contract trade Comments:
1 $30,000 $30,000 5.00%
2 $30,000 $60,000 100.00% 5.00% peak 5% risk
3 $30,000 $120,000 100.00% 3.75%
4 $30,000 $210,000 75.00% 2.86%
5 $30,000 $330,000 57.14% 2.27% hits 2% risk around 400K
6 $30,000 $480,000 45.45% 1.88%
7 $30,000 $660,000 37.50% 1.59%
8 $30,000 $870,000 31.82% 1.38%
9 $30,000 $1,110,000 27.59% 1.22%
10 $30,000 $1,380,000 24.32% 1.09%
11 $30,000 $1,680,000 21.74% 0.98%
12 $30,000 $2,010,000 19.64% 0.90%
13 $30,000 $2,370,000 17.91% 0.82%
14 $30,000 $2,760,000 16.46% 0.76%
15 $30,000 $3,180,000 15.22% 0.71%
16 $30,000 $3,630,000 14.15% 0.66%
17 $30,000 $4,110,000 13.22% 0.62%
18 $30,000 $4,620,000 12.41% 0.58%
19 $30,000 $5,160,000 11.69% 0.55%
20 $30,000 $5,730,000 11.05% 0.52%

Page 8
$30K Account, $30K Delta

onal, but it still


nt increases.

Page 9
$45K Account, $15K Delta

The goal of this spreadsheet to limit peak risk to 5%.


Increasing the initial account to $45K helps considerably versus the $30K account
with $30K Delta.

Initial $45K account, Delta = $15K


% of account
risked on
Current Required % of account $1,500 risk
position account for adding 1 per contract
size Delta balance more contract trade Comments:
1 $15,000 $45,000 3.33%

2 $15,000 $60,000 33.33% 5.00% peak 5% risk


3 $15,000 $90,000 50.00% 5.00%
4 $15,000 $135,000 50.00% 4.44%
5 $15,000 $195,000 44.44% 3.85%
6 $15,000 $270,000 38.46% 3.33%
7 $15,000 $360,000 33.33% 2.92%
8 $15,000 $465,000 29.17% 2.58%
9 $15,000 $585,000 25.81% 2.31%
10 $15,000 $720,000 23.08% 2.08% hits 2% risk around $800K
11 $15,000 $870,000 20.83% 1.90%
12 $15,000 $1,035,000 18.97% 1.74%
13 $15,000 $1,215,000 17.39% 1.60%
14 $15,000 $1,410,000 16.05% 1.49%
15 $15,000 $1,620,000 14.89% 1.39%
16 $15,000 $1,845,000 13.89% 1.30%
17 $15,000 $2,085,000 13.01% 1.22%
18 $15,000 $2,340,000 12.23% 1.15%
19 $15,000 $2,610,000 11.54% 1.09%
20 $15,000 $2,895,000 10.92% 1.04%

Page 10

You might also like