by RiverHurt » Sat Dec 14, 2019 2:01 pm
Hi WhiteRider,
Thank you for the response! I a trying to do the following (An extract from a hand history is shown below):
** Dealing down cards **
MONSTER902 folds
mafilla14 folds
a12tel folds
komaa1 folds
POTCHECKER99 folds
vespr folds
PPFish735 raises [2,870]
Joiz86 calls [755]
** Dealing flop ** [ 3d, 4d, Qs ]
** Dealing turn ** [ 5s ]
** Dealing river ** [ Jc ]
** Summary **
PPFish735 shows [ 9h, Ac ]
Joiz86 shows [ Ah, Kc ]
Joiz86 collected [ 1,790 ]
If the player folds then a zero is put against their name. If the player does not fold (checks, bets, limps or raises) then a 1 is put against their name. Then sum the total number, this number would be the preflop VPIP count. In the hand above the preflop VPIP count would be 2.
I am trying to apply the stat to my tournament hands for analysis, I am not playing cash games at the moment. I am doing this to try to get a feel for ranges in different spots.
Ranges shift somewhat, become tighter, when the pot is multi-way (say 4 players) preflop and only two players end up seeing the flop after some additional preflop betting. (This hand would have a preflop VPIP count of 4 and a saw flop count of 2)
When one player raises preflop and another calls the two go to the flop. This hand would have a preflop VPIP count of 2 and a saw flop count of 2. In this case the ranges would tend to be wider than a preflop VPIP count of 4 and a saw flop count of 2. I would like to group the hands based on the preflop VPIP count and figure out how the ranges vary.
I can code this stat in excel after exporting the hand histories and applying if statements to the strings in the rows of the text file between ** Dealing down cards ** and ** Dealing flop ** [ 3d, 4d, Qs ]. Basically saying "if this cell contains the string "folds" enter zero otherwise enter 1. Is this difficult to do in PT?
Thanks again for the help guys!
D