PDA

View Full Version : Flushdraws flopped/made etc



El Helado
08-10-2009, 06:55 AM
Was wondering if anyone made any reports with like average hands made? It would be cool to see like

flushdraws (number), flushdraws hit%, flushdraws expected to hit

It would also be cool if someone calculated about how many 2pairs/sets/straights a normal FL SH-guy gets in 10 000 hands and it can compare to that and get a figure like; "Twopair dealt; 25% of normal rate"

TheZepper
08-17-2009, 06:12 PM
This ought to get you started:

ValueExpressions="sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and Flop.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as Flopflushdraw; sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and RIVER.MadeHandValue in (100,101,102,103,104,105) then 1 else 0 end) as HitFlushDrawbyRiver;" Evaluate="HitFlushDrawbyRiver/Flopflushdraw"

This is the stat I use for % of flopped flush draws hit by river (not inc. backdoor flush draws or those w/pocket pairs)...

antneye
08-17-2009, 10:08 PM
This ought to get you started:

ValueExpressions="sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and Flop.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as Flopflushdraw; sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and RIVER.MadeHandValue in (100,101,102,103,104,105) then 1 else 0 end) as HitFlushDrawbyRiver;" Evaluate="HitFlushDrawbyRiver/Flopflushdraw"

This is the stat I use for % of flopped flush draws hit by river (not inc. backdoor flush draws or those w/pocket pairs)...

Are you sure this works as typed? It's not working for me.

El Helado
08-18-2009, 06:58 AM
This ought to get you started:

ValueExpressions="sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and Flop.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as Flopflushdraw; sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and RIVER.MadeHandValue in (100,101,102,103,104,105) then 1 else 0 end) as HitFlushDrawbyRiver;" Evaluate="HitFlushDrawbyRiver/Flopflushdraw"

This is the stat I use for % of flopped flush draws hit by river (not inc. backdoor flush draws or those w/pocket pairs)...

Thanks but it sure looks like it shouldnt be working, i thought all stats started with a tab etc.

TheZepper
08-22-2009, 02:15 PM
I keep forgetting that I should post the entire stat rather than just the essentials (but, unfortunately, u can't copy the entire stat over the internet) - so here are 3 related, better stats to make up for my oversight:

<Stat GroupName="Draw" ColumnName="Flop AI MadeFlsh %" ValueExpressions="sum(case when ph.StreetWentAllin = 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) and RIVER.MadeHandValue in (100,101,102,103,104) then 1 else 0 end) as xMadeFlushAINUM; sum(case when ph.StreetWentAllin = 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as xFlopFlDwPossNUMAI;" Evaluate="xMadeFlushAINUM1/xFlopFlDwPossNUMAI" ColumnHeader="FLOP AI\nFlsh Dw\n 34.97%" ColumnFormat="0.0%" ColumnWidth="61" Tooltip="% of time player makes flop flush draw after moving all-in" />
<Stat GroupName="Draw" ColumnName="Turn MadeFlsh %" ValueExpressions="sum(case when ph.MaxStreetSeen >= 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) and TURN.MadeHandValue in (100,101,102,103,104) then 1 else 0 end) as xMadeFlushTurnNUM; sum(case when ph.MaxStreetSeen >= 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as xFlopFlDwPossNUM;" Evaluate="xMadeFlushTurnNUM/xFlopFlDwPossNUM" ColumnHeader="FLOP DW\nFlsh TN\n 19.15%" ColumnFormat="0.0%" ColumnWidth="61" Tooltip="% of time player makes flop flush draw on turn" />
<Stat GroupName="Draw" ColumnName="River MadeFlsh %" ValueExpressions="sum(case when ph.MaxStreetSeen >= 3 and FLOP.FlushDrawValue in (1,2,3,4,5,6) and TURN.FlushDrawValue in (1,2,3,4,5,6) and RIVER.MadeHandValue in (100,101,102,103,104) then 1 else 0 end) as xMadeFlushRiverNUM; sum(case when ph.MaxStreetSeen >= 3 and FLOP.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as xFlopFlDwPossNUM;" Evaluate="xMadeFlushRiverNUM/xFlopFlDwPossNUM" ColumnHeader="FLOP DW\nFlsh RV\n 19.57%" ColumnFormat="0.0%" ColumnWidth="61" Tooltip="% of time player makes flop flush draw on river" />
AND SOME DAYS NOTHING WILL COPY!
Hope these will fly for ya..

TheZepper
08-22-2009, 02:26 PM
I don't have any more time right now, so I'll just complete the first stat:

At the begiining, insert < Stat - WITHOUT a space between the < and Stat (the system won't let me do this!), then

GroupName = "Draw" ColumnName = "FlopDraw Made by River" ValueExpressions="sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and Flop.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as Flopflushdraw; sum(case when ph.MaxStreetSeen >= 3 and ph.holecardvalue_ID > 13 and RIVER.MadeHandValue in (100,101,102,103,104,105) then 1 else 0 end) as HitFlushDrawbyRiver;" Evaluate="HitFlushDrawbyRiver/Flopflushdraw"
ColumnHeader="FlopDW\nFL Made\n % " ColumnFormat = "0.0%" ColumnWidth = "61" />

TheZepper
08-22-2009, 04:57 PM
One last try:

Preceded by dreaded < followed by Stat:

GroupName="EVDraw"
ColumnName="Flop AI MadeFlsh"
ValueExpressions="sum(case when ph.StreetWentAllin = 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) and RIVER.MadeHandValue in (100,101,102,103,104) then 1 else 0 end) as xMadeFlushAINUM; sum(case when ph.StreetWentAllin = 2 and FLOP.FlushDrawValue in (1,2,3,4,5,6) then 1 else 0 end) as xFlopFlDwPossAINUM;"
Evaluate="100*(xMadeFlushAINUM/xFlopFlDwPossAINUM)"
ColumnHeader="FLOP AI\nFlsh DW\n 34.97"
ColumnFormat="0" ColumnWidth="61" />

This is % of Flop Flush draws made when get All-in on flop. Probability of making flush is 34.97% when draw two cards. The biggest problem with draw stats is that u often fold when miss - therefore simply dividing made flushes by flopped flushes is completely misleading. Flop All-ins resolve this difficulty.
The prob of hitting flopped 4 card flush on turn is 19.15%, on river is 19.57% and on either street is 34.97%. I put this "target" percentage directly in the ColumnHeader so I can compare my results to it without ever having to recalculate. Saves a lot of time and effort later.

I assume that by "normal rate" u mean mathematical expectation - u can compare your hiiting percentage v. the applicable "target" percentage (which I call a "%EV" stat)by: Evaluate="100/.3497*(xMadeFlushAINUM/xFlopFlDWPossAINUM - 0.3497) ....