Why is the Backtesting the best statistics tool on the market? [Tutorial 5]
We are creating a unique statistics tool here, no doubt about that. I have written about the Spreadsheet, the Backtesting and Notifications system separately before.
As these things go hand in hand and are heavily related to each other, I took a few days to write what I have noticed about these fantastic options we are offering in this statistics tool named Statistic Sports. I have talked with a lot of users and tried to help as much of you as possible. In this article I'm going to address some of the most common issues and questions.
Let's start from the beginning!
Can this statistics tool be profitable?
Yes, it can, and I have examples for this and can prove it! The first and most common mistake is unrealistic results. The 2nd big mistake is looking at the wrong numbers.
As I'm also active in tipsters market and have seen a lot of great results, I have also seen a lot of unrealistic expectations. Lets set this straight, profits of 20%, 35% or even 45% Yields in the long term, month in, month out are not realistic expectations. You could hit them maybe in 1 month if some luck included or excellent models using our statistics tool, 2 or 3 months per year.
To have over 20% EVERY single month is just pushing it too far, in my opinion of course. You can make a big mistake by chasing these numbers while modifying your properly good notifications.
People are excluding leagues from the notifications too early with not enough big sample size. Yes, the first 3 tips lost in Bangladeshi 2nd league, but maybe the next 5 will win, and you miss them now due to excluding the league too early?
The power of compound
Think about it. Set up realistic targets! A fully automated model producing 10-15% PER MONTH is already a very very good and realistic model. The more you can push the model, the better, of course.
I'll show you the power of compound interest and use the first example as an unrealistic interest rate. Let's take the starting bank as 2000 euros and rate 30% per month. After the first month, your bankroll would be 2600. Throw this 2600 in another monthly cycle, and you would have 3380 already. This 3380 with another 30% profit per month would mean 4394 after the third month, and after a year you would be sitting on 46596.
Call me a pessimist if you want, but with these calculations, my 2k starting bank would be over a million in 2 years.
Keep in mind, that Yield and ROI are not the same effectively as interest rate, but with this example, I can show the power of the compound. Everything over 10% in bookies are already super results, everything over 5% in Asia is also good results already.
Let's change the 30% to 7% and the year would finish with 4500, with an effective annual rate of 125%. You would more than double the bankroll adding 7% per month for one year.
How to start?
I suggest starting from the big sample size. I'm going to show some of the examples while using my own notifications. I have been testing the tool a lot, with backtesting and collecting the data manually into the spreadsheet.
During the backtesting using our statistics tool, I have got some good results in terms of Yield. I'm talking something around 15% easily, and at first, the impression is like wow. Then I'm checking the number of bets, and this brings back down to earth.
An example size of around 150 bets during the year is too small, in my opinion. Keep in mind that we are not talking about pro tipsters following only some certain leagues, using his methods like team news or following the games closely. We are talking about raw data betting, and for this, I would prefer a much bigger sample size.
So my first suggestion is to go for sample size, at least this has helped me out a lot. I use one of my favourite notifications as an example of the process for me. This is not a Backtesting notification, but a notification which I create exactly a year ago and started collecting the data in. The results were very good already, but the amount of 2500 tips means around 208 shots per month which means there's plenty of room for some trimming for my taste.
Statistics tool Spreadsheet options
There are a lot of different options to start working on your model in our football statistics tool. I suggest to try them all out with every model and database. In this current situation for this particular notification, I could exclude some options already. This model is created on betting the UNDER goal line and on the main goal line.
This model is created on betting the UNDER goal line and on the main goal line. At first, I tried if I can cut some games with ODDS. The odds range in the Spreadsheet were between 1.3 to 2.3. I adjusted the odds minimum to 1.8, and I managed to cut exactly 4 games. Not getting much help from this, so no point to adjust the odds range in the notification modification also.
Not getting much help from this, so no point to adjust the odds range in the notification modification also. The second set I tried was SUBMARKET. Around 90% of the alerts were all between lines 1 to 2.5, and there I was in good profit. So, no point to play with the Submarket sorting also and same for the current score/goals range as the model is built to alert from 0-0 score.
The fastest and most significant cut in the number of alerts were obviously from the Countries and Leagues blocks.
Excluding Countries and Leagues
As you could guess, I axed Bahrain, Brazil, Bolivia, Denmark and England from this screenshot. I removed some more countries, but the reasonings are different. Brazil and England are the perfect examples of how to cut the excess amount of alerts. 115 bets and I'm down 10 units. In Brazil, I'm down 4 stakes, but can cut 50 extra bets with dead Yield. Denmark and Bolivia can remove another 50 bets, and I still have big enough database and amount of alerts to be happy.
Very often, I cut also green Countries—for example, a country with 85 bets and profit of 2 stakes. Could go either way with next 3-4 bets and missing some profits, but my current intention, in this case, is to cut excess fat.
Very often, I cut also green Countries—for example, a country with 85 bets and profit of 2 stakes. Could go either way with next 3-4 bets and missing some profits, but my current intention, in this case, is to cut excess fat. In general, I start the excluding process from the Leagues, because there could be 2-3 leagues in very high minus and 3-4 leagues with a decent profit, but the red ones exceed the profit.
A good example of this notification is Ireland. - 400 with 23 bets, but the - 483 came from 1 league only with 4 bets! Removing this 1 league instead of a whole country leaves me with 500 in green.
In total, I removed 14 countries, have now 2020 bets with 23977 profits and a 12% Yield with 100 stakes. This makes it around 168 bets per month and time to check out the Leagues statistics.
I usually check the leagues and countries in the opposite direction, leagues first and then countries. Why I made an exception in this notification? It's because I needed to cut a lot of games to be happy with the number of tips.
Leagues should be more like for fine-tuning. With this notification, I took a stance to remove some leagues which are not in good timezone for me. Also, some leagues where I know it can be hard to get on due to my bookies.
In two lower leagues in Wales, I had 20 bets with 500 in minus; two low Taiwan leagues another minus 600 in 14 games. Three leagues from Estonia, another 70 bets and minus 950. Total I removed around 35 leagues. As mentioned, some of them were dark red and some of them were in bad leagues for me. The results? Totally against what I said earlier about expected Yield.
I managed to trim this notification down to 1687 bets and a whopping 19% Yield. That's profits of 31490 in 1 year. Around 140 bets per month, but need to keep one thing in mind now.
During the Covid downtime, we had of course much fewer bets, and already in June and July, this notification had 199 and 362 bets per month. So far in September, 278 bets and still three days to go.
It's down to personal preference, but as I have around 7-8 notifications running as a background, I rather prefer around 150 bets with this notification and much less with others, which are much more strict and will give out fewer bets.
Keep in mind
I know I mentioned about the realistic Yield at the start of this article. Now I'm showing notification with 19% Yield, how come? I have been testing and collecting data for this notification for over a year. I knew this is above anything else and wanted to show the exception. There is always a chance to punch above, but behind this is a lot of work and time working with this statistics tool.
I also suggest splitting your notification by months. With this, you can see the expected workload for the model created in the statistics tool.
In September 2019, I had fewer bets because of leagues at that time. December and January are always more quiet months as we know.
During the springtime...well, enough said, we all know the reason for fewer alerts. June and July were great in terms of profits and Yield, but also in the number of bets.
A lot of news leagues started, and some leagues restarted during the summertime. This means that there were also more games than usual during this time.
Now it's a decisions time, either to cut some more leagues or wait a little to see how many alerts there are in the next month.
Statistics Sports statistics tool offers now something very unique.
The question, can it be profitable?
Yes, it can.
But, it needs some time and dedication. Don't try to push it too far. I'll show some other results in next blog where the results are more close to 'normal'. The most important is to have a big enough database created to start working.
Don't cut the leagues and countries too early. Start excluding from the leagues and countries which are anyway hard to bet for you. Use all the filters available you, as the minimum odds change from 1.4 to 1.7 can make wonders in the model already.
Don't forget to check the Submarkets, don't forget to check the goal ranges and game clock. Every small change can affect the results positively.
You may also like
- Tipsters and tipping sites
- Arbitrage and betting tools
- Transfer news
- Football in general
- Betting in general
- International Football Tournaments