Custom Stat: "Bet River Thin"

[parraka]

Hi everyone,I'm working on a custom stat to track "Bet River Thin" (weak bets with marginal one-pair hands).

I noticed that this specific hand filtering is available and works perfectly within NoteTracker, so I assume it can be replicated exactly using a SQL expression for a Custom Column.I’ve put together the following expression and would like to confirm if it’s the most accurate way to mirror that logic:

Expression: sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_combinations.flg_r_1pair AND ((cash_hand_player_combinations.id_r_hand_strength BETWEEN 1 AND 2) OR (cash_hand_player_combinations.id_r_hand_strength BETWEEN 11 AND 14)), 1, 0])

My reasoning:

flg_r_bet: Player made a bet on the river.
flg_r_1pair: Ensures the hand is exactly one pair.
id_r_hand_strength 1 to 2: Aiming to capture Underpairs/Bottom Pairs (pocket pairs or both cards used).
id_r_hand_strength 11 to 14: Aiming for Middle/Weak pairs (using one hole card).

Questions:

Since this logic is available in NoteTracker, am I using the correct id_r_hand_strength IDs to match it?

Is there any scenario where flg_r_1pair might conflict with the id_hand_strength if the board is paired?

Are there any other flags I should include to ensure it doesn't count hands that improved to a Flush or Straight on the river?

Thanks for your help!

[Flag_Hippo]

id_r_hand_strength 11 to 14: Aiming for Middle/Weak pairs (using one hole card).

id_r_hand_strength ranges from 0-6 for one pair hands. This post lists all the id_x_hand_strength values.

Is there any scenario where flg_r_1pair might conflict with the id_hand_strength if the board is paired?

You will need to use cash_hand_player_combinations.val_r_hole_cards_used so you don't count hands where a player bets/bluffs river on a paired board.

Are there any other flags I should include to ensure it doesn't count hands that improved to a Flush or Straight on the river?

If the player improves on the river then cash_hand_player_combinations.flg_r_1pair would no longer be true.

This would be the equivalent expression for the NoteTracker definition:

Code: Select all

sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_combinations.flg_r_1pair AND ((cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength BETWEEN 4 AND 5) OR (cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength <= 2)), 1, 0])

[parraka]

Hi, thanks! If I change "rs" for "ts" and "fs", will it work for Flop and Turn or do i need to take other details into account?

[Flag_Hippo]

On the flop or turn a player can also have draws to go with their pair.

[parraka]

Hi, I have been testing it and it is okey to keep "Non Top Pair" + Draws in Flop and Turn.

My last question is about Bluffs, would these column work good?

cash_hand_player_statistics.flg_f_bet AND cash_hand_player_combinations.flg_f_highcard
cash_hand_player_statistics.flg_t_bet AND cash_hand_player_combinations.flg_t_highcard
cash_hand_player_statistics.flg_r_bet AND cash_hand_player_combinations.flg_r_highcard

Flag highcard includes all type of draws in Flop / Turn? Should I take into consideration number of cards used or is it irrelevant?

Thanks in advance!

[Flag_Hippo]

My last question is about Bluffs, would these column work good?

cash_hand_player_statistics.flg_f_bet AND cash_hand_player_combinations.flg_f_highcard
cash_hand_player_statistics.flg_t_bet AND cash_hand_player_combinations.flg_t_highcard
cash_hand_player_statistics.flg_r_bet AND cash_hand_player_combinations.flg_r_highcard

That will work but only if the player has a high card hand. It will not count hands where the player has another hand strength such as a flush on the river without using any of their hole cards.

Flag highcard includes all type of draws in Flop / Turn?

Yes unless you specify otherwise.

Should I take into consideration number of cards used or is it irrelevant?

It can be used but only if you want differentiate between holecards that are under/over the lowest board card. On the flop it is not relevant as highcard will always be cash_hand_player_combinations.val_r_hole_cards_used = 2.

[parraka]

Hello, thanks for all the help. Now I have doubts about "bluff", what do you think it would be the most accurate column to do it for Flop / Turn / River?

It doesnt make sense to discard cases where Board is 774JK, Villain has A2 and it counts as Pair.

How is it done the Notetracker Note "3 Barrels with Air"?

[Flag_Hippo]

Now I have doubts about "bluff", what do you think it would be the most accurate column to do it for Flop / Turn / River?

You would need to define what a "bluff" is and then you can build your columns around that definition. For example:

Code: Select all

(cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 2) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 2) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.val_r_hole_cards_used = 0) OR (.........

How is it done the Notetracker Note "3 Barrels with Air"?

That just uses cash_hand_player_combinations.flg_r_highcard for the river. You can check the filter being used by selecting the note definition in NoteTracker:

Guide: NoteTracker