The Power Of 9 Soccer Leagues at touch of button

Post Reply
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

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
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Or would you prefer them all on one sheet?

image.JPG
You do not have the required permissions to view the files attached to this post.
WigWamBam
Posts: 24
Joined: Mon Jul 01, 2019 1:20 pm
Location: Leicester

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
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Try this one
Top 9 Leagues (Rev 2) - Power Query.xlsx
You do not have the required permissions to view the files attached to this post.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

Love the 2nd one Tom. Fantastic.

Is it easy to implement a heat map??

I hope your well and Happy New Year
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Realrocknrolla wrote:
Wed Jan 06, 2021 7:44 pm
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.:) :) :)
User avatar
ilovepizza82
Posts: 490
Joined: Thu Nov 02, 2017 3:41 pm
Location: Sewers
Contact:

....
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

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

Mickey Mouse may answer
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

almost as believable as Nottingham forest winning it twice,
jtrader
Posts: 100
Joined: Thu Feb 09, 2017 11:35 am

Hi,MemphisFlash! I have that problem with this file when I've tried to refresh it Image
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Try this one
Top 9 Leagues (Rev 2) - Power Query.xlsx
You do not have the required permissions to view the files attached to this post.
jtrader
Posts: 100
Joined: Thu Feb 09, 2017 11:35 am

MemphisFlash wrote:
Tue Sep 12, 2023 1:13 pm
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)?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

kind of table i like, Us at the top
tot.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

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.
Post Reply

Return to “Excel Power Query”