The Uberscript

3 Feb: Fix for currency calculations.

One of my goals for 2011 is to become less results orientated (framing a session as 'good’ or 'bad’ based on how much I’ve won or lost), but process orientated. So instead, I consider a good session one that I’ve played well in. I set some session goals for the year that are based on game quality and stakes, and less focus on playing lots of tables and grinding it out. I want to scout out better games, heads up or ultra-shorthanded (where I feel my biggest edge lies), and play more 10/20 and 15/30, with my sights set on higher stakes as the year progresses.

So now for me a 'good session’ is one with a high average big blind, and low average number of players at the table.

Thus is born the uberscript. It’s a batch file that I can fire up whenever I get the itch mid-session to check how I’m doing. Type in the timeframe (last 2 hours, last 7 days), and it spits out all relevant information I want.

I can also use it to review the week or month to see how well I’ve 'performed’.

You can download the batch script below. To get it working, you first need to allow host access to the postgres as outlined in a previous blog post. Then you need to edit the first lines in the script:

set dbname=holdemmanager
set pgpath=C:\Program Files (x86)\PostgreSQL\8.4\bin\psql.exe
set pguser=postgres
set playeralias=YourAliasName
set minbigblind=100

Put in your database details and the name of your HEM player alias (if you don’t use an HEM player alias, create one and put your SN in it). Min big blind is the minimum big blind in cents that will be included in the counts; anything below doesn’t count (I added this to exclude low stakes 'test’ or messing-around type hands from the regular count).

It’s customized to exactly the info I want (average # of hands per table, average $ BB, average tournament buyin). You will probably want to customize the queries to exactly the information you want to check on a daily basis.

Download Sickread Uberscript