The Power Of 9 Soccer Leagues at touch of button

[MemphisFlash]

Think you guys will like this.
A power query that incorporates last 5 matches, BTTS, 1.5+, 2.5+ and other stats for


The English Premier League
The English Championship
The EFL leagues 1 and 2
The Scottish Premier League (Mickey Mouse League)
The German Bundesliga
The French Ligue 1
The Itialian Serie A and
The Spanish La Liga

9 leagues.JPG

9 leagues. -2JPG.JPG

FootyStats Top 9 Leagues - Power Query.xlsx

[MemphisFlash]

Or would you prefer them all on one sheet?

image.JPG

[WigWamBam]

Hi Memphis
This sheet is great, i've just tried to update it and it didn't work.
Do you have an updated version of this please?

Thanks

[MemphisFlash]

Try this one

Top 9 Leagues (Rev 2) - Power Query.xlsx

[Realrocknrolla]

Love the 2nd one Tom. Fantastic.

Is it easy to implement a heat map??

I hope your well and Happy New Year

[MemphisFlash]

Love the 2nd one Tom. Fantastic.

Is it easy to implement a heat map??

I hope your well and Happy New Year

happy new year to you too.

[ilovepizza82]

....

[MemphisFlash]

Capture.PNG

[StellaBot]

Is it true a team called Celtic
from "Mickey Mouse League"
were FIRST BRITISH TEAM
TO WIN THE EUROPEAN CUP ?

Mickey Mouse may answer

[MemphisFlash]

almost as believable as Nottingham forest winning it twice,

[jtrader]

Hi,MemphisFlash! I have that problem with this file when I've tried to refresh it

[MemphisFlash]

Try this one

Top 9 Leagues (Rev 2) - Power Query.xlsx

[jtrader]

Try this one

Top 9 Leagues (Rev 2) - Power Query.xlsx

Thank you very much,Memphis! It's working fine now! And how could I change that spreadsheet if I wanna see last 10 games for example(and merge them on home only/away only and BTTS or O/U and etc. stats in these last games)?

[MemphisFlash]

kind of table i like, Us at the top

tot.PNG

[Euler]

Good chance you will bounce back straight away. You need some earlier season momentum to make a charge and get enough points for the inevitable wobble.