NEED HELP WITH SPREADSHEET WITH BETTING AMOUNT PER UNIT...ANYBODY with SUGGESTIONS???

Question

I want to bet 3% (60.00) of my bankroll (2,000.00) per unit. If I win or lose, my unit size should increase or decrease. Example shown below:

Starting Bankroll ~ 2,000.00 Total 0.00 unit

1 bet ~ 1u 60.00 WIN 60.00
2 bet ~ 1u 60.00 LOSE (66.00)
3 bet ~ 1u 60.00 LOSE (66.00)
4 bet ~ 1u 60.00 LOSE (66.00)
Total ~ -2.3 unit lost for -138.00 (for the day)

Ending Bankroll ~ 1,862.00 Total -2.3 unit

So my next betting unit will be 55.86 (3% of 1862.00)

But now when I multiply my betting amount to my total unit size (55.86 x -2.3u = -128.48), it does not equal what I have lost which is suppose to be -138.00. Eventhough it is a small difference, in the long run, the discrepancy will be far apart. Can somebody tell me what I am doing wrong. I want to be able to see if I am up or down to the exact amount with my unit total to lose/win total. Any suggestions is greatly appreciated. Thanks.

lokes08 · Answer

I want to bet 3% (60.00) of my bankroll (2,000.00) per unit. If I win or lose, my unit size should increase or decrease. Example shown below:

Starting Bankroll ~ 2,000.00 Total 0.00 unit

1 bet ~ 1u 60.00 WIN 60.00
2 bet ~ 1u 60.00 LOSE (66.00)
3 bet ~ 1u 60.00 LOSE (66.00)
4 bet ~ 1u 60.00 LOSE (66.00)
Total ~ -2.3 unit lost for -138.00 (for the day)

Ending Bankroll ~ 1,862.00 Total -2.3 unit

So my next betting unit will be 55.86 (3% of 1862.00)

But now when I multiply my betting amount to my total unit size (55.86 x -2.3u = -128.48), it does not equal what I have lost which is suppose to be -138.00. Eventhough it is a small difference, in the long run, the discrepancy will be far apart. Can somebody tell me what I am doing wrong. I want to be able to see if I am up or down to the exact amount with my unit total to lose/win total. Any suggestions is greatly appreciated. Thanks.

JackBauer · Answer

lokes08 - good question, my advice would be that you should only resize your base risk amount when your total bankroll increases or decreases by a certain percentage.&#xD;&#xA; &#xD;&#xA;i.e. with a $2,000 bankroll, you would stick to your $60 unit to risk until your bankroll increases to $2500, or decreases to $1500 (a 25% increase)&#xD;&#xA; &#xD;&#xA;What you are doing wrong is confusing your base risk amount, which is $66, not $60 or 3.3%....that is why your numbers are not adding up.....

JackBauer · Answer

[Quote: Originally Posted by JackBauer] &#xD;&#xA; &#xD;&#xA;i.e. with a $2,000 bankroll, you would stick to your $60 unit to risk until your bankroll increases to $2500, or decreases to $1500 (a 25% increase)&#xD;&#xA; &#xD;&#xA;[/Quote]&#xD;&#xA;should say 25% change

lokes08 · Answer

Jack,But the fact is I lost 60 plus juice. That has to reflect in my bankroll. I can&#x27;t say I lost 18.00 when I lost 198.00. Where would I keep tabs on the -18.00 juice I lost. This is only for a line of -1.10. What happens when I lay heavier chalk?? I want to maximize but hot streaks by upping my unit amount and minimizing when I&#x27;m cold...still haven&#x27;t figured it out...Thanks for the input.

lokes08 · Answer

I can&#x27;t say I lost 18.00 when I lost 198.00.That should say 180.00 when I lost 198.00.

JackBauer · Answer

Check out my post in this section.... If you risk the same on every play, you won&#x27;t run into this problem.&#xD;&#xA; &#xD;&#xA;For example: Boston -150 (you risk $60 to win $39.96) If you are laying heavier chalk and not risking the same amount, you are not betting 3% of your bankroll. You will be betting a higher percentage, thus the deviation.&#xD;&#xA; &#xD;&#xA;Your base unit needs to be the total amount risked for your math to work as you have laid it out.

lokes08 · Answer

Jack,After reading your post and using your example in my spreadsheet, it all totals up to the exact amount. Thank you for the pointer. It&#x27;s greatly appreciated.

JackBauer · Answer

no problem lokes gl to you

NEED HELP WITH SPREADSHEET WITH BETTING AMOUNT PER UNIT...ANYBODY with SUGGESTIONS???

Hot Forum Topics