- Limits before you bet: money, time and number of bets per day, written down while you are calm.
- Traffic light and 24 hours: when you pass a cap or lose several in a row, you stop for a day.
- Ask for help if you need it: the spreadsheet does not replace a professional or your country's helpline.
Bookmark this guide and come back when your spreadsheet is open, so you can follow the steps from where you left off.
Your progress is saved in this browser.
Why set limits before you bet?
You set limits while you are calm.
Not after you lost and want to win it back.
That is the whole point of this guide.
Betting can be entertainment.
But it can also get out of control without you noticing.
A spreadsheet with limits gives you an objective signal when that starts to happen.
We are not going to tell you to bet less or to quit.
We give you a tool so you can decide with a cool head.
The decision is always yours.
This guide is for information only and for adults 18 and over.
The numbers are examples with made-up data.
If gambling worries you, look for professional help and your country's official helpline.
Which limits to set: money, time and frequency
There are three types of limit.
Each one protects something different.
| Type of limit | What it protects | Example |
|---|---|---|
| Money | Your finances | Maximum 40 per month (example) |
| Time | Your hours and your sleep | Maximum 30 minutes per day |
| Frequency | Your impulses | Maximum 3 bets per day |
| Loss | Your mood | If you lose 3 in a row, take a 24-hour break |
| Cooling off | Your judgment | At least 10 minutes between looking and betting |
The money limit comes first.
Use only money you can lose without touching your basic expenses.
Never use money meant for rent, food, debts or savings.
How to choose the money number
There is no universal figure.
A simple way is to start from your free money for the month.
That is what is left after you pay for everything important.
Then you pick a small slice of that.
For example, 10% of that free money.
If your free money is 400 (example), the monthly limit would be 40.
That calculation is only a starting point.
If 40 feels like a lot, set 20.
There is no prize for reaching the maximum.
The limits spreadsheet: a simple model with formulas
The limits spreadsheet has two parts.
A table of caps and a tracking table.
Filling them in takes less than five minutes a week.
| Cap (example) | Value | Status |
|---|---|---|
| Free money for the month | 400 | input |
| Monthly limit (10%) | 40 | cap |
| Weekly limit (25% of monthly) | 10 | cap |
| Maximum time per day | 30 min | cap |
| Maximum bets per day | 3 | cap |
Now the tracking.
You log what you spend and compare it with the cap.
The formula tells you which color you are in.
| Week (example) | Spent | % of cap | Color |
|---|---|---|---|
| Week 1 | 4 | 40% | GREEN |
| Week 2 | 8 | 80% | YELLOW |
| Week 3 | 11 | 110% | RED |
| Week 4 | 0 | 0% | GREEN (break) |
Week 3 went over the weekly cap of 10.
The spreadsheet shows red.
That is the moment to stop, not to "make up for it" the following week.
The formulas, written out as text
We use English-language Excel, with a comma as the separator.
If your Excel is in Spanish, IF is called SI, AND is called Y, SUM is called SUMA and the separator is a semicolon.
| Data | Formula | What it does |
|---|---|---|
| Spent (week) | =SUM(B2:B8) | Adds up what was spent in the week |
| % of cap | =B10/Caps!B3 | Spent divided by the weekly cap |
| Color | =IF(C10<0.8,"GREEN",IF(C10<=1,"YELLOW","RED")) | Under 80%: green. Up to 100%: yellow. More: red |
| Streak of 3 losses | =IF(AND(E5="L",E4="L",E3="L"),"BREAK","") | Warns you if your last three bets were losses |
With week 3 of the example, 11 divided by 10 gives 1.10, or 110%.
Since it is above 1, the formula returns RED.
With week 2, 8 divided by 10 gives 0.8, which lands in YELLOW.
Behavior traffic light: green, yellow and red
Besides the money, look at your behavior.
The behavior traffic light is a list of yes-or-no questions.
You count how many "yes" answers you have.
| Color | How many "yes" | What you do |
|---|---|---|
| GREEN | 0 to 1 | Carry on with your plan |
| YELLOW | 2 to 3 | Take a 24-hour break and review your limits |
| RED | 4 or more | Stop betting for a few days and talk to someone you trust |
These are the questions.
Answer them in writing, once a week.
- Did I bet more money than I had decided?
- Did I raise my stake after losing to win it back?
- Did I bet without analysis, just on impulse or out of boredom?
- Did I bet to change my mood?
- Did I hide or play down what I bet from someone?
- Did I use money that was meant for something else?
Each "yes" is a clue, not a verdict.
We all have worse weeks.
What matters is seeing it in time.
Warning signs: what to look for in your own behavior
There are three classic signs.
If you see them, it is time to stop.
- Chasing losses: betting more, or faster, to win back what you lost.
- Raising the stake: betting ever larger amounts to feel the same thrill.
- Betting without analysis: picking any match just to have some action.
There are other signs.
Thinking about betting all day, lying about what you bet, or feeling irritable when you cannot do it.
It is not a diagnosis: it is a clue to look at yourself honestly.
If you want to understand why this happens, read the guide on the psychology of the bettor.
It explains biases such as the gambler's fallacy and loss aversion.
The 24-hour rule
It is the simplest rule and the most effective.
When you lose or get angry, you do not bet for 24 hours.
Period.
The rule works because it separates emotion from decision.
An impulse that lasts 10 minutes usually loses strength within 24 hours.
Self-exclusion and sportsbook tools
Many licensed sportsbooks offer control tools.
They include deposit limits, time limits, breaks and self-exclusion.
Look for them in the responsible gambling section of the operator you use.
| Tool | What it does | When it helps |
|---|---|---|
| Deposit limit | Caps the money you add | To avoid going over for the month |
| Time limit | Alerts you or ends the session | For long sessions |
| Break | Blocks your account for days or weeks | After a bad run |
| Self-exclusion | Blocks your account for a long period | If you feel you have lost control |
Ideally you activate a deposit limit at the sportsbook and also write it in your spreadsheet.
That way you have two barriers, not one.
If your country has an official self-exclusion register, check with the local regulator.
A contract with myself: a template to copy
A contract with yourself is not legal, it is personal.
Writing it down and signing it makes it feel more real.
Copy this model and adjust it.
I, [NAME], commit for [MONTH]: 1) Not to bet more than [AMOUNT] in total and more than [WEEKLY AMOUNT] per week. 2) Not to bet more than [N] times per day or for more than [MINUTES] minutes. 3) To wait 24 hours if I lose [N] bets in a row. 4) Not to raise my stake to win back losses. 5) To log every bet before I place it. 6) To talk to [TRUSTED PERSON] if I break two rules. Signature: ______ Date: ______
Hang it near where you bet.
Review it on the first day of every month.
If you broke a rule, do not punish yourself: adjust and move on.
When to look for professional help
Spreadsheets help, but they do not replace a professional.
If gambling is causing problems with your money, your relationships or your mood, ask for help.
It is not a weakness, it is a brave decision.
- Talk to a psychologist or a mental health professional.
- Look for your country's official helpline for problem gambling.
- Tell someone you trust what is going on.
- Activate self-exclusion at the sportsbooks where you play.
We do not share phone numbers or specific sites because they change from country to country.
Look for your country's public service by searching "problem gambling help" plus your country's name.
If you are in crisis, call your local emergency services.
What to read next
If you do not have a log yet, start with the Excel template to track your bets.
It has the stake traffic light that goes with this spreadsheet.
To decide how much to set aside, use the bankroll calculator.
And to understand the size of each bet, read fixed vs variable stake.
The background guide is betting responsibly.
And the overview of the topic is in AI for betting: the complete guide.
Calculate your bankroll before you bet
Frequently asked questions
What limits should I set for betting?
Three basic ones: money (per week and per month), time (minutes per day) and frequency (bets per day).
Write them down before you bet and do not change them in the middle of a bad run.
The money should only be what you can lose without affecting your living costs.
What is the 24-hour rule?
It means not betting for 24 hours after you lose or when you feel angry.
It separates emotion from decision.
After that time, you reread your limit and decide with a cool head.
What are the warning signs of problem gambling?
Chasing losses, raising your stake more and more, and betting without analysis.
Also hiding what you bet or using money that was meant for something else.
They are not a diagnosis, but they are a reason to stop and take a look at yourself.
What is self-exclusion?
It means asking a sportsbook to block your account for a period of time.
Many licensed operators offer it in their responsible gambling section.
Check whether your country also has an official register.
Is a spreadsheet enough to control gambling?
It helps you see it, but it does not replace a professional.
If gambling affects you financially or emotionally, look for professional help.
You can also look up your country's official helpline.
Can I keep betting if the spreadsheet shows red?
The signal is to stop, not to continue.
Take a break of at least 24 hours and review your limits.
If the red keeps repeating, talk to someone you trust or to a professional.