Power Query - Horse Racing Tips Predictor
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
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.
For you to peruse, analyse and use where you can.
Power Query - Horse Racing Tips Predictor
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Update attached containing 1,999 selections dating back to 30/10/2020.
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Thanks for all your contributions Puggsie!
Top man
Top man
- MemphisFlash
- Posts: 2198
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
More Power Query, Bring it on Boys
-
- Posts: 9
- Joined: Thu Jun 13, 2019 5:36 pm
Hi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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 wrote: ↑Sat Dec 30, 2023 3:10 pmHi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
I've revamped the Predictor tool.iphoneshoey wrote: ↑Sat Dec 30, 2023 3:10 pmHi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
You do not have the required permissions to view the files attached to this post.
- wearthefoxhat
- Posts: 3237
- Joined: Sun Feb 18, 2018 9:55 am
paspuggie48 wrote: ↑Wed May 01, 2024 11:35 amI've revamped the Predictor tool.iphoneshoey wrote: ↑Sat Dec 30, 2023 3:10 pmHi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
Predictor.xlsx
Good work Pugsy.
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Thanks Foxywearthefoxhat wrote: ↑Wed May 01, 2024 12:44 pmpaspuggie48 wrote: ↑Wed May 01, 2024 11:35 amI've revamped the Predictor tool.iphoneshoey wrote: ↑Sat Dec 30, 2023 3:10 pmHi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
Predictor.xlsx
Good work Pugsy.
The Query King reigns supreme! Great work Puggsie. Does this also include the History?wearthefoxhat wrote: ↑Wed May 01, 2024 12:44 pmpaspuggie48 wrote: ↑Wed May 01, 2024 11:35 amI've revamped the Predictor tool.iphoneshoey wrote: ↑Sat Dec 30, 2023 3:10 pmHi
I downloaded the predictor+history spreadsheet
When I update the sheet it gives error could someone have a look please
James
Predictor.xlsx
Good work Pugsy.
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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
- Posts: 2198
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 670
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
...be with you !