Does anyone have any results that say they are running better than they should?? All of my results say negative difference...

Check out advis0r's results earlier in the thread. He is aboove his EV.

I can't for hte life of me get this to produce a result. Below are my paramters:

db_host = localhost
db_name = PTPGSQL2
db_user = postgres
db_pwd = 303909
screenname = odub303
filter_date = 2007-02-01
filter_stake = $0.25/$0.50

any ideas?

Ryan

Can someone please rehost this script for me?

Wow that's some bad luck dude. I haven't really taken a look at how advisor modified the query so I could be wrong here, but I believe he just eliminated the hands where multiple people saw a showdown, whereas in mine, I believe those hands were being counted multiple times (I have a fix for that, but been sick and lazy the last few days). So that could definitely account for a 4 buy-in difference.

I'm just the guy with the good ideas, I need other people to actually make 'em work

tytytytytytyt for this... finally Im certain about the fact that I am THE LUCKIEST BITCH ALIVE.

+20% on EV or sth.

ship it

My last 5 days of 1/2NL:

found 201 headsup allin situations
won: 122 lost: 58 tied: 21
average potsize: $220.26
average ev: 0.5616
money won: $27188.16
money expected (based on allin equity): $24239.44
money difference: $+2948.72
total_bet: $22663.04

Wow, this is awesome. Thanks!

i ran like 1.3k below equity while shortstacking 1/2 this weekend (8k hands), then i ran like 1.5k above when at 2/4 and 3/6. this is shortstacking and YMMV.

Does anyone else feel like a little kid on christmas eve waiting for the beta tomorrow? I forsee spending like 3 hours just looking through pots and stuff, it really looks awesome tho. Maybe im just a math nerd ><

I'm running -18% at the stake I'm taking shots at.

I'm running +18% at my "Im Tired - Lets play Low" stake.

STANDARD

I'm running +4% at my normal stake though...

Jehaim:

I ran terrible at my normal stakes, moved up to 3/6 yesterday and ran hotter than god. Good times will come

True.

Best tactic would obviously be to leave my normal stake where im due a downswing and move up to where I'm due a hot streak.

Do either of these programs work with Sit n Go's or are they just for cash games?

output.txt says : postgresql-8.2-504.jdbc3.jar not found

My settings are:

db_host = localhost
db_name = GRIND (i think this is the name of the freshly converted SQLdb, where i can doublecheck?)
db_user = postgres
db_pwd = mypassword
screenname = myscreenname (don't need to do it for each alias right?)
filter_date = 2001-01-01
filter_stake = none

I'll def send a few bucks if i can get this going.

Did you download the .jar file and put it in the same directory as the script itself? Did you execute the script from the folder all the files are in?

Prima network doesn't show mucked hands, so there is a lot of hu allin situation where you won the pot but don't know the opponents cards. I suppose this will screw up the calculation?

Oh right, simply missed this download.

found 658 headsup allin situations
won: 368 lost: 281 tied: 9
average potsize: $326.56
average ev: 0.5349
money won: $122558.76
money expected (based on allin equity): $121542.04
money difference: $+1016.72
total_bet: $103929.13

So it says my edge in these spots was 3.5%, and i'm a slightly over my EV. Standard.

Just cash.

Will they ever? How hard would it be to adapt them so they did?

Juk

There's not really any reason they shouldn't work with cash games. I didn't write the query to specifically do anything with tourneys, but I imagine it would either work out of the box with tourneys or would with very small modifications.

Cool, I'll have to give it a try later then and see what it shows up.

Juk

I tried with SNGs with no luck. For cash, it worked as advertised.

Does this work with PT Omaha?

I tried with PTO, it gives an output but it only looks at two hole cards.

first of all, thanks to the guy that sent me 20 bucks on stars

no but i think Phil153's program will (see earlier in this thread)

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...

to all the others:
be careful with these numbers. the query doesnt get all allin situations and sometimes the pot numbers of the situations it finds arent right (if there are sidepots, multiple allin, more betting after you are allin etc.)

i could fix this but lets just wait for Phil153's program and see how it does