Stats 3bet vs single raise (2nd bet) to Heat Map

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Stats 3bet vs single raise (2nd bet) to Heat Map

Postby chrispbr » Sun Mar 14, 2021 12:58 am

Hello friends, I'm making a heatmap for 3 bet not allin, so far everything is ok ...

But the squeezes are being counted, that is, there was a raise, a cold call and then the 3 Bet ...

I want the stats to return only spots where there was an open raise and then there was a 3bet ...

the formula I used is this, if someone can help me thank you:

Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_3bet AND  tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.id_holecard = 1, 1 , 0])
chrispbr
 
Posts: 4
Joined: Fri Mar 12, 2021 11:05 pm

Re: Stats 3bet vs single raise (2nd bet) to Heat Map

Postby Flag_Hippo » Sun Mar 14, 2021 6:39 am

Add this within your expression:

Code: Select all
AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Stats 3bet vs single raise (2nd bet) to Heat Map

Postby chrispbr » Sun Mar 14, 2021 9:58 am

Flag_Hippo wrote:Add this within your expression:

Code: Select all
AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp


thanks for your answer, it worked ...

but I found one more spot that needs to be filtered, limp

ex:

Player1 limp 1bb
Player2 raise to 4bb
Player1 raise to 12bb this is being counted as 3 Bet

How to eliminate spots like this? Thanks for your help
chrispbr
 
Posts: 4
Joined: Fri Mar 12, 2021 11:05 pm

Re: Stats 3bet vs single raise (2nd bet) to Heat Map

Postby Flag_Hippo » Sun Mar 14, 2021 2:22 pm

chrispbr wrote:but I found one more spot that needs to be filtered, limp

ex:

Player1 limp 1bb
Player2 raise to 4bb
Player1 raise to 12bb this is being counted as 3 Bet

How to eliminate spots like this? Thanks for your help

Code: Select all
AND NOT tourney_hand_player_statistics.flg_p_limp
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Stats 3bet vs single raise (2nd bet) to Heat Map

Postby chrispbr » Mon Mar 15, 2021 11:02 am

Flag_Hippo wrote:
chrispbr wrote:but I found one more spot that needs to be filtered, limp

ex:

Player1 limp 1bb
Player2 raise to 4bb
Player1 raise to 12bb this is being counted as 3 Bet

How to eliminate spots like this? Thanks for your help

Code: Select all
AND NOT tourney_hand_player_statistics.flg_p_limp


Thks again for your help
chrispbr
 
Posts: 4
Joined: Fri Mar 12, 2021 11:05 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 30 guests

cron