Power Query - PGA Tournament Results

[paspuggie48]

This is a very simple Power Query solution to get the results of PGA tournaments and combine them all into one Table.

PGA Tournament Results.xlsx

PGA Result.png

It works by using the URL on the Tournaments worksheet to get a list of all the Golfers who played in the event and then a function is applied to get their scores.

PGA URLs.png

I have included the classics and some other events but one can add as many as they want from the website.

[paspuggie48]

If one wants to add more events, then from the website select a Year and Tournament from the drop down menus.

Copy the URL from the address bar and paste it into the Table in the Tournaments worksheet.

PGA Tournaments.png

It is self-explanatory but also include the other information to complete the Table. The Column called "Course" is just for information but can be copied from the webpage if required.

PGA URLs.png

After you've added more Tournaments go to the 'TournamentsResults' worksheet, select a cell on the Table and right-click "Refresh". After a couple of minutes it will update.

Note: it takes a few minutes to update so even if your Excel says "not responding" just leave it alone and it will work fine.

[MemphisFlash]

nice work, the force is strong with you!!!

[paspuggie48]

nice work, the force is strong with you!!!

Capture.PNG