PokerTracker

Hi i am building a panel that logs the past 10 actions of my opponent in the sb and bb in HUSNGs and the HU portion of spins

i have most of it down but cannot get the hud to record a check v SB limp as 'X'

here's what i have tried:

substr(string_agg(CASE WHEN tourney_hand_player_statistics.position = 8
THEN ( CASE WHEN tourney_hand_player_statistics.flg_p_check THEN 'X'......)

and:

WHEN tourney_hand_player_statistics.flg_p_open_opp AND NOT tourney_hand_player_statistics.flg_p_first_raise THEN 'X'

neither of which produces an 'X' when villain checks back v a limp. everything is sql valid

does anyone know how to write the statement that would produce an X when villain checks?



also would there be a way of assigning different colours to check backs, isolation raises, preflop calls etc.

also also, is there a way of limiting the information retrieved to just the current tournamnet as having history / games-flow from the last game isnt helpful?

many thanks in advance,

alan

Try this for a check in de bb when the sb limps.

Code: Select all

tourney.hand_player_statistics.position = 8
and lookup_actions_p.action = 'X'

Thank you for your time, but currently i have the following line:

WHEN tourney_hand_player_statistics.flg_p_open_opp AND NOT tourney_hand_player_statistics.flg_p_first_raise
THEN 'X'

this is a valid SQL statement only it doesn't catch checks and report them as 'X' [it simply records them as '0' the default lable i assigned to anything that doesnt match one of my action lables]

when i swap it to

WHEN tourney.hand_player_statistics.position = 8
and lookup_actions_p.action = 'X'
THEN 'X'

it is now not a valid SQL statement.

My bad. There is a . in tourney_hand_player_statistics instead of a _.

Code: Select all

tourney_hand_player_statistics.position = 8
and lookup_actions_p.action = 'X'

you are a gent and a scholar, thank you.

you also helped without knowing as some of your old posts also helped me fix bugs today.

thanks again for your time

if anyone can help with the following:

also would there be a way of assigning different colours to check backs, isolation raises, preflop calls etc.

also also, is there a way of limiting the information retrieved to just the current tournamnet as having history / games-flow from the last game isnt helpful?

i'd be grateful

You can assign colors to stats in the Configure -> Statistics -> Colors section based on column values. Note though that the number of colors is limited on PokerStars due to their terms of service changes.

could you post an example of what the code might look like.

say i want output L to be green and R to be red what would be an example of code that would produce that.

You can use regular inequalities - if your column is named L you could do L >= 50 as the expression and it would work - you just set the color using the color picker (double click the black box next to Color).

i am very new to this.

i typed L=50 into the colour expression but it isnt a vaild statement

can you give an example of a valid colour expression?

to be clear, the output in my HUD is L when villain limps.

and i would like to be able to assign a colour to that