Stats based only on hands played vs hero ?

[WhiteRider]

The last one.

[Darvini]

So 4bets screw up stats about to what sized steals people fold to. We can get the right number of folds to certain steal size, but not the right number of opportunities to fold to that size.

[Darvini]

Or does it. We can count the size of the steal from blinds 3bet size if there was a 4bet.

[kraada]

I'm not sure I understand your suggestion entirely - if people vary their 3bet size independently of raise size, wouldn't that cause problems?

[Darvini]

Lets say button steals to amount x and bb 3bets. Now we have:

amt_p_raise_made_pct = amt_p_raise_made / (sb+bb+x)
x = (amt_p_raise_made / amt_p_raise_made_pct) - sb -bb

[kraada]

Ah I see - yes that will work.

[Darvini]

So I made my three columns.

[Edit/Kraada: Removed as they had issues; they're fixed later in this thread]

Now these should count for all actions from the blinds againsta a button or CU steal that is under 2.5 bb right? I made the form such that I can just place the required steal amount in bb:s instead of percentages of pot. So its easier to modify but more difficult to read.

Also shouldnt the permanent sb call to steal column:

cnt_sb_steal_call
sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND lookup_actions_p.action LIKE 'C', 1, 0])

have lookup_actions_p.action LIKE 'C%' instead? I dont even know what have lookup_actions_p.action LIKE 'C' actually means. Is it the same as = 'C' or LIKE '%C%' or what.

[Darvini]

Oh, I noticed a problem in my cnt_blcall_s column. It should have lookup_actions_p.action = 'C' to disregard squeezes from the bb that would make the steal amount unknowable. Ok, just a little smaller sample size but no affects on the reliability of the stat.

[Darvini]

Found another mistake so Ill repost my columns here corrected. Now they are giving believable results.

cnt_bl3B_s
sum(if[ (holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.flg_blind_def_opp and 2.5 > (((holdem_hand_player_detail.val_p_raise_made_pct / 100) / holdem_hand_player_detail.amt_p_raise_made) - (holdem_limit.amt_sb+ holdem_limit.amt_bb + holdem_hand_player_statistics.cnt_players * holdem_hand_player_detail.amt_ante)) / holdem_limit.amt_bb), 1, 0])

cnt_blcall_s
sum(if[ (holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_def_opp and lookup_actions_p.action = 'C' and ((holdem_hand_player_detail.val_p_raise_facing_pct / 100) * (holdem_limit.amt_sb + holdem_limit.amt_bb + holdem_hand_player_statistics.cnt_players * holdem_hand_player_detail.amt_ante) + holdem_limit.amt_bb) / ((1 - holdem_hand_player_detail.val_p_raise_facing_pct / 100) * holdem_limit.amt_bb) < 2.5) or (holdem_hand_player_statistics.flg_blind_s and holdem_hand_player_statistics.flg_blind_def_opp and lookup_actions_p.action = 'C' and ((holdem_hand_player_detail.val_p_raise_facing_pct / 100) * (holdem_limit.amt_sb + holdem_limit.amt_bb + holdem_hand_player_statistics.cnt_players * holdem_hand_player_detail.amt_ante) + holdem_limit.amt_sb) / ((1 - holdem_hand_player_detail.val_p_raise_facing_pct / 100) * holdem_limit.amt_bb) < 2.5), 1, 0])

cnt_blfold_s
sum(if[ (holdem_hand_player_statistics.flg_bb_steal_fold and ((holdem_hand_player_detail.val_p_raise_facing_pct / 100) * (holdem_limit.amt_sb + holdem_limit.amt_bb + holdem_hand_player_statistics.cnt_players * holdem_hand_player_detail.amt_ante) + holdem_limit.amt_bb) / ((1 - holdem_hand_player_detail.val_p_raise_facing_pct / 100) * holdem_limit.amt_bb) < 2.5) or (holdem_hand_player_statistics.flg_sb_steal_fold and ((holdem_hand_player_detail.val_p_raise_facing_pct / 100) * (holdem_limit.amt_sb + holdem_limit.amt_bb + holdem_hand_player_statistics.cnt_players * holdem_hand_player_detail.amt_ante) + holdem_limit.amt_sb) / ((1 - holdem_hand_player_detail.val_p_raise_facing_pct / 100) * holdem_limit.amt_bb) < 2.5), 1, 0])

Now these should count for all actions from the blinds againsta a button or CU steal that is under 2.5 bb right? I made the form such that I can just place the required steal amount in bb:s instead of percentages of pot. So its easier to modify but more difficult to read.

Shouldnt the permanent sb call to steal column:

cnt_sb_steal_call
sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND lookup_actions_p.action LIKE 'C', 1, 0])

have lookup_actions_p.action LIKE 'C%' instead? I dont even know what have lookup_actions_p.action LIKE 'C' actually means. Is it the same as = 'C' or LIKE '%C%' or what.

[kraada]

LIKE 'C%' means the first action must be call and there can be any actions after that. LIKE 'C' means the one and only action can be call. Would you like me to edit out your post with definitions earlier in this thread so that other users finding the thread don't get sent in the wrong direction?