if your looking for footy stats i dont think you will get more comprehensive than this.
more stats than you have had hot dinners!!!
check it out!!
this page in particular... Check the match reports
https://fbref.com/en/comps/9/schedule/P ... d-Fixtures
fbref.com
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Might have a look at scraping that site, been meaning to find a football stats site for a while.
Just noticed they even have the data downloadable as csv for you already
Just noticed they even have the data downloadable as csv for you already
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
its not just a footy site, they have others as well,
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
I can only concentrate on a few things at once, Memphis. We can't all clean up on every sport.
Where is that?spreadbetting wrote: ↑Mon Nov 16, 2020 3:02 pmMight have a look at scraping that site, been meaning to find a football stats site for a while.
Just noticed they even have the data downloadable as csv for you already
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
On most pages they have a link showing Share and more , haven't checked all pages but even if it's just for single pages it'll make data mining easier for me
Looks like https://statsbomb.com/data/ is the site providing the data and have an API , dunno the costs
Looks like https://statsbomb.com/data/ is the site providing the data and have an API , dunno the costs
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
it was easy in power query for excel.
ive already done loads from those sites
ive already done loads from those sites
-
- Posts: 1070
- Joined: Fri Nov 20, 2015 9:38 am
They have added columns to the data tables in each of the last two weeks - so potentially an ongoing maintenance job if you are running a query... maybe worth building in some sense checks..MemphisFlash wrote: ↑Mon Nov 16, 2020 5:10 pmit was easy in power query for excel.
ive already done loads from those sites
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Can you power query to pull in the match reports and gather teams goal times?MemphisFlash wrote: ↑Mon Nov 16, 2020 5:10 pmit was easy in power query for excel.
ive already done loads from those sites
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i have done one, but it involves some manual manipulation that some excel users might not have the knowlede to do so i havent posted it
- MemphisFlash
- Posts: 2152
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.