Power Query - Racing Post Summary

[paspuggie48]

This simple Power Query solution extracts the Racing Post Summary it has for every horse racing in UK & IRE on the day.

Racing Post Summary.xlsx

racingpostsummary.png

Basically it extracts all the URLs for each race

myracing.png

Once it has the URL for every race, it looks for each Racing Post comment for every horse, adds the relevant other columns of data and then combines accordingly.

To update select any cell on the Table and right-click "Refresh"

Note: it does take 2-3 minutes to refresh.
Note: if a horse has no comment it is more than likely a NR

[ChrisF]

Good Morning

Could you not extra the form as well?

[makkad]

Has been working intermittently - but now not working at all - Windows 11

[paspuggie48]

Has been working intermittently - but now not working at all - Windows 11

I've not used it in a while but refreshed my version and although it took a few minutes it worked fine.

Here is today's comments

Racing Post.jpg

Try your privacy settings, as I note in this thread

viewtopic.php?t=29223

I'm still using Win10 but I doubt Win11 is an issue.

[weemac]

Could this be created for the BF/Timeform comments?