Display Villian's VPIP when WENT ALL IN in Players Report

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Display Villian's VPIP when WENT ALL IN in Players Report

Postby pt4pt4pt4 » Tue Jun 19, 2012 12:31 am

Not sure if this is possible but will give it a try.

I would like to create a report in which i have pocket pairs from the button and RAISED ALL IN, with the BB calling.
Can i display the Villians (BB) VPIP at that session (time) or lifetime VPIP, when he called my ALL IN?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby kraada » Tue Jun 19, 2012 9:54 am

If I'm understanding you correctly you want to only look at data when you raised and were called. The problem then is that if you were already called, in those cases your opponents will have VPIP = 100 - because they're always calling in these cases by definition.

Instead, perhaps you want a report to tell you what the players' lifetime stats are given that the player called this kind of all-in at least once? The problem then is that you won't be able to see which hands they called with or how many times they did so - but you will be able to see their normal VPIP values.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby pt4pt4pt4 » Tue Jun 19, 2012 10:41 am

kraada wrote:If I'm understanding you correctly you want to only look at data when you raised and were called. The problem then is that if you were already called, in those cases your opponents will have VPIP = 100 - because they're always calling in these cases by definition.

Instead, perhaps you want a report to tell you what the players' lifetime stats are given that the player called this kind of all-in at least once? The problem then is that you won't be able to see which hands they called with or how many times they did so - but you will be able to see their normal VPIP values.


I will try to make an example of the report if possible (using any variables to make it easier to understand):

Hero Position = Button .....................Villian Position = BB.....................HERO RAISED ALL IN

PFR Action , Hero Hole Cards . Villian Hole Cards . Villian's VPIP for Session . Villian's VPIP Lifetime at that date

R......................88......................A7......................23.1 % ......................12.1 %......................

What is the closest that I can get with PT4 if I can't get something like this?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby kraada » Tue Jun 19, 2012 12:09 pm

Due to the way reports are set up, I'm not sure how much progress it's possible to make here - and I don't think that it's very much. Let me explain why a little and hopefully that will help.

The PT4 reports system has two main sections - Player reports and Hand reports. Player reports display data based on groups of hands - so for example, a player's VPIP or PFR. The Hand report shows data based on individual hands - so for example, a player's hole cards, or his first preflop action.

The reports system is also not designed to combine data from multiple different players into a single row. The nature of the database tables and the design makes this impossible in most cases.

Now, we can apply filters to data though and that does help - so for example, you could make a report that displays all hands where Hero was on the button and Villain was in the BB and Villain faced an all-in. You could then display, for those hands, what Villain held. But since it's a Hand report you can't then display VPIP (session or otherwise).

You could create a report that displayed the VPIP of any Villain who called an all-in in the BB when Hero was on the button, but then you couldn't display the individual hands and you'd need to make a different report to look at that information.

I hope that helps clarify the limitations of the system somewhat for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby pt4pt4pt4 » Tue Jun 19, 2012 2:02 pm

Yes it does.

I could by your explanation, create both of those reports individually including a hand number (Hand #), then export them separetly. Sort them by hand number and then I could combine the 2 reports side by side (by Hand #) to display the data that I am looking for?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby kraada » Tue Jun 19, 2012 2:38 pm

Yes, with that extra work yourself you could make that happen. We can export our data (via the right click menu) to Excel and that's probably going to be the best place to manipulate things for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby pt4pt4pt4 » Tue Jun 19, 2012 11:40 pm

kraada wrote:You could create a report that displayed the VPIP of any Villain who called an all-in in the BB when Hero was on the button, .



Looked at the reports and didn't see this option anywhere or in the stats.

is this a custom stat?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby WhiteRider » Wed Jun 20, 2012 3:45 am

It looks to me as if Kraada meant that you can display the [normal] VPIP stat when you filter for villains who called an all-in from the BB when Hero was on the button. That wouldn't be a filter to those specific hands, though, because in that case the VPIP would always be 100%.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby pt4pt4pt4 » Wed Jun 20, 2012 9:36 am

is there a stat that displays the lifetime VPIP of the player at a specific position?

If I Raise all in AA from the button and each time the BB calls, can I display the VPIP lifetine of the BB through a custom stat /call?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Display Villian's VPIP when WENT ALL IN in Players Repor

Postby kraada » Wed Jun 20, 2012 9:51 am

Well, or you could use a complex filter expression to filter to players who were in that spot.

This Filter Expression will filter only to players who faced an all-in raise preflop in the big blind from hero and called:

tourney_hand_player_statistics.id_player in (SELECT thps.id_player from tourney_hand_player_statistics thps where thps.enum_face_allin = 'P' and thps.flg_f_saw and thps.position = 8 and thps.id_hand in (SELECT thps2.id_hand from tourney_hand_player_statistics thps2 where thps2.flg_hero and thps2.enum_allin = 'P' and thps.position = 0))

I presumed you want this for tournaments - if not, change "tourney_hand_player_staitistics" to "cash_hand_player_statistics".

That will filter your report to players who faced a preflop all in, saw the flop, were in the big blind in a hand where the hero went all-in preflop from the button. I don't think you want to filter to only pocket pairs here because when the player makes the call of your all-in he has no idea if you have a pocket pair or not.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 0 guests