Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
by 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
by 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
by 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
by 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
by 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
Users browsing this forum: No registered users and 1 guest