Welcome Guest
You last visited December 9, 2016, 8:10 pm
All times shown are
Eastern Time (GMT-5:00)

# The GELE Filter - P3

Topic closed. 15 replies. Last post 7 years ago by retxx.

 Page 1 of 2

United States
Member #7437
October 3, 2004
383 Posts
Offline
 Posted: February 24, 2010, 1:04 pm - IP Logged

Hi Everyone:

Here's another filter for your toolbox. It's called the GELE filter, (GE = greater than or equal to, LE = less than or equal to).

Here's how it works: Let the digits of an arbitrary draw be A, B and C. We get a set of stats over a set of N past draws. The stats tell us how many times A GE B, B GE A , etc. In addition, we get a set of GELE stats for the pairs, AB, AC, and BC, i.e, how many time AB GE BC, BC GE AC, etc. Over the long haul the numbers in the GELE comparisons should be close to equal, but for the short term there are often noticeable trends. This filter can be very useful, for example in playing sums. If you find from the stats, for example, that B GE A has not been happening as often as expected, by only considering plays where A GE B can reduce the number of straight plays by one half.

Here's how to get started. Go to the link

http://cid-53e66599b04974a6.skydrive.live.com/browse.aspx/GELE%5E_P3

and download geleStats.exe to a working direcrory. Prepare a past draw text file called drawsP3.txt and place it in the same directory. The drawsP3.txt file should contain only one entry per line. No spaces or extra characters, latest draw on top and oldest draw on bottom. Also the text file should be ASCII encoded.

Click on the geleStats.exe icon and you'll see a pop up window asking you how many past draws you want stats on.  Pick a large number , say 100 or more, for long term trends and a smaller amount for short term trends. The stats are written to the console, and after exiting, you'll find the same output written to a file called p3Stats4GELE.txt.

Here's an example from the NY Midday P3 using a past draw file containing 100 entries. We started from Jan. 1, 2010 going back 100 draws. Here are the stats for those 100 draws:

*************GELE Digit Stats***********
A GE B - 59
B GE A - 53
A GE C - 57
C GE A - 47
B GE C - 60
C GE B - 50

*************GELE Pair Stats***********
AB GE BC - 56
BC GE AC - 53
AC GE BC - 59
BC GE AC - 53
AB GE AC - 60
AC GE AB - 50

For the pairs and the digits the 60 is a stick out (B GE C and AB GE AC), because we should be expecting a number closer to 50.

Below are the next 5 days worth of draws for the NY P3 Midday.  Let's see how many draws showed a reversal(C GE B or AC GE AB)

A B C

Jan 6 '10    3 7 8
Jan 5 '10    2 3 0
Jan 4 '10    7 6 8
Jan 3 '10    0 2 8
Jan 2 '10    1 5 6

On Jan2, 3, 4, and 6  C came out GE B. On Jan 2, 3, 4 and 6 AC came out GE AB.

WINSUMLOOSESUM : In case you are listening to this thread, this would be very easy to implement in EXCEL.

Try this filter out on your circuit. It looks promising.

jayemmar

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: February 24, 2010, 10:24 pm - IP Logged

tried to download,got an error. can you help? hope someone writes this to excel. would be great.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 24, 2010, 11:26 pm - IP Logged

tried to download,got an error. can you help? hope someone writes this to excel. would be great.

Here is the Excel program for GELE.

Create a new folder and unzip the 2 Excel files into your newly named folder.

There is 1 Excel file with all the Pick 3 draws and the 2nd called Doubles that has the GE-LE Tab (3rd one form the left)

You need to have both Excel files opened for this to work.   This is with Excel 2002 by the way.

If you click the 1st Tab (Doubles.xls) you will see all the Tab labeled "Toolbars" that contains all the states (midday, evening, and combined)

You can click any states' toolbar.  For example you can click NY3M for New York Midday Pick 3 only draws jsut like jayemmar's New York midday example.

In the GE-LE Tab you can adjust the number of draws to show the hits for each GE-LE. In cell B1 and B2 you can change the 1 and 100 to whatever you wish.  For example B1 = 54 and B2 = 153.  This would give you the 100 past draws for New York Midday Pick 3 draws from Jan 1 2010 going back 100 draws.  This is the same calculations jayemmar used in the 1st  thread.

Let me know if you have any questions.

Here i the download link to the zip file.  Remember to create a new folder first.  Then unzip the 2 Excel files into this newly named folder.

Have fun!!

http://www.box.net/shared/ubn6a395t9

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 25, 2010, 7:27 am - IP Logged

http://www.box.net/shared/pj0v7o1pf7

United States
Member #7437
October 3, 2004
383 Posts
Offline
 Posted: February 25, 2010, 10:56 am - IP Logged

Hi winsumloosesum:

I'm going to leave this one for you, since everyone likes to work with EXCEL. Let's tackle the P4 with the GELE filter. Each P4 can be represented by ABCD, where A,B, C and D are between 0 and 9. So we need stats for:

A GE B, B GE C,  C GE D etc. Also we need a set of stats for the pairs, AB, BC, AC, AD, BD, CD. In addition, we can add stats for the four triples, ABC, ABD, BCD, ACD(ABC GE BCD, etc.).

This filter looks like it can be very valuable in the P3 and P4.

jayemmar

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 25, 2010, 7:17 pm - IP Logged

Hi winsumloosesum:

I'm going to leave this one for you, since everyone likes to work with EXCEL. Let's tackle the P4 with the GELE filter. Each P4 can be represented by ABCD, where A,B, C and D are between 0 and 9. So we need stats for:

A GE B, B GE C,  C GE D etc. Also we need a set of stats for the pairs, AB, BC, AC, AD, BD, CD. In addition, we can add stats for the four triples, ABC, ABD, BCD, ACD(ABC GE BCD, etc.).

This filter looks like it can be very valuable in the P3 and P4.

jayemmar

Create a new folder.  Name it whatever you wish (example: Pick 4 GE LE)

http://www.box.net/shared/g7x8mlq1c0

Unzip the 2 Excel files from the zip file into your newly named folder (Pick 4 GE LE)

Open the P4Draws.xls Excel file first and then open the GELE.xls Excel file 2nd.

In the GELE Excel file, go to the Tab labeled "Toolbars" and you will see all the Toolbars for all the states (Midday, Evening, and Combined)

Click your states Toolbar and the macro will transfer 1000 past draws to the Calculations Tab.

Go to the GE-LE Tabs for "Digits", "Pairs", and "Trips"

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 26, 2010, 8:28 am - IP Logged

Updated state drawings Excel files.

Create a new folder on your desktop and name it "Draw Updates" (without quotes)

http://www.box.net/shared/rlpo4q0f0s

4.  Unzip the contents of the Zip file (P3StateDraws.xls & P4StateDraws.xls) into the "Draw Updates" folder.

5.  You should have 2 folders you created previously from the earlier posts.  "Pick 4 GELE" and "Pick 3 GELE" (or whatever folder name you created)

6.  Copy and paste  the P3StateDraws.xls Excel file from the "Draw Updates" folder to the "Pick 3 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

7.  Copy and paste  the P4StateDraws.xls Excel file from the "Draw Updates"folder to the "Pick 4 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

8.  Now you have the most current Draing files in both folders.

9.  Follow the instructions in the previous posts on how to run your states' calculations.

Good Luck!!

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: February 26, 2010, 9:10 am - IP Logged

when I opened doubles folder and clivk on f-48/49 i get runtime error"9" subscript out of range. what now?

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 26, 2010, 10:03 am - IP Logged

when I opened doubles folder and clivk on f-48/49 i get runtime error"9" subscript out of range. what now?

1.  Both the P3StateDraws.xls and the Doubles.xls Excel files should be in the same folder

2.  Open the P3StateDraws.xls file 1st

3.  When the P3StateDraws.xls file opens go to the top of the Main Menu and choose >File > Open.  Then open the second Excel file Doubles.xls in your Pick 3 GELE Folder (or whatever folder you named it)

4.  You should now have both Excel files opened.  You need both open for this to work

5.  Next, in the Doubles.xls Excel file go to the "States" Tab and select your states Toolbar.  So retxx, you would select Mass Midday, Evening, or Combined in cell rows 48 &49

You need both Excel files open for this to work.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 27, 2010, 11:54 am - IP Logged

Updated state drawings Excel files.

Create a new folder on your desktop and name it "Draw Updates" (without quotes)

http://www.box.net/shared/rlpo4q0f0s

4.  Unzip the contents of the Zip file (P3StateDraws.xls & P4StateDraws.xls) into the "Draw Updates" folder.

5.  You should have 2 folders you created previously from the earlier posts.  "Pick 4 GELE" and "Pick 3 GELE" (or whatever folder name you created)

6.  Copy and paste  the P3StateDraws.xls Excel file from the "Draw Updates" folder to the "Pick 3 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

7.  Copy and paste  the P4StateDraws.xls Excel file from the "Draw Updates"folder to the "Pick 4 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

8.  Now you have the most current Draing files in both folders.

9.  Follow the instructions in the previous posts on how to run your states' calculations.

Good Luck!!

http://www.box.net/shared/ndhsen22i2

Draws updated through Friday Feb 26 2010

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: February 28, 2010, 10:53 am - IP Logged

can you explain how you came up with those #'s from the 2nd to the 6th to play. Where would they be on which chart on doubles.? thanks

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 28, 2010, 11:03 am - IP Logged

What Jayemmar I beleive is looking for is high GELE (Greater Than Equal To or Less Than Equal T0) values based on "X" amount of past draws.  For example, read the 1st post.  If the GELE value for example for for Front Pairs is high for Great Than (GE) then look for a reversal of a lesser Pair.  Jayemmar was just showing the next few drawings after he ran the GELE program to show you how digits or pairs reversed because of the high GELE value.  Jayemmar can explain better than my explanation.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 28, 2010, 11:11 am - IP Logged

Hi Everyone:

Here's another filter for your toolbox. It's called the GELE filter, (GE = greater than or equal to, LE = less than or equal to).

Here's how it works: Let the digits of an arbitrary draw be A, B and C. We get a set of stats over a set of N past draws. The stats tell us how many times A GE B, B GE A , etc. In addition, we get a set of GELE stats for the pairs, AB, AC, and BC, i.e, how many time AB GE BC, BC GE AC, etc. Over the long haul the numbers in the GELE comparisons should be close to equal, but for the short term there are often noticeable trends. This filter can be very useful, for example in playing sums. If you find from the stats, for example, that B GE A has not been happening as often as expected, by only considering plays where A GE B can reduce the number of straight plays by one half.

Here's how to get started. Go to the link

http://cid-53e66599b04974a6.skydrive.live.com/browse.aspx/GELE%5E_P3

and download geleStats.exe to a working direcrory. Prepare a past draw text file called drawsP3.txt and place it in the same directory. The drawsP3.txt file should contain only one entry per line. No spaces or extra characters, latest draw on top and oldest draw on bottom. Also the text file should be ASCII encoded.

Click on the geleStats.exe icon and you'll see a pop up window asking you how many past draws you want stats on.  Pick a large number , say 100 or more, for long term trends and a smaller amount for short term trends. The stats are written to the console, and after exiting, you'll find the same output written to a file called p3Stats4GELE.txt.

Here's an example from the NY Midday P3 using a past draw file containing 100 entries. We started from Jan. 1, 2010 going back 100 draws. Here are the stats for those 100 draws:

*************GELE Digit Stats***********
A GE B - 59
B GE A - 53
A GE C - 57
C GE A - 47
B GE C - 60
C GE B - 50

*************GELE Pair Stats***********
AB GE BC - 56
BC GE AC - 53
AC GE BC - 59
BC GE AC - 53
AB GE AC - 60
AC GE AB - 50

For the pairs and the digits the 60 is a stick out (B GE C and AB GE AC), because we should be expecting a number closer to 50.

Below are the next 5 days worth of draws for the NY P3 Midday.  Let's see how many draws showed a reversal(C GE B or AC GE AB)

A B C

Jan 6 '10    3 7 8
Jan 5 '10    2 3 0
Jan 4 '10    7 6 8
Jan 3 '10    0 2 8
Jan 2 '10    1 5 6

On Jan2, 3, 4, and 6  C came out GE B. On Jan 2, 3, 4 and 6 AC came out GE AB.

WINSUMLOOSESUM : In case you are listening to this thread, this would be very easy to implement in EXCEL.

Try this filter out on your circuit. It looks promising.

jayemmar

*************GELE Digit Stats***********
A GE B - 59
B GE A - 53
A GE C - 57
C GE A - 47
B GE C - 60
C GE B - 50

*************GELE Pair Stats***********
AB GE BC - 56
BC GE AC - 53
AC GE BC - 59
BC GE AC - 53
AB GE AC - 60
AC GE AB - 50

====================================

In the "Digit Stats" above you see "B GE (Greater Than or Equal) to C - 60".  This means that the second position "B" has been greater than the 3rd position "C" 60 times in the last 100 draws.  So look for a reverse meaning B (2nd Position) now being LE (Less than or Equal To the 3rd Position)

Same goes for the "GELE" Pair Stats. "AB GE AC - 60"  The front pair AB is GE (Greater than or Equal to) the Side Pair AC in the last 100 draws 60 times.  So look for a reversal of the AB (front pair) being LE (less than or equal to) the side pair AC.

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: March 1, 2010, 10:58 am - IP Logged

DIGITS   (>=   GE)                              Index     Average
1ST     > =     2ND     A     GE     B     0.63     1.59
2ND     > =     1ST     B     GE     A     0.90     2.22
1ST     > =     3RD     A     GE     C     0.64     1.56
3RD     > =     1ST     C     GE     A     0.49     2.04
2ND     > =     3RD     B     GE     C     0.98     2.04
3RD     > =     2ND     C     GE     B     0.61     1.64

PAIRS   (>=   GE)                              Index     Average
FRONT     > =     BACK     AB     GE     BC     0.59     1.69
BACK     > =     FRONT     BC     GE     AB     0.82     2.44
SIDE     > =     BACK     AC     GE     BC     0.63     1.59
BACK     > =     SIDE     BC     GE     AC     0.90     2.22
FRONT     > =     SIDE     AB     GE     AC     0.98     2.04
SIDE     > =     FRONT     AC     GE     AB     0.61     1.64
here are Mass #'s. what would you play for next days play?

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: March 1, 2010, 8:16 pm - IP Logged

can you walk me thru my example and step by step how to come up with plays. Thanks

 Page 1 of 2