Filters - Actions

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Filters - Actions

Postby Bole » Tue Apr 12, 2011 11:29 am

Hello,

I am trying to break down preflop actions in filters to understand exactly what compose VPIP for eg. SB action. I managed to break dow this tab easily when SB vs BB heads up. It all complicates with previous raisers, 3bet, 4bet, all in actions, etc.

Basically I would like to construct a pie chart, with my SB action breaken into individual actions.

So SB VPIP =

- Limp w/prev. callers
- Call raise
- Open limp
- Chance to steal raised
- Chance to steal sqz
- Any raise

???

Cannot make numbers match, due to some stats beiing duplicated i think, VPIP should be a summary of all individual actions and yet I cannot match. So what exactly is VPIP for this specific SB case a summary of ? Sorry if this has been already covered, did not find anything in reference documents.
Bole
 
Posts: 9
Joined: Tue Apr 12, 2011 10:55 am

Re: Filters - Actions

Postby kraada » Tue Apr 12, 2011 12:33 pm

"Any Raise" includes "chance to steal, raised" so you're probably double counting hands.

You VP$IP any time you put money in the pot regardless of the situation. An exhaustive and mutually exclusively list of potential actions is going to be difficult to come up with.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests