Identifying patterns in lotto results can be difficult but one pattern that is consistent is the frequency of prime numbers.

Prime numbers should make up around 30% of all lotto results and this article introduces the idea of moving averages and how they might help improve your own lotto odds.

A moving average is simply the average over a subset or period of data. It becomes a powerful tool when you consider subsequent averages which might indicate a move away or back to the mean.

Prime Numbers And A Random Data Set

The easiest way to test lotto ideas is to create your own random data set which should simulate a series of lotto results.

You need to create a table of random results and calculate how many prime numbers are in each line. Then, we can write some VBA code to calculate the average to see if there are any patterns in the numbers.

You should have a data table looking like this, where the final column is a count of how many primes are in each line.

18 19 26 29 30 33 2

2 9 12 22 35 39 1

6 9 12 19 20 31 2

5 16 20 22 27 29 2

18 20 23 28 31 39 2

3 19 20 27 31 35 3

Now we’re ready to write some VBA code which will calculate the averages.

Lotto Results, VBA Code And Moving Averages

As an example, in our data set above the result with a period of 2 lines would look like this.

18 19 26 29 30 33 2 

2 9 12 22 35 39 1 1.5

6 9 12 19 20 31 2 1.5

5 16 20 22 27 29 2 2

18 20 23 28 31 39 2 2

3 19 20 27 31 35 3 2.5

In our VBA code, we’ll use a period of 10 to get some meaningful results.

The Excel formula to create an average over the first 10 lines is below, where “h” is the column which will hold your results.

=AVERAGE(h1:h10) 

To calculate the next 10 period moving average you simply increment the row number.

=AVERAGE(h1:h10) 

=AVERAGE(h2:h11)

In this example, just type the formula into row “h10” on the right hand column; then we’ll use VBA code to reiterate through the data set.

The code selects the first cell with the formula, calculates how many rows of data there are and then fills in the same formula through the whole data set.

range("h10").activate

i = ActiveCell.Offset(0, -1).End(xlDown).Row

Selection.AutoFill Destination:=Range("H10:h" & i)

Development Of The Lotto Prime Numbers Moving Average

When I ran the moving average module the results came out as expected, with moves away from the median on a regular basis. Some further development of the module might include the following:

• Creating a chart to enable visual identification of trends.
• Highlighting the lines of data that are above or below the global average.
• Determining maximum and minimum variations from the mean.

Summary

This article has introduced the concept of using VBA code to calculate averages of prime numbers in random data sets. The concept can easily be applied to lotto results and with a little creativity other idea and theories can be developed and explored.

Source by A. Lewis Gibson

There are many roulette systems and strategies available to the avid roulette player, some probably as old as the game itself. The majority of these don’t work, if at all. Here I will share two simple outside betting strategies that capitalize on the patterns in roulette. Patterns, you say?

Yes, allow me to explain. As you’re probably aware, many roulette systems bet on numbers that have not shown for some time and felt to be due. These are typically called cold numbers. Some systems try to play repeat numbers or numbers occurring frequently in a specific period of time. These are sometimes called hot numbers. In reality, they are both right. To beat roulette, you must combine both methods. Why?

Because the numbers of the roulette wheel tend to occur in cycles of 21 spins and create what can be called patterns. In addition, certain sets of numbers tend to trend together thus creating what people call “hot” numbers. These numbers will turn “cold” after they run for an unspecified length of time and then stop. The key to winning roulette is exploiting short-term patterns. Basically, play when the numbers are hot and stop when the numbers are cold or bet on a particular pattern.

The challenge is locating the patterns and knowing when to start and stop. Here I offer you one way to do this. The following are two highly profitable outside betting strategies, in particular playing red and black. The only drawback is that they use a 5-step Martingale progression but that is because of how the patterns work. The win rate more than makes up for it. Here’s how they work –

Red & Black Roulette System: Pattern 1

This is an amazing roulette strategy with a high win rate. When you see 5 black or red numbers in a row, you bet the SAME color to win using a 5-bet progression. If a zero occurs in the series, ignore it, and count the numbers as if it weren’t there. It works on both wheels as well as online. Win rate is practically 99%!

Examples:

25 (R)

1 (R)

14 (R)

5 (R)

27 (R)

27 (R)

5 (R)

31 (B)

After you see the fifth red number in a row, you would then bet on RED. You would’ve won on the first bet.

17 (B)

0

35 (B)

20 (B)

15 (B)

17 (B)

5 (R)

22 (B)

You ignore the zero. After the 5th black number, #17, you would’ve started betting on black and won on the second bet with the #22.

Other Even Money Wagers:

You can do the same for all other even money wagers. Wait for 5 high/lows or 5 odd/evens in a row then bet the SAME, not the opposite, to win!

Pattern 2:

Here is another outside bet pattern that occurs frequently. It also plays Red (R) or Black (B). When you see the pattern BBRB bet on Red. When you see RRBR bet on Black. Ignore zeros in the sequence. Progression is also 5 bets. It wins 98-99 out of 100 wagers. That equals $140-$340 using $5 chips.

Example 1:

6

26

15

22

6 (B)

28 (B)

9 (R)

28 (B)

21 (R)

17

3

Reading from top to bottom, this example shows the BBRB pattern winning on Red (#21).

Example 2:

25 (R)

34 (R)

35 (B)

12 (R)

31 (B)

21

5

4

4

1

8

24 (B)

31 (B)

19 (R)

35 (B)

11 (B)

30 (R)

8

32

Reading from top to bottom, this example shows RRBR winning on Black (#31) and the BBRB pattern winning 2 spins later on Red (#30).

Example 3:

25

19 (R)

18 (R)

0

31 (B)

21 (R)

20 (B)

This example demonstrates ignoring the zero in a sequence. The zero interrupts a RRBR pattern but still wins on Black (#20).

Note: This bet also works online but if you plan to test in real money mode, due to the way RNG software works, make sure you have not played Red or Black in the last 6 sessions and keep sessions within 15 minutes or less. Also, after you use this bet to win in a session, you can’t use it again for the next 5 sessions! A session ends when the software is exited for at least 20 minutes, not if you re-start the numbers. Never play at Flash casinos. The numbers do run the same way when playing for fun because software only reacts when playing for real money, so you can verify that this bet works in fun mode. When playing for real money, how you play will have to change but I can’t go into full details in this short document. Of course, live play does not have these restrictions.

Red/Black Progression:

1-2-4-8-16

31 units

This is just one way to use patterns to win roulette. Additionally, there are several other pattern bets that work in conjunction with these outside bets.

Source by Carrie LaShawn

Artificial Intelligence or “AI” can be defined as the “ability of a system to learn from previous experience in an attempt to predict future events”. While this might seem a forlorn hope in making lottery predictions, let’s see if this might be possible.

The big problem in analysing lottery results is the large number of possible combinations. In a standard “40 x 6” ball game there are 3,838,380 lines to choose from.

Generating A Starting Point For A Lotto AI System

It makes sense to reduce the possible number pool before we implement any AI possibilities. I’ll use the “Prime” probability system which assumes there will be 2 primes, 1 odd and 3 even numbers in each winning line.

We’ll try to use AI to group the prime results into some kind of pattern when they do occur.

For example, the last 6 weeks results of NZ Lotto were:

10,15,17,19,35,39

4,16,20,25,29,37

2,10,24,26,29,33

7,14,17,18,25,30

4,20,22,34,36,37

13,14,27,31,38,40

The numbers in results 2,3,4 and 6 meet the prime system criteria so we only want to look at those lines. If we can establish a pattern within the prime results then we can greatly reduce our combinations for when the prime system numbers come up.

We’ll use the Structured Query Language, or SQL, to query the prime system database of all possible lottery combinations; a total 575,586 lines of 6 numbers.

The structure of the database is as follows:

Number types: prime,prime,odd,even,even,even

Column name: n1,n2,n3,n4,n5,n6

For example:

3,5,9,10,14,28

Using A SQL Query To Recognize The Lottery Pattern

What I’ll do is create a SQL query that selects each line of winning prime system numbers. We can then combine the queries in an “and/or” statement to cover the different scenarios.

In this way, we can learn the commonalities between the different results, just like a real life AI application.

Most of the prime results above contained at least one number divisible by 4. We can cover that scenario with this query:

n4%4=0 or n5%4=0 or n6%4=0
Records returned: 525,690 

The percent symbol is a special code in SQL which gives us the remainder from dividing the two numbers.

Each prime line appears to have at least two numbers within 4 of each other. We’ll cover that possibility like this:

(n6-n5<5)

or

(n5-n4<5)
Records returned: 305,316 

We can now combine the queries with the following command:

(n4%4=0 or n5%4=0 or n6%4=0)

and

(

(n6-n5<5)

or

(n5-n4<5)

)

The combined query returned 276,210 combinations, a reduction of around 40%, which is fairly impressive.

I noticed the first even number was always equal to or less than 14 and when I factored that parameter in, the combinations returned were 165,726.

In future weeks I’ll look at other common factors, for example excluding numbers from recent results.

Summary

This article explored the possibility of using AI techniques and SQL to reduce possible combinations. By analysing results that meet certain parameters it should be possible to reduce line numbers and improve our lottery chances.

Source by A. Lewis Gibson