Power Query - UK Lotto Draw Numbers

Post Reply
User avatar
paspuggie48
Posts: 611
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: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

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.
User avatar
paspuggie48
Posts: 611
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: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

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: 2004
Joined: Fri Apr 05, 2019 2:31 am

Zeljko made some big bucks with this exact premise
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Updated version attached

PQLottery.PNG
Lotto-Draw-History Oct 2023.xlsx
You do not have the required permissions to view the files attached to this post.
Johnedale
Posts: 60
Joined: Sat Jul 21, 2018 10:28 pm

Podcast out today about a guy in the US who made money exploiting lottery loopholes https://podcasts.apple.com/gb/podcast/r ... 0632512026
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

Johnedale wrote:
Wed Oct 25, 2023 6:37 pm
Podcast out today about a guy in the US who made money exploiting lottery loopholes https://podcasts.apple.com/gb/podcast/r ... 0632512026
listened to that and definitely relate to a lot of his thinking (albeit on a lot less smarter scale!! :D). I liked in particular the bit where he talks about trying to ensure that the operators perceive you as being dumb and unsavvy. this is definitely a positive trait in the gambling world. Also liked that he spoke about energy vs risk - i.e. that risk, like energy has to go somewhere, therefore talking and sharing ideas helps spread that risk..

interesting stuff!
User avatar
jamesedwards
Posts: 2234
Joined: Wed Nov 21, 2018 6:16 pm

Interesting data. As you might expect, there is an obvious correlation between the number of balls drawn above 30, and the number of winners. Presumably this is because lots of people use birth dates? Also since 10/10/2015 the number of balls increased from 49 to 59 so people still doing the same numbers won't be picking balls in their 50s.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

It's usually the case with lotteries that birthdays (0-12 slightly more that 13--31) are most popular followed by notable numbers like 22 33 44 and primes. And then there's the popular combos like 1 2 3 4 5 6 & 1 11 21 31 41 51 etc

It's academic anyway. There's so many people doing this picking "unpopular" combos you'd probably have to share with more people than you would by choosing at random.
Post Reply

Return to “Excel Power Query”