Page 1 of 1

column for tourney that reached HU only

PostPosted: Tue Sep 12, 2023 1:27 pm
by kondom91
Code: Select all
count(distinct tourney_summary.id_tourney)


Can I count only the tournaments where I played at least 1 HU hand?

Re: column for tourney that reached HU only

PostPosted: Wed Sep 13, 2023 6:28 am
by Flag_Hippo
I don't know of a method to do that but you can get the number of tournaments from a report and filtering for heads-up hands. If you want a custom statistic then you could sum the amount of your first and second place finishes using:

Code: Select all
cnt_finish_1 + cnt_finish_2

but bear in mind if you are playing alot of Spins or similar tournaments then you might have a number of tournaments with a top 2 finish where no heads up hand was played.

Re: column for tourney that reached HU only

PostPosted: Wed Sep 13, 2023 7:31 pm
by kondom91
Yes, that's the problem. Basically I am trying to create a statistic with HU SB chipsEv and HU BB chips ev.

Maybe there is a way to sum up all the tournaments where at least one hand has players dealt in the hand = 2 and hero is either in SB/BB?

Re: column for tourney that reached HU only

PostPosted: Thu Sep 14, 2023 5:23 am
by Flag_Hippo
kondom91 wrote:Basically I am trying to create a statistic with HU SB chipsEv and HU BB chips ev.

You didn't include this information in your original post. PokerTracker 4 does not calculate 'EV' but it has a built in statistic called 'All-In Equity Adjusted BB' so if you want to see those results for heads up play you can use that statistic and then filter for hands with only two players dealt in. If you want to create a custom statistic then you can add tourney_hand_summary.cnt_players = 2 to the columns from the original statistic. You have previously created a similar column in this post that calculates adjusted BB for the big blind when BTN folds.

Re: column for tourney that reached HU only

PostPosted: Mon Sep 18, 2023 12:30 pm
by kondom91
Flag_Hippo wrote:
kondom91 wrote:Basically I am trying to create a statistic with HU SB chipsEv and HU BB chips ev.

You didn't include this information in your original post. PokerTracker 4 does not calculate 'EV' but it has a built in statistic called 'All-In Equity Adjusted BB' so if you want to see those results for heads up play you can use that statistic and then filter for hands with only two players dealt in. If you want to create a custom statistic then you can add tourney_hand_summary.cnt_players = 2 to the columns from the original statistic. You have previously created a similar column in this post that calculates adjusted BB for the big blind when BTN folds.


Yes, thank you. A friend asked me for a chipsEv stat from HU SB, but he probably use the bb100 adj I have already made