Power Query - UK Lotto Draw Numbers

Example spreadsheets and comments on example spreadsheets.
Post Reply
paspuggie48
Posts: 427
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Simple Power Query that scrapes Lotto draw numbers, dating back to 1994 !

Lotto-Draw-History.xlsx

Screenshot 2021-10-11 162725.png

To refresh simple select Data Tab > Refresh All

Design the Table however you wish :D
You do not have the required permissions to view the files attached to this post.
User avatar
Euler
Posts: 21586
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

If you can pull in the number of winners that would be interesting as you can figure out the patterns people enter. I did this quite a few years ago.

You would need to know number of winners for each prize per round.
paspuggie48
Posts: 427
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

The breakdown like this Peter?

Screenshot 2021-10-11 180159.png
You do not have the required permissions to view the files attached to this post.
User avatar
Euler
Posts: 21586
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

Yeah. If you know the winning numbers and number of prize, especially over that period of time. You should be able to get some insight. My one is a bit old now, but I would re-run it if I had the data.

Obviously, you can't increase your chance of winning. But you can suggest better numbers.
Anbell
Posts: 1212
Joined: Fri Apr 05, 2019 2:31 am

Zeljko made some big bucks with this exact premise
Post Reply

Return to “Bet Angel - Example spreadsheets”