How to filter for all in adj bb/100 after winning/losing x b

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

How to filter for all in adj bb/100 after winning/losing x b

Postby ommaha » Thu Aug 24, 2023 6:39 pm

Hi,
I was wondering if there is an opportunity to filter for my performance after winning/losing x amount of bb or $ in a session.
Maybe in pokertracker, pgadmin, excel aso? I remember the program tiltbreaker to have that function. But it doesn't seem to exist anymore.

I would be very interested to know if a stop loss of your would be beneficial for me.

I would really appreciate any help very much.
ommaha
 
Posts: 221
Joined: Sun Jul 29, 2012 8:46 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby Flag_Hippo » Fri Aug 25, 2023 6:16 am

There isn't currently any filters or apps available in PokerTracker to filter for your "performance".
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby ommaha » Fri Aug 25, 2023 10:11 am

with performance I mean all in adj bb/100 ;-)

Is there a way to filter for that?
ommaha
 
Posts: 221
Joined: Sun Jul 29, 2012 8:46 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby Flag_Hippo » Fri Aug 25, 2023 12:01 pm

There isn't a filter but there is a built-in statistic called 'All-In Equity Adjusted BB/100' which you can add to your reports.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby Smoothed90 » Tue Apr 02, 2024 4:51 am

Flag_Hippo wrote:There isn't a filter but there is a built-in statistic called 'All-In Equity Adjusted BB/100' which you can add to your reports.

Hello. This has been updated? I mean, in reports, can I make a quick filter that will show me the hands with "All-In Adj BB" between a range of Bb's?
Smoothed90
 
Posts: 13
Joined: Sun Dec 19, 2021 3:09 pm

Re: How to filter for all in adj bb/100 after winning/losing

Postby Flag_Hippo » Tue Apr 02, 2024 6:53 am

That will need an expression filter:

Cash
Code: Select all
cash_hand_player_statistics.amt_expected_won / cash_limit.amt_bb

Tournaments
Code: Select all
tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb

Bear in mind that in hands with no all-in adjustment the adjusted result will be the same as the actual result so you might want to compare the two in the expression filter. For example:

Code: Select all
(tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb) != (tourney_hand_player_statistics.amt_won / tourney_blinds.amt_bb) and tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb > 50

You can use expression filters by clicking on the 'Filters' link and selecting 'Add New Expression Filters' in a custom report:

Guide: Creating My Reports
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby Smoothed90 » Tue Apr 02, 2024 8:52 am

Thank you for your answer but I couldn't solve it. The second code you gave me is not valid. Anyway I think what I need is the third one but doesn't work properly. Let me explain you what I need to see if it's possible (it's incredible all the posibilities of the program!)

I have Thousands of hands, I play SPINS and I want to study all the hands horribly played.
I have, in the report page, a STAT named "All-In Adj, BB", So i want to filter all the hands whick "All-In Adj. BB" are between "-9" and "-25". Horribly wrong played in spins.
Any possibility?
Thank you.
Smoothed90
 
Posts: 13
Joined: Sun Dec 19, 2021 3:09 pm

Re: How to filter for all in adj bb/100 after winning/losing

Postby Flag_Hippo » Tue Apr 02, 2024 1:07 pm

Smoothed90 wrote:The second code you gave me is not valid.

You also need to include a value (or range of values) for the amount of big blinds you want as per the final example (which is for an adjusted bb amount greater than 50).
Smoothed90 wrote:Anyway I think what I need is the third one but doesn't work properly. Let me explain you what I need to see if it's possible (it's incredible all the posibilities of the program!)

I have Thousands of hands, I play SPINS and I want to study all the hands horribly played.
I have, in the report page, a STAT named "All-In Adj, BB", So i want to filter all the hands whick "All-In Adj. BB" are between "-9" and "-25". Horribly wrong played in spins.
Any possibility?

That would be this:

Code: Select all
tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb between -9 and -25
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: How to filter for all in adj bb/100 after winning/losing

Postby Smoothed90 » Wed Apr 03, 2024 8:57 am

Flag_Hippo wrote:
Smoothed90 wrote:The second code you gave me is not valid.

You also need to include a value (or range of values) for the amount of big blinds you want as per the final example (which is for an adjusted bb amount greater than 50).
Smoothed90 wrote:Anyway I think what I need is the third one but doesn't work properly. Let me explain you what I need to see if it's possible (it's incredible all the posibilities of the program!)

I have Thousands of hands, I play SPINS and I want to study all the hands horribly played.
I have, in the report page, a STAT named "All-In Adj, BB", So i want to filter all the hands whick "All-In Adj. BB" are between "-9" and "-25". Horribly wrong played in spins.
Any possibility?

That would be this:

Code: Select all
tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb between -9 and -25


THANK YOU SO F**** MUCH. That's just what I needed.
Just wanted to say, in case someone is in the same situation as me, that the code you gave me won't work with those values, you have to write first the lowest value, which is -25. It would be this way:

Code: Select all
tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb between -25 and -9
Smoothed90
 
Posts: 13
Joined: Sun Dec 19, 2021 3:09 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 44 guests

cron