3w BB v SB stat

[kondom91]

Hi,

I am trying to create a 3w BB v SB adj BB/100 stat for spin & go.

I created amt_expected_bb_won__3w_BB_v_SB column:

Code: Select all

sum(if[tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.position=8 AND NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos=0 AND tourney_hand_player_statistics.cnt_p_face_limpers <= 1, 1, 0])

and cnt_p_3w_bb_v_sb:

Code: Select all

sum(if[tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.position=8 AND NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos=0 AND tourney_hand_player_statistics.cnt_p_face_limpers <= 1, 1, 0])

My final stat is:

Code: Select all

amt_expected_bb_won__3w_BB_v_SB / (cnt_p_3w_bb_v_sb / 100)

I am getting a result, but it does not match with the number i get if using tournaments filters instead which is:

Players Dealt Into Hand Between 3 and 3
AND
NOT(Position of First Raiser Position of selected Exaclty 0)
AND
Number of Limpers Between 0 and 1

[Flag_Hippo]

In your first column your then condition is 1 instead of (tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb). Also NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos = 0 isn't comparable to NOT (Position of First Raiser Position of selected Exactly 0). NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos = 0 means that the final preflop aggressor was not the button which isn't the same thing as not being the first raiser.

[kondom91]

In your first column your then condition is 1 instead of (tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb). Also NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos = 0 isn't comparable to NOT (Position of First Raiser Position of selected Exactly 0). NOT tourney_hand_player_statistics.val_p_raise_aggressor_pos = 0 means that the final preflop aggressor was not the button which isn't the same thing as not being the first raiser.

I now tried this but it is still not right I think

Code: Select all

sum(if[tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.position=8 AND tourney_hand_summary.str_aggressors_p NOT LIKE '0%' AND tourney_hand_summary.str_actors_p NOT LIKE '0%' AND tourney_hand_player_statistics.cnt_p_face_limpers <= 1, tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb, 0])

[kondom91]

Upon analyzing the quick filter I found out it is not filtering the scenario correctly.
I came to the conclusion, using an expression filter to check the hands, that the correct solution should be:

Code: Select all

tourney_hand_summary.cnt_players=3 AND tourney_hand_player_statistics.position=8 AND tourney_hand_summary.str_actors_p NOT LIKE '0%'

So, my amount expected from BB v SB 3way is:

Code: Select all

sum(if[tourney_hand_summary.cnt_players=3 AND tourney_hand_player_statistics.position=8 AND tourney_hand_summary.str_actors_p NOT LIKE '0%', tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb, 0])

The number of hands played is:

Code: Select all

sum(if[tourney_hand_summary.cnt_players=3 AND tourney_hand_player_statistics.position=8 AND tourney_hand_summary.str_actors_p NOT LIKE '0%', 1, 0])

And my final stat is: amt_expected_bb_won__3w_BB_v_SB / (cnt_p_3w_bb_v_sb / 100)

Do you agree with it?

[Flag_Hippo]

Upon analyzing the quick filter I found out it is not filtering the scenario correctly.

The filter is likely to be working correctly but it's not possible to filter the situation you want using built-in filters since there is no existing filter for the positions of callers/limpers.

Do you agree with it?

Assuming you want hands where the button did not VPIP at all then yes.

[kondom91]

Upon analyzing the quick filter I found out it is not filtering the scenario correctly.

The filter is likely to be working correctly but it's not possible to filter the situation you want using built-in filters since there is no existing filter for the positions of callers/limpers.

Do you agree with it?

Assuming you want hands where the button did not VPIP at all then yes.

Yes. I came to the same conclusion.
Thank you very much for your help, I was able to complete my reports with all the custom stats I wanted to create