Home
Creators
Search Recent Missing Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

How to Update 2024 ClubELO Model Daily! (Patreon)

Published:
2024-08-12 21:55:42
Imported:
2026-06
haven't archived this post yet. have a subscription? use the importer!

Downloads

  • 340110561.txt

Missing 1 file, as this post has not yet been imported.

Content

G'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

Clirim

Thanks for everything you do. Can I ask you why so many matches are missing from the daily schedule, for example South America?

Excel LADZ
>>148563798

Hi, 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 👍

Clirim

Thanks 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?

Excel LADZ
>>152217058

No 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 🔥

Clirim

Hi, 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!

Excel LADZ
>>153132483

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 👍