How to report money won/lost of a specific play?

[Suboptimal88]

Hi , at the report section i want to be able to see how much money i won or lost with a specific move , currently it only shows the total money lost or won during the specific time period , i want it to show the money lost or won of the play , for example i have reports for cbetting , i want to watch how much i win or lose with cbetting. how can i do this?

[kraada]

You want to filter for having made the play in question - then the report will show you profit (or loss) when you made that action. See this tutorial for more details on how to use our filtering system.

[Krutch525]

Hi, I'm looking for a stat the same as OP suggested (though it doesn't seem like a traditional stat). H2N 4 has what is called "action profit". For example, when I filter for River Probe in PT4, it gives me the result (BB won or amt won) of the whole pot. I want the result of the specific action of river probe; does it make or lose me money. I want the result for performing that action only. And this stat or whatever it is should be available across all actions like "bb won or amt won".

[Flag_Hippo]

To calculate that for river probes will require separate custom statistics for BB and amount won. This guide covers the basics on custom statistics creation and this guide goes into more detal. While the latter was written for PokerTracker 3 the techniques still apply to PokerTracker 4.

[Krutch525]

Thank you for the information. I would like this custom stat to apply across any of the hundreds of filters I use. For each scenario, I would rather not have to make an individual "action profit" stat. I have been told it's not possible in PT4's engine.

For the River Probe scenario, I am trying to make a column so it will start the sum counting 'amt_won' at time of river probe but I keep getting 'invalid SQL':

if[cash_hand_player_statistics.flg_t_probe,(cash_hand_player_statistics.amt_won + cash_hand_player_statistics.amt_bet_p + cash_hand_player_statistics.amt_bet_f) / cash_limit.amt_bb, 0]

[Flag_Hippo]

Thank you for the information. I would like this custom stat to apply across any of the hundreds of filters I use. For each scenario, I would rather not have to make an individual "action profit" stat. I have been told it's not possible in PT4's engine.

That is correct. You will need a custom statistic for each scenario although instead of building this for only a turn probe (see below) you can do it for any turn bet (bet, donk bet, cbet, probe bet) instead and then use filters to specify the type of turn bet.

For the River Probe scenario, I am trying to make a column so it will start the sum counting 'amt_won' at time of river probe but I keep getting 'invalid SQL':

if[cash_hand_player_statistics.flg_t_probe,(cash_hand_player_statistics.amt_won + cash_hand_player_statistics.amt_bet_p + cash_hand_player_statistics.amt_bet_f) / cash_limit.amt_bb, 0]

1. If you are writing this as a 'Player' statistic your custom column should be in this format:

Code: Select all

sum(if[expression, then, else])

2. You say this is for a river probe but the code you are providing is for the turn.

3. cash_hand_player_statistics.flg_t_probe does not exist in the database schema. You can get the code for a turn probe from the cnt_t_probe column expression:

Code: Select all

cash_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND ((cash_hand_summary.cnt_players >= 3 and cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b))

4. H2N provide this definition for action profit:

Action Profit of a specific action in a specific hand equals the difference between our stack size at the end of the hand and our stack size right before the action.

which for a turn probe would be:

Code: Select all

(cash_hand_player_statistics.amt_before + cash_hand_player_statistics.amt_won) - (cash_hand_player_statistics.amt_before - cash_hand_player_statistics.amt_bet_p - cash_hand_player_statistics.amt_bet_f)