2-3 last openraise sizing

[lukwww]

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.

[lukwww]

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

[athrac]

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...

[kraada]

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.

[lukwww]

Its not work + i ask for tournament version

[WhiteRider]

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

[BillGatesIII]

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.