Another example of a Downloader to get data from embedded files on a website.
This time, Men's ATP & Women's WTA tennis results.
Some of you will be familiar with the website in question and there is a hyperlink to their Glossary 'LINK TO NOTES'.
I wasn't able to download the file with all the results as it was too big to attach, so I have removed most of the rows of data to accommodate.
To update, simply right click anywhere in the green Tables and select "Refresh".
It should take less than 20 seconds to refresh both Tables to get the same number of results (as per my screenshots above)
Periodically when the website updates it's embedded worksheets repeat the refresh process on this tool.
Good luck !!
Power Query - Tennis Results Downloader
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
-
- Posts: 17
- Joined: Sun Jul 20, 2014 10:49 pm
Brilliant!
I've just discovered your posts regarding Power Query and it's... well... power!
Thanks for sharing all these ways to use Power Query, I definitely must learn to use it (New Year's resolution!)
I've just discovered your posts regarding Power Query and it's... well... power!
Thanks for sharing all these ways to use Power Query, I definitely must learn to use it (New Year's resolution!)
- CitizenEra5ed
- Posts: 28
- Joined: Sun Oct 22, 2023 9:26 pm
Thanks for sharing. Ive tried updating but getting the following message - any idea what the issue is please?
Regards
Chris
Regards
Chris
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Many thankstimevoyager wrote: ↑Tue Dec 26, 2023 10:35 amBrilliant!
I've just discovered your posts regarding Power Query and it's... well... power!
Thanks for sharing all these ways to use Power Query, I definitely must learn to use it (New Year's resolution!)
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Probably because of your privacy settings, check this thread viewtopic.php?f=83&t=28180CitizenEra5ed wrote: ↑Tue Dec 26, 2023 12:31 pmThanks for sharing. Ive tried updating but getting the following message - any idea what the issue is please?
Regards
Chris
- CitizenEra5ed
- Posts: 28
- Joined: Sun Oct 22, 2023 9:26 pm
Have things changed with the latest version of Excel? (i am a 365 subscriber) - I've been looking for the best part of a week for how to update this chart you posted. I've followed your advice on the thread you linked to but cannot find Query Options > Privacy anywhere and it's doing my head in now!paspuggie48 wrote: ↑Wed Dec 27, 2023 8:45 amProbably because of your privacy settings, check this thread viewtopic.php?f=83&t=28180CitizenEra5ed wrote: ↑Tue Dec 26, 2023 12:31 pmThanks for sharing. Ive tried updating but getting the following message - any idea what the issue is please?
Regards
Chris
I've looked at numerous posts online but every example i look at looks different to my Excel.
Any help greatfully received
Chris
- CitizenEra5ed
- Posts: 28
- Joined: Sun Oct 22, 2023 9:26 pm
I've managed to get it to update after much frustration but I'm seeing a data error with the ATP sheet - the WTA is fine.
Anybody else seeing this?
Chris
Anybody else seeing this?
Chris
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Not sure why you cannot find it because all versions of Excel have this in the Query Options. Go to your Data Tab , then Get Data, then Query Options, then PrivacyCitizenEra5ed wrote: ↑Sun Dec 31, 2023 6:48 pmHave things changed with the latest version of Excel? (i am a 365 subscriber) - I've been looking for the best part of a week for how to update this chart you posted. I've followed your advice on the thread you linked to but cannot find Query Options > Privacy anywhere and it's doing my head in now!paspuggie48 wrote: ↑Wed Dec 27, 2023 8:45 amProbably because of your privacy settings, check this thread viewtopic.php?f=83&t=28180CitizenEra5ed wrote: ↑Tue Dec 26, 2023 12:31 pmThanks for sharing. Ive tried updating but getting the following message - any idea what the issue is please?
Regards
Chris
I've looked at numerous posts online but every example i look at looks different to my Excel.
Any help greatfully received
Chris
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
I've updated it this morning and it works perfect. Have you opened Excel in Desktop version, not Online (web) versionCitizenEra5ed wrote: ↑Sun Dec 31, 2023 8:09 pmI've managed to get it to update after much frustration but I'm seeing a data error with the ATP sheet - the WTA is fine.
Anybody else seeing this?
Chris
2023-12-31_20-04-37.jpg
- CitizenEra5ed
- Posts: 28
- Joined: Sun Oct 22, 2023 9:26 pm
it was the online version, I've now downloaded it/installled it on my Mac but still seeing the same issue with the ATP sheet - even after redownloading a fresh copy of the tennis results downloader. Any other ideas?
Regards
Chris
Regards
Chris
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Not sure, never used Mac. Not sure if it will work, as per the note below shows.CitizenEra5ed wrote: ↑Mon Jan 01, 2024 4:25 pmit was the online version, I've now downloaded it/installled it on my Mac but still seeing the same issue with the ATP sheet - even after redownloading a fresh copy of the tennis results downloader. Any other ideas?
Regards
Chris
You do not have the required permissions to view the files attached to this post.
- CitizenEra5ed
- Posts: 28
- Joined: Sun Oct 22, 2023 9:26 pm
Thanks, it may be the Mac version that doesn't work properly then.paspuggie48 wrote: ↑Mon Jan 01, 2024 6:01 pmNot sure, never used Mac. Not sure if it will work, as per the note below shows.CitizenEra5ed wrote: ↑Mon Jan 01, 2024 4:25 pmit was the online version, I've now downloaded it/installled it on my Mac but still seeing the same issue with the ATP sheet - even after redownloading a fresh copy of the tennis results downloader. Any other ideas?
Regards
Chris
Capture.PNG
chris
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Good spot, thanks I found the error in my function and rectified (hopefully)
You do not have the required permissions to view the files attached to this post.