Very cool program advis0r...

Just couple questions...

Is the rake supposed to be taken into consideration at all? Example equity =1.000 pot size =100.00 / expected win =100.00 / actual won =97.00 / Result = -3.00

Which leads to my next question... I ran my numbers for each month so far this year... each month my average EV is over 0.56+ but each month the money difference is negative... does that mean I'm just running bad every month so far?? or could that have something to do with the rake??

Any way to take results from multiple DB's, and merge the results?

Finally what would be optimal #'s??

Ok Im a software idiot. I downloaded advis0r's 3 files and put them in the same folder. But I have no idea what to type in for my settings to make it work. Can anyone point me in the right direction? Also is the settings file the only thing I need to edit? Thanks

Is your DB in postgreSQL?

Previous poster: The rake isnt calculated. Just realized this, so some #'s are def. gonna be off.

RE: It not being addressed byo a single query? Yeah, I saw that.

Quote:
"Is your DB in postgreSQL?"

Haha, my ignorance shows even more. I dont know what this means...

Search around the pokertracker site and you will find how to convert it. makes it run faster, as well as compatibility for this calc.

Ok, im in postgreSQL and I entered my stuff in the settings, but when I run the .bat file, it says to check the output.txt, however this is completly blank. Any ideas?

The program seems to give positive results for pots that are lost, if the all-in push is large compared to villain's stack:

[ 2007-03-31 17:16:03+03 ] [ Qs Jd ] [ Qc 9c ] [ Js 8s 6h Th _ 2h ] [ 0.0340 ] [ 194.40$ / 6.61$ / 130.60$ / +123.99$ ] [ NL ($0.50) ]

Seat 5: Hero ($162.75 in chips) DEALER
Seat 8: Villain ($32.15 in chips)
Seat 10: dddrrr ($72.75 in chips)
Villain: Post SB $0.25
dddrrr: Post BB $0.50
*** HOLE CARDS ***
Dealt to Villain [C9 CQ]
Dealt to Hero [DJ SQ]
Hero: Raise $2.00
Villain: Call $1.75
dddrrr: Fold
*** FLOP *** [SJ S8 H6]
Villain: Check
Hero: Bet $3.50
Villain: Call $3.50
*** TURN *** [H10]
Villain: Check
Hero: Allin $157.25
Villain: Allin $26.65
*** RIVER *** [H2]
*** SUMMARY ***
Total pot $194.40 Rake $1.00
Hero: wins $130.60
Villain: wins $63.80

Having troubles downloading:
"You have reached the download-limit for free-users. Want to download more?"

actually i dont know wether the rake should be substracted from the potsize or not. i dont know how pokertracker saves this because here is a hand from my db:
[ 7h 7s ] [ Ac Qc ] [ 6d 6c 2s 7c _ Jh ] [ 1,0000 ] [ 131,25$ / 131,25$ / 131,25$ / +0,00$ ] [ NL ($0.50) (6 max) ]

the rake saved with this hand by pokertracker is 2.0, how come its +0,00$ in this hand? pokertracker experts may comment on the connections between potsize, rake etc?
does it save it differently for different sites?

what site is the hh from?
is it common for all pokersites to include uncalled bets in the total pot?
if so, using the potsize to make these equity calculations is pretty flawed indeed.

You recently downloaded from rapidshare as a free user and thus have to wait a lil bit till you can download again (or dial in again to get a new ip)

The hh is from iPoker network. I don't know how this program pulls the hands from PT, but I would assume PT does the hh parsing before storing them in common format to the database, and this program reads from there. So this would affect hh's from all sites. Dunno for sure though.

You have to take rake into account. For small numbers of hands you can fudge it from the total rake stored in pokertracker database. The only solution when working with large numbers of hands is to have rake tables for every site and level, otherwise crossing the rake boundary on later streets can lead to an increasing divergence from the true EV line.

Yes. Overbets are stored differently too. The PokerTracker database has quite a few flaws and inaccuracies - which are a major pain in the ass. I'd estimate 1/3 of my development time (22,000 lines of code) has been spent working around this stuff. The other problem is that people sometimes import after a hand history change or when pokertracker has bugs, then forget to do a purge and reimport. That can send the EV line haywire, depending on what data gets screwed up. For some of the more obscure sites there's no solution but to pull up the hand history and parse it yourself. I do it anyway for the replayer but it kills performance during the calc.

Re the program, I'm still not happy with the hand history replayer, the documentation and a few other things, so I'm going to do a trimmed down pre-beta release tomorrow so that you guys can start using it. I'll make a post tomorrow.

Was I supposed to edit anything other than the setting file? I have tried many times to get this to work, but the output file is always blank. Thanks guys.

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

Can someone tell me what to put in the settings to send it to Port 5433? My postgres runs there instead of 5432.

Yeah I got this same problem. I edited the settings and this is what the blank output text looks like for me:

found 0 headsup allin situations
won: 0 lost: 0 tied: 0
average potsize: $NaN
average ev: NaN
money won: $0.00
money expected (based on allin equity): $0.00
money difference: $+0.00
total_bet: $0.00

You got more than I did. My output file is completly blank, i dont have any text at all...

is output.txt completely blank or does it say it finds 0 hands?
if it finds 0 hands do your filter-settings make sense? leave filter_stake to "none" at first and see if it connects to the db and finds anything at all.
and also you could set filter_date to something like 2000-01-01 at first.

if you find 0 hands and think its not your fault at least show your settings and be sure that screenname, filter_stake etc do make sense for your db

did you try setting "db_host=localhost:5433" ?

we all should be looking forward to your program Phil153
what language do you code in? why did you spend 1/3 of your dev-time to work around the flawed PT-Datebase (if you have to parse some handhistories anyway) ?

These were the settings that I used:

db_host = localhost
db_name = PTPGSQL1 (this is the real name of my db)
db_user = postgres
db_pwd = password (i used my real pw not password)
screenname = screenname (i used my real screename)
filter_date = 2007-01-01
filter_stake = none

I somehow managed to get wildzer0's program running and working even though I don't much at all about computers and I thought this one would be easier and it would be cool to compare the results from the two but I have no idea what I'm doing wrong. I even tried the 2000-01-01 you just suggested.

here are my settings, it gives me a completly blank output, no text at all.


db_host = localhost
db_name = PTPGSQL1
db_user = postgres
db_pwd = mypassword
screenname = myscreenname
filter_date = 2006-03-01
filter_stake = none

hmmm, your settings look fine,
some things that might cause finding 0 hands:
- you used a screenname that you combined in pokertracker with a screenname from another site. if so, you should be using the "master-screenname" in your settings.txt
- you accidently entered some whitespace behind some settings (like screenname)

GoHeels: does the command window that comes up when running the batch show any unusual output? (more than "running AllinCalc... done ... see output.txt")

i hate seeing the program having so many problems, but it was just planned as a quick standalone of the php version and since Phil153 is working on a better program i dont think i will really work it over with multiple queries, correct sidepots etc.

Awesome. Your a genius. There was some white space behind my screename and now it works perfectly. Thanks so much. It is a bit different result from wildzer0's I guess due to the headsup vs. multiway? Not sure haven't really looked hard but over 70k hands yours says I'm owed 13 buyins and wildzers say 17. And thanks a ton to you also wildzer0. Now I know I'm not just paranoid and really am running bad

Here is the output from the .bat file.

running AllinCalc...
Exception in thread "main" java.lang.UnsupportedClassVersionError: AllinCalc (Un
supported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknow n Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
done ... see output.txt
Press any key to continue . . .

you have an older version of java installed than i used to create the program (class files) with.

check www.java.com for the latest version (something like "JRE Java Runtime Environment Version 6 Update 1") and it should work

I retract my earlier statement about rake. I got a 6 and 8 confused in the HH I looked at, but the calc does take potsize (post rake) when calculating equity, so no worries.

You have no idea how much I am looking forward to the beta.

Prefect, it works now. Much thanks. Now I need to figure out how to change my luck and not be down over 10% from my EV.