Call vs Open from EP

[Stratocaster]

The new stat should count % of time player calls open (raise 1st) form early position. I just modify the Call vs Open stat, numerator:

Code: Select all

sum(if[substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_actors_p from 1 for 1) AND cash_hand_player_statistics.flg_p_3bet_opp AND lookup_actions_p.action like 'C%' AND cash_hand_player_statistics.position = substring(cash_hand_summary.str_actors_p from 2 for 1)::int AND ((cash_hand_summary.cnt_players = 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int = 3) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 5) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 5 and 7)), 1, 0])

Denominator:

Code: Select all

sum(if[substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_actors_p from 1 for 1) and cash_hand_player_statistics.flg_p_face_raise and cash_hand_player_statistics.flg_p_3bet_opp and not(cash_hand_player_statistics.flg_p_squeeze_opp) AND ((cash_hand_summary.cnt_players = 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int = 3) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 5) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 5 and 7)), 1, 0])

[Stratocaster]

Sh*t wrong subforum Pls move this topic to "Custom Stats, Reports and HUD Profiles".

[kraada]

A question - what what wrong with the original stat that you wanted to change?

[Stratocaster]

A question - what what wrong with the original stat that you wanted to change?

"Sh*t wrong subforum Pls move this topic to "Custom Stats, Reports and HUD Profiles".

Well nothing is wrong and I don't want to change anything This is new stat only for myself, just want to know is it correct.

[kraada]

Sorry, I didn't realize we were lacking "Call" for this case.

Those columns look good.

[potamito]

What happens when the table size gets below 6?

[WhiteRider]

There is no "EP" for less than 6 players. You can see how the different position groupings are defined for each number of players here.