New Free Software - Bankroll tracker 0.3 - Poker Software -- Two Plus Two Poker Forums

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software

New Free Software - Bankroll tracker 0.3

Post Reply Subscribe

...

Page 1 of 3

1 2 3

Page 1 of 3

1 2 3

04-13-2009 , 07:50 PM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Here's a little project I've been working on for a few months now. The idea is to have a central place where you can track your online poker bankroll. It tracks your bankroll taking into account any PokerTracker (2 or 3) or HoldemManager database you might have. You can specify multiple databases if you want. It also tracks other bankroll transactions such as deposits, bonus, rakeback etc.

The program requires a postgres database and supports PT2 (Holdem, Omaha & Stud), PT3 and HEM. In case of PT2, it only supports postgres databases.

When you start it up, it will prompt you for a new Bankroll Tracker database. This is not your PT database, it's a new database used only by Bankroll Tracker. Once you create this database, you can add trackers from the File menu.

You can add transactions from the File menu or from the toolbar

This software is free. If you really like it, feel free to make a small donation to my Full Tilt account 'nowan' or my Stars account 'nowanuno'. Hey, you'll even be able to log the donation transaction in Bankroll Tracker

Oh, it requires the Microsoft .NET Framework.

Download here.

A few screenshots:

When you run for the first time, you need to configure the BankrollTracker database. Normally, you'll need to enter just the postgres password and a new database will be created for you.

After configuring the database, you will see an empty graph because you haven't configured any trackers. Select the File/Trackers menu item to add trackers. BankrollTracker supports Poker Tracker 2 & 3 as well as Holdem Manager.

You can add multiple trackers. For example, I track my hands by year so I have a PT3 database for each year I played. I also have a PT2 Omaha tracker configured.

After you configure at least one tracker, you'll see something like this:

Now you can start adding transactions. For example, here I'm adding a deposit. Transactions can be anything you like. Here are some examples: Deposit, Bonus, Rakeback, Transfer, Staking etc'

Here's the graph with the added transactions. Notice the big jump in the beginning compared to the previous screenshot.

The detail tab lists all the transactions you added and also shows you a breakdown of you bankroll per site and per transaction type.

Finally, you can change the view between Daily, Weekly, Monthly & Yearly. Also note the tooltip that gives a breakdown of the transactions included in the selected period.

Last edited by fozzy71; 05-26-2009 at 05:27 PM. Reason: Updated OP, title, Screen Soots, and download link.

Quote

04-13-2009 , 11:31 PM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Of course, I managed to post a bad binary. Here's a good one:

Last edited by fozzy71; 05-26-2009 at 05:20 PM. Reason: removed old version download.

Quote

04-20-2009 , 12:25 AM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Bump.

Quote

05-21-2009 , 12:22 PM

Alexander Spirin

stranger

Join Date: May 2009 Posts: 7

It could be very interesting!

You have to develop this project!

Good luck!

Quote

05-21-2009 , 12:46 PM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by Alexander Spirin

You have to develop this project!

Not sure what you mean. It pretty much works already...
Just download it and give it a try...

.

New in this version:
* Transactions types are free text, you make up your own as you go along.
* You can now chart by day, week, month or year.

Last edited by fozzy71; 05-26-2009 at 05:20 PM. Reason: removed old version download link

Quote

05-21-2009 , 03:23 PM

signuptoday

old hand

Join Date: Apr 2009 Posts: 1,283

will this work with hem?

Quote

05-21-2009 , 03:29 PM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by signuptoday

will this work with hem?

No. Unfortunately, I have very little insight into HEM database schema. I tried to figure it out a couple of times but it was just too messy and I gave up on it.

Tell you what though, if you can find someone that will help me create a HEM equivalent SQL query to the ones I use for PT 2 & 3, I'll add HEM support.

Here's an example of what I need. This query returns the total winnings per day in ring games from PT3 database:

Code:

SELECT
  date_trunc('day', date_start AT TIME ZONE 'GMT') AS date,
  sum(amt_won) AS profit
FROM
  holdem_table_session_summary AS s
WHERE TRUE
  AND id_player = (SELECT CAST(setting_value AS INT) FROM settings WHERE setting_name = 'my_player_id')
GROUP BY
  date_trunc('day', date_start AT TIME ZONE 'GMT')
ORDER BY
  date_trunc('day', date_start AT TIME ZONE 'GMT')

Quote

05-21-2009 , 06:36 PM

GrindUnumb

old hand

Join Date: Oct 2006 Posts: 1,359

Any 2+2ers out there know how to do this? I would love to try his program out with HEM.

Quote:

Originally Posted by alon.albert

Code:

SELECT
  date_trunc('day', date_start AT TIME ZONE 'GMT') AS date,
  sum(amt_won) AS profit
FROM
  holdem_table_session_summary AS s
WHERE TRUE
  AND id_player = (SELECT CAST(setting_value AS INT) FROM settings WHERE setting_name = 'my_player_id')
GROUP BY
  date_trunc('day', date_start AT TIME ZONE 'GMT')
ORDER BY
  date_trunc('day', date_start AT TIME ZONE 'GMT')

Quote

05-21-2009 , 08:17 PM

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

OK, so I managed to extract ring game data from HEM database and integrated into BankrollTracker. However, I can't find any tourney information. Sure, HEM has a Tourney tab but it only has hand information, not buyin and winnings info. It does have a few database tables that suggest that this feature is at least planned but for now the tables are all empty even though I do have tourneys imported.

I'll have the partial HEM support version up soon. Need to test it out a bit.

Quote

05-21-2009 , 08:44 PM

#10

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,193

Sounds like you might have an old version of HEM installed. HEM added tourney support recently, so you should grab the latest beta version (1.08.04) from the hem forums. I obv know nothing about the inner workings of SQL tho.

Quote

05-26-2009 , 12:21 AM

#11

signuptoday

old hand

Join Date: Apr 2009 Posts: 1,283

anyupdate?

Quote

05-26-2009 , 09:54 AM

#12

jurrasstoil

Carpal \'Tunnel

Join Date: Sep 2007 Posts: 8,743

Quote:

Originally Posted by signuptoday

anyupdate?

+1

and maybe some screenshots

Quote

05-26-2009 , 04:08 PM

#13

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

OK, I managed to add HEM support. New version is here.

Also made a few screenshots:

When you run for the first time, you need to configure the BankrollTracker database. Normally, you'll need to enter just the postgres password and a new database will be created for you.

After you configure at least one tracker, you'll see something like this:

Now you can start adding transactions. For example, here I'm adding a deposit. Transactions can be anything you like. Here are some examples: Deposit, Bonus, Rakeback, Transfer, Staking etc'

Here's the graph with the added transactions. Notice the big jump in the beginning compared to the previous screenshot.

The detail tab lists all the transactions you added and also shows you a breakdown of you bankroll per site and per transaction type.

Finally, you can change the view between Daily, Weekly, Monthly & Yearly. Also note the tooltip that gives a breakdown of the transactions included in the selected period.

Quote

05-26-2009 , 05:38 PM

#14

theeviltwin69

enthusiast

Join Date: May 2007 Posts: 61

Looks good I'll try it tonight or tomorrow morning

Quote

05-26-2009 , 06:43 PM

#15

theeviltwin69

enthusiast

Join Date: May 2007 Posts: 61

I can't seem to get past the first screen,and I know my SQL pass is correct.

hold on I did not have service set for auto start

Quote

05-26-2009 , 06:45 PM

#16

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by theeviltwin69

I can't seem to get past the first screen,and I know my SQL pass is correct.

hold on I did not have service set for auto start

Are you getting any kind of error or just stuck on the first screen after clicking OK?

Quote

05-26-2009 , 07:42 PM

#17

theeviltwin69

enthusiast

Join Date: May 2007 Posts: 61

I got as far as the blank graph screen.Got a fatal error>it shut down>tried to re-open>BRtracker has encountered a problem & has to close.
Thats where I'm at.
I checked SQL>the DB was there>I dropped it>I tried to delete and DL again but I get the same thing.

Quote

05-26-2009 , 08:18 PM

#18

GrindUnumb

old hand

Join Date: Oct 2006 Posts: 1,359

I installed and connected to HEM, but everything at $0.00 and no graph.

Quote

05-26-2009 , 08:31 PM

#19

theeviltwin69

enthusiast

Join Date: May 2007 Posts: 61

yeah but thats how I think it starts untill you input some sort of a starting roll

Quote

05-27-2009 , 06:19 PM

#20

theeviltwin69

enthusiast

Join Date: May 2007 Posts: 61

Quote:

Originally Posted by alon.albert

Are you getting any kind of error or just stuck on the first screen after clicking OK?

Any ideas or word on this? I have not tried to do anything since we spoke last night.

Quote

05-28-2009 , 02:45 AM

#21

signuptoday

old hand

Join Date: Apr 2009 Posts: 1,283

it work with HEM now? sweet, i'm gonna tray

Quote

12-17-2009 , 03:05 PM

#22

NetZorro

stranger

Join Date: Dec 2009 Posts: 1

Quote:

Originally Posted by GrindUnumb

I installed and connected to HEM, but everything at $0.00 and no graph.

I don't think the replay is right, that it will "soon come".
I had the same problem, and i checked around little, and found out that if u using HEM the standard/recommende installation encoding is: UTF.

Thats not the case with Bankroll Tracker. When you start BRT, and create a new database, you dont get the chanse to choose, it autocreats a DB, with ASCII encoding. That means that it wont work.

What you can do, what i did, is to set up a new DB, with HoldemM, and the ASCII encoding. (The problem is that ASCII do not work on all Comp, with HEM)

Tranfering the hands etc. is easy with HEM. You will need to create new alias etc. (reports etc).

But then it works with Bankroll Tracker.

So the real question is to alon.albert, can you add a choice when creating a DB, that is either UTF / ASCII.

/NetZorro

Quote

12-17-2009 , 03:36 PM

#23

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Yeah, I can make the DB UTF or give a choice but I don't understand why this would be a problem to begin with. It's 2 different databases so it shouldn't matter matter that HEM is UTF and BRT is ASCII. I'll look into it though.

Quote

12-21-2009 , 05:05 PM

#24

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

New version 0.4 posted here:

BankrollTracker 0.4

- Added delete button for tracker configuration
- Added right click menu for transaction view
- Create database as UTF8 rather than ASCII. This might have caused issues with HEM though I can't see how.
- Fixed a couple of small bugs.