PDA

View Full Version : Help for AFq code



Gener
09-19-2009, 11:21 AM
Hello :)

I need a stat that comptablise all the folds please.

i have :rolleyes:

Stat GroupName="Default" ColumnName="AFq" ValueExpressions="sum(ph.TotalFlopBets) as FlopBets;sum(ph.TotalFlopCalls) as FlopCalls;sum(ph.TotalFlopFolds) as FlopFolds;sum(ph.TotalTurnBets) as TurnBets;sum(ph.TotalTurnCalls) as TurnCalls;sum(ph.TotalTurnFolds) as TurnFolds;sum(ph.TotalRiverBets) as RiverBets;sum(ph.TotalRiverCalls) as RiverCalls;sum(ph.TotalRiverFolds) as RiverFolds;" Evaluate="(FlopBets+TurnBets+RiverBets)/1.0/(FlopBets+TurnBets+RiverBets+FlopCalls+TurnCalls+R iverCalls+FlopFolds+TurnFolds+RiverFolds)" ColumnHeader="AFq" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Aggression Frequency" /

but


sum(ph.TotalFlopFolds) as FlopFolds sum(ph.TotalTurnFolds) as TurnFolds sum(ph.TotalRiverFolds) as RiverFolds .


not exist. :eek:


If you know the formula equivalent :D

sorry for my bad english :(

fine day for all :cool:

fozzy71
09-20-2009, 10:16 AM
I have forwarded this thread to the developer for a reply.

Rvg72
09-21-2009, 12:26 AM
It's a little more complex - I used the playeractiontype ID lookup which I documented in another post tonight. There might be better ways to do this but this works and is pretty fast.

<Stat ColumnName="fold" ValueExpressions="sum(case when ph.flopplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as FlopFolds;sum(case when ph.turnplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as TurnFolds;sum(case when ph.riverplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as RiverFolds" Evaluate="FlopFolds+TurnFolds+RiverFolds" ColumnHeader="FoldCount" ColumnFormat="0" ColumnWidth="*" Tooltip="Total Folds postflop" />

Gener
09-23-2009, 04:58 PM
Hello :)

Thank you, :D
I'll watch it all.

This is new to me, but I'll get there.

Good day to you.

Edit :this is ? :D

Stat GroupName="Default" ColumnName="AFq" ValueExpressions="sum(ph.TotalFlopBets) as FlopBets;sum(ph.TotalFlopCalls) as FlopCalls;sum(ph.TotalTurnBets) as TurnBets;sum(ph.TotalTurnCalls) as TurnCalls;sum(ph.TotalRiverBets) as RiverBets;sum(ph.TotalRiverCalls) as RiverCalls;sum(case when ph.flopplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as FlopFolds;sum(case when ph.turnplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as TurnFolds;sum(case when ph.riverplayeractiontype_id in (0,1,2,3,7,12,13,17,23,24,25,29,34,35,39,45,46,47, 51,56,57,61,67,68,69,73,78,79,83) then 1 else 0 end) as RiverFolds" Evaluate="(FlopBets+TurnBets+RiverBets)*100/1.0/(FlopBets+TurnBets+RiverBets+FlopCalls+TurnCalls+R iverCalls+FlopFolds+TurnFolds+RiverFolds)" ColumnHeader="AFq" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Aggression Frequency" /