|
|
|
|
#1
10-12-07, 03:02 AM
|
||||
|
||||
I HAVE to post it...
O...
M... G!!! Full Tilt Cash game, $1/$2 No Limit, 6 players Hand History by HERO (SB): $375.80 BB: $215 UTG: $200 MP: $80 CO: $412.70 Button: $216.40 HERO posts Small Blind $1 BB posts Big Blind $2 Pre-flop: Q  Q ($3)UTG folds MP folds CO raises to $7 Button raises to $20 HERO raises to $69 BB folds CO folds Button raises to $216.4 and is all in HERO calls $147.4 Flop: 9  6 7 ($441.8)Turn: 9 6 7 Q ($441.8)  River: 9 6 7 Q 8 ($441.8)Button shows A AHERO wins $438.80 with three of a kind Queens |
|
#4
10-12-07, 12:45 PM
|
||||
|
||||
|
I assume you mean pocket 6s.
Yeah, this blew me away. It's been a long time since I've been on this end of the AA vs KK vs QQ vs JJ all in preflop type deal. I *feel* like I'm on the other end of it much more often, but that's probably selective memory. de-coder: Can you whip up some SQL to help us take a look at that? Ideally, I'd like to see something that looks at ALL the times HERO gets it all in preflop against one villain with PP vs PP. Then, of those times, these numbers: -How often we have the higher PP -% of time it gets cracked -How often we have the lower PP -% of time it sucks out |
|
#7
10-12-07, 05:28 PM
|
||||
|
||||
|
INDEED! Nice call with the 55.
|
|
#9
10-13-07, 01:35 PM
|
||||
|
||||
|
Believe it or not - there's a field in the database for all-in and forced all in so I thought I was gold. Turns out it's not used
There's no way I can get the info out - it's not in there. --------------- That's a post I started last night sometime. Since then I went back to see if there couldn't be some way to manage this. So now for the bad news - the data isn't really in there the way I need to provide you exactly what you've asked for. I can't give you a neat and tidy answer on this one. The good news is - I think I've come pretty close. What you can do is run a query that will return all games in which hero saw showdown, had pockets against pockets, and someone was all-in preflop (I just figured that part out now). It returns 4 columns - game_id, who_won (player_id of winning player), villains hole cards, heros hole cards. With those columns it's pretty easy to tell whether someone sucked out or not, but yoiu have to do that on your own. I've organized it so the results list in order of who won so the winning hands for hero should all show up at the top (because hero's playerid is usually pretty low). Of my 10000 hand sample (just one of my DB's) there are only 16 hands that qualify. Of those I won with suckouts: 99 v AA QQ v KK and lost to suckouts: AA v QQ x2 The following hands held up for me: AA v QQ x2 QQ v JJ x2 and I lost the following hands as I should have: TT v AA x2 77 v AA JJ v QQ 99 v TT 77 v QQ 55 v AA KK v AA well, that's depressing... In order to run the query you will need your player_id, which you should know from the last exercise. And now the query: everywhere it says player_id = 6 change it to your own player_id #. Have fun. 
|
 |
|
|
Hybrid Mode
