SuperSized
06-10-2011, 06:14 PM
I'm trying to anlayse HU from super-turbo games on Stars. I want to know the shoving range for villains from the SB. I have obtained this information, but know I want to know what is the villain's shoving range when he is short stacked vs big stacked.
I made an alias containing all villains. I'm using the filters to return 2 players, effective stacksize = 2-4, Pos = SB. Now I'm trying to see how many times of the 400 hands that are returned by HEM, is the SB short-stacked. Since there are 4500 chips in total in each game, if "hero" has < 2250 he is short.
Why does this return 0 ....
Stat GroupName="Default" ColumnName="Short stack(#)"
ValueExpressions="sum(case when phmisc.stacksize < 2250 then 1 else 0 end) as ShortStack"
Evaluate="(ShortStack)" ColumnHeader="Short stack (#)" ColumnFormat="0" ColumnWidth="61" Tooltip="Short stack" />
.... while this returns the total number of hands, 400
Stat GroupName="Default" ColumnName="Big stack(#)"
ValueExpressions="sum(case when phmisc.StackSize >= 2250 then 1 else 0 end) as BigStack"
Evaluate="(BigStack)" ColumnHeader="Big stack (#)" ColumnFormat="0" ColumnWidth="61" Tooltip="Big stack" />
Note: "<" removed from before "Stat" to wrap tags around code.
I made an alias containing all villains. I'm using the filters to return 2 players, effective stacksize = 2-4, Pos = SB. Now I'm trying to see how many times of the 400 hands that are returned by HEM, is the SB short-stacked. Since there are 4500 chips in total in each game, if "hero" has < 2250 he is short.
Why does this return 0 ....
Stat GroupName="Default" ColumnName="Short stack(#)"
ValueExpressions="sum(case when phmisc.stacksize < 2250 then 1 else 0 end) as ShortStack"
Evaluate="(ShortStack)" ColumnHeader="Short stack (#)" ColumnFormat="0" ColumnWidth="61" Tooltip="Short stack" />
.... while this returns the total number of hands, 400
Stat GroupName="Default" ColumnName="Big stack(#)"
ValueExpressions="sum(case when phmisc.StackSize >= 2250 then 1 else 0 end) as BigStack"
Evaluate="(BigStack)" ColumnHeader="Big stack (#)" ColumnFormat="0" ColumnWidth="61" Tooltip="Big stack" />
Note: "<" removed from before "Stat" to wrap tags around code.