3-betting Pre-Flop - Anyone know the SQL? Care to share?

[_dave_]

title says it all really - I want to be able to find out how often certain opponents re-pop me when I am the PFR - or if there can be derived any heuristic between their PFR stat and PF aggro factor to approximate my chance of being re-raised while at the table.

I am thinking surely this can be extracted with a super-long SQL query, but I can't for the life of me decode the "possible_actions" fields in the game_players table - which I am assuming is key to finding this data.

Anyone any ideas?

dave.

[Sciolist]

I seem to remember somebody saying that it wasn't possible to get this data because of the way the PokerTracker schema is setup, but I haven't looked into it myself yet...

[Gregg777]

What site is it for?

My programmer wrote a SQL db for hands and I am sure the actions table is nothing as complex as PT, but I could be wrong [img]/images/graemlins/tongue.gif[/img]

[_dave_]

But it seems we have all the information needed, although I cant find documentation on PT site so I am unsure of some of the meanings of values.

in the game_players table there is:

pfr_raise: wtf does this mean? sounds like this field alone would do? can be 0 or 1 - looks promising, but I really don't know what it means I get 0.3% (and quickly) when I run a query against myself using only this stat - surely I re-pop a PFR more than that, but maybe not. surely if this was the case PokerAce would have implemented this stat?

[_dave_]

[ QUOTE ]

What site is it for?


[/ QUOTE ]
I'd be wanting to pull this from my pokertracker DB, so any supported site I suppose.

However right now I play only on Stars. I may return to FT to clear my signup bonus, but it clears so very slow, and time is running out.

dave.

[Gregg777]

I only had him parse the data for UB and the Party.

[_dave_]

Actually, is 0.3% out of line for re-popping a PFR in NL? thinking about it, I am folding to PFRs a great deal of the time...

EDIT: what else could pfr_raise signify?

[Dazarath]

Dave, pfr-raise does not signify 3-betting. I created a test DB. I imported only a few hands, and pfr_raise is 0 for one of the hands where I 3-bet PF.

[rvg72]

[ QUOTE ]
Actually, is 0.3% out of line for re-popping a PFR in NL? thinking about it, I am folding to PFRs a great deal of the time...

EDIT: what else could pfr_raise signify?

[/ QUOTE ]

Average would be 3ish% for small to mid stakes 6 man NL cash. 6% reraising is on the higher end of the scale.

The pfr_raise in PT should signify this but either it does not work or is there for something else.

rvg

[NoahSD]

I think I remember the pfr_raise meaning that the preflop raisers first action on the flop was to raise.

Dave.. if you get this working, please please please make an AHK script that'll display this stat.