investment summary template

investment-summary-template investment summary template


investment summary template

This article explains a simple way to create a lottery template: view the latest results and identify patterns.

We use a real lottery, the New Zealand Lotto, a standard 6-by-40-ball game in which you win by drawing the balls in any order. There are 3,838,380 possible combinations, so your odds are 1 to 3.8 million.

The same pattern recognition method can be used for each lottery.

Recent results of the New Zealand lottery

Consider as a starting point the latest result:


At first glance, there seems to be no patterns that we can use. But let’s take a closer look.

There are an equal number of odd and even numbers
Two primes

A quick glance might point to a simple system with an equal number of even and odd numbers, including two prime numbers.

Let’s look at some more results





In three out of the last four results, there were at least two primes, which means that 80% of the most recent results had at least two primes.

We create a lottery template based on the following parameters:

Two primes in each line
Same number of odd and even numbers

Each combination must be in the following format:

Prime, Prime, Odd, Even, Even, Even

In this example we ignore 2 as prime.

Reduction of possible lottery combinations

The goal of a template is to reduce your overall combinations to a level until you can either invest in the lines yourself or create a lottery or syndicate.

We can calculate the combinations with the Excel formula “combin”.

To use the “Combine” formula, simply enter = combine (n, k) in an empty cell. Where “n” is the population size and “k” is the group size.

2 primes: 66 combinations

1 odd number: 8

3 even numbers: 1140

Although these numbers appear small, we need to multiply each set of numbers to get the sum.

Total = 66 x 8 x 1140

total = 902,880

The number of 902,880 is certainly large, but it increases our odds of winning considerably over the 1 to 3.8 million quota we started with.

Here’s the good news: We can further reduce the number by removing unlikely scenarios in each group of combinations. Let’s try a fine-tuning.

Primes: 9
Quote: 7
Even numbers: 15

The above scenario reduces the combinations to 114,660, which is an ideal figure for crowd sourcing or a lottery syndicate.

Examples of the reduction of the combinations could be:

Remove even-numbered lines in a single decile
Ignore some of the low primes
Looking at hot and cold numbers


In this article, some real lottery results have been used to create a template system.

We will follow the results over the next few weeks to tune the system to current figures and remove improbable combinations.

A. Lewis Gibson is a long-time student of number systems and trends. As a seasoned Excel and VBA programmer, he has developed a website that generates all possible lottery number combinations and invites suggestions for their development.

Leave a Reply