No video :(

Predict the Outcome of Football Matches Using this Model

Подписаться 16 тыс.

Просмотров 172 тыс.

50% 1

You can predict the outcome of football matches using this prediction model. The model uses previous goal scoring data and a method called Poisson distribution to determine the probability of certain outcomes including the number of goals and overall result of the game. This model automatically determines the implied odds which you can use to assess if there is an opportunity for value.
This video walks you step by step through the process of creating this model, but if you find it confusing or want to save yourself time I have created and uploaded models for the Premier League, Bundesliga, La Liga, Serie A and Ligue 1 available for you to download...
👉️ My Patreon: / kiemillett
Patreon's get 1 trading video & 1 P&L breakdown video each month as well as many other perks!
► Twitter: / kiemillett
Music from Pixabay.com
Disclaimer: This video is made for informational purposes and is NOT financial advice

Опубликовано:

24 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 167

@KieMillett 2 года назад

Hi everyone! Models for the 2022/23 Premier League, Bundesliga, La Liga, Serie A and Ligue 1 seasons are available for Patreon's www.patreon.com/KieMillett

@polyzos4775 Год назад

Hello! Congrats for your videos. I would like to know, the above excel models, in which subscription they are available? Basic or advanced supporter?

@HarrysConstandinou Год назад

Soo if i be member of the 11 euro i gonna have all the leauges?

@ewanenkumberamsey1711 5 месяцев назад

How can I download it?

@domorewithsage Год назад

Good explanation, however poisson distribution tends to favour lower scores, its a known flaw in the distribution and hence why there is another distribution called zero inflated poisson.

@seanashley2835 Год назад

Sorry in advance for the long post. I did this for my Mathematics dissertation in 2016, to give the pros and cons of using this model. The model is decently accurate but it depends on many factors. First it depends on the data you use whether the information would be relevant to the current matches so that means how long back shall you go my advice 2 seasons. Next the model over and under estimates goals means that teams who scored lots in the data will continue to score loads of goals and pick up plenty of point and vica versa for low scoring teams. This means in the seasons Man City and Liverpool finished with 98-100 points would have given great return but seasons where the title was won with low 80 points would have given poor returns.

@Epistmonas 7 месяцев назад

what if insteed of this we do it with Poisson Distribution, what is your opinion on that? What you worked with Poisson Distribution?

@pedrohenriquepereiradefrei7109 5 месяцев назад

Hi, do you mind giving me the dissertation name? I'm trying to get into this subject

@adityathorat4239 Год назад

Great Video very helpful, thank you so much for sharing. You can use "=IF(ISNUMBER(SEARCH("-", cell)), LEFT(cell, SEARCH("-", cell)-1), LEFT(cell, SEARCH("+", cell)-1))" in your sheet to retain the numbers before xG, xC and xPTS and clear the rest! 😁

@twoshedsjackson6478 2 года назад

That complex formula at 13:18 is contained within Excel (I'm using LibreOffice Calc and it's in there too) it would read "=Poisson.Dist(D44, $B$44, 0)", much simpler, you might need to change the cell numbers if your sheet isn't exactly the same as the video. You can use the same format for the home goals, again, adjusting the cell references as appropriate.

@KieMillett 2 года назад

Yep! That does seem a lot more simpler than what I did here

@sirwalterheisenberg Год назад

@@KieMillett Yeah. I ended up applying Poisson Distribution to the table in this section of the video and got the same outcomes predicted. =POISSON.DIST($I7,$B$63,FALSE)*POISSON.DIST(J$6,$B$62,FALSE) I moved my table up next to the correct score table, so my cells are different, but it works for every model I made so far using your template.

@ivanomatijevic8822 2 года назад

Wow this is impressive stuff and I have been looking for this type of video for ages now and finally found it...You earned urself a new subscriber

@KieMillett 2 года назад

Thanks Ivano, glad you enjoyed it!

@tomphillips5513 10 месяцев назад

This was excellent! I just adjusted it so that it would be applicable to the NFL and now I have my very own model to assist making decisions :) Thank you for taking the time to make this video.

@temitopeayoade5924 9 месяцев назад

do you mind sharing the model?

@hypers17 Год назад

Easier functions, work with other leagues' team names: =INDEX(W3:W22;MATCH(A2;O3:O22;0)) =INDEX(AJ3:AJ22;MATCH(C2;AA3:AA22;0)) =INDEX(AI3:AI22;MATCH(C2;AA3:AA22;0)) =INDEX(X3:X22;MATCH(A2;O3:O22;0))

@LUXXY_vi 3 месяца назад

Thank you so much after searchin for an hour thats much easier than the ifs bloody statement

@peznino1 2 года назад

Poisson model - gets you a prediction - but doesn't necessarily identify value - if it only were that simple!

@keypoint1293 10 месяцев назад

It is not a model it is a calculation, a model is dynamic.

@quench100 2 года назад

=INDEX(W3:W22,MATCH(A2,O3:O22,0)) Much easier than the IFS function.

@darrenjordan2929 2 года назад

Excellent. Will definitely need to view multiple times to benefit from the info. Need to work on my excel skills for sure. Big Up Yourself!!!! Thanks

@KieMillett 2 года назад

Thanks for watching Darren, working on your Excel skills is a decision you will not regret!

@paulwilkinson5656 2 года назад

Brilliant job Kie.

@KieMillett 2 года назад

Thanks Paul, I'm glad you enjoyed!

@chunkymonkey55555 Год назад

I know how to create a macro to take out those annoying "+numbers". Use "left" function. State cell and number of digits you want. Make a column of edited numbers u want, Copy pate them (text only" into new column. You can then make a macro to do these processes for each table, I would make a lil button at the top of each. (Edit shape into a button I find easiest)

@quench100 2 года назад

Also the poisson formula is built into excel. So in cell E44 you could have typed =POISSON.DIST(D44,$B$44,0)

@qi-cd8op 8 месяцев назад

good

@fasampjg3186 2 года назад

Thank you brother for your help it really means a lot to us

@Clampers 2 года назад

Another cracking video Kie so much useful information I am going to try and setup a spreadsheet now.

@KieMillett 2 года назад

I'm glad you enjoyed it Lenny, good luck making the spreadsheet!

@gedclayson44 2 года назад

Great stuff! I already have something similar that first assesses the optimal distribution (including poisson) for a given data range. Your workbook is much more manageable and user friendly. To anyone viewing the video and reading this, a month's patreon subscription for this workbook alone would be an absolute bargain of an investment for your betting and trading.

@KieMillett 2 года назад

Thank you for the kind words Ged!

@quench100 2 года назад

Copy cell F44, then select the rest of the table and right-click, click Paste Special... then click Formulas, then OK. It saves having to repeatedly type in the formulas to multiply everything together and preserves your colourful formatting.

@user-nc4jt3vp7c Год назад

It doest work

@expatwealthasia8702 Год назад

Fair play to creating your own analysis

@Rasmus98 2 года назад

Looks great thanks for the tips! I was wondering though if you need the goals scored in the league for the ratings? Surely that just pulls down on the good teams and makes a bad team look better since the average is higher? Good video though

@handeyecoordinationskills Год назад

I predicted 3-1 celtic yesterday and 1-1 pool , it was just instinct 👍. Ill try and understand ur formula. Could u give certain matches and give us an idea if a few possible scores? Thanks

@Idkfa17 6 месяцев назад

You are Really good at this obviously. It would be Really cool to see a model for props ( all from player props to card/cornor markets) Any chance You Will do something like that in the future?

@LaSuerteesdeD10S 8 месяцев назад

Gracias por el viseo!... Saludos desde Perú!

@robtaylor8495 Год назад

I Subbed! Thanks for this, it's been good fun setting it up after never doing excel before! One question - Liverpool v Wolves tomorrow night. Based on last 5 games, Wolves are predicted to score zero goals, because Liverpool haven't conceded at home during that time. A value of zero really messes up the data in a lot of the cells - is there anyway for the sheet to cope with this?

@robijn91 Год назад

Maybe I'm doing something wrong, but at 8:08 I can't select W3. It gives a error "There's a problem with this formula."

@georgekotjipati684 2 года назад

Brilliant, I love this Mr.Millett

@KieMillett 2 года назад

Thanks George!

@manuelgroeneveld4933 2 года назад

Thanks so much! I have been trying to use my own model with lots of stats, this is way better and I can use it to compare! Took my some time to pause the video every time and try to redo it, esspecialy because I did in on Google Spreadsheets, which meant I couldnt use commas but ; in formulas which took a lot of time to find out.. Anyways, massive thanks!

@KieMillett 2 года назад

Thanks Manuel, glad it has been useful for you!

@SL0409 2 года назад

People get too bogged down with stats and place far to much emphasis on them when in reality they are pretty pointless and don't really mean anything Every football match is a 90 minute random event with multiple variables. Even the selection of a referee can alter the final outcome of a game 89th min of a game whilst at 0-0 one ref could wave play on for a foul on the edge of the box and the game ends 0-0 Another ref could see it as a foul and give the freekick on the edge of the box and they score and win 1-0 2 completely different outcomes dependant on 1 humans interpretation of a foul/no foul Chelsea hammer Southampton 0-6, the next game Southampton beat Arsenal 1-0 and then the next game Arsenal win 2-4 at Chelsea Chelsea lost to a team who lost to a team who Chelsea beat 6-0 Arsenal lost 3 in a row v Palace, Brighton and Southampton scoring 1 goal in those 3 games Their next 2 games they beat Chelsea and man utd scoring 7 in the 2 games Its all random and what the 2 team s do on the day is all that matter. Past stats have zero relevance to future events At the end of the day, results make stats, stats don't make results

@bonezville1627 2 года назад

@@SL0409 why dont u stop being a hater and give us a link to ur channel where u can show us how u go on about doing ur own predictions....this model is being trusted by serious traders and bettors for years...i personally being using this model for 5 years and there has been a lot of improvements with my bets... the model alone is not enough , u also need to know ur football as well... and yeees the guy even mentioned that all models are wrong @ the beginning of the video....the combination of ur football knowledge and the model will do u wonders, believe me..... THIS KIND OF NEGATIVITY IS NOT WHAT WE NEED!

@abiolaolalekan6215 Год назад

Hello Kie. please i want you to help me out. am been stock along the line. the formular for average home team gpg scored at home down to average home team gpg conceded at home is not working on my sheet. i have tried to do and undo it many time but no way. kindly help me out. ie B37:B40

@JoshLGGG 7 дней назад

hey man great vid. is there a way to implement draw no bet implied odds?

@leonardodavidalbitresortiz2063 Год назад

the calculator can be used for any league mike

@AfonsoLopes16 10 месяцев назад

Hello, Kie! Brilliant Video! Firstly, I will become a member just to thank the help here. Do you think that the Poisson distribution will be useful to model yellow card bets ? Thanks again for the help! Greetings from Brazil.

@meelsonweels1 2 года назад

Hi Kie, absolutely brilliant video. Mind you I couldn't understand a word of it LOL as it is way above my knowledge of excel which is next to nothing! I know you said that no model was perfect but I just wondered if you'd used this at any time and how successful it was? Cheers

@KieMillett 2 года назад

Hi, I use these models everyweek as a guide when I'm trading. I haven't gone to the depths of tracking to see how accurate they are (in all honesty I'm not stats based enough to know how to determine the accuracy of a model). Anecdotally I can say the model is good enough for a rough guide, but insufficient to be used in isolation to determine your trading decisions.

@meelsonweels1 2 года назад

@@KieMillett okay thanks very much for your reply Kie

@leekelso4106 2 года назад

Hey is there something I have missed can't seem to find where the average league goals conceded both home and away is used.

@at0micsheep 2 года назад

This only works in Excel versions newer than Excel 2016 as the IFS function doesn't exist in earlier versions of Excel

@at0micsheep 2 года назад

But you can make it work with nested IF statements should you need to get it working

@KieMillett 2 года назад

Thanks for pointing this out, I didn't know this about the IFS function

@RandomClips27. 2 года назад

Pervious data is not going to help you in anyway 2bh as you see many underdogs beat favorites all the time in all types of sports I made a ton of money that way as the odds on favorites are really low so can lay them with low liability and cash out after 1 goal with a decent profit even with a low stake as liability is low

@mattc396 Год назад

Great video, why does the table need to be in alphabetical order?

@kharmon7984 9 месяцев назад

Loved the video and became a free paetron member. However, just to clarify, in order to get the excel spreadsheets, you need to get a paid subscription, correct?

@user-ve2bw5ll7i Год назад

Have you got a model for corners? I'm guessing this could easily be transferrable?

@williamanderson4400 2 года назад

Have you looked at changing the data for second half score lines? For the start of the season how many games would you want to see before you start to use this data?

@KieMillett 2 года назад

I haven't used second half data tbf. In terms of how many games before it starts working, that really is the million dollar question. There is obviously no perfect answer, the more data you get the better of course but the older the data becomes the less relevant it is (teams changing form etc.). I tend to create multiple of the same spreadsheet and use different numbers of games for each one to give me an overall better understanding.

@at0micsheep 2 года назад

Btw. You can quickly delete the Plus and Minus symbols from the xG data @ 19:20 by using the "Text to Columns" option in the data tab

@KieMillett 2 года назад

Hi, I did try this, however as you have to do it twice (once for the '+' and once for the '-') I found that I could do it the way I did it in the video slightly faster

@saveBRITAIN-e3n 2 года назад

@@KieMillett Try the find function (ctrl+f) first select column then find and select replace '+' with nothing

@temitopeayoade5924 9 месяцев назад

Hey, please can you share the excel sheet?

@leonardodavidalbitresortiz2063 Год назад

como seria para poner formula ifs?

@michaelsviews9851 2 года назад

Bravo dude, bravo....one question, now burnley, norwich and watford have been relegated can I just replace the teams in the formula or do I need to redo the whole formula so as to keep them in alphabetical order ? Or can I just swap burnley for fulham for example despite the fact burnley are the 3rd team alphabetically and fulham aren't ?

@KieMillett 2 года назад

Hi Michaels, When I have updated my model, I found the easiest way was to redo the entire formula so that the teams appear in alphabetical order. This is slightly time consuming but I've yet to think of a more optimal way of doing it.

@My_oh_face 5 месяцев назад

you could learn how to write all these formulas for excel or you could just as easily build a time machine that lets you transport from the past back to the future...

@michalthefox1517 11 месяцев назад

Hi does anybody know the stats like footystats but for hockey? Thank you in advance.

@manelkapesrighthand6115 Год назад

Are you aware of any sites that display Leagues like understat does? I want to incorporate different leagues but need to find them organised into alphabetical order…Thanks ❤

@88adri99 Год назад

Hi Kie, thanks for the content! Since the new season is about to start, do you think the model could be useful after how much of games?

@robinmulder6857 Год назад

@bonezville1627 2 года назад

this is a good video, only that after this video you never showed how you make your picks from the model, I believe there are some who would like to see that especially those who never used the model

@malcolmwasher2308 2 года назад

I subbed

@KieMillett 2 года назад

Thank you very much Malcolm!

@ricksonmindset 2 года назад

good

@KieMillett 2 года назад

Thanks!

@clearairtrading1591 Год назад

I have put the whole formula in the "Avg home team gpg scored at home" cell and I am getting the following error. #N/A. I have double checked it and it is correctly entered. I am using an up to date Office 365. Anyone have any suggestions.

@SuperYtc1 2 месяца назад

Yeah, as if the betting companies aren't already doing this, with far more sophisticated models, lol.

@protagonistasoficial8956 2 года назад

Brother, with Index and Match you save yourself the uncomfortable yes formula, which extracts the average number of goals from you.

@KieMillett 2 года назад

I wasn't aware of this, would save me a lot of time

@jvee6057 2 года назад

@@KieMillett as an example, for the Avg Home Team gpg scored cell the formula would be =INDEX($W$3:$W$22,MATCH($A$2,$O$3:$O$22,0)) . Great video by the way!

@penissimon9815 4 месяца назад

i cant do this =ifs(a2="arsenal", it sais '' it's a problem with this form...

@ivanandresperezmedina4464 2 года назад

Tengo un problema, con la funcio IFS, cuando trato de hacer lo mismo Error

@stanrae 2 года назад

Great video. I think that your “ifs” formula can be replaced using a simple lookup formula e.g. in B37 type “=XLOOKUP(A2,O2:O21,W2:W21) but I may be wrong.

@KieMillett 2 года назад

Unfortunately, I am not the greatest with Excel. Things like this I should learn to save me time in the future 😊

@ngombakickers1969 2 года назад

What is a specific site using?

@forty4096 2 года назад

Brilliant! for those using an excel version without XLOOKUP functionality, use LOOKUP.

@BennySantana501 2 года назад

@@forty4096 VLOOKUP(A2,O3:X22,9,FALSE) definitely works. The 9 represents the 9th column of the array.

@KC.06 11 месяцев назад

Bro I was done that formula and it disappeared so then I saw this and you just saved me 2 hrs of my life

@leonardodavidalbitresortiz2063 Год назад

How would it be to put the ifs formula since my keyboard is Spanish? Could you guide me?

@fasampjg3186 2 года назад

Please can you help to know how to read match football ⚽

@onekhae7710 8 месяцев назад

I need some one from out the country to work with fro betting games and I am ready to do everything

@panapuestas5076 8 месяцев назад

We can help you get this model. Let us know if you are interested

@thomasouko720 Год назад

Can l do the stasstics with phone kindly advice or l mast have laptop to do model predictions actions.

@jeishantamang9156 Год назад

what is manual formula for average home team gpg scored at home

@nicolestrachan4964 7 месяцев назад

will there be one for 2023/2024

@georgenjenga-vz3vi Год назад

does the sum of draw home or away win have to add up to 100%

@ronwhitehouse23 2 года назад

What are the predictions in real game Is this successful?

@philwaters2396 Год назад

Definitely not

@ganesh8495 3 месяца назад

Nice ❤

@parkerryan9588 Год назад

Could you have not just done a vlookup for each team in the table, instead of having to have the super long formula clicking on each team?

@ualterreis8220 3 месяца назад

Hello, where can I get this spreadsheet?

@jamesegahi7656 Год назад

Thank you greatly. Can you get one for VFL for me?

@njoroogemorgan1913 Год назад

I KEEP ON GETTING ''IFs expects all arguments after position 0 to be in pairs'' while filling out the average away.... just like at 9;32 of the video. help?

@panapuestas5076 8 месяцев назад

Hi, were you able to get this issue resolved?

@dimitri3605 2 года назад

Bonjour comment allez-vous quel est la formule sur excel utiliser vous pour predire htft car actuellement je fait un tableau de prediction de tout les ligue Je vous remercie. Dimitri

@jaytanpedro5387 2 года назад

I did everything like you explained but excel keeps giving me errors like #NUM and #N/A. Is it because it's still early in the new season or what could it be?

@handeyecoordinationskills 2 года назад

Bottom line , do u try to predict a score before kick off ? And if so , do u put cover bets down to protect your original stake. I have no idea what this formula you talk about is all about even though I listened to the whole thing 😁

@hodanubenjamin8851 Год назад

Hi. Please can you help me, am tired of losing a game

@hcrnn7518 Год назад

Hey am not good at excel but I know R. Football data is hard to find in CSV format. Any sources you know of?

@johnramsay7408 2 года назад

Will you be doing a model for 22/23 season Kie?

@KieMillett Год назад

Available on my Patreon to download

@ErickHub_ke 2 года назад

Getting an #N/A error on : 1. Avg home team gpg scored at home =IFS(A2="Arsenal",W3,A2="Aston Villa",W4,A2="Brentford",W5,A2="Brighton",W6,A2="Burnley",W7,A2="Chelsea",W8,A2="Crystal Palace",W9,A2="Everton",W10,A2="Leeds",W11,A2="Leicester",W12,A2="Liverpool",W13,A2="Manchester City",W14,A2="Manchester United",W15,A2="Newcastle United",W16,A2="Norwich",W17,A2="Southampton",W18,A2="Tottenham",W19,A2="Watford",W20,A2="West Ham",W21,A2="Wolveshampton Wanderers",W22) 2. Avg away team conceded per game away =IFS(C2="Arsenal",AJ3,C2="Aston Villa",AJ4,C2="Brentford",AJ5,C2="Brighton",AJ6,C2="Burnley",AJ7,C2="Chelsea",AJ8,C2="Crystal Palace",AJ9,C2="Everton",AJ10,C2="Leeds",AJ11,C2="Leicester",AJ12,C2="Liverpool",AJ13,C2="Manchester City",AJ14,C2="Manchester United",AJ15,C2="Newcastle United",AJ16,C2="Norwich",AJ17,C2="Southampton",AJ18,C2="Tottenham",AJ19,C2="Watford",AJ20,C2="West Ham",AJ21,C2="Wolveshampton Wanderers",AJ22) please help.

@KieMillett 2 года назад

Hi Erick, I've had a quick look at your calculation, one thing I did see is that you have put "Wolveshampton" instead of "Wolverhampton". The syntax of the equation looks correct to me, without seeing your spreadsheet I can't confirm if there are any other errors in terms of cell references Kie

@ErickHub_ke 2 года назад

@@KieMillett Thank you much. I corrected and Its working perfectly. 🤜

@majklx2776 Год назад

hey bro, sucha a níce video. You have source code on your Patreon ?

@martinesr7198 2 месяца назад

I doubt your model really...when you dont know what is best period lengt from past to use then you dont know what model works.period length from past is key

@emmanuelawotwe4063 2 года назад

Please i couldn't find the models on your site to download, can you assist me in doing that

@Cyanrhapman 10 месяцев назад

What do the implied odds mean? Any help would be appreciated

@KC.06 3 месяца назад

The implied odds are like the odds you would see on a betting website they are the match odds

@fehmikonkur20 2 года назад

Merhaba ben Türkiye den öncelikle başarılar dilerim güzel bir algoritma ile hazırlanmış bir dosya olduğunu her halinden belli peki bu dosyayı bende kullanmak istesem nasıl temin edebilirim şimdiden teşekürler

@johnlartey1238 Год назад

Please post odds

@jamesegahi7656 Год назад

The link is not working. I tried to follow you to make my excel model but the explanation is too fast.

@KieMillett Год назад

The link is working fine for me. You can slow the video down through RU-vid and rewind where necessary.

@dansmallz6434 Год назад

great video Kie, thanks! I set up a predictor for all leagues from understat. Are there other websites that cover other leagues? All the UK leagues would be great....anyone know? Also, I have a fast way to remove the XG + and - numbers. highlight the columns, ctrl+H (find and replace) in the find box write -* and leave the replace box blank. then press replace all. change to +* and replace all. job done. :) I'm creating a football betting community and I'm looking for football fans who are good at predicting and enjoy betting on football. Let me know if you are interested. :) Keep up the good work, best of luck with your bets.

@mashudumashamba7321 9 месяцев назад

You got discord?

@temitopeayoade5924 9 месяцев назад

can you please share the excel sheet again?

@panapuestas5076 8 месяцев назад

If you are still in need for this model we can share it with you

@fuonli 2 года назад

Replace your IFS formulas with a Vlookup

@KieMillett 2 года назад

I'm not familiar with V Look up, this is something I must check out at some point

@sakuragi8269 Год назад

CAN YOU DO NBA PROBABILITY USING THIS MODEL?🙂🙂

@KieMillett Год назад

NBA is something that I have never looked at.

@sakuragi8269 Год назад

@@KieMillett I experimented using this method but I couldn't get it 😆 . Can you do the NBA probability?❤️

@sirmburu7805 Год назад

Where is the excel bro?

@agyekumkenneth3466 10 месяцев назад

It gave me error at the ifs function

@panapuestas5076 8 месяцев назад

Hi, were you able to get this resolved?

@taytavideoproduction 7 месяцев назад

wow it is grat

@marcelonovo4649 Год назад

You said we can download it, but I can't find the free spreadsheet. Why is it 15$ per month? How many people have you scam with this trick?

@KieMillett Год назад

I said you can download it if you support me on Patreon. If you don't want to support that is absolutely fine, however you will then after follow the tutorial in the video.

@bigloudnb6038 2 года назад

Fantastic video - thanks for the super clear explanation! For this 2022-23 season do you think it would be useful to also incorporate last season's EPL data, and if so, how to incorporate it in the model? Thanks again !!

@KieMillett Год назад

Generally speaking I wouldn't advice using data from the previous season.

@austinweinhauer6879 8 месяцев назад

Bro just use a vlookup

@flow7309 2 года назад

Can someone download this worksheet for me please

@KieMillett 2 года назад

Spreadsheet is available on my Patreon, obviously not everyone can afford to support the channel or would want to. This is why I gave step by step instructions on how to make this spreadsheet yourself in the video!