To refresh simple select Data Tab > Refresh All
Design the Table however you wish
Power Query - UK Lotto Draw Numbers
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
Simple Power Query that scrapes Lotto draw numbers, dating back to 1994 !
To refresh simple select Data Tab > Refresh All
Design the Table however you wish
To refresh simple select Data Tab > Refresh All
Design the Table however you wish
You do not have the required permissions to view the files attached to this post.
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
The breakdown like this Peter?
You do not have the required permissions to view the files attached to this post.
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.
Obviously, you can't increase your chance of winning. But you can suggest better numbers.
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
Updated version attached
You do not have the required permissions to view the files attached to this post.
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!!Johnedale wrote: ↑Wed Oct 25, 2023 6:37 pmPodcast out today about a guy in the US who made money exploiting lottery loopholes https://podcasts.apple.com/gb/podcast/r ... 0632512026
). 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!
-
jamesedwards
- Posts: 3920
- 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.
-
ShaunWhite
- Posts: 10354
- 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.
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.