Rake per street

[4StarGen]

From what I see in the stats, rake is gathered through the cash hand history summary, but what if I need to know the raked pot size OTF instead of the total? Is there a way I can code it?

[Flag_Hippo]

I don't see how that can be calculated with the database schema. The size of the pot on the flop is cash_hand_summary.amt_pot_f but that is before any betting commences and cash_hand_summary.amt_pot_t would be the size of the pot at the end of the flop/start of the turn but only if the turn is reached so while you could adjust that based on the rake for your poker site(s) it wouldn't account for hands that actually ended on the flop.

[4StarGen]

it seems you already helped a player https://www.pokertracker.com/forums/vie ... et#p375447

[Flag_Hippo]

Is that what you needed? Apologies but I thought based on your OP that you wanted something different.

[4StarGen]

Don't apologize plz, you are here, helping people out for free... Ty for this

The end goal is to make custom bet stats that takes into account the rake taken before the hand is over. I guess I will make it thanks to that thread but I haven't understand the river AI thing.
I mean, if I decide to go down this route, what technical challenges I would face?

[Flag_Hippo]

The end goal is to make custom bet stats that takes into account the rake taken before the hand is over. I guess I will make it thanks to that thread but I haven't understand the river AI thing.

Are you referring to why the OP in that thread wants to omit river all-in bets or are you not sure on the method used for that (cash_hand_player_statistics.amt_r_bet_made < cash_hand_player_statistics.amt_r_effective_stack)? I can't speak for why the OP wants to exclude them but maybe part of the reason is that for some situations a player has a shorter stack on the river which limits their bet size options.

I mean, if I decide to go down this route, what technical challenges I would face?

That may depend somewhat on the rake structure of your poker site and if you are only playing on a single site that would be more straightforward then trying to build bet sizing statistics that would account for different rake structures across multiple sites.