How to Update 2024 ClubELO Model Daily!
Added 2024-08-12 21:55:42 +0000 UTCG'day lads! In this video I'll show you how to update the 'Excel LADZ - 2024 ClubELO Model' every day, so you can bring in probabilities for games based on ClubELO's ELO Ratings formula.
To download this spreadsheet, click here: https://www.patreon.com/posts/excel-ladz-2024-107986871
Please let me know if you have any further questions lads! 🔥 👍
Comments
No worries, lad! Unfortunately, a results feature is not supported by the ClubELO API (which the spreadsheet connects to). The website states the only features available to connect to are “One day’s ranking”, “one club’s rating history” and “upcoming games” - which is what the file uses right now. Here’s the link to the website’s API information: http://clubelo.com/API Sorry if that’s not helpful lad, it would be a good idea for them to create a results feed 👍
Excel LADZ
2024-10-23 21:36:51 +0000 UTCHi, thanks for the reply. I wanted to ask you if it is possible to modify the query so that at the end of the day you can download the final results of the games played that day? Thanks for everything you are doing!
Clirim
2024-10-23 12:57:38 +0000 UTCNo worries, lad 🔥 Thanks for sending that link. I had a look in the "Analysis" section. It seems like they've got a custom formula to come up with their own ELO Ratings for each team. Usually ELO Ratings are between 1,000 and 1,800. This website has scaled their ratings according to their own formula. Unfortunately, there's no exact way of knowing how these's ratings came about. However, these ELO Ratings produce an "Expected Goals" figure for the match. The website then uses the Poisson Distribution to find the Win Probability for each team, based off the "Expected Goals". For example, São Paulo vs Vasco da Gama have expected goals 1.42 & 1.08 respectively. Using the Poisson Distribution, São Paulo has an approximately 44.9% of winning, with Vasco da Gama having a 28.5% chance. A draw is expected to occur 26.5% of the time. I've used this method to come up with percentages for markets a few times, especially in this video: https://www.youtube.com/watch?v=vg5BxFCdYnE Hopefully that helps, lad 🔥
Excel LADZ
2024-10-16 23:39:28 +0000 UTCThanks for the reply, is it possible to make an excel file with the data from https://it.besoccer.com/risultati/ which has all the matches in the ANALYSIS section calculated with the Elo ranking?
Clirim
2024-10-13 17:17:12 +0000 UTCHi, mate! Apologies for the late response. The model pulls in everything listed on the ClubELO Website. So, if anything isn't listed there, it won't be brought into the model 😢 I hope this helps, lad. If you have any further questions, please don't hesitate to message me personally through Patreon 👍
Excel LADZ
2024-10-09 10:43:58 +0000 UTCThanks for everything you do. Can I ask you why so many matches are missing from the daily schedule, for example South America?
Clirim
2024-09-05 08:07:09 +0000 UTC
