EASIEST Model to PREDICT Football Matches With ELO | Excel Beginner Tutorial

  Рет қаралды 31,691

Excel LADZ

Excel LADZ

Күн бұрын

Пікірлер: 181
@2357y1113
@2357y1113 4 ай бұрын
Thank you for the excel tutorial. But did you have any success actually betting with these predictions? Can you share some experience? How many games did you need to make a more or less consistent net gain?
@victorbongos9269
@victorbongos9269 Ай бұрын
Your Excel skills are top-notch. Tell me, how can I update the matches on the excel on a regularly basis without interfering with the data in the table?
@ChristianRavnkildeAndersen
@ChristianRavnkildeAndersen 10 ай бұрын
Great video and model. I'm trying to re-build it, but is having a small issue with the games drop down on the Dashboard. When I select the drop down I only get the first game for each date. The drop down says (e.g. Jan 13): "Rækkemærkater" (Danish equal to Row Labels) "Alcorcon vs Mirandes" When I see the Games sheet everything looks fine. All games from coloumn A copied into column B. Do you have any idea what the problem can be?
@excel_ladz
@excel_ladz 10 ай бұрын
Hi lad, thanks for watching 🔥 My first suggestion would be to ensure that the copied timeline in 10:10 of the video updates the 'games' range when you change the date. You can just switch back and forth between the 'Dashboard' and 'Games' worksheet to doublecheck this 👍 My second suggestion would be that when you select the 'list' in Data Validation, make sure the boxes 'Ignore blank' and 'In-cell drop-down' are both selected. This can be seen at 10:40 of the video. If none of these work lad, it may be due to your version of Excel not supporting dynamic ranges or arrays. It's odd though that Column B of the 'Games' worksheet works yet your Dashboard worksheet dropdown list is not. Let me know if that helps lad 😃
@twokeys2671
@twokeys2671 Жыл бұрын
Thank you so much, I won using your technique in data analysis which is the first time I ever won a football bet. Again thank you. I just have one question on how to update the data from the API given. I tried to copy paste but it isn't reflected on the pivot table even after refreshing it
@excel_ladz
@excel_ladz Жыл бұрын
I'm glad you won lad 💪 I would try and keep re-doing the process, trying to 'Refresh All' (found in the Data tab) as soon as the data is copy and pasted into the spreadsheet. Make sure you update the slicer 👍 I hope that helps lad, let me know if you have any other issues 🔥
@twokeys2671
@twokeys2671 Жыл бұрын
@@excel_ladz It helped a lot thank you.
@metteh.j.4836
@metteh.j.4836 11 ай бұрын
Great 🤓video! Even learned a few new tricks on the way and have a new reference point of fast formula writing. And just love the way DATA is pronouced in your part of the world (I'm Danish). Absolutely going to check out your other content.
@jorisaboughe9631
@jorisaboughe9631 Жыл бұрын
Can you create the program with HT/FT and correct score please ??
@AlissonCruz92
@AlissonCruz92 Жыл бұрын
Mr. Lad! That's amazing video! You help us a lot with your teachings. I'd like to ask about API. Do you know where can I find any API similar to ClubElo to put more championship? (for example: J League, MLS, Australia, Brazil). Thank you!
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, thanks for the comment 🔥 As of right now, unfortunately I don't know a reliable website where you can find ELO ratings for leagues outside of Europe 😢 I'll be sure to post it in the community tab of the channel when I find one of similar quality to the ClubElo ratings 👍
@nadthawadeau-arunyachot1371
@nadthawadeau-arunyachot1371 Жыл бұрын
Pls recommend best market ie. over under, win the game and example compare market. Thank you
@excel_ladz
@excel_ladz Жыл бұрын
For sure lad, this is coming soon. Make sure you’re subscribed 💪
@-Tharos-
@-Tharos- Жыл бұрын
Brilliant idea Mr. Lad! Video already saved in my favorites! :) Once I skimmed through that club ELO API but I didn't pay much attention to it. I'm glad you got this great idea. Thanks! Idea for you (if feasible): Dixon-Coles implementation of Poisson Distribution. Basically the two gentlemen added a parameter to the two independent Poisson Distributions of a matchup with the objective of creating a kind of dependence between the two Poissons and correct the low score probabilities (1-0, 0-0, 0-1). The challenge is calculating that parameter. I've seen it done in code (R or Python) but maybe it is not feasible in Excel... Cheers
@excel_ladz
@excel_ladz Жыл бұрын
I'm glad you liked the video lad! Your comment is very interesting. I have read about certain limitations of the Poisson distribution surrounding the low scores, so I'll definitely do some research surrounding the Dixon-Coles implementation. However, this will most likely take some time, so unfortunately it may not be a video in the short term.
@seychelles44
@seychelles44 Жыл бұрын
That’s wicked. Well done. I’m not sure if I missed it, but can this be made so it’s automated by dragging in the latest stats?
@excel_ladz
@excel_ladz Жыл бұрын
Thanks for watching lad 🔥. To update the mode for the upcoming games, simply copy and paste in the new raw stats from the website (the text to columns part only takes a couple of seconds). Then, go into the Data tab and hit Refresh All or Refresh Data. If you do these two very quick steps (takes under 30 seconds), then the model will update for that new day 💪 If this helped lad, make sure you’re subscribed 👍
@seychelles44
@seychelles44 Жыл бұрын
@@excel_ladz oh I am subscribed lol 😂
@seychelles44
@seychelles44 Жыл бұрын
@@excel_ladzm having issues.. I can’t workout a few things. For some reason I keep getting 0 for team names on the dashboard. And I have 0% on the heat map. I’m now at a point where I’m stuck. Can you just add a link under the videos to where we can just download the sheets? Cheers, and I must say; this is the first ever KZbinr I’ve seen where you don’t need to even ask for subscribers. When I try to save the worksheet, my laptop says some data maybe lost if I save as a CSV file. What shall I do? When I updated the sheet, it seems to only put data in the left hand side of the sheet in A1 only. And back to original format. I think it would be easier if you have a link to download the sheet from. Sorry if I’m being an absolute T@@T.
@excel_ladz
@excel_ladz Жыл бұрын
@@seychelles44 Don't apologise lad! It's my job to answer questions from loyal subscribers 👍 1. If you're getting a 0 for the Team Names in the Dashboard then there's a couple things that could be wrong. Firstly, check that you have access to the XLOOKUP function. Only recent versions of Excel have it. If you don't, change the function to VLOOKUP and adjust accordingly. Secondly, you may simply have just entered the XLOOKUP formula wrong. However, if the XLOOKUP formula (12:00) is correct, that means your Team ID's column has not been formatted like mine. This means the XLOOKUP is searching for the wrong range to return. 2. If you're getting 0% for the heat map, then it's more than likely it's the same issue here. Check if you have XLOOKUP, and then check if your data is formatted EXACTLY like mine in the video. 3. I'd save this file as a regular Excel worksheet. When you update the sheet, do what I do at 1:25 and go to the Text to Columns Wizard. I hope this all helps lad 💪When I become monetised on KZbin, I'm looking to start a membership where I can build up this Excel LADZ community some more. Through this, the link to all Excel LADZ models will be available 👍 Thanks again for being a subscriber 🔥
@seychelles44
@seychelles44 Жыл бұрын
@@excel_ladz nice one. I’ll check it out and see how it goes in a few days when I get more time. I’ll also look into other ways to find a system that works well with this. Cheers
@bigbadbobthefish
@bigbadbobthefish Жыл бұрын
This is good - is the data on Club Elo actual data rather than expected? One thing I’ve noticed is that the win % it gives can be very different to Poisson for example
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, I myself have found that the Poisson method is much more accurate than the data this model imports. The ELO data is based on scorelines, and gives no bearing to who was playing in matches and the importance of a match to each club... This means, a Poisson model, factoring player strength in each match, is a much more predicative method 👍 Very soon lad I'll be releasing a video on how to build this model on Excel 💪 Thank you for watching lad!
@bigbadbobthefish
@bigbadbobthefish Жыл бұрын
@@excel_ladz yes agreed - it would be good if you could alter the future model to exploit the other markets which aren’t as liquid and are more exploitable, like win to nil, for example. The 1x2 markets are notoriously tough to beat as the bookies have these models dialled in. I personally have been having more success with bet builders and goalscorer markets. The goalscorer market you can reverse engineer the market odds to give some success.
@spurs87
@spurs87 Жыл бұрын
Greetings, Excel LADZ. I absolutely love these videos. Fantastic work! I am trying to model a league of my own (purely as a hobby). May I ask if you offer one-to-one Excel tutorials on a commercial basis at all? Thank you.
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, thanks for the support 🔥. You can reach out to me on Twitter. My handle is @excel_ladz
@spurs87
@spurs87 Жыл бұрын
@@excel_ladz Hey, Lad. Thank you very much for getting back to me, I appreciate it.
@bonezbooth1845
@bonezbooth1845 Жыл бұрын
u will be doing a video on automating the sheets soon so for now do I have to do the whole process over again for the new fixtures?
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, because this is a very simple model I haven’t included the process of a power query. If you’re able to, a power query would update the stats automatically for you. 👍
@bonezbooth1845
@bonezbooth1845 Жыл бұрын
@@excel_ladz Got it right, now updating takes about a minute using power query....Thanks a lot Lad
@matus6021
@matus6021 6 ай бұрын
@@bonezbooth1845can you send me yours sheet please 🙏
@Sgsnippets
@Sgsnippets Жыл бұрын
Hi Lad Great stuff, how could we add a what if scenario based analysis ?
@Sgsnippets
@Sgsnippets Жыл бұрын
Or lad how can we get this model to suggest an over/unders game?
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, I’m really glad you enjoyed the video. The what-if analysis function is not really relevant in this video as the win percentages are already calculated for each team. When I use what-if analysis, it’s for a Monte Carlo simulation where I can simulate scenarios on a large scale. Then from there, the probability of each outcome makes itself apparent, e.g. Arsenal beats Man United 3450 out of every 10000 simulations, therefore Arsenal have a 34.50% chance of winning. I use this method when I do not already know the probability distribution for a game. I hope this helps lad.
@bobnicholson6350
@bobnicholson6350 Жыл бұрын
Hello Lad; great video...easy to follow...by the by got brand new computer (wife) alas the NBA model STILL didn 't work? unbelievable!!!
@excel_ladz
@excel_ladz Жыл бұрын
That's a shame. If I remember correctly, you were having a problem with the Pts Sim? I've got two new methods for you to try and solve your problem lad. Firstly, can I confirm you are using an English version of Excel? There was one subscriber who's issue with the formula was immediately fixed, because he was using the French version of Office, and so the BINOM.INV formula was written differently. Secondly, try breaking up the formula into parts. To simulate the 2 pointers, enter in: 2*BINOM.INV(BINOM.INV(F12,G12,RAND()),H12,RAND()) If this simulation works and changes every time you update the cells, then move onto the 3 pointers and Free Throws until the formula for Pts Sim. is complete. I hope this helps you lad, let me know how it goes.
@bobnicholson6350
@bobnicholson6350 Жыл бұрын
@@excel_ladz yes US English
@bobnicholson6350
@bobnicholson6350 Жыл бұрын
Morning: =if (d13>0,iferror(2*binom.inv(binom.inv(f13,g13,Rand()),h13,Rand()) is this correct...my data is on row 13
@excel_ladz
@excel_ladz Жыл бұрын
@@bobnicholson6350 Try entering this: =2*BINOM.INV(BINOM.INV(F13,G13,RAND()),H13,RAND()) for Row 13. This should spill out the simulated points for only 2-point shots for that player in Row 13.
@bobnicholson6350
@bobnicholson6350 Жыл бұрын
@@excel_ladz Tried that but got #num! error...pasted numbers in different cells as Values and got same result.#NUM!...What to do??!!
@danieljackson5497
@danieljackson5497 Жыл бұрын
Hello Lad. Any chance you know anything about VBA code/macros and make downloading the data automatic? so we don't need to copy and paste the data every other day or whatever it is? This would be legendary.
@excel_ladz
@excel_ladz Жыл бұрын
G'day lad, thanks for watching! I usually use a power query on Excel to import data that updates automatically (so I don't need to copy and paste the data every day). An example of this is my NBA video where I import live stats to predict games. The reason I didn't do it for this particular video was because it was mainly geared at beginners who, without prior experience, would find obtaining the live date tedious and difficult. However, future videos on Football ELO Models will definitely feature live data lad 👍
@danieljackson5497
@danieljackson5497 Жыл бұрын
@@excel_ladz cant wait for that!
@DJTJHokie
@DJTJHokie Жыл бұрын
Any chance you can do Major League Baseball with that season starting up soon?
@excel_ladz
@excel_ladz Жыл бұрын
Yes lad, that'll be a priority heading into March. 👍
@NVCardMaster
@NVCardMaster Жыл бұрын
Hey! Any chance you can do NHL playoffs? Love the videos 👌🏻
@excel_ladz
@excel_ladz Жыл бұрын
Thank you for watching lad 🔥 I’ll try and release a video predicting this season’s playoffs using a basic model. If unfortunately I’m unable to release this due to it being too late to publish, I’ll definitely release a video walking my subscribers through how to predict NHL games/seasons/playoffs using Excel in the short term 💪
@iainmoran2495
@iainmoran2495 Жыл бұрын
Thanks Lad, great video, as usual. Would be even better if we could update the data automatically. That would make a brilliant part two :)
@excel_ladz
@excel_ladz Жыл бұрын
Thanks lad, I appreciate the support. Usually I would definitely use a power query to import the data, which would update automatically in Excel. However, this video was more geared towards beginners, and at first the power query skill is a bit tedious and difficult to complete. Future Football ELO models will absolutely include a power query and automatically updated data lad, stay tuned 👍
@manuelantoniodanca9351
@manuelantoniodanca9351 Жыл бұрын
What do you think about Google sheets
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, in my opinion Excel is much more powerful, however Google Sheets can provide Google users a very easy introduction to spreadsheets.
@ganesh8495
@ganesh8495 6 ай бұрын
Nice video for football since 2017❤
@collinsombagi115
@collinsombagi115 Жыл бұрын
Hi lad, thanks for this impactful video, however I'm stuck where in the pivot table when I put in = games, it only shows one game not all of them and also on the dashboard my formulae bring errors. Kindly enlighten, what I'm I doing wrong
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, thanks for watching 🔥 You may not be doing anything wrong... Unfortunately later versions of Excel (e.g. Excel 2016 and later) don't recognise the XLOOKUP function. Is the #name error appearing on your dashboard? The solution for this would be to replace all the XLOOKUP functions in the formulas with a VLOOKUP function. I hope that helps lad 💪
@hybridinc1035
@hybridinc1035 Жыл бұрын
Good job... pls drop the NBA model with injuries and day's rest included 🙏
@excel_ladz
@excel_ladz Жыл бұрын
Of course lad, I’ll work hard so that the video can be uploaded within the next 7 days👍
@Testopyry
@Testopyry 3 ай бұрын
Thanks for the video, Im little slow so it took me ages to finally make this, but now im wondering, when we get new upcoming games, how do i add them to this existing model? I tested with adding the same games again to the rawdata and made new pivottable with the new ones included but the new ones i added wont show there? do you know what i mean, I would appreciate it if you can help me.
@fxgumpp
@fxgumpp 6 ай бұрын
I think every 2 day repeat process again? for updated data?
@sister_janet
@sister_janet Жыл бұрын
Hello, I have been using this model. How can I update the new fixtures to automatically generate the dashboard predictions
@excel_ladz
@excel_ladz Жыл бұрын
G’day, thanks for watching! You can update the fixtures by deleting the old matches, and replacing them with a new copy and paste from the Club ELO Ratings Website (like we did at the start of the video). From there, use text to columns to clean up the data (again, exactly like the video). Then, click the Refresh All button to refresh all worksheets, and the model should update automatically 🔥
@CharisP
@CharisP Жыл бұрын
Amazing as always. Kudos lad
@tonyvela923
@tonyvela923 Жыл бұрын
any tips on how to make an elo rating system for NFL games, now that the season is about to start?
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, I would firstly find the most reliable site. There would be a million different ways to compile ELO Ratings, so use the most well established ELO website for the NFL. The formula to compile the win percentage based off of the ELO Ratings will differ with each system… While I don’t recommend you get the actual ratings from Wikipedia, it’s good for searching for mathematical formulas to transform the ratings into win probability. ELO Ratings only deal with win/loss scenarios. As a result, any expected goals calculations as well as draw probabilities cannot reliably be calculated. I know all this is probably common sense, but I hope it helps a bit lad 🤞
@MarkWilson-bx9gg
@MarkWilson-bx9gg 9 ай бұрын
I'm using excel 2016 can't get this to work. Does that sound right? I know I don't have xlookup function
@excel_ladz
@excel_ladz 9 ай бұрын
All you'll have to do is swap the XLOOKUP function with VLOOKUP 👍
@MarkWilson-bx9gg
@MarkWilson-bx9gg 9 ай бұрын
Will try that tomorrow. I couldn't get the list of games to appear when you typed =games around 9 minutes into video. It only shows one match when I do it. Not a list
@boldbuzz
@boldbuzz Жыл бұрын
Please when will you upload the video for Over or Under Basketball total points Prediction?
@daxter224
@daxter224 Жыл бұрын
Have you/Can you do a backtest video to see the effectiveness of the model suggestions?
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, unfortunately with the way the data is pulled, there’s no concrete way to backtest the model’s suggestions. However, you could keep a running ‘success rate’ of the model and track its success. Of this was helpful lad, please subscribe!
@jocke78
@jocke78 Жыл бұрын
Hello, great video but I can’t get this to work, when I copy it it doesn’t look like it does in the video, it turns up directly into excel and it won’t transform it to % either, I really don’t know what’s wrong here,
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, I’ll try and give you a couple broad suggestions in the hope it’ll fix it for you. Wit regards to the percentages, you have to convert them yourself by selecting all the relevant cells, and then clicking on the percentage icon in the home tab. Once all your data is in, go to the Data tab and select ‘Refresh All’. This will make sure your pivot table updates, and you can then use the slicer to file yet games by date. If you’re using an old version of Excel (one that doesn’t support XLOOKUP), you’ll have to write the formulas with VLOOKUP functions 👍 I hope that helps lad
@jorisaboughe9631
@jorisaboughe9631 Жыл бұрын
Please Can you help me in the sheet dashboard the last calcul what does it mean ??
@excel_ladz
@excel_ladz Жыл бұрын
G'day lad, I'm just using an XLOOKUP function to pull in the data values for each scoreline. If the stats we imported say that a 0-0 draw has a 0.121 likelihood, then I'm just grabbing that and plugging it into the dashboard to make it easy to read and understand 👍
@Hoobel
@Hoobel Жыл бұрын
How do I add other leagues. I got 15 following your video but they were all Spanish. Thanks
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, the website has data for all Major Leagues including the EPL, Serie A, Ligue 1, Bundesliga, La Liga and many more competitions. I would try the model on another day, such as before the next EPL competition weekend, to see those games come up. If this helped lad, make sure you subscribe for more 🔥 Follow me on Twitter @excel_ladz 💪
@playalexandros3068
@playalexandros3068 Жыл бұрын
Hi Which version of excel are you using? There is a problem with the formulas =IF(ISTEXT(C2)=TRUE, C2&" vs "&D2,"'") =IF(SUM(L2:Q2)=0,"",SUM(L2:Q2))
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, I’m using Excel with a Microsoft 365 subscription (the latest version). The ISTEXT function is available on all Excel versions dating back until 2000, so I assume your version can support it 🔥 Just make sure that your ranges are correct lad, and make note of the specific error your formula is returning (e.g. a #NAME? error) which could help you solve your problem 💪
@JeanBedros
@JeanBedros 25 күн бұрын
hello there save as type which option ?? cause i save it but when i opened it's not saving right
@kirrillywaring613
@kirrillywaring613 Жыл бұрын
Great stuff as always
@tayeajisafe27
@tayeajisafe27 Жыл бұрын
Hi, I'm having hard time seeing the formula using wrote under game_ID and the other formula at the top. I would appreciate if you can write them out for me. Thanks.
@457max
@457max Жыл бұрын
game_ID looks like: =IF(ISTEXT(C2)=TRUE,C2&" vs "&D2,"")
@tayeajisafe27
@tayeajisafe27 Жыл бұрын
Thanks
@gokudesenho715
@gokudesenho715 Жыл бұрын
Could you create a rating model for soccer players? It would also be interesting to create a power ranking Sorry if the English was not written correctly. I am Brazilian and still learning
@excel_ladz
@excel_ladz Жыл бұрын
Don't worry lad, your English is good. Perfectly understandable. As to your question, the idea of a rating model for individual soccer players was something I hadn't previously thought of. So that's a great idea I'll definitely look into. In terms of power rankings, that's easy for me to create once I've done the ratings for players. Thanks for the comment lad, great ideas for future videos!
@serdaraldkact5703
@serdaraldkact5703 Жыл бұрын
Hello. Is it possible for you to publish this excel you have made here? Thanks.
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, in the near future I’m considering setting up a website/page where all of my Excel models will be available for purchase. Would you be interested in this lad?
@serdaraldkact5703
@serdaraldkact5703 Жыл бұрын
@@excel_ladz Yes sir.
@serdaraldkact5703
@serdaraldkact5703 Жыл бұрын
As long as the price is right and there is success, of course I buy.
@SannyDavid7
@SannyDavid7 6 ай бұрын
Hi, I have rebuilt it one to one but I don't know how to update it for today's games? Please answer 👋🏻
@AmukelaniSalvation
@AmukelaniSalvation Жыл бұрын
Is it working on 2013 Excel?
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, it should still work in Excel 2013. All you have to do is replace every XLOOKUP formula to a VLOOKUP. This is because unfortunately, XLOOKUP is only available in 365 Microsoft subscriptions as well as Excel 2021 and later.
@rozzy7341
@rozzy7341 Жыл бұрын
Great Vid. Really helpful...thankyou!!
@SelinaAhamd
@SelinaAhamd 7 ай бұрын
Hi this is great but can I get the formulas by re-writing it in the comment section
@danielkelly758
@danielkelly758 Жыл бұрын
Hi Excel Ladz can't get the Data Id formula to work can you post it?
@danielkelly758
@danielkelly758 Жыл бұрын
=IF(AND(ISBLANK(C2)=FALSE, ISBLANK(D2)=FALSE),C2&" vs "&D2,"")
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, very sorry for the late response. This is the formula I have inputted for cell AT2 in the 'Raw Data' worksheet under the 'Game_ID' header: =IF(ISTEXT(C2)=TRUE,C2&" vs "&D2,"") Try this lad, and let me know how it goes 👍 .
@hildamunggaran880
@hildamunggaran880 9 ай бұрын
i got something weird when importing data, the number is too big for probability. it's over 100%, is that normal ?
@excel_ladz
@excel_ladz 9 ай бұрын
Hi lad, yeah that shouldn’t be the case. The sum of all probabilities for a match’s scoreline should be 100%, so there’s probably an error somewhere in your formulas (if the imported data is correct). Let me know if you have anymore specific questions lad 👍
@reportspayment
@reportspayment Жыл бұрын
@excel ladz can you create a video with posession model and poison distribution model combines?
@excel_ladz
@excel_ladz Жыл бұрын
Thanks for watching lad, I appreciate the support. With regards to your question, in the future I will be making a football video in which multiple parameters (e.g. possession, shots, passing, etc) are used in the model. And then from then, maybe rather than simulating the goals scored in the match, I can use the poisson distribution to solve for each team's chance of winning the match. I hope that helps lad.
@reportspayment
@reportspayment Жыл бұрын
@@excel_ladz That will be helpful waiting for the video
@reportspayment
@reportspayment Жыл бұрын
@@excel_ladz is there a way you can add an output of correct scores, highest and the second highest values with there corresponding correct score outcome and percentage? for example, probable outcome 3-2 14%..
@excel_ladz
@excel_ladz Жыл бұрын
@@reportspayment Hi lad, I do this at stage 19:30 of the video. Instead of spilling out the highest probable scoreline though, I use conditional formatting to highlight it for me. This is shown in 20:30.
@TRACK8REMIX
@TRACK8REMIX 6 ай бұрын
THANK YOU just done it
@ThePaulokeeffe
@ThePaulokeeffe Жыл бұрын
When i do the formula to lookup to return the home team keeps saying formula is wrong any chance typing it here please
@excel_ladz
@excel_ladz Жыл бұрын
Thanks for watching lad, make sure you're subscribed 👍 . In this video I use the XLOOKUP function to grab the home team. However, only Excel 2021 and the Microsoft 365 versions of Excel have access to this function. If you are using an older model of Excel, you must use VLOOKUP instead of XLOOKUP (it's a relatively easy switch between the two). I hope that helps lad 💪. If not, make sure you comment again and I'll get back to you as soon as possible.
@williamjacksquilliam
@williamjacksquilliam Жыл бұрын
Some nice data.
@excel_ladz
@excel_ladz Жыл бұрын
Appreciate it lad. Great data makes life worth living.
@nfgamesreviews1972
@nfgamesreviews1972 11 ай бұрын
Thank you👍
@PATRICKBETTINGTIPS
@PATRICKBETTINGTIPS 11 ай бұрын
Please what 😢 short cut code did you use to load the home win away win draw % at once without stress myself please help 😮
@twokeys2671
@twokeys2671 Жыл бұрын
Hello Lad. I just had a suggestion, there are some markets for betting over and under goals. How can i I do it using this elo rating method. It seems to work I just don't know how to go about it. There could also be a filter to generate games that have goals over or under a certain number
@basbos566
@basbos566 Жыл бұрын
prima tips excel thank you
@shalomdosseh5367
@shalomdosseh5367 Жыл бұрын
Hi Which version of excel are you using? There is a problem with the formulas =SI(Games!$D$11=0,"",Games!$A$4:DECALER(Games!$A$4(Games!$A$4,Games!$D$11-1,0)) error : not enough arguments to this function
@flamequote1440
@flamequote1440 8 ай бұрын
=games is not working as yours can you please advise me it only shows one game form the top of the list, and not the whole pivot table list
@jamesshoemark9807
@jamesshoemark9807 Жыл бұрын
Hi i`m trying to add column B which is league name to GAME ID but i tried and failed, can you please
@excel_ladz
@excel_ladz Жыл бұрын
G'day lad, sorry for the late reply. First of all, make sure your Game_ID formula at 3:21 of the video is correct. Then, at stage 8:15, go into Name Manager in the Formulas tab, and make sure you exactly type in the same formula I do under the name 'games'. If you still have further troubles, try to be as specific as you can when commenting so I can help you fix it lad!
@3ecke11er
@3ecke11er Жыл бұрын
Do you know how the potential results are calculated on ELO score? I am using predictions based on xG and the poisson distribution function
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, I haven't yet combined ELO Ratings with the Poisson Distribution. With Poisson, I normally go a different route and calculate Attack and Defence ratings for each club and then for each matchup calculate xG. An example of this is in the first ever video I made on this channel.
@-Tharos-
@-Tharos- Жыл бұрын
Given two teams, A and B, with Elo ratings Elo_A and Elo_B, the probability of team A to win the match is: 1 / (1 + 10^ ((Elo_B - Elo_A)/400) ). For Team B, just swap Elo_A and Elo_B in the equation. Elo rating doesn't account for draws. Also I don't know how club Elo is calculating the goal difference using Elo ratings.
@3ecke11er
@3ecke11er Жыл бұрын
I am using poisson distribution to predict where I generate the xG and than use this in the formular
@-Tharos-
@-Tharos- Жыл бұрын
@@3ecke11er I didn't get your method, can you elaborate? You calculate the goal expectation probability of each team using Poisson, and then you multiply the two Poissons to get the probability of match results (0-0, 1-0, ...), right? At least this is the most common way of using Poisson.
@3ecke11er
@3ecke11er Жыл бұрын
@@-Tharos- This is correct
@nap1346
@nap1346 Жыл бұрын
very interesting video
@excel_ladz
@excel_ladz Жыл бұрын
G'day lads, if you want access to this model (and every other Excel LADZ model), join the Excel LADZ community! Sign up here: www.patreon.com/ExcelLADZ 💪
@williamjacksquilliam
@williamjacksquilliam Жыл бұрын
You should run a Blackjack simulation in Excel
@excel_ladz
@excel_ladz Жыл бұрын
@@williamjacksquilliam Sounds like an idea... Will take a lot of planning though, so not a video in the short term unfortunately.
@boldbuzz
@boldbuzz Жыл бұрын
Please when will you upload the video for Over or Under Basketball total points Prediction?
@excel_ladz
@excel_ladz Жыл бұрын
@@boldbuzz I'm glad you're eager lad, this will be published very soon in the coming weeks 💪 💪.
@nikosss5363
@nikosss5363 Жыл бұрын
=IF(ISTEXT(C2)=TRUE, C2&" vs "&D2,"') THERE IS A PROBLEM WITH THIS FORMULA
@razvanbaraian214
@razvanbaraian214 Жыл бұрын
How i can have this program?
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, make sure you subscribe because in the short term I'll set up a website/page in which these models can be purchased for a small fee.
@nikola7875
@nikola7875 Жыл бұрын
you didn't mention when you insert new data that everything needs to be refreshed to accept the new data!
@excel_ladz
@excel_ladz Жыл бұрын
That’s absolutely correct lad 🔥 I’ll make sure to update the video’s description in case some subscribers can’t work it out 👍
@ngyuishing
@ngyuishing Жыл бұрын
I wonder how the API in clubelo calculate the probabilities
@excel_ladz
@excel_ladz Жыл бұрын
Most computer models use what's called the 'Monte Carlo Method' to calculate the probabilities. If you have any further questions lad, just ask me about it 👍
@ngyuishing
@ngyuishing Жыл бұрын
@@excel_ladz But not sure what model clubelo is using. Maybe Poisson distribution? But not sure how to get an expected mean solely based on Elo ratings.
@wizardracing2810
@wizardracing2810 2 ай бұрын
My Name manager is making empty cells 0 instead of blank. can any tell me why?
@osariemenagbonavbare2449
@osariemenagbonavbare2449 2 ай бұрын
You need to correct spelling error or check if XLOOKUP addon is in your excel version
@jorisaboughe9631
@jorisaboughe9631 Жыл бұрын
I can't put the numbers in percentage
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, if you already have the decimal values then it just involves changing the format from General to Percentage in the Home tab. However, if you're unable to get any values, double check your XLOOKUP formula; if you don't have access to XLOOKUP use a VLOOKUP formula 🔥Thanks for watching lad!
@acostevanovic9989
@acostevanovic9989 Жыл бұрын
THIS LAG FOR ME I GO TO TEXT TO COLUMS AND NOTHING
@hasantoroslu3462
@hasantoroslu3462 Жыл бұрын
Bu verilerin ilk yarılarının Verisi varmı sitede varsa. Ht ft analizi için süper olmazmı
@excel_ladz
@excel_ladz Жыл бұрын
Thanks for watching lad, but unfortunately the website I've imported the date from does not provide first half / second half data for us to calculate. This is an extremely simple model, a more detailed football model which I'm planning to upload int he short term will go though half analysis.
@gamingdata610
@gamingdata610 5 ай бұрын
I cannot see the formula
@itsricky5686
@itsricky5686 6 ай бұрын
=games not working on my PC too
@jameswairia4099
@jameswairia4099 Жыл бұрын
The data from the source was not that accurate since most of the predictions were wrong , with team statistics why don't you get your own winning,draw, losing chances
@excel_ladz
@excel_ladz Жыл бұрын
G’day lad, I 100% agree with you. There are many flaws with this website’s calculations. Have a look at my NBA video where I walk through how to build a model, completely from scratch, on how to predict basketball games using player stats. Thanks for watching the vid lad, make sure you’re subscribe for more 🔥 Follow Excel LADZ on Twitter to be able to DM me about any sports modelling questions (@excel_ladz) 💪.
@willmidfield56
@willmidfield56 Жыл бұрын
I have an issue thanks
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, I just answered your question on the NFL Touchdowns video. Do you have any more specific questions?
@willmidfield56
@willmidfield56 Жыл бұрын
I'll.look sorry lad cheers
@willmidfield56
@willmidfield56 Жыл бұрын
Still no joy mate I've took a screenshot cab I send it to u
@manuelantoniodanca9351
@manuelantoniodanca9351 Жыл бұрын
NHL?
@excel_ladz
@excel_ladz Жыл бұрын
Definitely before the season starts 🔥
@manuelantoniodanca9351
@manuelantoniodanca9351 Жыл бұрын
@@excel_ladz what league do you really recommend: NHL? Baseball, NBA, Soccer ⚽,? And which markets (MoneyLine, Spread, Totals)?
@carjosh77
@carjosh77 Жыл бұрын
Esta tabla para sudamerica
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, unfortunately this website doesn't provide stats for South American football leagues 😔 However, very soon I'll publish a video on 'How to Predict Football Games using the Poisson Distribution' that will be a much more accurate system of predicting matches than this video. Furthermore, you will be able to apply this to South American leagues 👍 Thank you for being a loyal subscriber lad 💪
@fehmikonkur20
@fehmikonkur20 Жыл бұрын
ben aynısını yaptım ve (2,5 alt 2,5 üst) karşılıklı gol var yok gibi seenekleride kledim
@briansacha51
@briansacha51 Жыл бұрын
Has anyone won money using this system?
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, not that I know of yet mate. This is a very simple model, make sure you're subscribed for more accurate models I'll be releasing very soon 💪.
@hasantoroslu3462
@hasantoroslu3462 Жыл бұрын
Aynısını yaptım
@informationalproducts
@informationalproducts 7 ай бұрын
this is not working =IF(Games!$D$11=0,"",Games!$A$4:OFFSET(Games!$A$4,Games!$D$11-1,0)
@vilemschrojf8026
@vilemschrojf8026 Жыл бұрын
Hello, I'm using office 2016 where the XLOOKUP function is missing and I used the VLOOKUP function so unfortunately the teams are not displayed in the field after the formula. where could be the problem ?
@excel_ladz
@excel_ladz Жыл бұрын
Hi lad, the VLOOKUP function is slightly different to XLOOKUP so watch you don’t accidentally list the wrong ranges in the formula 👍 With a VLOOKUP in this video, it should be: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, FALSE) If you have a more specific issue with the formula (e.g. at one stage of the video) please let me know lad 🔥
@vilemschrojf8026
@vilemschrojf8026 Жыл бұрын
@@excel_ladz The problem has been solved, but there is another problem I can't save the file with all the sheets. When I save the file, excel says that I have to save each sheet in the file separately. so I saved each sheet separately and when I open them again, the table with the formulas stops working actually all the formulas are missing. how the hell do I do that thanks for the advice.
@TheShick34
@TheShick34 Жыл бұрын
@@excel_ladz having the same problem,can you type the formula using vlookup?
@myarnie1950
@myarnie1950 Жыл бұрын
@@excel_ladz Hi Unfortunately I'm using excel 2019 and don' have Xlookup, can you provide a workaround for the lookup at 12:20 stage Thanks
PREDICT MLB Matches With Excel | Tutorial
29:02
Excel LADZ
Рет қаралды 11 М.
the balloon deflated while it was flying #tiktok
00:19
Анастасия Тарасова
Рет қаралды 35 МЛН
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18
Family Love #funny #sigma
00:16
CRAZY GREAPA
Рет қаралды 38 МЛН
The Elo Rating System for Chess and Beyond
7:09
singingbanana
Рет қаралды 1,3 МЛН
Football Betting Algorithm in Python Explained
8:12
Liam Hartley
Рет қаралды 78 М.
Predict the Outcome of Football Matches Using this Model
21:02
Kie Millett
Рет қаралды 185 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 299 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 236 М.
Easiest Multi-Level Drop-Down Lists in Excel!
8:27
Excel Off The Grid
Рет қаралды 13 М.
PREDICT NHL Matches With Excel | Tutorial
29:20
Excel LADZ
Рет қаралды 2,7 М.
PREDICT NBA Games With Probability | Excel Tutorial
51:08
Excel LADZ
Рет қаралды 42 М.
the balloon deflated while it was flying #tiktok
00:19
Анастасия Тарасова
Рет қаралды 35 МЛН