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
That's the one. Thank you.
Andrew James
2024-05-30 08:51:15 +0000 UTCHi lad, this may be what you're seeking: https://www.patreon.com/posts/easiest-model-to-84701508
Excel LADZ
2024-05-25 03:57:53 +0000 UTCYes 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
2024-05-24 08:47:00 +0000 UTCThe ELO is on Youtube, my apolgies, but I don't see it on Patreon.
Andrew James
2024-05-23 14:57:23 +0000 UTCYes I know the method, I've downloaded the European 5 leagues.
Andrew James
2024-05-23 14:55:57 +0000 UTCHi 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 ๐ช
Excel LADZ
2024-05-22 20:48:22 +0000 UTCWhere do I find the model posted on Patreon? Do you have a link please?
Andrew James
2024-05-22 18:42:49 +0000 UTC
