Here's a little teaser on the type of things you'll be able to do with HM:

1) backup and then open up your program files\rvg software\holdem manager\config\reportstats.xml file with notepad

2) add this line near the bottom

<Stat ColumnHeader="VV Turn CBet%" ColumnFormat="0.0" ColumnWidth="61" ToolTip="" SQL="(case when sum(case when TurnContinuationBetPossible = true then 1 else 0 end) = 0 then 0 else sum(case when TurnContinuationBetMade = true then 1 else 0 end)*100.0/sum(case when TurnContinuationBetPossible = true then 1 else 0 end) end)*(case when sum(case when FlopContinuationBetPossible = true then 1 else 0 end) = 0 then 0 else sum(case when FlopContinuationBetMade = true then 1 else 0 end)*100.0/sum(case when FlopContinuationBetPossible = true then 1 else 0 end) end)/100.0 as VVTurnContinuationBetPct" StatGroup="KeyPostFlopStats" />

You now have a new stat named VVTurnContinuationBetPct which is equal to your flop CB X turn CB

3) backup and then open your program files\rvg software\holdem manager\reports\overall.xml file with notepad

4) Add this line under the other similar lines:

<DefaultStat FieldName="VVTurnContinuationBetPct" />

5) Relaunch Holdem Manager and run your Overall Report and check out the VanVeen Turn CBet %.

6) Profit

The open ended nature of the reporting is going to let people become very creative in their analysis. Getting this new stat to appear in your HUD is much more of a challenge but I'm working on ways to do this. For the huge majority of you that don't feel too comfortable messing around with xml and sql don't worry - you'll be able to browse and download new reports that people share right from within HM. That's the plan anyways

rvg

v 0.11b
There is some discrepancy between HM and PT
I have only done PP at the mo.
Exported from PT and imported into HM about 600K hands.

In PT my total hands are 8,462
In HM my total hands are 8,905
Only filter in PT is site

HM is higher in hands played??? That's kind of weird. There definately will be differences right now as I'm still fixing lots of little (and some big) importing issues.

rvg

ok, no update tonight.

I have stickied a complete list of suggestions and bugs from my forum here (int the suggestions and bugs groups):

Forum

although I need to go through this thread and update the two lists.

If you are getting a lot of import errors then you might need to change your regional settings to English-US (or wait until the next version where I have this fixed).

if you are importing 0 hands all the time then I'm still working on that and hopefully tonight (Tuesday) I will have a fix.

rvg

In the hands filters, is it possible to filter by total bb's put in on all streets instead of just a specific street?

hmmm was fine yesterday now i get this error when trying to open it.

http://img53.imageshack.us/img53/108...ererrorys0.jpg

Can someone indicate some good resources (books and/or websites) for learning sql well enough to get the most out of this app? Assume comuter literate with some programming experience but very little SQL experience.

any update on what to do if ur drive isnt in ntfs?

change it ldo

someon posted how to change it, just ctrl+f the whole thread for "ntfs" and you will find it.

Can't wait to try this out, looks awesome

importing 6 million hands, will report back in 12 hours

Everything works great. Fantastic program. Can't wait to dig into a little more.

6 million hands? are you serious?

i still cant figure out my error

Make sure you vacuum analyze playerhands,compiledresults and compiledplayerresults when you are done. That will make it run many,many times faster.

When I have a bit more time I'll be documeting how the reports work and how to create your own reports. Doing it this way the SQL is generated for you. For more "unique" queries then yeah, you could jump right into the DB and query away although I don't know of any good books off hand.

Can you open your program files\rvg software\holdem manager\config\holdemmanager.config file and let me know what the ConnectionString line says. I just want to make sure that didn't get garbled. You can also try running Start Menu - Postgre - PG Admin and then try double clicking on the server name and see what happens. Maybe the service isn't running or something?

There are a lot of filters that I haven't added yet that work right now and this is one of them. So you will be able to do this soon.

rvg

You know what I'm thinking?

I'll add one more site this week - let's do this the democratic way. List grabbed from pokersitescout and slightly modified - if the winning sites HH's are a pain then I reserve the right to go down the list

Can you add custom folders to the autoimport so that, for instance, while playing on Party you can import played hands from the normal PP folder and observed hands from elsewhere?
Thanks

I vote for prima ! So add it!)

Isnt lad and prima similair hh´s?

Prima please

Looks like its prima then

i opened the config file heres what was in it:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<setting name="ConnectionString">DATABASE=HoldemManagerB eta;SERVER=localhost;PORT=5432;UID=postgres;PWD=ju ly111984</setting>
<setting name="CurrentFilter">IsTourney,IsTourney,EqualT o,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="DefaultPlayerID">3</setting>
<setting name="FishListQuery">having extract(DAY from now() - max(LastPlayedDate)) < 21 and sum(totalhands) > 50 and case when sum(totalhands) = 0 then 0 else sum(vpiphands)*100.0/sum(totalhands) end * 2 + case when sum(couldcoldcall) = 0 then 0 else sum(didcoldcall)*100.0/sum(couldcoldcall) end >= 150 order by case when sum(totalhands) = 0 then 0 else sum(vpiphands)*100.0/sum(totalhands) end * 2 + case when sum(couldcoldcall) = 0 then 0 else sum(didcoldcall)*100.0/sum(couldcoldcall) end desc</setting>
<setting name="AutoImportFolderList">Party,C:\Program Files\PartyGaming\PartyPoker
Stars,C:\Program Files\PokerStars\HandHistory
FullTilt,C:\Program Files\Full Tilt Poker\HandHistory</setting>
</configuration>


also heres the error i get when i opened the database from the admin thing.



oh and also i dont see PKR on that list :P

did you get a chance to take a look at the HHs i sent you?

is it even possible to convert them?

Yes