Power Query - Top Rated Horses by Race From Sharpbetting

[paspuggie48]

Here is an example of Power Query scraping top rated selections for each race in the UK from https://sharpbetting.co.uk/racecards

Sharpbetting Ratings.xlsx

Sharpbetting.png

To refresh, click any cell inside the Table then go to the 'Data Tab' and click on "Refresh All"

Note: it takes a couple of minutes to refresh so be patient.

[teambulldog]

Thankyou for posting this

[sIGNAL]

Thank you mate, much appreciated as always

[paspuggie48]

Thank you mate, much appreciated as always

The tool is obviously free sIGNAL but I hope you put in a good word for me on Discord

[Atho55]

Here are a few days results. Grouped 10-9 and 8-7 ratings into lists and did lookup into Promo sheet @ £10 Back (ex comms). First few days excluded Ire races as well.

Sharpe Pics.xlsx

[sIGNAL]

Thank you mate, much appreciated as always

The tool is obviously free sIGNAL but I hope you put in a good word for me on Discord

Sorry mate only just seen this. Yeah I would of updated it to say I modified it from your original file, but the TTM discord group has been since closed down.

Alot of rumours circling shady goings on with that group, so who knows what's what with them.

[Fugazi]

Thank you mate, much appreciated as always

The tool is obviously free sIGNAL but I hope you put in a good word for me on Discord

Sorry mate only just seen this. Yeah I would of updated it to say I modified it from your original file, but the TTM discord group has been since closed down.

Alot of rumours circling shady goings on with that group, so who knows what's what with them.

Tbh I think they just want to funnel everyone into sports-iq and bump up the prices without mass complaint

[ilovepizza82]

Is it any good ? ALso why does it produce only 1 runner per race ?

[paspuggie48]

Is it any good ? ALso why does it produce only 1 runner per race ?

I provided the link to the website in the post, where one can check the race cards.

One can see every runner has a rating but as noted the tool only gets the top rated, hence only 1 runner per race.

They are relatively new on the scene so not much data behind it, so it's up to oneself to collate the data to see if their ratings are any good

[makkad]

Having problems with this query - could it be my excel settings?

sb_BA.jpg

Edit: Furthermore Beaten Favourites Query timed out !! So I need help please

[paspuggie48]

Having problems with this query - could it be my excel settings?
sb_BA.jpg

Edit: Furthermore Beaten Favourites Query timed out !! So I need help please

Try the errors thread bud

viewtopic.php?t=29223

[makkad]

Having problems with this query - could it be my excel settings?
sb_BA.jpg

Edit: Furthermore Beaten Favourites Query timed out !! So I need help please

Try the errors thread bud

viewtopic.php?t=29223

I've checked privacy settings and already set up fine as advised - see image

[makkad]

Furthermore - when i hit the refresh I get this window pop up immediately see image

[paspuggie48]

Furthermore - when i hit the refresh I get this window pop up immediately see image

Not to sound too condescending but did you by any chance click on "connect"?

As the dialogue box states, it's trying to connect to said website but it won't until you select it.

This pop-up usually occurs when one removes/edits permissions which is in the Data Source Settings, not Query Options (as per my advice in the Error thread). Basically if one changes those permissions or removes them it means it needs to re-connect to the website in order to run the query.

[Hepburn]

Looks interesting. If anyone has a stash of say 6 months or more worth of racecards pls let me know. ta v muchly