Calling Down Turn Raise Stat

[gamingmouse]

I just created a stat for calculating profit when calling down a turn raise when HU on the turn. It's my first custom stat/reports, so I'd want to make sure there aren't any errors. Also, any suggestions for improvement/simplicity are appreciated.

So here are the steps I took:

1. Created a new column call "cust_flg_cd_t_raise" with this definition:

holdem_hand_summary.cnt_players_t = 2
AND holdem_hand_player_statistics.flg_t_face_raise
AND holdem_hand_player_statistics.flg_showdown
AND NOT holdem_hand_player_statistics.flg_t_3bet
AND holdem_hand_player_statistics.cnt_r_call = 1
AND NOT holdem_hand_player_statistics.flg_r_bet

2. Created a variable "var_amt_cd_t_raise_profit" to get the per hand profit (in BB) using this flag:

if(cust_flg_cd_t_raise=false,0,
if(flg_won_hand, (amt_pot / lookup_limit_bb( id_limit )) - 3, 0 - 3 )
)

3. Created a statistic with

value expression: var_amt_cd_t_raise_profit
format expression: format_number(var_amt_cd_t_raise_profit,2,false, false)

Then ran a report with this stat in it. It seemed to work. But I thought there might be a better way to do it....

Thanks for any advice,
Jonah

[WhiteRider]

I'll have a look at this in more detail later, but your fields look reasonable.
What section is this in? Holdem Cash Hand?
Are the 3's because the blinds are 1/2?

[gamingmouse]

I'll have a look at this in more detail later, but your fields look reasonable.
What section is this in? Holdem Cash Hand?
Are the 3's because the blinds are 1/2?

Yes to holdem cashhand. No to your other question.

The 3's are an error.... it should be 2's... which is the number of big bets it costs you to calldown.

[gamingmouse]

Oh also I forgot to ask: I'd like the same stat except specifically when c/raised, not just raised. But I couldn't find a face_check_raise flag... I could build one but I thought there might be something I'm missing....

Thanks,
Jonah

[WhiteRider]

No, there isn't a face check raise flag (unfortunately!), but you can use
holdem_hand_player_statistics.flg_t_bet (specifically, a "bet" not a raise)
holdem_hand_player_statistics.flg_t_face_raise
holdem_hand_player_detail.flg_t_has_position (I don't think you need this if you use the above two, but it's a useful one to know about)