winrates bb/100 in different spots

[Kevin Hofstadter]

I would like to build a report that will include All-in adjusted bb/100 stats for various spots i.e facing an ISO, facing XR on the flop etc. My understanding is the way to do it is to make custom winrates stats. So far I can't figure out how to combine tourney_hand_player_statistics.amt_expected_won with specific condition. Can someone point me to the right direction, please?

[Flag_Hippo]

For each statistic you need two custom columns. The first would sum the amount of adjusted BB won in a particular spot:

custom_column_1

Code: Select all

sum(if[your_custom_expression, tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb, 0])

the second the number of hands in that spot:

custom_column_2

Code: Select all

sum(if[your_custom_expression, 1, 0])

then you can create a custom statistic with:

Code: Select all

custom_column_1 / (custom_column_2 / 100)

If you need it see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. The latter was written for PokerTracker 3 but the techniques all apply to PokerTracker 4, the interface is just slightly different.

[Kevin Hofstadter]

Thank you for quick reply. This is exactly what I've been looking for!