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