Announcements
*** June Competition Winners: Well done to Le Male (NAPS), Coco69 (KO Cup), Saddlesore (Royal Ascot) & Like2Fish (Poker) ***
*** New Last Man Standing Competition - Win up to £1500 Annually - See Competitions Forum ***
perkon

Excel filtering soccer stats

Recommended Posts

Hello everyone!

As a stat-freak I created my own stat based system in excel sheets, which contains multiple stat datas, streaks, balances, positions, odds, ELO points, poisson calculated tips and other tips.

It's only for soccer and for national championships and for the main betting (1X2 and goals categories) categories.

Making the stats for the week-end games, it's a very time consuming thing... but after the week-end matches, I created also a results analysis in excel.

In this analysis there are more than 400 conditions / filter columns in which we will find some interesting relationships.

In this analysis after the filtering process there are hit rate % and yield %.

So the link for the sheet (previous week-end games analysis):

 

Edited by Sir Puntalot
link removed

Share this post


Link to post
Share on other sites

Ok then!

So in the name of the principle of the presumption of innocence, :) in my second post I post a screenshot about a 2 filtered situation from the previous week seeking probable draw matches.

1.filter: matches where most probable result 1-1 calculated by poisson dist.

2. Total points (ELO and form): between -50 and 50.

It was a profitable filtering process for betting the draw (53% yield).

It's just a small example and with this free excel tool there are a lot of options (according to personal choices) to filter some maybe profitable situations. I know the filtering process is just trials and errors but with this we simply controls or double-checks our premises about betting with the help of stats and datas.

Don't know why protect members from free data...

 

 

 

2filter.jpg

Share this post


Link to post
Share on other sites

Ok! Ready for the week-end with the excel stats and tips.

Unfortunately there is no option to post a link for the sheet, so I will stay with the screenshot.

If anyone interested contact me!

 

tips.jpg

Share this post


Link to post
Share on other sites

Seriously don't understand why won't allowed to share free stats and datas in this complex ways (filter by more than 400 conditons).  Personally don't just advertise any site, but don't have any chance to share my excel. (no download links, no site reference.) In this excel sheets I have a lot of working hours and want to share with the betting community for free (of course just to who interested).

Anyway Trefik, Cgmbet (paid services), and rdata allowed to advertise his sites. Smells like kind of a double standard...

How this direction helps the betting community? Or is there a rule here to use for exapmle ELO ratings, tips only from this site or something...? No offense, just curious.

Share this post


Link to post
Share on other sites
13 hours ago, perkon said:

Seriously don't understand why won't allowed to share free stats and datas in this complex ways (filter by more than 400 conditons).  Personally don't just advertise any site, but don't have any chance to share my excel. (no download links, no site reference.) In this excel sheets I have a lot of working hours and want to share with the betting community for free (of course just to who interested).

Anyway Trefik, Cgmbet (paid services), and rdata allowed to advertise his sites. Smells like kind of a double standard...

How this direction helps the betting community? Or is there a rule here to use for exapmle ELO ratings, tips only from this site or something...? No offense, just curious.

@perkon It's not as simple as that. We're responsible for everything that is promoted on Punters Lounge and the backlash that follows. Just saying you're a free site is what anyone can say, but what is your end game with it? What are you trying to achieve?

CGMbet has been a forum member for years, and the other sites are indirect mentions and heavily watched for any over the line promotion. CMGBet has earned that reputation over years and has a long standing relationship with Punters Lounge.

We'll allow you to go ahead if the majority of info is posted on the forum, and it is not about to suddenly turn subscription (this often happens). Just directing traffic to another website is not only advertising, free or not, but defeats the whole ethos of a betting community right here. ;) 

 

Share this post


Link to post
Share on other sites

Well, I fully understand your concerns about it and in global you're totally right but if you take notice of my side, I have no other option but write a download link or site reference, cause there is no another solution to display here such a big (hundreds of datas) information. I know for the greater goods we may punish the confinding members.

You alluded to my end game: Well, as I mentioned earlier I like to observe basic stats, looking for relationships to find some (maybe) profitable situations, so my final goal is to share this database to others and the possibility to everyone of searching this kind of situations with this filtering process cause there are millions of different filtering we made, and this is a very time consuming thing, mops up a lot of working hours (even though excel macro quicken the process).

Of course this sheet is developing constantly.(for nearly a year).

So far the undermentioned stats could be filtered:

ELO Points, Forms, Form Bends, Streaks, Result Odds, Ante post odds, 1X2 and goal tips by stats,Last 5 matches sequences, Team balances, League balances, Team positons, Fair odds, Poisson tips, Value%, etc.

An example: I trying to find possible draw matches with a three filtered way:

1. Set the ELO point differences down. between: -50 and 50.

2. Set the 3 most probable result by poisson at first place to 1-1.

3. Set the Home Team at Home Draw balance >30%.

After this filtering process in the weekend matches (2019.01.12.-01.14.) there are 7 games and from these games there are 5 drawn games with 136% yield. (1 0-0, and 4 1-1).

It's just a small example and I know it's a constant trials or errors, but more than nothing.

 

 

 

Share this post


Link to post
Share on other sites
1 hour ago, perkon said:

Well, I fully understand your concerns about it and in global you're totally right but if you take notice of my side, I have no other option but write a download link or site reference, cause there is no another solution to display here such a big (hundreds of datas) information. I know for the greater goods we may punish the confinding members.

You alluded to my end game: Well, as I mentioned earlier I like to observe basic stats, looking for relationships to find some (maybe) profitable situations, so my final goal is to share this database to others and the possibility to everyone of searching this kind of situations with this filtering process cause there are millions of different filtering we made, and this is a very time consuming thing, mops up a lot of working hours (even though excel macro quicken the process).

Of course this sheet is developing constantly.(for nearly a year).

So far the undermentioned stats could be filtered:

ELO Points, Forms, Form Bends, Streaks, Result Odds, Ante post odds, 1X2 and goal tips by stats,Last 5 matches sequences, Team balances, League balances, Team positons, Fair odds, Poisson tips, Value%, etc.

An example: I trying to find possible draw matches with a three filtered way:

1. Set the ELO point differences down. between: -50 and 50.

2. Set the 3 most probable result by poisson at first place to 1-1.

3. Set the Home Team at Home Draw balance >30%.

After this filtering process in the weekend matches (2019.01.12.-01.14.) there are 7 games and from these games there are 5 drawn games with 136% yield. (1 0-0, and 4 1-1).

It's just a small example and I know it's a constant trials or errors, but more than nothing.

 

 

 

@perkon Ok, you appear to be quite genuine, so you're approved. :ok 

Share this post


Link to post
Share on other sites

Very interested in your spreadsheets. I am starting a 'laying 0-0' experiment with small stakes and would love to be able to use your spreadsheet to see the probability of a game being 0-0.

Share this post


Link to post
Share on other sites

Ok! Good luck for your experiment.

I will reupload the sheets if it will be allowed to publish here.

It contains a "Notes" part, a brief summary. The databse is just contains the previous weeks' results but week after week it will be bigger.

My observation: I think the poisson distribution is fairly accurate with low scoring games where ELO ratings differences' is small between teams. (ok, the pattern is irrelevant small for now...)

 

 

Share this post


Link to post
Share on other sites

Thank you liero! Slowly two years I am constantly developing the basic table, involving many new, but basic stats and datas. 

I think for now the basic stats and structures are ready to gather from week to week.

So, sadly there are no huge historical database. But from now every weekend I create and collect the stats and the database will be bigger and bigger.

Otherwise theoretically the basic table is suited to make stats from any time from the past, if the historical results and odds are available.

 

Share this post


Link to post
Share on other sites
On 1/24/2019 at 5:40 AM, perkon said:

Thank you liero! Slowly two years I am constantly developing the basic table, involving many new, but basic stats and datas. 

I think for now the basic stats and structures are ready to gather from week to week.

So, sadly there are no huge historical database. But from now every weekend I create and collect the stats and the database will be bigger and bigger.

Otherwise theoretically the basic table is suited to make stats from any time from the past, if the historical results and odds are available.

 

Hello, Perkon!

I am also statistics fan and i am scrapping football and tennis data. If there's a way to collect historical data and check it retrospectively - i can assist with programming.

Share this post


Link to post
Share on other sites

Hi, I use cgm bet and I'm trying to export onto excel so I can filter certain criteria from historical data but I have no experience with excel can anyone point me in the right direction? Thanks

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.