Effective M filter?

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Effective M filter?

Postby redicerap » Sat Oct 14, 2017 5:44 pm

Flag_Hippo wrote:I gave you the formula and an expression filter for 'Effective M' in my first reply and Holdem Manager 2 uses the same formula for their built-in filter.

yes, ty. and (i hope) i told you that the expression i wanted to do exceeded the character limit, whereas it would be possible to make this filter in the QUICK FILTER SECTION (by building many smaller filters and combining them into one single filter), but there's no effective m filter in the QUICK FILTER SECTION.
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby Flag_Hippo » Mon Oct 16, 2017 12:07 pm

If you cannot paste your expression into PokerTracker 4 then please save that to a plain text file and send that to us in a Support Ticket. Also if using your expression generates any error in PokerTracker 4 then enable logging, reproduce the issue and attach your log file to the ticket as well:

Guide: How to Create & Submit a PokerTracker4.log File
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Effective M filter?

Postby redicerap » Mon Oct 16, 2017 10:50 pm

Flag_Hippo wrote:If you cannot paste your expression into PokerTracker 4 then please save that to a plain text file and send that to us in a Support Ticket. Also if using your expression generates any error in PokerTracker 4 then enable logging, reproduce the issue and attach your log file to the ticket as well:

Guide: How to Create & Submit a PokerTracker4.log File


Hi, I tried it again and I don't know why it sometimes cut the code but it does work!! This is really amazing!

I first copied the code again and it cut it. Then I tried to copy paste the whole code part by part. The first two times it cut it but kept adding new code. Then the third time, instead of pasting with ctrl+v, I right clicked and pasted it that way and in pasted the rest of the code completely. And it seems to show the hands I was looking for!

Now I need a little further help to expand the filter. What are the expressions for the following:

VPIP=True
VPIP=False
NOT-expression on hand range (invert hand range)
RAISER'S POSITION = 0 (Villain is first in and open raises on the button)
OPPORTUNITY TO COLD CALL 2BET PREFLOP (no callers in between open raiser and hero)
OPPORTUNITY TO CALL 2BET PREFLOP (regardless if there are callers in between)

Thanx a lot in advance. Epic job you are doing here!
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby redicerap » Tue Oct 17, 2017 12:36 am

Sry i dont know how to edit a post, but i also need the expression for "Effective Average M (excluding players who have folded)".


PokerStars - 900/1800 Ante 150 NL - Holdem - 8 players
Hand converted by PokerTracker 4: http://www.pokertracker.com

Hero (MP): 10,034
MP+1: 49,266 (VPIP: 33.33, PFR: 37.50, 3Bet Preflop: 50.00, Hands: 10)
CO: 46,382 (VPIP: 0.00, PFR: 0.00, 3Bet Preflop: 0.00, Hands: 10)
BTN: 5,106 (VPIP: 5.41, PFR: 6.06, 3Bet Preflop: 0.00, Hands: 37)
SB: 14,155 (VPIP: 16.85, PFR: 9.30, 3Bet Preflop: 5.13, Hands: 91)
BB: 44,795 (VPIP: 24.69, PFR: 20.25, 3Bet Preflop: 10.71, Hands: 82)
UTG: 39,523 (VPIP: 16.13, PFR: 12.75, 3Bet Preflop: 4.03, Hands: 310)
UTG+1: 124,215 (VPIP: 20.00, PFR: 10.00, 3Bet Preflop: 16.67, Hands: 10)

8 players post ante of 150, SB posts SB 900, BB posts BB 1,800

Pre Flop: (pot: 3,900) Hero has 9s Ad
fold, fold, Hero raises to 9,884 and is all-in, fold, fold, fold, fold, fold

Hero wins 5,700


Effective Average M Players left to act =
10,034 (MP+1)
+ 10,034 (CO)
+ 5,106 (BU)
+ 7,155 (SB)
+ 6,795 (BB)
= 39,124 / 5 (Players left to act)
= 7,825 / 3900 (Pot)
= 2.0

It sounds so complicated, so i made the example :)
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby Flag_Hippo » Tue Oct 17, 2017 7:13 am

redicerap wrote:VPIP=True

Code: Select all
tourney_hand_player_statistics.flg_vpip = true

redicerap wrote:VPIP=False

Code: Select all
tourney_hand_player_statistics.flg_vpip = false

redicerap wrote:NOT-expression on hand range (invert hand range)

Code: Select all
NOT tourney_hand_player_statistics.id_holecard in  (1,2,4,6,8,10,12,14,16,18,20,22,24,3,26,27,29,31,33,35,37,39,41,43,45,47,5,28,49,50,52,54,56,58,60,7,30,51,70,71,73,75,77,9,32,53,72,89,90,92,94,11,34,74,91,106,107,109,111,13,121,122,124,15,134,135,137,17,145,146,19,154,155,21,161,23,166,25,169)

redicerap wrote:RAISER'S POSITION = 0 (Villain is first in and open raises on the button)

Code: Select all
tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '0%'

(see this post for more information on how the aggressors/actors strings work).
redicerap wrote:OPPORTUNITY TO COLD CALL 2BET PREFLOP (no callers in between open raiser and hero)

Code: Select all
tourney_hand_player_statistics.amt_p_2bet_facing > 0 and tourney_hand_player_statistics.flg_p_squeeze_opp = false

redicerap wrote:OPPORTUNITY TO CALL 2BET PREFLOP (regardless if there are callers in between)

Code: Select all
tourney_hand_player_statistics.amt_p_2bet_facing > 0

redicerap wrote:but i also need the expression for "Effective Average M (excluding players who have folded)".

That looks like you are using effective stacks in your calculation but I am not sure how you came up with the SB and BB numbers but if you want to include information about the other players effective stacks in your expression then that would require a complex subquery. I am not aware of a method to do that but it would require accessing the effective stacks of the remaining players individually and you would need to know SQL and how to build a subquery to make it work correctly. Also the effective stack has a very specific meaning in PokerTracker - it's the amount a player can potentially lose in a pot as of their first action in the hand so the effective stacks of the remaining players can vary depending on the specific actions in a hand. So in your example the effective stack of MP+1 will be influenced by the players left to act and the effective stacks of the SB and BB will change depending on whether MP+1/CO enters the pot or not.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Effective M filter?

Postby redicerap » Wed Oct 18, 2017 8:29 pm

thanks a lot!




yea you are right, i changed the values of the blinds so it gets more obvious what im looking for and forgot to change the values above. i try to do it again. i think what im looking for is def possible (this is for the first-in filter. i dont know yet how to specify things when someone entered the pot, i will come to that later maybe):

Hero (MP): 10,034
MP+1: 49,266 (VPIP: 33.33, PFR: 37.50, 3Bet Preflop: 50.00, Hands: 10)
CO: 46,382 (VPIP: 0.00, PFR: 0.00, 3Bet Preflop: 0.00, Hands: 10)
BTN: 5,106 (VPIP: 5.41, PFR: 6.06, 3Bet Preflop: 0.00, Hands: 37)
SB: 7,155 (VPIP: 16.85, PFR: 9.30, 3Bet Preflop: 5.13, Hands: 91)
BB: 6,795 (VPIP: 24.69, PFR: 20.25, 3Bet Preflop: 10.71, Hands: 82)
UTG: 39,523 (VPIP: 16.13, PFR: 12.75, 3Bet Preflop: 4.03, Hands: 310)
UTG+1: 124,215 (VPIP: 20.00, PFR: 10.00, 3Bet Preflop: 16.67, Hands: 10)


39,523 (UTG folded, gets ignored)
124,215 (UTG+1 folded, gets ignored)

10,034 (Hero, action is on me, so from this situation on it should calculate)
+ 10,034 (MP+1)
+ 10,034 (CO)
+ 5,106 (BU)
+ 7,155 (SB)
+ 6,795 (BB)
= 49,158 / 6 (Players left to act)
= 8,193 / 3900 (Pot)
= 2.1

Note how i forgot to include hero the first time due to a logical flaw.

Looking at it now i think it's just:
effective average stack / the pot = effective average M.

This will be coupled with "hero opportunity to open the pot", so it doesnt matter if anybody before hero entered or whatever.
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby Flag_Hippo » Thu Oct 19, 2017 6:09 am

The effective stacks for each player in PokerTracker 4 are calculated as of their first action in the hand and not yours. For example if you VPIP and MP+1 folds then the effective stack for CO will be stored in the database as 10,034 but if MP+1 enters the pot the effective stack for CO will be stored as 46,382 and if both you and MP+1 fold then the effective stack for CO will be 7,155. Finally the effective stack for MP+1 will be 46,382 and not 10,034 as the CO is still to act behind them. This also does not change the fact that you would still need to build a complex subquery to access the effective stack for each of the remaining players.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Effective M filter?

Postby redicerap » Thu Oct 19, 2017 6:12 am

My bad, I had no logical flaw. The average effective M should not calculate hero. It should just use hero's stack to cap other stacks:

+ 10,034 (MP+1)
+ 10,034 (CO)
+ 5,106 (BU)
+ 7,155 (SB)
+ 6,795 (BB)
= 39,124 / 5 (Players left to act)
= 7,825 / 3900 (Pot)
= 2.0
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby redicerap » Thu Oct 19, 2017 6:24 am

Nono you misunderstood me. I don't need effective stacks from other players' point of view. It is just:

- average stack size of players left to act behind me (whereas bigger stacks than me should be treated as my own stacksize)
- divided by the pot size at the start of a hand

Maybe I misunderstood you. If it's really not possible then it's unfortunate. It at least sound pretty simple.
redicerap
 
Posts: 37
Joined: Wed Mar 25, 2009 10:20 am

Re: Effective M filter?

Postby Flag_Hippo » Thu Oct 19, 2017 2:36 pm

PokerTracker 4 stores the effective stacks in the database as of each players first action in the hand therefore this information can be retrieved from the database however treating bigger stacks to have an effective stack as yours and not based on any other players stacks is information that is not stored in the database and I am not able to give you an expression to filter your data in that way.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

PreviousNext

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 52 guests

cron
highfalutin