I noticed that the built in stats for 3bet relative to 2bet size and 4bet relative to 3bet size do not work. This was leading to incorrect conclusions when studying spots. I managed to make an expression that fixed the 3bet relative to 2bet size but not for 4bet relative 3bet size.
Does anyone know where I am going wrong here?:
Column: val_p_4bet_size_x_custom_copy_copy
Expression:
if[not(cash_hand_player_statistics.flg_p_4bet), 0,
if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 2, 1, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 2.25, 2, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 2.75, 3, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 3, 4, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 3.25, 5, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= (cash_hand_player_statistics.amt_p_3bet_facing) * 3.75, 6, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 4, 7, if[cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made <= cash_hand_player_statistics.amt_p_3bet_facing * 4.5, 8, 9]]]]]]]]]
Description: Groups hands by comparative amount of the last 4+Bet the player made preflop compared to the size of the raise he faced. Types are:
0 - No raise.
1 - 4+Bet less than or equal to 2x the 3bet.
2 - 4+Bet more than 2x the 3bet but less than or equal to 2.25x the 3bet
3 - 4+Bet more than 2.25x the 3bet but less than or equal to 2.75x the 3bet
4 - 4+Bet more than 2.75x the 3bet but less than or equal to 3x the 3bet
5 - 4+Bet more than 3x the 3bet but less than or equal to 3.25x the 3bet
6 - 4+Bet more than 3.25x the 3bet but less than or equal to 3.75x the 3bet
7 - 4+Bet more than 3.75x the 3bet but less than or equal to 4x the 3bet
8 - 4+Bet more than 4x the 3bet but less than or equal to 4.5x the 3bet
9 - 4+Bet more than 4.5x the 3bet
(Copied from val_p_4bet_size_x_custom_copy)
It shows the majority of my 4bets are <2x 3bet but when i go to verify this in hand history or using the filter (Actions and Opportunities<Preflop Bet Sizing<4Bet Size<Multiple of the 3Bet Between) then i know this is untrue. As I have no 4bets of this size. Im really stuck and have tried various ways of making it work.