New Free Software - Bankroll tracker 0.3 - Page 2 - 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 2 of 3

1 2 3

Page 2 of 3

1 2 3

12-21-2009 , 06:00 PM

#26

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by Mruuugacz

Hey could u upload the new version to some other site?

Thnx

Any suggestions for a good file sharing site?

Quote

12-21-2009 , 06:09 PM

#27

Mruuugacz

enthusiast

Join Date: Nov 2009 Posts: 52

megaupload is fine imo

Quote

12-21-2009 , 06:15 PM

#28

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Bankroll Tracker 0.4 Megaupload Link

Quote

12-22-2009 , 10:58 AM

#29

madlion

old hand

Join Date: Jan 2009 Posts: 1,550

Nice work will try later

Quote

12-22-2009 , 02:19 PM

#30

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Added support for PT3 Omaha if database has it.

BankrollTracker-0.5.zip

Quote

12-23-2009 , 08:45 PM

#31

sleech

journeyman

Join Date: Feb 2005 Posts: 322

I think there must be an error confusing Tourney hands with cash hands:

However, the details page is correct.

Quote

12-27-2009 , 07:13 AM

#32

madramor

newbie

Join Date: Jul 2006 Posts: 33

Program runs and I can manually enter transactions but it doesn't seem to be reading my HEM db. DB name and login info looks ok to me on trackers screen. Using v0.5 on Win XP

Quote

12-27-2009 , 11:59 AM

#33

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by sleech

I think there must be an error confusing Tourney hands with cash hands:

However, the details page is correct.

Can you provide a bit more detail? Like what trackers you are working with? A screenshot of the details page would also help.

Quote

12-27-2009 , 12:40 PM

#34

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by madramor

Program runs and I can manually enter transactions but it doesn't seem to be reading my HEM db. DB name and login info looks ok to me on trackers screen. Using v0.5 on Win XP

Are you playing cash or tourneys or both?

Here's the query I run for cash games:

Code:

SELECT
  date_trunc('day', handtimestamp) AS date,
  cast(cast(sum(netamountwon) AS NUMERIC(11,2)) / 100 as numeric(11,2)) as profit,
  count(pokerhand_id) AS hands
FROM playerhandscashkeycolumns
WHERE TRUE
  AND player_id in (SELECT player_id FROM aliases WHERE aliasplayer_id = (SELECT player_id FROM selectedplayer ORDER BY selectiondate DESC LIMIT 1))
GROUP BY date_trunc('day', handtimestamp)
ORDER BY date_trunc('day', handtimestamp)

And here's the one for tourneys:

Code:

SELECT
  date_trunc('day', t.firsthandtimestamp AT TIME ZONE 'GMT') AS date,
  cast(cast(sum(winnings - buyin - rake - rebuyamount) AS numeric(13,0)) / 100 as numeric(11,2)) AS profit,
  0 AS hands
FROM tourneydata AS t
JOIN tourneyplayerdata AS p ON p.tourneynumber = t.tourneynumber
WHERE TRUE
  AND p.player_id in (SELECT player_id FROM aliases WHERE aliasplayer_id = (SELECT player_id FROM selectedplayer ORDER BY selectiondate DESC LIMIT 1))
GROUP BY
  date_trunc('day', t.firsthandtimestamp AT TIME ZONE 'GMT')
ORDER BY
  date_trunc('day', t.firsthandtimestamp AT TIME ZONE 'GMT')

Try running these in pgAdmin directly against the database and see what you get.

Also, try running this:

Code:

select * from players where player_id in (SELECT player_id FROM aliases WHERE aliasplayer_id = (SELECT player_id FROM selectedplayer ORDER BY selectiondate DESC LIMIT 1))

This last SQL should return all the aliases configured in HEM.
Let me know what they return. PM me your email and we can carry on via email.

Quote

12-27-2009 , 12:42 PM

#35

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by alon.albert

Can you provide a bit more detail? Like what trackers you are working with? A screenshot of the details page would also help.

OK, I found the problem. Fix is on the way.

That's what I get for supporting a database I don't work with regularly

I don't have a HEM licence so I used the demo to create a small DB and I don't test against that much...

Quote

12-27-2009 , 12:47 PM

#36

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

* Fix for tourney data on HEM
* Fix a bug when deleting a PT3 tracker

BankrollTracker 0.6

Quote

12-27-2009 , 03:53 PM

#37

Thois

adept

Join Date: Apr 2007 Posts: 935

very sick program

ty very much

EDIT: Still needs a rakeback function like in HEM I think, manually entering rakeback $ every time is not cool... And also some type of currency converter function (where I can say I want everything listed as Euro, and then it converts each value to euros). Also possibility to add transactions in other currencies in 'Add transaction' menu obviously.

Im not sure though if it's worth your time though, as I guess this isn't a commercial project. But if you add those things, you can sell this thing for sure, I'd pay for it... Also perhaps you should change the name of this program, I never looked into this thread until now because somehow it didn't look appealing. The thread's title should be something like: New Software: Automated/Dynamic/Whatever Bankroll Manager for PT3/HEM - The All-In One Solution for Bankroll Management (or whatever, just an example)

Not trying to be a smart ass, just trying to help you to get this program more popular, it needs more love... It has a lot of potential

Last edited by Thois; 12-27-2009 at 04:16 PM.

Quote

12-27-2009 , 04:53 PM

#38

Kaizen2000

stranger

Join Date: Apr 2009 Posts: 9

Quote:

Originally Posted by alon.albert

OK, I found the problem. Fix is on the way.

That's what I get for supporting a database I don't work with regularly

I don't have a HEM licence so I used the demo to create a small DB and I don't test against that much...

None of the SQL-queries work for postgres/HM- no results shown after running each query.

I did backup and upload my database, please feel free to download, restore and have a look at the postgres tables/schemes.

For link to download please check your PM-box.

Quote

12-27-2009 , 05:17 PM

#39

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by Thois

Still needs a rakeback function like in HEM I think, manually entering rakeback $ every time is not cool...

I don't know. Sounds like a good idea in theory but Rakeback tends to vary from formulas. Mostly due to bonus deduction etc' I would find the need to adjust the estimated Rakeback to the actual Rakeback more annoying. Besides, my favorite activity with this software is to add Bonus & Rakeback transactions anyway

Quote:

Originally Posted by Thois

And also some type of currency converter function (where I can say I want everything listed as Euro, and then it converts each value to euros). Also possibility to add transactions in other currencies in 'Add transaction' menu obviously.

Yeah, I was considering this also but the problem is that currency conversion rates change over time so and I don't see how I could adjust for that. Say for example, you import hands you played a week ago, you would need to know what the conversion rate was back then.

Not sure what the best solution here is. Do you play the same site using different currencies? Is that for Table Selection considerations?

Quote:

Originally Posted by Thois

just trying to help you to get this program more popular, it needs more love... It has a lot of potential

LOL, maybe the moderators can help by changing the original topic to something cooler

Quote

12-27-2009 , 06:07 PM

#40

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by Kaizen2000

OK, it seems like you have no aliases set up in your database. I'm not sure exactly what the proper workflow is in HEM but when I played with it, I had to define aliases for my screen names on all the sites.

I'm not sure if you can do without that in HEM but for BT to work, you gotta define the aliases.

You also need to make sure that your alias is selected as the current player. Again, I don't remember exactly where you set that and I don't have HEM installed so you'll have to figure it out yourself

Quote

12-27-2009 , 06:37 PM

#41

sleech

journeyman

Join Date: Feb 2005 Posts: 322

Quote:

Originally Posted by alon.albert

* Fix for tourney data on HEM
* Fix a bug when deleting a PT3 tracker

BankrollTracker 0.6

Thanks for the fix... That worked. And it seems much faster now too.

Quote

12-27-2009 , 07:27 PM

#42

Kaizen2000

stranger

Join Date: Apr 2009 Posts: 9

Quote:

Originally Posted by alon.albert

Yes- works pretty perfect after I defined an alias. Didn't notice this part of the query: 'AND player_id in (SELECT player_id FROM aliases WHERE aliasplayer_id ='. Thanks a lot!

Quote

12-27-2009 , 09:55 PM

#43

genher

veteran

Join Date: May 2007 Posts: 2,931

doesn't work for me I get a error message 42p01: relation "playerhandscashkeycolumns" does not exist. I use HEM.

Any ideas how to fix it?

Quote

12-28-2009 , 12:58 AM

#44

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by genher

doesn't work for me I get a error message 42p01: relation "playerhandscashkeycolumns" does not exist. I use HEM.

Any ideas how to fix it?

Are you sure you have the right database name? If you don't mind letting me access your HEM database, you can back it up and upload it somewhere for me to take a look. PM me if you're in.

Quote

12-28-2009 , 06:38 AM

#45

genher

veteran

Join Date: May 2007 Posts: 2,931

any idea where I can find my HEM database...

Quote

12-29-2009 , 11:24 AM

#46

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,193

Quote:

Originally Posted by genher

any idea where I can find my HEM database...

http://www.holdemmanager.net/faq/afm....aspx?faqid=12

Quote

12-30-2009 , 04:35 PM

#47

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by fozzy71

http://www.holdemmanager.net/faq/afm....aspx?faqid=12

once more : TY fozzy

Quote

01-05-2010 , 03:14 PM

#48

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

New build.

I started noticing recently that BankrollTracker (BT) has been running slower and slower. This was due to my PT3 databases getting larger over time.

I decided to make a major change to the way I collect the data. Instead of querying the entire PT/PT3/HEM databases every time, I just scan for sessions/tourneys that happened since the last time I scanned last. I store the results in my own database which is much smaller and therefore faster.

This required a major change in my architecture so I may have introduced new bugs.

If you want to refresh the entire range, user Ctrl-F5 instead of F5.

BTW, HEM is the biggest beneficiary of this change because it doesn't store session information like PT3 does. Instead I have to scan all hands which is very slow.

BankrollTracker-0.7.zip

Quote

01-07-2010 , 04:32 AM

#49

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Mate... this little program is slicker than snot and just the thing I've been looking for. I have no probs with the little manual entries like rakeback etc and imo currency conversion is a waste of time.

Now to my problem. Am currently running BT 0.7 and HEM 1.10 Beta 6. BT seemed to work, then all of a sudden the HEM extracted data dissappeared laving me just the 'amendments' I added in. I ran the script you mentioned a while ago to list aliases from within PG and there was nothing in the output. I've conformed that HEM has hero names setup for the two poker sites I play at and a single alias combining those two names, but I just can't get BT to extract data from my HEM database.

Any suggestions?

Edit: Btw, selecting File > Exit in BT doesn't do anything. I have to close the prog by hitting the 'X' in the upper right corner.

Quote

01-07-2010 , 11:27 AM

#50

alon.albert

journeyman

Join Date: Aug 2007 Posts: 323

Quote:

Originally Posted by The Minder

then all of a sudden the HEM extracted data dissappeared laving me just the 'amendments' I added in.

Well,I don't have HEM installed anymore as my demo expired so it's a bit hard for me to figure these things out. What I do remember is that HEMhas a table where it keeps the currently selected user and it seems to keep a history of selected users so I had to select the TOP of that list meaning the most recent selection.

I may have been wrong in assuming the purpose of this list.

If you back up your HEM database and upload it somewhere and IM me the link to it, I can take a look.

Quote

Page 2 of 3

First

1 2 3

Last

Post Reply Subscribe

...

Page 2 of 3

First

1 2 3

Last