Power Query - Greyhound A to Z & Tips

[paspuggie48]

A very basic example of Power Query, this time to get a full list of all Greyhounds running today + the Tips suggested by that website

Greyhound AtoZ and Tip Sheet.xlsx

There are two worksheets.

The "Data" worksheet consists of 2 Tables, one to get all the A to Z runners for the day and to the right of that another Table that gets the Tips provided by that website. To update both, select any cell in each Table, right-click your mouse and select "Refresh". It does take a few minutes to download the days data.

AtoZTips.png

The "AtoZ+Tips" worksheet combines both the A to Z Table + Tips Table. To update, right-click on any cell inside the Table and click on "Refresh". It will only combine the data once you have updated the two Tables on the "Data" worksheet.

AtoZTipsCombined.png

[JAMESGLYNN67]

I've not been on the forum for a while and you seem to be a power query guru. I love the dogs and plan to spend the winter hibernating with them.

I've just done an 8 month summer contract as a chef and have 4 months off. First free Christmas in years.

I've been going through the bf promo greyhound result download after work for a few months. On paper I should be buying an island.

How do I get a spreadsheets set up like the bf promo.
Every dog in every race all on one sheet with a back and lay column. I understand this might bog my laptop down but i can counter that with refresh rates etc. I'm not looking for a fully automated betting sheets just something very basic with very little data.

I suspect I may be going down a power query route but i'm clueless.

Can you help or point me in the right direction

Cheers

[paspuggie48]

Every dog in every race all on one sheet with a back and lay column. n

Cheers

The easiest way is to load the markets into Guardian, set the columns you want displayed (meeting, time, dog name etc) then right-click on any of them and "Export the contents...."

You can save the CSV file to use as you please

[ShaunWhite]

Can you help or point me in the right direction

When you get your data the #1 rule is to research your strategy on a subset of it, and then test/prove it on a different subset. (maybe just randomly split it in half) Otherwise you'll quite easily find an edge but then there's no reassurance it will work on unseen races. Any one set of data no matter how large will always show baises due to natural variations, so to use the proper terminology, you need a training set and a validation set in order to eliminate backfitting.