(expression) filter for opponents stacksize?

[ommaha]

Is there a possibility to filter for the stacksize of the first raiser?

F.e. I only want to filter for 3bet opportunities where the openraiser has between 30 and 50 big blinds. tyvm

[Flag_Hippo]

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_first_raise and chps.amt_before / cl.amt_bb between 30 and 50)

[ommaha]

tyvm

that is completely new kind of syntax to me, especially "id_hand" and "chps".
Is there a tutorial or explanation what the different parts of the syntax mean available somewhere?

How would I filter for situations where I have a squeeze opportunity OTB 6max when there is exactly one caller of the first raise and I want the caller to have between 30 and 50 blinds f.e.?
I would start with the following but I have no idea about adding stacksizes:

cash_hand_player_statistics.flg_p_squeeze_opp and cash_hand_player_statistics.position = 0 and char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_actors_p) >= 2 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_actors_p from 1 for 1) and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 and 3 and substring(cash_hand_summary.str_actors_p from 2 for 1)::int BETWEEN 1 and 2 and (char_length(cash_hand_summary.str_actors_p) = 2 or (char_length(cash_hand_summary.str_actors_p) > 2 and not (((substring(cash_hand_summary.str_actors_p from 3 for 1)::int - cash_hand_player_statistics.position + 10) % 10) BETWEEN 1 AND (((substring(cash_hand_summary.str_actors_p from 2 for 1)::int - cash_hand_player_statistics.position + 10) % 10)))))

Any help very appreciated

[Flag_Hippo]

'id_hand' is the hand identifier and 'chps' is an just an abbreviation of 'cash_hand_player_statistics' - see here for further information on these queries.

How would I filter for situations where I have a squeeze opportunity OTB 6max when there is exactly one caller of the first raise and I want the caller to have between 30 and 50 blinds f.e.?
I would start with the following but I have no idea about adding stacksizes:

In this scenario the caller would have cold called so you can use this:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_ccall and chps.amt_before / cl.amt_bb between 30 and 50)

[ommaha]

tyvm

[ommaha]

I am sorry that I have to ask a very similar thing again.
What is the Syntax like when I want to have a Player in a certain Position with a certain stack. F.e. small blind has between 30 and 50bb?
btw is there a list available of all the flg_p to be used with PT4?

Any help very appreciated

[Flag_Hippo]

What is the Syntax like when I want to have a Player in a certain Position with a certain stack. F.e. small blind has between 30 and 50bb?

It's the same:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.position = 9 and chps.amt_before / cl.amt_bb between 30 and 50)

btw is there a list available of all the flg_p to be used with PT4?

You can find the files used to create the database in your PokerTracker 4 installation folder:

C:\Program Files (x86)\PokerTracker 4\Data\Schemas

The meaning of database fields with the same names haven't changed in any significant way from PokerTracker 3 however forum member 'Bininu' made their own schema document for PokerTracker 4 available in this thread.