Open Side Menu Go to the Top
Register
Sklansky bucks calculator (php script) Sklansky bucks calculator (php script)

04-11-2007 , 04:37 PM
Quote:
Quote:
I tried with SNGs with no luck
it doesnt work with SNGs since its only querying the cashgame database tables atm. after a quick look i think the query could be ported over to use the tourney-tables for calculating this info as well. but then it would be about chipsEV rather than $EV, which is quite a difference in sngs. a badbeat 4 handed is more important to the "running good"-factor than at other stages...
I think just knowing if you are losing more/less all-ins than you should would be helpful, but you could also use ICM by finding your "prizepool equity" when you lose/tie/win an all-in and use that in-place of the chip equity itself to get your $EV instead of chipEV. This would show up (magnify) if you are losing/winning the "important all-ins" more often than you should. The ICM calculation is relatively slow though as it's O(n!), but just having 3 prizes and a small n it shouldn't be too bad even for a big DB (for the end of MTTs it could become too slow though...).

Juk
Sklansky bucks calculator (php script) Quote
04-11-2007 , 06:41 PM
Rehost?

Thanks.
Sklansky bucks calculator (php script) Quote
04-11-2007 , 07:09 PM
Cmon Phil!
Sklansky bucks calculator (php script) Quote
04-11-2007 , 07:10 PM
First off, nice work .

I've found a little bug with PartyPoker handhistory's. This handhistory:
Quote:
Seat 4 is the button
Total number of players : 6
Seat 3: Bollefranz ( $ 171.02 USD )
Seat 5: Meijland01 ( $ 143.03 USD )
Seat 1: Rambambulle ( $ 146.25 USD )
Seat 6: Hero ( $ 266.55 USD )
Seat 2: Hempels82 ( $ 49.50 USD )
Seat 4: busto_ ( $ 98.50 USD )
Meijland01 posts small blind [$ 0.50 USD].
Hero posts big blind [$ 1 USD].
** Dealing down cards **
Dealt to Hero [ Qs Qh ]
Rambambulle calls [$ 1 USD]
Hempels82 folds.
Bollefranz calls [$ 1 USD]
busto_ raises [$ 5 USD]
Meijland01 folds.
Hero calls [$ 4 USD]
Rambambulle folds.
Bollefranz calls [$ 4 USD]
** Dealing Flop ** [ 6h, 7h, 7d ]
Hero checks.
Bollefranz checks.
busto_ bets [$ 10 USD]
Hero raises [$ 27 USD]
Bollefranz folds.
busto_ raises [$ 34 USD]
Hero is all-In.
busto_ is all-In.
** Dealing Turn ** [ Kc ]
** Dealing River ** [ 2h ]
busto_ shows [ As, Ah ]two pairs, Aces and Sevens.
Hero shows [ Qs, Qh ]two pairs, Queens and Sevens.
Hero wins $ 168.05 USD from side pot #1 with two pairs, Queens and Sevens.
busto_ wins $ 200.50 USD from the main pot with two pairs, Aces and Sevens.
Produces this line of output:
Quote:
[ 2007-04-04 10:36:28+02 ] [ Qs Qh ] [ As Ah ] [ 6h 7h 7d _ Kc 2h ] [ 0.0840 ] [ 368.55$ / 30.96$ / 168.05$ / +137.09$ ] [ NL $100 (6 max) ]
This is obviously wrong since I didn't win any money, yet it says I'm $137 above EV. The problem is caused by the PartyPoker handhistory's, that add "Uncalled bets" to the pot and gives it back through a side pot.

If you're up against short(er)stacks a lot, the output most likely produces a result that tells you you ran much hotter than you in fact did.
Sklansky bucks calculator (php script) Quote
04-11-2007 , 07:49 PM
Very interesting software, advis0r!

My results:

found 510 headsup allin situations
won: 313 lost: 125 tied: 72
average potsize: $98.65
average ev: 0.6281
money won: $30210.06
money expected (based on allin equity): $31511.81
money difference: $-1301.75
total_bet: $24917.94

I expected I ran bad, and actually -$1300 is less bad than I expected
Sklansky bucks calculator (php script) Quote
04-11-2007 , 07:52 PM
http://rapidshare.com/files/25520091..._v0.5.zip.html

i "fixed" some small stuff, hope it still works right
now i substract the total_bet difference between hero and villain off the pot and off total_won, should make for some more accurate numbers i guess.

debug_mode=1 shows hand history for every hand
Sklansky bucks calculator (php script) Quote
04-11-2007 , 08:44 PM
Quote:
Cmon Phil!
Sklansky bucks calculator (php script) Quote
04-12-2007 , 12:54 AM
cant get it to work,

PT and other tools are working fine with my dbs.

latest postgres.

settings.txt :

db_host = localhost
db_name = PARTYPOKER[2007]-PLAYED
db_user = postgres
db_pwd = postgres
screenname = Heroname
filter_date = 2007-01-01
filter_stake = none
filter_maxev = 1.0
filter_minev = 0.0
debug_mode = 0

Output.txt :

-- listing properties --
filter_date=2007-01-01
filter_minev=0.0
db_name=PARTYPOKER[2007]-PLAYED
filter_maxev=1.0
db_user=postgres
filter_stake=none
debug_mode=0
screenname=heroname
db_host=localhost
db_pwd=postgres

SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
SQLState: 08004
VendorError: 0

whut to do ?

/edit : running Postgres 8.2.3, also tested it the postgresql-8.2-504.jdbc4.jar
Sklansky bucks calculator (php script) Quote
04-12-2007 , 06:45 AM
Quote:
First off, nice work .

I've found a little bug with PartyPoker handhistory's. This handhistory:
Quote:
Seat 4 is the button
Total number of players : 6
Seat 3: Bollefranz ( $ 171.02 USD )
Seat 5: Meijland01 ( $ 143.03 USD )
Seat 1: Rambambulle ( $ 146.25 USD )
Seat 6: Hero ( $ 266.55 USD )
Seat 2: Hempels82 ( $ 49.50 USD )
Seat 4: busto_ ( $ 98.50 USD )
Meijland01 posts small blind [$ 0.50 USD].
Hero posts big blind [$ 1 USD].
** Dealing down cards **
Dealt to Hero [ Qs Qh ]
Rambambulle calls [$ 1 USD]
Hempels82 folds.
Bollefranz calls [$ 1 USD]
busto_ raises [$ 5 USD]
Meijland01 folds.
Hero calls [$ 4 USD]
Rambambulle folds.
Bollefranz calls [$ 4 USD]
** Dealing Flop ** [ 6h, 7h, 7d ]
Hero checks.
Bollefranz checks.
busto_ bets [$ 10 USD]
Hero raises [$ 27 USD]
Bollefranz folds.
busto_ raises [$ 34 USD]
Hero is all-In.
busto_ is all-In.
** Dealing Turn ** [ Kc ]
** Dealing River ** [ 2h ]
busto_ shows [ As, Ah ]two pairs, Aces and Sevens.
Hero shows [ Qs, Qh ]two pairs, Queens and Sevens.
Hero wins $ 168.05 USD from side pot #1 with two pairs, Queens and Sevens.
busto_ wins $ 200.50 USD from the main pot with two pairs, Aces and Sevens.
Produces this line of output:
Quote:
[ 2007-04-04 10:36:28+02 ] [ Qs Qh ] [ As Ah ] [ 6h 7h 7d _ Kc 2h ] [ 0.0840 ] [ 368.55$ / 30.96$ / 168.05$ / +137.09$ ] [ NL $100 (6 max) ]
This is obviously wrong since I didn't win any money, yet it says I'm $137 above EV. The problem is caused by the PartyPoker handhistory's, that add "Uncalled bets" to the pot and gives it back through a side pot.

If you're up against short(er)stacks a lot, the output most likely produces a result that tells you you ran much hotter than you in fact did.

I have the same problem

Thanks for fixing
Sklansky bucks calculator (php script) Quote
04-12-2007 , 06:47 AM
Big difference for me with the new version (and more accurate with my own expectations)

found 510 headsup allin situations
won: 313 lost: 135 tied: 62
average potsize: 92.37$
average ev: 0.6335
money won: 27006.17$
money expected (based on allin equity): 29745.86$
money difference: -2739.69$
max money diff: at +0.00$
min money diff: 2007-03-29 13:01:30+02 at -2865.44$
total_bet: 24917.94$
Sklansky bucks calculator (php script) Quote
04-12-2007 , 02:46 PM
OK, the pre-beta is ready. Apologies for keeping everyone waiting.

I've left some features out that aren't quite ready for a broader release (the HH replayer, range calcs), but you'll be seeing them very soon. I don't want to keep you guys waiting any longer. At this time I'm limiting the beta to a couple of hundred testers as I haven't mapped out all the sites yet, and I really want to get the accuracy perfect before giving it to everyone.

I'd greatly appreciate if people can send me hand histories (hundreds or thousands of them)from non-tested sites so I can finish mapping out all the inaccuracies and issues with the PT database, then do a proper release. Best way is via email. At present you can run the program on any PokerTracker supported site but I can't guarantee it'll be accurate for all sites. Some sites (such as Prima, Ongame) don't save mucked showdown hands, so the results aren't very useful (and possibly completely wrong) on those sites.

I'll be adding a lot of new features shortly, including a much broader range of stats and the things mentioned above. For now, you can use the filtering system and the available stats to do a lot of analysis.

I've put up a site at http://www.pokerevsoftware.com, if you want to beta test you can leave a message in the forum on the site, email phil@pokerevsoftware.com, or PM me here and I'll send you the link. Priority goes to 2+2 software forum posters obviously . The program is free and I don't accept donations. Oh and for the really eager, you'll have to wait about 6 hours till I can reply ; it's 4am here.
Sklansky bucks calculator (php script) Quote
04-12-2007 , 03:06 PM
w00t

(Is w00t still cool btw? )
Sklansky bucks calculator (php script) Quote
04-12-2007 , 03:55 PM
The php code mentioned is flawed. It includes situations where there are more than 2 people all-in and therefore overestimates your equity. The java code simply ignores multiway pots altogether. I hope the pokerevsoftware does better.
Sklansky bucks calculator (php script) Quote
04-12-2007 , 05:33 PM
Phil, you are such a tease
Sklansky bucks calculator (php script) Quote
04-12-2007 , 07:12 PM
I have a few questions:

1. does the average ev number take into account that the pot sizes for each all in is different, or is it just a straight average of every all in situation?

2. what do money won, and money expected mean? my values are positive for those fields even though I have an ev of less than .50


average potsize: 86.44$
average ev: 0.3704
money won: 100.30$
money expected (based on allin equity): 153.90$
money difference: -53.60$
max money diff: at +0.00$
min money diff: 2007-04-12 18:34:04-04 at -53.60$
total_bet: 216.65$
Sklansky bucks calculator (php script) Quote
04-12-2007 , 07:36 PM
CrunkinTilt...

1. Avg ev is just a straight average...

2. Money won = $ won from those all ins... and $ expected is how much you were expected to win... so in your case you were expected to win $153.90 but only won $100.30. However the part you are missing is the total_bet : $216.65 which you minus from your $ won... and if you subtract that from $ won or expected you end up with negative # both times due to your avg ev below .5

Hope that makes sense..
Sklansky bucks calculator (php script) Quote
04-12-2007 , 09:58 PM
Advisor:

I shipped you another $25 because this program is keeping me grounded in reality with regards to results. TY soso much.
Sklansky bucks calculator (php script) Quote
04-13-2007 , 03:30 AM
When I run the script I get a pop up from pokernum.exe that says "This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem."

Any idea what could be causing this?
Sklansky bucks calculator (php script) Quote
04-13-2007 , 04:35 AM
Still unable to download the script. Can anyone help me out?
Sklansky bucks calculator (php script) Quote
04-13-2007 , 08:34 AM
Phil, I am SO impressed by your program. Just started testing it out and it's great to see what my actual winrate should be Great work!
Sklansky bucks calculator (php script) Quote
04-13-2007 , 09:38 AM
Hey,
I'll test this out Phil, let me know how.
Sklansky bucks calculator (php script) Quote
04-13-2007 , 10:20 AM
Quote:
http://rapidshare.com/files/25520091..._v0.5.zip.html

i "fixed" some small stuff, hope it still works right
now i substract the total_bet difference between hero and villain off the pot and off total_won, should make for some more accurate numbers i guess.

debug_mode=1 shows hand history for every hand
This is so so incredibly hot. This is my last month of poker:



And It might just have something to do with this:

money won: 59094.90$
money expected (based on allin equity): 63226.95$
money difference: -4132.05$

when I break even I'll ship some money
Sklansky bucks calculator (php script) Quote
04-13-2007 , 05:36 PM
Quote:
When I run the script I get a pop up from pokernum.exe that says "This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem."

Any idea what could be causing this?
Sklansky bucks calculator (php script) Quote
04-13-2007 , 06:30 PM
i guess you are missing the following file: MSVCR71.dll
google it up and put it into windows/system or system32 dir

Sklansky bucks calculator (php script) Quote
04-14-2007 , 05:48 AM
I always thought i ran bad... to the tune of 10k =[

found 1912 headsup allin situations
won: 1179 lost: 613 tied: 120
average potsize: 258.63$
average ev: 0.5944
money won: 289048.30$
money expected (based on allin equity): 298156.57$
money difference: -9108.27$
max money diff: 2006-12-20 20:22:45-07 at +743.40$
min money diff: 2007-04-11 15:36:00-06 at -10348.80$
total_bet: 261833.42$
Sklansky bucks calculator (php script) Quote

      
m