Excel LADZ
patreon
Import ClubELO Data Automatically Using Power Query Editor
🕑 Added 2023-12-20 01:57:28 +0000 UTCG'day, lads
In this short video above, I run through how to write some code in Power Query Editor in order to import the Club ELO Data automatically. In the YouTube video up on the channel (and in the model posted to Patreon), the user is required to copy and paste the data into the model everyday. To save time, I've created code in the video above to write a Blank Query. This code can update the power query once you press 'Refresh All' in the Data tab.
Note: Unfortunately some versions of Excel don't have the ability to use a Power Query. Please check if you version of Excel supports this 👍
Comments
Andrew James
That's the one. Thank you.
Excel LADZ
Hi lad, this may be what you're seeking: https://www.patreon.com/posts/easiest-model-to-84701508
Andrew James
Yes I know the method, I've downloaded the European 5 leagues. The ELO is on Youtube, my apolgies, but I don't see it on Patreon.
Andrew James
The ELO is on Youtube, my apolgies, but I don't see it on Patreon.
Andrew James
Yes I know the method, I've downloaded the European 5 leagues.
Excel LADZ
Hi lad, welcome! All you have to do is click on a post. Scroll down to the bottom, and there should be an Excel file attached. For example, on my latest 'ANALYSE Football' post at the top of my page, the download link is at the bottom of the post once you click on it. Let me know if it's still an issue lad 💪
Andrew James
Where do I find the model posted on Patreon? Do you have a link please?
