PDA

View Full Version : 4bet formula



scorpycool
09-20-2011, 05:51 PM
Hi, I've got a problem:mad:. I need formula to calculate 4bet from data placed in HM database (postgres). I tried every combination - but nothing. In that post: "Formulas for every HM Stat! (Updated Nov 12, 2009)" there is'nt any formula for 4bet. Please help me to solve that:confused:.

Thanks.

Patvs
09-21-2011, 01:28 AM
I've forwarded your question to the stats programmers.

scorpycool
09-21-2011, 07:50 AM
I've forwarded your question to the stats programmers.

thanks

morny
09-22-2011, 12:29 PM
Hi,

The simplest thing to do to find the SQL for the stat is to enable logging. This can be done by closing down Holdem Manager and going to C:\Program Files (x86)\RVG Software\Holdem Manager\Config\HoldemManager.config and look for the following entry:

<setting name="LogDatabaseCommands">False</setting>

Change that setting to true, save the file and restart HoldemManager and youll get the following prompt: 26251

Once youve finished with logging be sure to turn this off as it can affect performance.

Once you enable logging and run any report it will create the SQL query for that report in the dbtrace.log file in C:\Program Files (x86)\RVG Software\Holdem Manager\Logs folder.

scorpycool
10-01-2011, 01:33 PM
I did that logging, but i cant find 4bet stat in that log. there are no any formulas at all.

I calc 3bet by that formula:

&lt;Stat GroupName="Default" ColumnName="3Bet" ValueExpressions="sum(case when ph.preflopaction_id = 3 or ph.preflopaction_id = 4 then 1 else 0 end) as CouldThreeBet;sum(case when ph.FirstPreflopActionType_ID = 3 and (ph.preflopaction_id = 3 or ph.preflopaction_id = 4) then 1 else 0 end) as DidThreeBet;" Evaluate="DidThreeBet*100.0/CouldThreeBet" ColumnHeader="3Bet%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player raises preflop when facing a raise" />


where can i find the same text about 4bet???:mad:

Sarek
10-03-2011, 12:58 PM
Publication of all formulas was promised by developers, but as you know they are very busy with HM2 right now.
Please be patient and wait

TheZepper
10-09-2011, 06:13 AM
This will do it:
ColumnName="PF 4Bet %"
ValueExpressions="sum(case when ph.positionType_ID <> 1 and ph.PreflopAction_ID in (0,1,2) and ph.PreflopPlayerActionType_id between 67 and 87 then 1 else 0 end) as PFv3BetxFace; sum(case when ph.positionType_ID <> 1 and ph.PreflopAction_ID in (0,1,2) and ph.PreflopPlayerActionType_id between 78 and 87 then 1 else 0 end) as PFv3Betx4Bet;"

Evaluate="PFv3Betx4Bet/PFv3BetxFace"
ColumnHeader=" 4BET%"
ColumnFormat="0.00%"
ColumnWidth="61"