RECORDING PAST ACTIONS

[tommyborstal]

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

[BillGatesIII]

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'

[tommyborstal]

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.

[BillGatesIII]

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'

[tommyborstal]

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

[tommyborstal]

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

[kraada]

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.

[tommyborstal]

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.

[kraada]

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

[tommyborstal]

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