Pennsylvania United States
Member #1,340
April 6, 2003
2,584 Posts
Offline
added conditional formatting to backtest mirror hits in the next draw...
2005 results
1. Mid-Day No hits, plenty of 1 and 2 numbers but no hits
2. Eve. 1 straight hit. 3/25 draw was 583, which mirrors to 038... 038 was the 3/26 draw!
wow, even if I just played the mirror number for the next draw eve for $1 straight I would be ahead for the year... I am liking this so far. I wouldn't play the mid-day regardless because I am boycotting PA computer draws (mid3 and mid4 day)
tntea, we're only in the 102 stage and already you are hanging in there with backtesting WTG!
United States
Member #23,382
October 11, 2005
485 Posts
Offline
Ok..I just found this....
GA mid GA Vtrac
11/23/05 566 v122
11/24/05 590 v151
11/25/05 587 v143
11/26/05 385 v441
Missing vtrac 2
2 last seen with 21
1 last seen with 44
Strings to play
244/422 112/221 411/441 124
Now I made a list of the exchange/mirrors
566 011 v for 011 = v122
590 045 v for 045 = v151
587 043 v for 043 = v154
385 830 v for 830 = v441
Now by looking above..I see that 2 strings I am saying to play have each hit twice in the last 4 days..the 2 are v122 and 441
I am still not sure if I have the correct strings in play or not...I may not be fully understanding this "last seen with" info..I have reread all 3 threads 4 times...lol..I will do so again, til I get it right..
Switching between Fairfax, VA and Belgium Belgium
Member #19,286
July 29, 2005
2,254 Posts
Offline
added conditional formatting to backtest mirror hits in the next draw...
2005 results
1. Mid-Day No hits, plenty of 1 and 2 numbers but no hits
2. Eve. 1 straight hit. 3/25 draw was 583, which mirrors to 038... 038 was the 3/26 draw!
wow, even if I just played the mirror number for the next draw eve for $1 straight I would be ahead for the year... I am liking this so far. I wouldn't play the mid-day regardless because I am boycotting PA computer draws (mid3 and mid4 day)
tntea, we're only in the 102 stage and already you are hanging in there with backtesting WTG!
Total draws for Arizona Pick3 : 2313
Straight mirror hits : 2
Boxed mirror hits : 4 (doubles: 4)
Cost to play ($2/draw) : $4626
Retrieved : $3000
------------------------------- - $1626
Total draws for California Daily 3 : 2700
Straight mirror hits : 2
Boxed mirror hits : 15 (doubles: 0)
Cost to play ($2/draw) : $5400
Retrieved : $4050
------------------------------- - $1350
Total draws for Georgia Cash3 (evening, only 2005) : 331
Straight mirror hits : 0
Boxed mirror hits : 0 (doubles: 0)
Cost to play ($2/draw) : $662
Retrieved : $0
------------------------------- - $662
Total draws for Georgia Midday 3 (only 2005) : 284
Straight mirror hits : 0
Boxed mirror hits : 2 (doubles: 2)
Cost to play ($2/draw) : $568
Retrieved : $600
------------------------------- + $32
Total draws for Illinois daily 3 Eve : 3225
Straight mirror hits : 2
Boxed mirror hits : 15 (doubles: 0)
Cost to play ($2/draw) : $6450
Retrieved : $4050
------------------------------- - $2400
Total draws for Illinois midday 3 : 2765
Straight mirror hits : 5
Boxed mirror hits : 19 (doubles: 0)
Cost to play ($2/draw) : $5530
Retrieved : $7350
------------------------------- + $1820
Total draws for New York midday : 1453
Straight mirror hits : 2
Boxed mirror hits : 11 (doubles: 0)
Cost to play ($2/draw) : $2906
Retrieved : $3450
------------------------------- + $544
Total draws for New York numbers : 2694
Straight mirror hits : 3
Boxed mirror hits : 8 (doubles: 8)
Cost to play ($2/draw) : $5388
Retrieved : $5100
------------------------------- - $288
Total draws for Pennsylvania Daily number : 2700
Straight mirror hits : 3
Boxed mirror hits : 18 (doubles: 0)
Cost to play ($2/draw) : $5400
Retrieved : $5400
-------------------------------
$0
Total draws for Pennsylvania Midday : 1021
Straight mirror hits : 2
Boxed mirror hits : 5 (doubles: 0)
Cost to play ($2/draw) : $2042
Retrieved : $2550
------------------------------- + $508
Total draws for South Carolina Midday 3 : 754
Straight mirror hits : 0
Boxed mirror hits : 3 (doubles: 0)
Cost to play ($2/draw) : $1508
Retrieved : $450
------------------------------- - $1058
Total draws for South Carolina Pick3 : 1362
Straight mirror hits : 2
Boxed mirror hits : 8 (doubles: 0)
Cost to play ($2/draw) : $2724
Retrieved : $3000
------------------------------- + $276
Total draws for Virginia midday 3 : 2315
Straight mirror hits : 1
Boxed mirror hits : 19 (doubles: 0)
Cost to play ($2/draw) : $4630
Retrieved : $3750
------------------------------- - $880
Pennsylvania United States
Member #1,340
April 6, 2003
2,584 Posts
Offline
wow paurths, nice data to have!
PA evening seems a bit light on draws(@2700)...
I stopped tracking pick3 in PA eve 7/25/2004....
from inception (3/1/1977) until 7/25/2004 there were 9,357 draws.
I will eventually backtest against all of 'em, but tntea isn't done with the lessons just yet.
also they had an area after 7/25/04 where they had a "bonus draw" on the same night if a green ball came up.... that lasted a few months and I need to add all of that data yet.
Switching between Fairfax, VA and Belgium Belgium
Member #19,286
July 29, 2005
2,254 Posts
Offline
wow paurths, nice data to have!
PA evening seems a bit light on draws(@2700)...
I stopped tracking pick3 in PA eve 7/25/2004....
from inception (3/1/1977) until 7/25/2004 there were 9,357 draws.
I will eventually backtest against all of 'em, but tntea isn't done with the lessons just yet.
also they had an area after 7/25/04 where they had a "bonus draw" on the same night if a green ball came up.... that lasted a few months and I need to add all of that data yet.
I don't have all the drawings, i know.
Not all official sites offer a download-possibility that is somewhat "workable" before importing it into my database.
If it's too much trouble, i get the draws from another place, but it only goes back until 1998.
United States
Member #5,344
June 30, 2004
23,639 Posts
Offline
I did a little LP search and found this list, attributed to adolph's forum, research credits to Laverne...
Travelling Number Mirror States:
IOWA = MAINE
IOWA = OREGON
OHIO = NEW YORK
VERMONT = ONTARIO
KANSAS = IDAHO
TEXAS = QUEBEC or KENTUCKY
MAINE = KENTUCKY
OREGON = FLORIDA
MONTANA = KENTUCKY
NEW YORK = ARIZONA
ONTARIO = MARYLAND
IDAHO = FLORIDA or MISSOURI
QUEBEC = MISSOURI
KENTUCKY = ILLINOIS
ARIZONA = INDIANA
MARYLAND = MINNESOTA
FLORIDA = NEW JERSEY
MISSOURI = TRI-STATE
NEBRASKA = GEORGIA
ILLINOIS = GEORGIA
INDIANA = VIRGINIA
MINNESOTA = DELAWARE
NEW JERSEY = WISCONSIN
TRI-STATE = LOUISIANA
GEORGIA = NEW MEXICO
VIRGINIA = MICHIGAN DELAWARE = PENNSYLVANIA WISCONSIN = WASHINGTON
LOUISIANA = CALIFORNIA
NEW MEXICO = CONNECTICUT
MICHIGAN = SOUTH CAROLINA PENNSYLVANIA = WEST VIRGINIA WASHINGTON = WASHINGTON DC
CALIFORNIA = NEW HAMPSHIRE
CONNECTICUT = MASSACHUSETTS
CONNECTICUT = WEST CANADA
SOUTH CAROLINA = BRITISH COLUMBIA
WEST VIRGINIA = IOWA
WASHINGTON DC = OHIO
NEW HAMPSHIRE = KANSAS
MASSACHUSETTS = OREGON
WESTERN CANADA = TEXAS
BRITISH COLUMBIA = MAINE
I might use that for a start...
I Have printed this and will check it out myself..
Pennsylvania United States
Member #1,340
April 6, 2003
2,584 Posts
Offline
wow paurths, nice data to have!
PA evening seems a bit light on draws(@2700)...
I stopped tracking pick3 in PA eve 7/25/2004....
from inception (3/1/1977) until 7/25/2004 there were 9,357 draws.
I will eventually backtest against all of 'em, but tntea isn't done with the lessons just yet.
also they had an area after 7/25/04 where they had a "bonus draw" on the same night if a green ball came up.... that lasted a few months and I need to add all of that data yet.
I don't have all the drawings, i know.
Not all official sites offer a download-possibility that is somewhat "workable" before importing it into my database.
If it's too much trouble, i get the draws from another place, but it only goes back until 1998.
I pulled data from PA's site one year at a time, then simply pasted it into excel, sorted by date ascending, cleaned up the formatting, and it was ready for export/"save as" to any type of file (including CSV, for database import)
17 years (at the time) in under 10 minutes ;-)
I am still updating the entire list to date, I am wondering if MS access might be a better choice... or at least maintain an access DB along with the excel sheets...
United States
Member #5,344
June 30, 2004
23,639 Posts
Offline
wow paurths, nice data to have!
PA evening seems a bit light on draws(@2700)...
I stopped tracking pick3 in PA eve 7/25/2004....
from inception (3/1/1977) until 7/25/2004 there were 9,357 draws.
I will eventually backtest against all of 'em, but tntea isn't done with the lessons just yet.
also they had an area after 7/25/04 where they had a "bonus draw" on the same night if a green ball came up.... that lasted a few months and I need to add all of that data yet.
I don't have all the drawings, i know.
Not all official sites offer a download-possibility that is somewhat "workable" before importing it into my database.
If it's too much trouble, i get the draws from another place, but it only goes back until 1998.
I pulled data from PA's site one year at a time, then simply pasted it into excel, sorted by date ascending, cleaned up the formatting, and it was ready for export/"save as" to any type of file (including CSV, for database import)
17 years (at the time) in under 10 minutes ;-)
I am still updating the entire list to date, I am wondering if MS access might be a better choice... or at least maintain an access DB along with the excel sheets...
Pennsylvania United States
Member #1,340
April 6, 2003
2,584 Posts
Offline
ok, neither WV or DE have sunday drawings... and WV has no mid-day
would it be better to just stick with PA?
You are going to basically observe what comes out a fews prior to your state.. it doesn't matter if they have a day off..
TX has Sunday off but provides me with info on TN picks
then I guess I will add DE... WV having no mid-day at all seems a bigger hurdle than every 7th day off...right?
actually DE has no sunday MID draw... tricky import, but now I have a version that has PA and mirror DE... If requesting a copy, please specify single state (Still PA, just change numbers), 1 mirror state (PA and DE, again just change numbers) or both.
I don't plan on doing multi-state mirrors, it's too hard to see in excel... I'll leave that to the hearty pencil and paper crew!
Pennsylvania United States
Member #1,340
April 6, 2003
2,584 Posts
Offline
Quote tntea:
"I could use some lessons on that..."
pulling draw data from state websites? anytime... we all owe you big!
I never hesitate to give back to the LP community with excel when I can... I learned ALOT about excel here in the forums. there are a bunch of tech-savvy excel wizards on the LP doing some very creative things, and I thank them all for what I have gained skill-wise.