AllinCalc for PT3 v0.96 (Updated 12/4)

[advis0r]

btw: until now, the query (and thus programm) does not consider hands where there is a sidepot after someone is allin, or when its a multiway allin.

[advis0r]

bump with newer version:
http://rapidshare.com/files/148842512/A ... 4.zip.html

users: read the first post in this thread!

if you notice some odd values use debug_mode = 2 and report the errors with the hand history.

@moderators: can someone fix the bb code in the first post?

[Peligroso]

@moderators: can someone fix the bb code in the first post?

done, updated the first post with the new link too

[balder]

I have run the program now and im only getting 11 allin-pots over 5k HU hands. Does it not calculate the times opponents with shortstacks went allin and i called?

[GbjAndyS]

Great tool ! Thank you very much !
P.S.: Cannot share the code with Josh so can be integrated in the PokerTracker3 client interface ?

[advis0r]

I have run the program now and im only getting 11 allin-pots over 5k HU hands. Does it not calculate the times opponents with shortstacks went allin and i called?

are you 100% sure that you should be seeing much more allins being listed?
is it possible that u have false expectations about the number of hands where you were allin with cards to come?

if you are sure, can u find a hand in your database that doesnt get listed?

if the program missing out some it is due to the sql query not selecting every allin pot, shouldnt have anything to do with shortstacks going allin and u calling

Great tool ! Thank you very much !
P.S.: Cannot share the code with Josh so can be integrated in the PokerTracker3 client interface ?

my code is in java and there is no "easy way" to just integrate it into pt3.
also i'm pretty sure Josh will integrate EV features into PT3 sometime in the future and thus the speed, detail and filtering will be much better overall anyway

[balder]

yes i can find some.
it looks like it's only counting hands played on the 28'th and 29'th.

here's the settings.

-- AllinCalc for PT3 v0.94 --
db_host:
db_name:
db_user:
screenname:
filter_since: 2005-12-31
filter_until: none
filter_stake: none
filter_maxev: 1.0
filter_minev: 0.0
filter_site: none

[ 2008-09-28 14:21:37 ] [ 5h 7h ] [ Kh 8h ] [ 5d Jh 8d 7c _ Ah ] [ 0,8182 ]
[ 2008-09-28 14:36:40 ] [ Qd As ] [ 3h 3d ] [ 8h 2s Ts _ 9h 7d ] [ 0,3152 ]
[ 2008-09-28 16:47:28 ] [ Qs Ts ] [ 9s 7h ] [ 7d Qh 2d _ 8h Qd ] [ 0,8162 ]
[ 2008-09-28 16:55:42 ] [ Qd Ah ] [ Tc Jc ] [ Td 7c 4c As _ 5s ] [ 0,6818 ]
[ 2008-09-28 16:57:34 ] [ Ts Th ] [ 9s 9c ] [ _ 9d 8c 7s Ac 8h ] [ 0,8200 ]
[ 2008-09-28 17:12:44 ] [ Ad 8d ] [ 7h 7c ] [ 5h 3d Kd 6d _ 2s ] [ 1,0000 ]
[ 2008-09-28 17:37:55 ] [ Kc Qd ] [ As 4d ] [ Qc Qs 8c _ 3s 8d ] [ 0,9970 ]
[ 2008-09-28 17:46:13 ] [ 2d Ad ] [ Js Ks ] [ 6c 2s As _ 8d 9s ] [ 0,6596 ]
[ 2008-09-28 17:47:04 ] [ 7s Qs ] [ Js 9d ] [ _ Kc 6d Td 6c Jd ] [ 0,5850 ]
[ 2008-09-28 18:33:13 ] [ 8d 9d ] [ 2s Kd ] [ 2h 7d 8h _ Ac 9h ] [ 0,8061 ]
[ 2008-09-28 18:55:34 ] [ Kc Kh ] [ 7c 2c ] [ 6s 8h 2d 5h _ 7d ] [ 0,7045 ]
[ 2008-09-29 17:00:00 ] [ 8c Jd ] [ 7c 3s ] [ _ 6d Th 2h 8s Kc ] [ 0,6754 ]
[ 2008-09-29 17:08:35 ] [ 8h Kh ] [ 6s 5h ] [ Tc 6c Kd 6h _ Qh ] [ 0,0455 ]
[ 2008-09-29 17:08:42 ] [ Ac As ] [ Js Ts ] [ 4s Jd 9s 5s _ 4d ] [ 0,1591 ]
[ 2008-09-29 17:15:56 ] [ Kh Kd ] [ Ac Qc ] [ _ 6h 8d Qd 7s Ts ] [ 0,6788 ]

found 15 headsup allin situations
won: 8 lost: 7 tied: 0
average potsize:
average ev: 0,6508
money won:
money expected (based on allin equity):
money difference:
max money diff: 2008-09-28 14:21:37 at
min money diff: 2008-09-29 17:08:42 at
>>> Be aware that the calculated numbers might not be 100% accurate! <<<

could it be a filter in PT3?

[archangel95]

Approximately how long does this take to run on a db of about 600,000 hands?

[advis0r]

yes i can find some.
it looks like it's only counting hands played on the 28'th and 29'th.
...
could it be a filter in PT3?

it does find hands on all dates for me and i dont see a reason why it shouldnt.
are you sure there are allin hands on other dates that dont get found?
in your quoted output you cut out a lot of text, right?

also the pt3 filter has nothing to do with it, since the program operates on the database directly.

Approximately how long does this take to run on a db of about 600,000 hands?

try it, usually quite fast

[balder]

yes i cut out alot of stuff

here's the full one:

-- AllinCalc for PT3 v0.94 --
db_host: localhost
db_name: PT3 DB
db_user: postgres
screenname: name removed
filter_since: 2005-12-31
filter_until: none
filter_stake: none
filter_maxev: 1.0
filter_minev: 0.0
filter_site: none

[ 2008-09-28 14:21:37 ] [ 5h 7h ] [ Kh 8h ] [ 5d Jh 8d 7c _ Ah ] [ 0,8182 ] [ 104,80$ / 85,75$ / 104,80$ / +19,05$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 14:36:40 ] [ Qd As ] [ 3h 3d ] [ 8h 2s Ts _ 9h 7d ] [ 0,3152 ] [ 64,40$ / 20,30$ / 0,00$ / -20,30$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 16:47:28 ] [ Qs Ts ] [ 9s 7h ] [ 7d Qh 2d _ 8h Qd ] [ 0,8162 ] [ 22,68$ / 18,51$ / 22,68$ / +4,17$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 16:55:42 ] [ Qd Ah ] [ Tc Jc ] [ Td 7c 4c As _ 5s ] [ 0,6818 ] [ 34,10$ / 23,25$ / 34,10$ / +10,85$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 16:57:34 ] [ Ts Th ] [ 9s 9c ] [ _ 9d 8c 7s Ac 8h ] [ 0,8200 ] [ 33,00$ / 27,06$ / 0,00$ / -27,06$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 17:12:44 ] [ Ad 8d ] [ 7h 7c ] [ 5h 3d Kd 6d _ 2s ] [ 1,0000 ] [ 64,96$ / 64,96$ / 64,96$ / +0,00$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 17:37:55 ] [ Kc Qd ] [ As 4d ] [ Qc Qs 8c _ 3s 8d ] [ 0,9970 ] [ 28,30$ / 28,21$ / 28,30$ / +0,09$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 17:46:13 ] [ 2d Ad ] [ Js Ks ] [ 6c 2s As _ 8d 9s ] [ 0,6596 ] [ 98,00$ / 64,64$ / 0,00$ / -64,64$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 17:47:04 ] [ 7s Qs ] [ Js 9d ] [ _ Kc 6d Td 6c Jd ] [ 0,5850 ] [ 7,41$ / 4,34$ / 0,00$ / -4,34$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 18:33:13 ] [ 8d 9d ] [ 2s Kd ] [ 2h 7d 8h _ Ac 9h ] [ 0,8061 ] [ 22,70$ / 18,30$ / 22,70$ / +4,40$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-28 18:55:34 ] [ Kc Kh ] [ 7c 2c ] [ 6s 8h 2d 5h _ 7d ] [ 0,7045 ] [ 45,70$ / 32,20$ / 0,00$ / -32,20$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-29 17:00:00 ] [ 8c Jd ] [ 7c 3s ] [ _ 6d Th 2h 8s Kc ] [ 0,6754 ] [ 1,81$ / 1,22$ / 1,81$ / +0,59$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-29 17:08:35 ] [ 8h Kh ] [ 6s 5h ] [ Tc 6c Kd 6h _ Qh ] [ 0,0455 ] [ 30,80$ / 1,40$ / 0,00$ / -1,40$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-29 17:08:42 ] [ Ac As ] [ Js Ts ] [ 4s Jd 9s 5s _ 4d ] [ 0,1591 ] [ 98,20$ / 15,62$ / 0,00$ / -15,62$ ] [ IPN ] [ $0.50 NL ]
[ 2008-09-29 17:15:56 ] [ Kh Kd ] [ Ac Qc ] [ _ 6h 8d Qd 7s Ts ] [ 0,6788 ] [ 106,60$ / 72,36$ / 106,60$ / +34,24$ ] [ IPN ] [ $0.50 NL ]

found 15 headsup allin situations
won: 8 lost: 7 tied: 0
average potsize: 50,90$
average ev: 0,6508
money won: 385,95$
money expected (based on allin equity): 478,11$
money difference: -92,16$
max money diff: 2008-09-28 14:21:37 at +19,05$
min money diff: 2008-09-29 17:08:42 at -126,40$
>>> Be aware that the calculated numbers might not be 100% accurate! <<<


Here are some that's not on the list.

GAME #1185645279: Texas Hold'em NL $0.25/$0.50 2008-09-27 00:14:28
Tablename removed
Seat 3: Alkaholik74 ($26.27 in chips)
Seat 8: name removed($78.69 in chips) DEALER
name removed: Post SB $0.25
Alkaholik74: Post BB $0.50
*** HOLE CARDS ***
Dealt to name removed[DA HK]
name removed: Call $0.25
Alkaholik74: Raise (NF) $2.00
name removed: Raise (NF) $78.69
Alkaholik74: Allin $24.27
*** FLOP *** [C4 D2 C2]
*** TURN *** [H8]
*** RIVER *** [C9]
*** SUMMARY ***
Total pot $103.96 Rake $1.00
Alkaholik74: Shows [C5 D5]
Alkaholik74: wins $51.54
name removed: wins $52.42

GAME #1185629744: Texas Hold'em NL $0.25/$0.50 2008-09-27 00:01:46
Tablename removed
Seat 3: Alkaholik74 ($15.01 in chips)
Seat 8: name removed($94.40 in chips) DEALER
name removed: Post SB $0.25
Alkaholik74: Post BB $0.50
*** HOLE CARDS ***
Dealt to name removed[SA HK]
name removed: Call $0.25
Alkaholik74: Raise (NF) $2.00
name removed: Raise (NF) $94.40
Alkaholik74: Allin $13.01
*** FLOP *** [C4 D4 H8]
*** TURN *** [C9]
*** RIVER *** [CQ]
*** SUMMARY ***
Total pot $108.41 Rake $1.00
Alkaholik74: Shows [DK S9]
Alkaholik74: wins $29.02
name removed: wins $79.39

GAME #1171744093: Texas Hold'em NL $0.25/$0.50 2008-09-18 18:25:58
Tablename removed
Seat 3: asseskiller ($48.50 in chips)
Seat 8: name removed($78.29 in chips) DEALER
name removed: Post SB $0.25
asseskiller: Post BB $0.50
*** HOLE CARDS ***
Dealt to name removed[H10 C10]
name removed: Raise (NF) $1.50
asseskiller: Call $1.00
*** FLOP *** [D3 H3 H2]
asseskiller: Check
name removed: Bet $2.50
asseskiller: Raise (NF) $5.00
name removed: Raise (NF) $9.00
asseskiller: Call $4.00
*** TURN *** [DK]
asseskiller: Bet $38.00
name removed: Call $38.00 <-------- no comments on call please
*** RIVER *** [C5]
*** SUMMARY ***
Total pot $96.00 Rake $1.00
asseskiller: Shows [CA C3]
asseskiller: wins $96.00

GAME #1169065725: Texas Hold'em NL $0.25/$0.50 2008-09-17 01:42:56
Tablename removed
Seat 3: name removed($31.73 in chips) DEALER
Seat 8: TTR62250402 ($14.61 in chips)
name removed: Post SB $0.25
TTR62250402: Post BB $0.50
*** HOLE CARDS ***
Dealt to name removed[S10 C10]
name removed: Raise (NF) $1.00
TTR62250402: Raise (NF) $14.61
name removed: Call $13.61
*** FLOP *** [S2 CQ HJ]
*** TURN *** [S3]
*** RIVER *** [CK]
*** SUMMARY ***
Total pot $28.22 Rake $1.00
TTR62250402: Shows [DJ D5]
TTR62250402: wins $28.22

I have also removed the filter on PT3 just to try it, but as you said it made no difference