The power of (2.718)

[MemphisFlash]

Capture.JPG

you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.

[firlandsfarm]

Capture.JPG

you need to have the "DATA" tab activated, then click "refresh All".

if you can't see that tab you may have to load it as described earlier in this thread

the fixture list is only for leicester city, as i'm leicester. next match is against leeds so won't refresh. All the queries within will refresh the stats.

Yes, as I said I did a Refresh All before posting. OK so is it intended only for use with Leicester?

[MemphisFlash]

no thats just for me,
the stats are for every team.
i'll work on that for every team fixtures shortly

[firlandsfarm]

Sorry to labour the point MF ... I can see the stats for all teams on the Team Statistics tab ... are you saying it's for the user to manually input the fixtures as a reminder, you're not downloading them from the Internet? I couldn't find any code to view, have you hidden it!

[MemphisFlash]

there is no code. it is all done with a feature called power query, and yes it all comes from the internet.
you don't input anything

[firlandsfarm]

yes, I found the Power Queries and Table 11 for Leicester's fixtures but I can't fathom where the filter for Leicester is ... I was hoping to spot it and change it to another team!

[MemphisFlash]

you have to go ito advanced editor then use the team url's to find which team you want and then replace the numbers.
that should do it.
try it first on soccerstats website to make sure

[Archery1969]

This is awesome stuff Memphis.

[MemphisFlash]

This is awesome stuff Memphis.

thanks

[gregory196]

Great file thanks !!! Guess wont update on excel 2007 ;-(

[paspuggie48]

Great file thanks !!! Guess wont update on excel 2007 ;-(

I not entirely sure but I think you have to have Excel 2010 and above

[Archery1969]

Great file thanks !!! Guess wont update on excel 2007 ;-(

I not entirely sure but I think you have to have Excel 2010 and above

I couldnt get it to work with anything apart from Office 365.

[paspuggie48]

Strange Archery, I used to have Windows 7 and Excel 2010 with no problems.

[Archery1969]

Strange Archery, I used to have Windows 7 and Excel 2010 with no problems.

Well, could be me then. The other office versions i tried it either didnt update or just hung for like 20mins. Same machine, installed office 365 and the spreadsheet updated in less than 10 seconds. All fine now.

[paspuggie48]

Brill Archery...Memphis loves it