Software and Tools Poker Forums

For the past few months, I have been working on a reporting tool for Hold'em Manager that I am calling Hold'em Analytics. Thanks very much to jimmyfloyd for his input along the way.

As a struggling micro NLHE player, my motivation for building the tool is to get better insight into my opponent's hand ranges. DC videos are full of insights, but I'm an engineer, so I like data :-). Using the data in your Hold'em Manager database, Hold'em Analytics generates several types of graphs showing the hand ranges you will face in different situations.

These graphs will help you answer questions like:

- Does an individual player have exploitable betting tendancies?
- Is the Baluga Theorem true?
- What range of hands does a LAG player call with on the flop, turn or river?
- What hands will players shove preflop, or postflop with?
- What proportion of Nits, TAGs, LAGs, etc. play at my site and my stakes?
- What is a good board to C-bet? How much does fold equity change from dry flop to an action flop?

Hand ranges are obviously biased to those that went to showdown, but the insights should be useful nonetheless.

There are some screen shots available at: http://www.holdemanalytics.com.

Each page in the application offers a flexible set of filters, including player stats, so you can answer more specific questions.

Left-clicking on most histogram data points lets you view or export hands for further analysis.

I put together a quick web site, where you can download and install from: http://www.holdemanalytics.com.


Details and disclaimers:

Hold'em Analytics is beta software. It works great on my Hold'em Manager database of a few hundred thousand 6-max NLHE hands. There are still bugs, but I am releasing it because I feel it is useful as-is, and I would like to get feedback on how it can be improved.

This tool only reads from your Hold'em Manager database. It will never, ever, write to it.

I have tested with Hold'em Manager 1.0.7 and 1.0.8.

The setup program uses Microsoft ClickOnce technology. This means you need to click the Install link (http://www.holdemanalytics.com/clickonce/publish.htm) using Internet Explorer (or FireFox 3 if you have .NET Framework 3.5 SP1 installed). Each time you run Hold'em Analytics, it will check for an updated version.

The database queries can be time consuming. If you have 100's of thousands or millions of hands in your Hold'em Manager database, start by setting stakes and date ranges. You can widen the date ranges as you get a feel for query times.


I hope you find this tool useful. If you have problems getting it running, please PM me. I look forward to your questions and feedback...

I have been fortunate enough to have had the opportunity to use the Beta version of this software for around the last 2-3 months.

It has some really impressive functionailty which can help you really explore the tendencies of the regulars you face without having to spend hours working with HEM filters.

I recommend anyone to download Holdem Analytics and try it out.

From the screenshots this looks really nice and I'd really like to try it.

But when I click the install link it just serves up an xml document in my browser. I've tried it in both Firefox and IE but got the same result in both.

I have .net framework 3.5 SP1 installed. Any ideas on how I can get the installer to work? Or is there a downloadable installer available?

Just noticed that I have Internet Explorer version 6 - maybe this is the problem?

Is there anyway that I can install this without having to upgrade IE? I really don't want to install a newer version of IE on my computer.

Downloading now

no im not. Download doesnt work?

Just noticed that I have Internet Explorer version 6 - maybe this is the problem?

Is there anyway that I can install this without having to upgrade IE? I really don't want to install a newer version of IE on my computer.

You should always keep IE updated, but never use it, imo.



Does this only work if you have a DB with a default name?? If so, that is a huge flaw, as I have never left my DB name as default.

2009-07-30 09:26:28,687 [1] ERROR HEMMiner - Error connecting to database
Npgsql.NpgsqlException:
database "HoldemManager" does not exist
Severity: FATAL
Code: 3D000

Does this only work if you have a DB with a default name?? If so, that is a huge flaw, as I have never left my DB name as default.

Agreed. I just added a database name setting. If you run the application again, you will be prompted to upgrade. In the Tools -> Options dialog, you can now specify your custom database name.

You should always keep IE updated, but never use it, imo.

Why update it if you never use it?

I never use IE (apart from today, when I tried to install this).

The reason I don't want to update IE is because an IE update completely borked a machine for me a few years ago and I had to do a full reinstall because of it.

And yeah, I don't use the default db name either. In fact I have several different dbs with custom names so the ability to define the db settings would be important to me.

I just added a standalone installer for those who prefer: http://www.holdemanalytics.com/?page_id=3. This version includes the option to specify a database name.

Let me know if you are able to get it installed and connected ok.

Why update it if you never use it?
......

Because the IE updates fix huge gaping security holes in IE, which can make your machine vulnerable, even if you never open IE.

I got it installed and running. But all the graphs show up blank.

I checked the log and every query is throwing an exception complaining about the log format.

Heres an example of what's in the log file from running the game statistics report:

http://pastie.org/565920

Any ideas?

I got it installed and running. But all the graphs show up blank.

I checked the log and every query is throwing an exception complaining about the datetime format.

Heres an example of what's in the log file from running the game statistics report:

http://pastie.org/565920

Any ideas?

The datetime issue should be resolved in the build I just posted.

Running veeeeeeery slow on my PC (Intel Core2 Quad 2.4GHz 2gb ram)

If I click just about any button it just freezes up for a long time and I sometimes get a message "Holdem Analytics encountered an unrecoverable error: Exception has been thrown by the target of an invocation"

Any ideas?