Search:

more accurately, the behavior is inconsistent. Sometimes it will find and open tables. Mostly it will not. Almost always it will find tables when I click join. Rarely will it actually join the...

nvm. updated to 1.10 b8 and all is working.

I have same problem OP described. Though the text size is already set to medium in pokerstars for me. HEM 1.10 beta 7. Both black and classic lobby theme.

Table opens fine. just doesn't join.

where should I be looking in the db to build stats for turn donk % and river donk %?

As a final clarification:

If I am on the button with 200bb. BB has 20bb and SB 100bb. I raise, SB folds, BB calls. The Effective stack is 100bb, even though I can only now lose 20bb. This is...

What is the formula for the effective stack stat? I ask because I am working on a report and trying to filter by effective stacks during the flop. Problem is I end up with many heads up post flop...

You can create custom stats and reports already. See: http://www.holdemmanager.net/faq/?f=44

The missing component is that you can't put custom stats in the HUD. That is something that I feel...

This looks straight forward, but why not just keep fold to cbet stat and know it's 100 minus it.

Copy it to your reports directory and rename the .txt to .Report

Open HEM, Choose the reports tab an select if from the dropdown.

Which video numbers/series are you referring to?

Dunno what the developer needs to do. I was just sharing my stat w/ the OP.

This is what I do (for 27% from Full Tilt)

<Stat GroupName="Default" ColumnName="TotalWin" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount;Sum(PH.NetAmountWon)/100 as NetWin"...

just a blank text file. You can right click, select New -> Text document.

Check this out and post if you have any problems:

http://www.holdemmanager.net/faq/?f=44

Note: you may need to create the customstats.txt file that is referred to in this FAQ entry.

<Stat GroupName="Default" ColumnName="Base FTPs" ValueExpressions="Sum(PH.RakeAmount*PH.NumberOfPlayers)/100.000 as BaseFTPsTotal" Evaluate="BaseFTPsTotal" ColumnHeader="FTPs" ColumnFormat="0"...

I don't know if this problem is still in the problem queue, but in 1.08.01 this is also a problem for the Turn Hand Value of Full House on Board (something that should be impossible I'd think.)
...

Haven't tested it, but this may work.


&lt;Stat GroupName="Default" ColumnName="EVStdDevbigbet" ValueExpressions="10*stddev((case when EV.SklanskyBucks <> 0 then EV.SklanskyBucks else...

Remove this:

&lt;Grouping FieldExpression="to_char(PH.HandTimeStamp,'HH24')" ColumnName="Hour of Day" /&gt;

From the text file.

try 'D'

Should get you a number 1 thru 7 with 1 = Sunday.

Here is a reference (Table 9-21):

http://www.postgresql.org/docs/8.1/static/functions-formatting.html

just bumping. I know Roy's busy, but any ETA on a response?

Thanks much,
nfh

Strange, mine is still empty, even when I have the HUD running. I look forward to hearing from Roy for some clarification on this.

-nfh

I'm trying to use a friends script that references the 'compiledresults' and 'compiledplayerresults' tables.

The problem is that those tables in my HEM DB are empty. They are defined, but have no...

&lt;Stat GroupName="Default" ColumnName="TotalWin" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount;Sum(PH.NetAmountWon)/100 as NetWin" Evaluate="(RakeBackAmount+NetWin)"...

Ok that last stat is crap.

This should do it:

&lt;Stat ColumnName="W$SDEV" ValueExpressions="sum(case when ph.maxstreetseen = 4 then (case when EV.SklanskyBucks <> 0 then EV.SklanskyBucks else...

understood. I may have just taken it that way.