Fold vs RFI

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Fold vs RFI

Postby Valvally » Wed Mar 16, 2016 12:10 pm

Hello!
I want to create stat Fold vs Raise First in

(cnt_p_fold_vs_open / cnt_p_fold_vs_open_opp) * 100

cnt_p_fold_vs_open_opp
sum(if[tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and not(tourney_hand_player_statistics.flg_p_squeeze_opp) and not(tourney_hand_player_statistics.flg_p_limp), 1, 0])

cnt_p_fold_vs_open
sum(if[tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and not(tourney_hand_player_statistics.flg_p_squeeze_opp) and not(tourney_hand_player_statistics.flg_p_limp) and lookup_actions_p.action like 'F%' , 1, 0])

This is the right stat?
Valvally
 
Posts: 34
Joined: Tue Mar 13, 2012 4:11 pm

Re: Fold vs RFI

Postby kraada » Wed Mar 16, 2016 12:36 pm

Not quite - replace not(tourney_hand_player_statistics.flg_p_limp) with substring(tourney_hand_summary.str_aggressors_p from 2 for 1) = substring(tourney_hand_summary.str_actors_p from 1 for 1) and then you'll get what you want. You're just saying you don't this player to have limped - but really you don't want any limpers of any kind in the hand.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold vs RFI

Postby Valvally » Fri Mar 18, 2016 9:57 am

Thank you!
PLease tell me what does mean
substring(tourney_hand_summary.str_aggressors_p from 2 for 1) = substring(tourney_hand_summary.str_actors_p from 1 for 1)
Valvally
 
Posts: 34
Joined: Tue Mar 13, 2012 4:11 pm

Re: Fold vs RFI

Postby kraada » Fri Mar 18, 2016 12:50 pm

That means the player who made the first raise also made the first action preflop. As a result you can be certain there are no limpers.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold vs RFI

Postby Valvally » Fri Mar 18, 2016 1:31 pm

Ok
from 1 for 1
or
from 2 for 1
- is it position opponent or not?
Sorry for stupid questions but I can't find information about it
Valvally
 
Posts: 34
Joined: Tue Mar 13, 2012 4:11 pm

Re: Fold vs RFI

Postby kraada » Fri Mar 18, 2016 3:16 pm

I'm not sure what you're asking. The first string is the list in order of the positions of all aggressive players preflop (it always starts with '8' for the big blind). The second string is the list in order of the positions of all players who voluntarily put money in. So if the second value in the first string (the first raiser's position) is the same as the first value in the second string (the position of the first person to put money in voluntarily) nobody can have limped.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold vs RFI

Postby Valvally » Sat Mar 19, 2016 8:55 am

Thank you again!
Valvally
 
Posts: 34
Joined: Tue Mar 13, 2012 4:11 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 1 guest