UEFA Seeding & Qualification based on ClubElo Values - Updates & Feedback

including formats, draws, seedings, etc.
elkjiaer is back
Posts: 250
Joined: Fri Jul 28, 2017 09:08

Post by elkjiaer is back »

SimonB wrote: Tue Jun 28, 2022 18:27
elkjiaer is back wrote: Tue Jun 28, 2022 15:18 I have simulated the outcome of all qualifiers for UCL , UEL and ECL. Those are the probabilities to qualify for the Group stage of the 3 competitions for all teams entering UCL qualifiers either Champions Path or League Path. Let me know if you have any comment

https://imgur.com/a/xMUAZw5
Interesting numbers, are these simulations based on a combination of current elo plus likely seeding outcomes, or have you used any different logic?
Yes exactly , current Elo ratings for teams’ strengths and Uefa coefficients for seeding in the next round .
Stadion
Posts: 360
Joined: Sat Mar 31, 2018 16:13

Post by Stadion »

Thanks for sharing your simulation @elkjiaer is back !
Glimt1916
Posts: 45
Joined: Fri Apr 15, 2022 11:58

Post by Glimt1916 »

Is the speadsheet now bogged?
Stadion
Posts: 360
Joined: Sat Mar 31, 2018 16:13

Post by Stadion »

Glimt1916 wrote: Tue Jul 05, 2022 23:09 Is the speadsheet now bogged?
I'm unable to automatically retrieve the league standings from Soccerway. I'm not sure if this is temporary or permanent (they may have blocked the type of scraping I'm doing of their site) at this point though.

WIth that said, does anyone know any other reliable site for retrieving up to date league tables and pulling into Google Sheets?
Ginaro
Posts: 76
Joined: Wed Jul 31, 2019 02:01
Location: Scotland

Post by Ginaro »

Stadion wrote: Wed Jul 06, 2022 04:31
Glimt1916 wrote: Tue Jul 05, 2022 23:09 Is the speadsheet now bogged?
I'm unable to automatically retrieve the league standings from Soccerway. I'm not sure if this is temporary or permanent (they may have blocked the type of scraping I'm doing of their site) at this point though.

WIth that said, does anyone know any other reliable site for retrieving up to date league tables and pulling into Google Sheets?
Wikipedia as a last resort?
mitsaras
Posts: 50
Joined: Wed Jun 08, 2022 22:44
Location: Kalamata

Post by mitsaras »

Is there any working spreadsheet?
Bjartne
Posts: 26
Joined: Sat Jul 23, 2022 10:05
Location: Norway

Post by Bjartne »

mitsaras wrote: Sat Jul 23, 2022 09:05 Is there any working spreadsheet?
I have been searching for one myself, after this amazing spreadsheet stopped working.

The one from Swiss Football Data is the closest thing I've found.
There is at least projected groups for all 3 competitions and they claim to update it regularly. :smile1:

https://swissfootballdata.com/2022/01/0 ... son-22-23/
User avatar
Firnen
Senior Member
Posts: 12187
Joined: Tue Mar 22, 2016 21:32

Post by Firnen »

This automatic spreadsheet was great, I hope Stadion finds a way to re-create it for next season !
ffero
Posts: 224
Joined: Tue Jun 20, 2017 14:55
Location: Bratislava

Post by ffero »

I have this link in my bookmarks: Seedings 22-23

https://onedrive.live.com/view.aspx?res ... Dbe7-QwpCY

but I don't remember, who is the author..
User avatar
dnina10
Senior Member
Posts: 3988
Joined: Mon Dec 19, 2016 22:26
Location: Canada
Contact:

Post by dnina10 »

ffero wrote: Sat Jul 23, 2022 17:22 I have this link in my bookmarks: Seedings 22-23

https://onedrive.live.com/view.aspx?res ... Dbe7-QwpCY

but I don't remember, who is the author..
That one is mine
eye
Posts: 394
Joined: Tue Jun 23, 2020 21:52

Post by eye »

Mine is working since end of May for the next season. The link and the explanation for the spreadsheet here

viewtopic.php?p=510837#p510837
User avatar
Firnen
Senior Member
Posts: 12187
Joined: Tue Mar 22, 2016 21:32

Post by Firnen »

eye wrote: Sun Jul 24, 2022 00:44 Mine is working since end of May for the next season. The link and the explanation for the spreadsheet here

viewtopic.php?p=510837#p510837
This is a very good one !

The visual formatting could use some work, but overall great job !
Stadion
Posts: 360
Joined: Sat Mar 31, 2018 16:13

Post by Stadion »

eye wrote: Sun Jul 24, 2022 00:44 Mine is working since end of May for the next season. The link and the explanation for the spreadsheet here

viewtopic.php?p=510837#p510837
What data source do you use for the league standings? I'm unable to scrape Soccerway using Google Sheets which is why my spreadsheet isnt working.

I plan to have it up and running again once most autumn-spring leagues have kicked off.
eye
Posts: 394
Joined: Tue Jun 23, 2020 21:52

Post by eye »

Stadion wrote: Sun Jul 24, 2022 09:31
eye wrote: Sun Jul 24, 2022 00:44 Mine is working since end of May for the next season. The link and the explanation for the spreadsheet here

viewtopic.php?p=510837#p510837
What data source do you use for the league standings? I'm unable to scrape Soccerway using Google Sheets which is why my spreadsheet isnt working.

I plan to have it up and running again once most autumn-spring leagues have kicked off.
I am getting data from xscores and futbol24. Soccerway is using script so it is not possible anymore to get data from there.
Stadion
Posts: 360
Joined: Sat Mar 31, 2018 16:13

Post by Stadion »

eye wrote: Sun Jul 24, 2022 11:32
Stadion wrote: Sun Jul 24, 2022 09:31
eye wrote: Sun Jul 24, 2022 00:44 Mine is working since end of May for the next season. The link and the explanation for the spreadsheet here

viewtopic.php?p=510837#p510837
What data source do you use for the league standings? I'm unable to scrape Soccerway using Google Sheets which is why my spreadsheet isnt working.

I plan to have it up and running again once most autumn-spring leagues have kicked off.
I am getting data from xscores and futbol24. Soccerway is using script so it is not possible anymore to get data from there.
Thank you!
Post Reply