Football Spreadsheet

[StellaBot]

Thanks Shaun

Brilliant

[jimibt]

further to what shaun posted, you COULD create a different tab for each league and that way, you could have discrete data sources for each required data pull. that would keep everything uniform. of course (without having reviewed your sheet in detail -which looked very good ) it may mean that you'd need to adjust some forumlas. but for the sake of atomicity, i think this might offer a good level of seperation to allow things to be easily maintained.

just an observation if using different data sources and looking to more or less automate the refresh.

[StellaBot]

Thanks Jimibt

I have completed the English premier and was wondering if I can scrape all the Home tables into one sheet?
or has to be as you suggested all seperate

[StellaBot]

ALERT ALERT ALERT , DOWNLOAD NEW VERSION
MISTAKES IN PREVIOUS

Thankfully due to others advice in this post re scraping
I started a new build capture sheet
Whilst transferring etc data to new capture sheet I found 2 major errors
Columns BD(didnt have correct data) and therefore BI was wrong

here is the updated sheet

and link where I built the sheet from

https://www.sbo.net/strategy/football-p ... tribution/

but worth reading 2nd site

https://www.thepunterspage.com/poisson- ... tep-guide/

[StellaBot]

BUMP
ALERT ALERT ALERT , DOWNLOAD NEW VERSION
MISTAKES IN PREVIOUS 13/07/20
Wonder why 13 was unlucky

[Kafkaesque]

If you want data from any stats site then watch this vid https://youtu.be/BuXLaQt9oEo
(19mins and you can skip the first 6mins if you have an especially short attention span)

No need to get into anything techy or code or macros or vba, web scraping is all built into Excel. Creating this table below took about 10 seconds....and it will update automatically. As I said you can grab everything off soccer stats with one click if you like, if you do a little work up front and it really is a little work.

Screenshot_s1.pngScreenshot_s2.pngScreenshot_s3.png

I've asked this on here previously with no luck, and I don't expect it to change, but you did say ANY stats site Does it work with the only site I want: whoscored.com?

Had a quick try based on the vid, without succes. Not at home with my primary computer, so may have messed it up...

[Atho55]

Looks to work for me...

WhoScored.com.jpg

[Kafkaesque]

Looks to work for me...

WhoScored.com.jpg

I'm missing my computer more than I really should

That's a complete gamechanger (for me) if true

[StellaBot]

****

3rd time lucky
soz guys/gals

I thought columns BD and Bi would self populate when I updated Premiership
Had to do it manually in the last ten mins(until Shauns and Jimibt suggestion is completed)

[StellaBot]

Here is the updated version of all leagues in play and games up until yesterday.

[ShaunWhite]

you did say ANY stats site ...

A bold and unqualified statement. "Works on any site it works on" might have been better.

[StellaBot]

Please find updated sheet with all in running leagues updated with games played today.
Added Sweden also

? Last sheet posted had Q5 and Q7 missing formula?

Think everything perfect now

[StellaBot]

Here is the updated spreadsheet.
I also noticed there was a slight error in the formula in cell B13 for the under 2.5 market

[StellaBot]

Here is an updated spreadsheet for some of the leagues with games today
Latvia, Sweden, Ireland and Norway

https://www.soccerstats.com/matches.asp

[jamesg46]

Does anyone know of a scraping friendly website for xG using Excel?

I'd much prefer not to have to go through it manually like last season & this week I plan to start putting this seasons sheets together.