PokerTracker

Hello.
I want to create statistic to hud that give me information about openraise sizing from last 2-3 situation when player openraise.
It is possible? Example (2x, 2.2x, 2x). I know about stat avarage 2bet sizing. looking for something better.

or 3 stats: last hand openraise sizing, (last hand)-1 openraise sizing, (last hand)-2 openraise sizing

This is what i came up with:

Code: Select all

array_to_string((array_agg(to_char(cash_hand_player_statistics.amt_p_raise_made/cash_limit.amt_bb, 'FM999D0')
order by cash_hand_player_statistics.date_played DESC)
filter (where cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp
))[1:3], ', ')


It works in reports but I can't seem to get it working in HUD and I have no idea why...

Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder.

Its not work + i ask for tournament version

If you export the stat and attach it to a Support Ticket we'll be able to take a look at it for you.

athrac wrote:This is what i came up with:

Code: Select all

array_to_string((array_agg(to_char(cash_hand_player_statistics.amt_p_raise_made/cash_limit.amt_bb, 'FM999D0')
order by cash_hand_player_statistics.date_played DESC)
filter (where cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp
))[1:3], ', ')


It works in reports but I can't seem to get it working in HUD and I have no idea why...

Nice piece of code It works here in my HUD, in the stat I set the Format Type to None.

For other people reading this, you'll need at least PostgreSQL 9.4 and it might be a bit slow with large databases.