Power Query - Horse Racing Tips Predictor

[paspuggie48]

Power Query - Horse Racing Tips Predictor

Predictor +History.xlsx

I'm sure I posted this one a long time back, alas I cannot find it.

A certain website that has a 'Predictor' page for selections each day.

Refresh the Predictor worksheet

Screenshot 2021-03-20 121102.png

I copy 'n paste those selections each day to the Historic Data worksheet.

I've saved over 1,000 selections from the end of Oct '2020 and added them to a 3rd sheet with relevant BF results, IPmin & IPmax figures and both Back & Lay profit figures.

Screenshot 2021-03-20 121144.png

For you to peruse, analyse and use where you can.

[paspuggie48]

Update attached containing 1,999 selections dating back to 30/10/2020.

Predictor +History.xlsx

[Realrocknrolla]

Thanks for all your contributions Puggsie!

Top man

[MemphisFlash]

More Power Query, Bring it on Boys

[iphoneshoey]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

[paspuggie48]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

This solution was developed some 3 years ago. It's most likely because they changed the website layout / links which is causing an issue. If I get time, I will have a look at updating the query.

[iphoneshoey]

Thank you

[paspuggie48]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

I've revamped the Predictor tool.

Predictor.xlsx

[wearthefoxhat]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

I've revamped the Predictor tool.


Predictor.xlsx

Good work Pugsy.

[paspuggie48]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

I've revamped the Predictor tool.


Predictor.xlsx

Good work Pugsy.

Thanks Foxy

[gstar1975]

Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please

James

I've revamped the Predictor tool.


Predictor.xlsx

Good work Pugsy.

The Query King reigns supreme! Great work Puggsie. Does this also include the History?

[paspuggie48]

The Query King reigns supreme! Great work Puggsie. Does this also include the History?

Thanks gstar, unfortunately there is no historic data in this version. However, every day you refresh it you could create another Table (with the same column headers name) and copy and paste the output into it (as per the original version)

[MemphisFlash]

may4th.jpg

[paspuggie48]

may4th.jpg

...be with you !

[gstar1975]

The force is strong in this one.