WSD when called River Cbet %

[oracle3001]

Could somebody just confirm that I have made this custom stat correctly, as the numbers I am seeing for opponents are very low (too low, I find it hard to believe reasonable regs are calling down triple barrels and only winning 10% of the time).

new column called "cnt_wtsd_won_when_r_call_cbet"

sum(if[cash_hand_player_statistics.enum_r_cbet_action='C',1,0]) and cash_hand_player_statistics.flg_won_hand and cash_hand_player_statistics.flg_showdown, 1, 0])

WSD when Called River CBet % = (cnt_wtsd_won_when_r_call_cbet / cnt_r_cbet_def_action_call) * 100

[pasita]

not sure of your stat (not at my PT-PC right now) but you can easily verify your numbers by creating a new opportunity stat: just drop the cash_hand_player_statistics.flg_won_hand from your stat. Check if the numbers remain the same.

[BillGatesIII]

PT4 has a built in stat WSD % After Call River.

Description says:

Percentage of the time that a player won at showdown given that he called a bet or raise on the river.

Formula: Number of Times Player Won Money at Showdown When Calling on the River / Number of Times Player Went to Showdown When Calling on the River

[WhiteRider]

Your new actions column looks OK except that you have an extra ",1,0])" in the middle that you need to remove.

sum(if[cash_hand_player_statistics.enum_r_cbet_action='C',1,0]) and cash_hand_player_statistics.flg_won_hand and cash_hand_player_statistics.flg_showdown, 1, 0])

..should be:

sum(if[cash_hand_player_statistics.enum_r_cbet_action='C' and cash_hand_player_statistics.flg_won_hand and cash_hand_player_statistics.flg_showdown, 1, 0])

However, you may need a new opportunities column.
I would think that you want to know the percentage of times that a player wins the hand, when they call a river CBet and go to showdown.
Currently you're getting the percentage of times that the player goes to showdown and wins, when they call a river CBet.

It's a subtle distinction, but currently your stat will show 0% (0/1) if they call a river CBet and then face a raise and fold, where I assume you would want that to be N/A (0/0)?

[oracle3001]

PT4 has a built in stat WSD % After Call River.

Description says:

Percentage of the time that a player won at showdown given that he called a bet or raise on the river.

Formula: Number of Times Player Won Money at Showdown When Calling on the River / Number of Times Player Went to Showdown When Calling on the River

Thanks, but that isn't quite what I am after.

[oracle3001]

It's a subtle distinction, but currently your stat will show 0% (0/1) if they call a river CBet and then face a raise and fold, where I assume you would want that to be N/A (0/0)?

What do I need to change to make this correct?

[WhiteRider]

Your opportunities column would need to be:

sum(if[cash_hand_player_statistics.enum_r_cbet_action='C' and cash_hand_player_statistics.flg_showdown, 1, 0])

(Exactly the same as the actions column but with "won hand" removed.)

[oracle3001]

Thanks.