Is the rake stat rakwe that I have paid or MGR/players?

hey rvg... great program, LOVE your database structure...

just amazing to do own queries...

i did some testing in the manager app itself and found out that if you put the filter "raised turn cbet = TRUE" it filters hands where he acutally folds to turncbets...

this is wierd... i looked it up in the database and saw that if he is making a turncbet, he is also facing one... why is that?

Must be a parsing bug or perhaps a bug related to the recent DB changes I made for version 0.31b - I still haven't audited all of the stats. I know for sure the River CBet stats are off as well at the moment. Before this launches the DB structure will change and all stats will be verified, new stats will be added and you'll need to reimport your hands. Any way you could send me the original hand history for a hand with this problem so I can get it taken care of right away?

Thanks, some of the "normalize everything" people won't be too happy with it but there are tradeoffs when normalizing things especially with a DB residing on a single desktop pc (vs servers that can easily be scaled out). I started off normalized and denormalized for specific reasons. The Compiled Stats table is structured like a data warehouse - very wide but very fast. That all being said, a future update will be changing a bunch of the table structures but fundamentally the approach won't change.

MGR/Players

you'll be able to filter based on pot size and all-ins and basic all-in equity filters but for more advanced equity calculations tools like PokerEV will hopefully fill the void. Once you get into that aspect of things it opens up a whole new can of worms.

rvg

good to know that you're changing stuff, i won't put more time in my own hud... (couln't wait so i had to find a solution i just couldn't take the performance of PT/PA anymore)

i'll send you som histories and suggestions, gonna look into it tomorrow... i really like the compiled database because of it's speed, basicly i switched my whole data stuff from PT to your manager even tough it's gonna change and its in beta, its already superior and a simple autohotkey / excel HUD is gonna do the job...

I have a new update patch that adds a new feature and fixes a couple of bugs.

The new feature is the ability to have multiple players in the Reports tab.

Step 1: Create an alias that includes all the players you want to compare
Step 2: Select the Alias as the Selected player
Step 3: Check the "Group Stats by Player" checkbox on the Reports tab.

Then, go ahead and run any reports with whatever filters you want.

http://www.rvgsoftware.com/hm/holdemmanagerpatch.zip

September 9th - 0.32b
* You can now group Reports by "Player". This is most effective when you create an Alias that includes a bunch of players that you would like to compare. With the group by players option on each players stats will be seperated for the report for easy comparison.
* Fixed recently added bug that caused the hand dates to be incorrect (you will have many hands that show up as 2008 or 2009). An upcoming update will have numerous DB changes and will require a reimport of all hands anyways but I do apologize about not catching this before rolling out the update.
* Fixed bug where an Alias that has been added will not appear in the player list until after you relaunch HM

rvg

If I'm not mistaken this basically groups a bunch of players and displays the total stats for all right?

What I really want is a way to show multiple player reports at once but displayed separately so it saves you time from having to keep switching players if you want to find the same stat for different players. I think someone had it set up in the forum. Is this in the works as well?

I have been saving my HH since I switched to HEM, but does this mean that I will lose all mined hands?

Oh yeah, RELEASE THE HUD. It sucks having two massive databases; one for HEM and the other for RealTime HUD

Yikes I haven't been saving hand histories. I'm concerned about this as well..

My fault I didnt have the separate player box checked. Thank you so much for this!

As he said! You're probably tired of the clamoring for it, but until some sort of a HUD is released, our HDs are filled with the same data in multiple locations.

I've been seeing references to having to recreate the DB, so have been saving all of my observed hands (actually, until Epassporte processes my bank account, they're the only ones I have). Any word when the DB will be set in stone, so we don't need to keep saving hands?

Cheers, Carl.

I'll have to add an Export Hands option. The original hand histories are stored safely in the database.

rvg

My plan from the start was to save up all of the major database changes for one update so that you'd only have to do this once so that's the plan.

Like I just mentioned in the previous post, I will provide an export hands option from existing DB's for those of you that did not save the originals.

rvg

ugg... broke some of the cbet calculations in version 0.30b. Will be fixed in next update which will come shortly.

rvg

I've haven't been able to figure this out:

Is there a way to set a report for position vs position match ups? I know you can select a position to run a report for but I want to select a position for an opponent and see how he plays against certain other positions.

For example how often he folds his bb to a sb open.

ok good...

as i said i like the strutcture from a users point of view. the compiledplayerresults tab might suffer some overkill i think. this table is mainly used for HUD puproses i guess, so you might consider delete everything that is not gonna add up to a decent samplesize in a couple of thousand hands (like the raiseraisevspfr stuff) i think after two actions it just gets usless HUD wise, and you can still get the information doing a report

you could consider adding some HU only postflop information (folded to cbet HU as an example)

also i would suggest to add something like a draw agression frequency, its very important to know how somebody plays his draws...

again, i really like the concept of the compiledplayerresults database, but i think you can cut it down a little bit, you'll save some space (the database gets kinda big anyways in my view) because its not used for in depth player analysis

i noticed som other stuff, but have to organize my arguments first.

You can saved mined hands? The files are TEMP... can HEM import these?

I have lines like this in the "standardizedhandhistories". This is from iPoker. Is this a bug or is it supposed to be that way? This irreggular things kind of suck when I'm trying to do queries on XML files.

How do I see the specific hands from a report in the reports tab? For example, say I run a report based on stack sizes. Is there a way for me see only the hands I played when I had a huge stack in the hands tab? I'm sure this is super easy, but I can't seem to figure it out yet.

The new Delete db exe looks strangely large and falls over with an error (for me at least).

I dropped the HEM db via PgAdmin; happily reimporting all hands at a great rate - 55 hands/sec now.

The delete database thing didn't work for me either. It gave some error about not being able to find something having to do with DBDelete.exe.

Can someone please tell me how to move my database to another partition?

There is a way but it requires a custom report. I haven't explained how to build these yet but I will closer to launch. Also, I'll try to add a report like this in the next little while that you can download and then use yourself.

Go ahead and send comments / suggestions to tourneymgr@gmail.com. I've been working on the new DB structure so now would be a good time to send me some more feedback.

From which site? Full Tilt mines hands should work - they did last time I tried anyways.

Can you send me the original HH?

In the filters set #BB's to > 200 (or whatever you want) and then go to the hands tab and grab however many hands you want and it will use your filter. You can't automatically jump from the stack size report to a smaller breakdown report by clicking on the "Large Stacks" row at this point but you will be able to.

ok, will look into this and get it fixed. Could you delete the DB before with the older version?

Hopefully someone can let you know how to do this through pgadmin. I believe you have to backup then create a new database cluster on the other drive and restore to there but not 100%. I'll be looking into this more closely soon when I actually attempt to do it myself.

rvg

Well, if someone knows and could give me some more information I'd really appreciate.