Fold to PF EP 2Bet

[Cooozy]

How can I make 'Fold to PF EP 2Bet' and 'Fold to PF MP 2Bet' custom stats?

I tried modifying 'Fold vs BTN Open'. I can replace 'cnt_p_3bet_opp_vs_btn_open' with 'cnt_p_3bet_opp_vs_ep_2bet', but there's nothing to replace 'cnt_p_call_vs_btn_open' with, because there's no corresponding stat for EP and MP.

Here's 'Fold vs BTN Open' below:

Code: Select all

((cnt_p_3bet_opp_vs_btn_open - cnt_p_call_vs_btn_open - cnt_p_3bet_vs_btn_open) / cnt_p_3bet_opp_vs_btn_open) * 100

[kraada]

You'd need to build the columns for this. That said, if you're playing 6 max there will be no difference between vs ep 2bet and vs ep open -- nobody else can act first -- and the only time mp can 2bet rather than open is vs a UTG limp, so this will be pretty rare.

[Cooozy]

You'd need to build the columns for this. That said, if you're playing 6 max there will be no difference between vs ep 2bet and vs ep open -- nobody else can act first -- and the only time mp can 2bet rather than open is vs a UTG limp, so this will be pretty rare.

I want to see how often they fold when the EP or MP opens/2bets in a fullring cashgame.

[WhiteRider]

You will need to make "vs_ep" and "vs_mp" versions of the columns used in the stats.
Take a look at the Custom Stats Guide for an overview of how custom stats work.

There are stats for 3bet vs EP/MP as well as vs BTN, and fold vs BTN, so take a look at the differences and you'll be able to see how to make fold vs EP/MP columns by combining [parts of those expressions.

[Cooozy]

You will need to make "vs_ep" and "vs_mp" versions of the columns used in the stats.
Take a look at the Custom Stats Guide for an overview of how custom stats work.

There are stats for 3bet vs EP/MP as well as vs BTN, and fold vs BTN, so take a look at the differences and you'll be able to see how to make fold vs EP/MP columns by combining [parts of those expressions.

So I need to create a column that's the EP version of 'cnt_p_call_vs_btn_open'. The original code is below:

Code: Select all

sum(if[lookup_actions_p.action LIKE 'C%' and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

Not sure how I would convert that to EP. If I look at one of the existing EP columns, I can't understand the code well enough to figure out what part makes it EP that I could use in the other code. Here's the code for 'cnt_p_3bet_vs_ep_2bet':

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) 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 7) 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])

Any help creating custom 'cnt_p_call_vs_ep_2bet' and 'cnt_p_call_vs_mp_2bet' columns would be much appreciated.

Thanks

[WhiteRider]

The complication is because the button is a single position, but for full ring tables "EP" and "MP" can be different positions depending on how many players are in the hand.

The zero (0) in cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' is the button's position.
For "2bet" rather than "open" we only actually need the first part:

cash_hand_summary.str_aggressors_p LIKE '80%'

The equivalent of this for EP (from the other expression you quoted) is:

((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) 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 7) 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))

This is doing the same test of "str_aggressors_p" but for different position numbers based on the number of players in the hand.

So anywhere that you see:
cash_hand_summary.str_aggressors_p LIKE '80%'
..in a BTN expression you need to replace that with the longer expression above for EP.
There is a similar expression with different table sizes and position numbers for MP, which you can find in the MP columns.

When you're looking at "open" stats (I'd suggest you start with "2bet" stats as they're a little simpler, and as Kraada suggested the "open" stats won't give you very different data for EP and MP) you'll also need to do the same comparison for the actors string (cash_hand_summary.str_actors_p LIKE '0%' from the first expression you quoted) but using the different position numbers for different table sizes.

Check out this post for more information on using the actors and aggressors strings.

[Cooozy]

Just got around to trying that, it seems the only problem is the 'cnt_p_call_vs_ep_2bet' custom column isn't working. Below is the code I'm trying to use, which WhiteRider provided above. If I try using just this column alone in it's own stat, I get a '-' instead of a percentage. I can't figure out how to fix this code.

Code: Select all

((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) 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 7) 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))

If I could get that working, then for a 'Fold vs PF EP 2Bet' custom stat, I should only need to do this...

Code: Select all

((cnt_p_3bet_opp_vs_ep_2bet - cnt_p_call_vs_ep_2bet - cnt_p_3bet_vs_ep_2bet) / cnt_p_3bet_opp_vs_ep_2bet) * 100

Thanks

[kraada]

This is what you want, I think:

sum(if[lookup_actions_p.action LIKE 'C%' and cash_hand_player_statistics.amt_p_2bet_facing > 0 and ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) 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 7) 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])

[Cooozy]

Thanks, that works.

I converted that from EP to MP and it also seems to work, but can you confirm that I made the correct changes?

BEFORE (EP):

sum(if[lookup_actions_p.action LIKE 'C%' and cash_hand_player_statistics.amt_p_2bet_facing > 0 and ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) 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 7) 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])

AFTER (MP):

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

[BillGatesIII]

Yep, those are correct.