BetBurger | Live and Pre-game surebets
RebelBetting - Turn betting into investing

statistical model from 0 on excel

Is this the new hack of smart gambling?
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

statistical model from 0 on excel

Mon Feb 05, 2024 7:04 pm

hi I'm creating a statistical model from 0 on excel. How long will it take to know if the statistical model works? Are 1000 bets enough?. my fear is that if the system works after a while the system no longer works.
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Mon Feb 05, 2024 8:38 pm

That depends on your edge and the prices which you are betting.
If your edge is good (5% or more) and the prices around equal, then it’s a pretty good number.

There are two ways to figure this out: if you’re familiar with statistics, then you probably know how to calculate the distribution of the average of 1000 Bernoulli variables - it is approximately Gaussian, with a mean determined by your edge, and a variance of p*(1-p) / 1000.

More generally - or if you’re suspicious of the math: you can simulate many games with your edge and prices which you bet, and see what the distribution of outcomes looks like.
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Mon Feb 05, 2024 9:18 pm

ex-hft wrote:
Mon Feb 05, 2024 8:38 pm
That depends on your edge and the prices which you are betting.
If your edge is good (5% or more) and the prices around equal, then it’s a pretty good number.

There are two ways to figure this out: if you’re familiar with statistics, then you probably know how to calculate the distribution of the average of 1000 Bernoulli variables - it is approximately Gaussian, with a mean determined by your edge, and a variance of p*(1-p) / 1000.

More generally - or if you’re suspicious of the math: you can simulate many games with your edge and prices which you bet, and see what the distribution of outcomes looks like.
I use the Asian Handicap 1X2 market only for football with 10 leagues. average odds 1.85. to calculate the odds by comparing it with the bookmakers I use a statistical % calculation and then I do a very in-depth analysis of the match based on the statistics of the historical precedents.
the % of the odds of the statistical calculation and that of the bookmakers must have at least a minimum difference of 5%. It will take me at least 1 year before I see if it really works. I hope that 1000 bets are enough to do a profit loss analysis and see if it works
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Mon Feb 05, 2024 9:33 pm

Good luck
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Wed Feb 07, 2024 6:17 pm

Is it possible that a statistical model works in one championship and doesn't in another championship?...I'm always talking about football.... I started comparing the odds with the % compared to those of the bookmakers and I'm seeing that in some championships it is more feasible and in some absolutely not
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Wed Feb 07, 2024 9:35 pm

francesco wrote:
Wed Feb 07, 2024 6:17 pm
Is it possible that a statistical model works in one championship and doesn't in another championship?...I'm always talking about football.... I started comparing the odds with the % compared to those of the bookmakers and I'm seeing that in some championships it is more feasible and in some absolutely not
Maybe, it could be.
See what happens if you look at the championships where your models performed well in the previous season. Do they also perform well this season?
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Thu Feb 08, 2024 1:53 am

ex-hft wrote:
Wed Feb 07, 2024 9:35 pm
francesco wrote:
Wed Feb 07, 2024 6:17 pm
Is it possible that a statistical model works in one championship and doesn't in another championship?...I'm always talking about football.... I started comparing the odds with the % compared to those of the bookmakers and I'm seeing that in some championships it is more feasible and in some absolutely not
Maybe, it could be.
See what happens if you look at the championships where your models performed well in the previous season. Do they also perform well this season?
I don't know how to program so it takes me time. I do everything by hand on excel. I'll update you in about 1 week. at the moment I only know how to analyze one championship. seeing some statistics on the internet based on my model that championship should have as little variance as possible. I'm comparing pinnacle sports odds!!. ah some information please. Is it advisable to take the opening or closing odds?. After how many seasons do I have to go back to see if the statistical model for that championship really works?
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Thu Feb 08, 2024 6:07 am

If you can't program, but are intelligent enough in order to build a statistical model, and serious enough to evaluate its results in depth like you do, then, I would offer that learning to program could be your best investment.
Over the course of the next six months, you will end up significantly ahead than if you keep on doing everything by hand, and the skills will stay with you for life.

Anyway - regarding number of games - the more the better. I think that it's basically impossible to build a model for a single league (=championship) and predict its behavior out of sample. You need good principles which work across many such leagues, and to win in average over them.
However - it might be possible to spot leagues which are better or worse than others for your model - for example, it only works in South America, or it only works on women's leagues, etc.

This is a pretty deep subject - balancing true and false discoveries, and not chasing results which in truth appear only due to chance.

Lastly - regarding which odds: opening odds are easier to beat, closing odds are where you can bet more money. I would try to beat the opening odds first.
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Thu Feb 08, 2024 6:42 am

ex-hft wrote:
Thu Feb 08, 2024 6:07 am
If you can't program, but are intelligent enough in order to build a statistical model, and serious enough to evaluate its results in depth like you do, then, I would offer that learning to program could be your best investment.
Over the course of the next six months, you will end up significantly ahead than if you keep on doing everything by hand, and the skills will stay with you for life.

Anyway - regarding number of games - the more the better. I think that it's basically impossible to build a model for a single league (=championship) and predict its behavior out of sample. You need good principles which work across many such leagues, and to win in average over them.
However - it might be possible to spot leagues which are better or worse than others for your model - for example, it only works in South America, or it only works on women's leagues, etc.

This is a pretty deep subject - balancing true and false discoveries, and not chasing results which in truth appear only due to chance.

Lastly - regarding which odds: opening odds are easier to beat, closing odds are where you can bet more money. I would try to beat the opening odds first.
Can you kindly explain to me why it is almost impossible to create a statistical model just for a single championship?. I noticed when creating the statistical model that if I use the same parameters in a different championship given that they have a different type of game and different variance the model does not work. at the moment it seems to work in only one league. Some days I'll show you a track record
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Thu Feb 08, 2024 11:57 am

The problem is that you don't have enough statistics.
If there is a theory that should only hold true for a specific league (for example - "In the Premier League they now add longer injury times, and therefore there will be more goals"), then you might have no choice - but still, you will not be able to tell very well.

If you have whatever random theory, and you look at a history of a few hundred games, then 10-20% of the time it will win. And then you look at ten different leagues, and say that it only "works" for one of them, when in fact - the result might be completely random.
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Thu Feb 08, 2024 1:36 pm

ex-hft wrote:
Thu Feb 08, 2024 11:57 am
The problem is that you don't have enough statistics.
If there is a theory that should only hold true for a specific league (for example - "In the Premier League they now add longer injury times, and therefore there will be more goals"), then you might have no choice - but still, you will not be able to tell very well.

If you have whatever random theory, and you look at a history of a few hundred games, then 10-20% of the time it will win. And then you look at ten different leagues, and say that it only "works" for one of them, when in fact - the result might be completely random.
so you're telling me that I have to put more championships that have more or less the same variance and type of game and from there analyze the model with the same parameters. I thought that if I analyzed only one championship at a time I could understand which championship I could make profits towards the end of each season. however in the next few weeks I will show you a track record in a single championship 2023. 2022. 2021. 2020. the model predicts only one market. I believe that by analyzing a championship for at least 4 years. in the months to come I will close in profit. then subsequently I will add championships that feature more or less the same type of game and I will try with the same statistical model to see if the numbers prove me right. thanks for everything and we'll talk to you soon
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Thu Feb 08, 2024 2:34 pm

Good luck. The test on the second championship is very important, it’s all too easy to lie to ourselves and then crash in reality.
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Sat Feb 10, 2024 4:03 am

ex-hft wrote:
Thu Feb 08, 2024 2:34 pm
Good luck. The test on the second championship is very important, it’s all too easy to lie to ourselves and then crash in reality.
I finished the story of 4 seasons in the same league maintaining a stake equal to 4% of the bankroll per bet. every year I would have closed with a paltry 18% per year >:( >:( >:( >:( >:( >:( >:( >:( ....I'm angry with myself. I would need a capital of at least 100k to make 18k a year in profit. crazy stuff!!!!!!.........
ex-hft
Has experience
Has experienceHas experience
Karma: 14
Posts: 225
Joined: Tue Jan 26, 2021 7:30 pm

Re: statistical model from 0 on excel

Sat Feb 10, 2024 5:52 am

Depending on the league and the time of betting, it’s also far from trivial that you can bet 4K at a time, even if you have the funds.
francesco
Gaining experience
Gaining experience
Karma: 1
Posts: 77
Joined: Sat Jul 02, 2022 10:15 am

Re: statistical model from 0 on excel

Sat Feb 10, 2024 6:05 am

my goal is to reach 50% annual profit. I see it very, very, very tough with sharp bookmakers, I think I'll have to continue studying my model. I have to find a way to speed up the process because not knowing how to program and always copying and pasting between site statistics and probability in the calculations would take me years to finish it. I'm trying many formulas on Excel but I always find myself copying and pasting after a couple of hours it gets really bad in my head perhaps it's a question of habit

Return to “Value betting talk”