HUD Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 - Page 32 - Poker Software -- Two Plus Two Poker Forums

Part of a line in your HUD_config.xml file will look this:
HH_path="~/.wine/drive_c/Program Files/Full Tilt Poker/HandHistory/abc/"
You need to change the path to your Hand History path (If you installed wine and full tilt normally, you just change abc to your full tilt name). You may have to change the site path if you installed it somewhere else also.

Quote

12-10-2008 , 03:23 AM

#778

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by xaiviax

Bankroll and RoR have been discussed in 1000's of threads. One good phzon post on the subject is here: http://forumserver.twoplustwo.com/32...48/#post967871

Thanks for the links. The fact that there are “thousands” of threads rather proves my point. It is silly that Pokertracker gives people their win rates and variance but leaves them to their own devices when determining how large their bankroll should be.

If I feel motivated I may add this feature myself, if only for my own use, in some sort of temporary form, which the developers can keep or throw out as they see fit. (In the end there will no doubt be a full set of statistical functions into which this should be incorporated.)

Quote

12-10-2008 , 04:33 AM

#779

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

I’ve looked into this briefly and discovered a problem with the design of the database.

I had thought that one’s profit could be determined with the SQL statement

select sum(winnings) from HandsPlayers where playerId = [the player’s ID];

but it turns out that “winnings” does not record what I expected it to. It is not the player’s net winnings on that hand (which should have the capacity to be positive or negative), but appears to be the size of the pot minus the rake. This is not useful.

Indeed, the players who lost money on the hand have a recorded “winnings” of zero, just like the players who weren’t involved. Obviously one’s losses need to be recorded as well as one’s wins. I can’t find any provision in the database for this.

To the developers: Have I missed something, or am I right that the database needs to be modified?

Another thing I have noticed is that rake is wrongly treated as a property of a player, i.e. it is recorded against the winner of the pot in HandsPlayers. But the rake should be treated as a property of the hand. For instance, if there is a rake of 15c and the pot is split two ways, the rake should be recorded once against the hand, not as (for instance) 7.5c paid by each of the two winners (which would be impossible, as the database does not allow for fractional cents).

Quote

12-10-2008 , 04:44 AM

#780

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Eleatic Stranger

Winnings can only be positive.

The profit graph and the new stats page in git show how to calculate profit correctly (i hope)

Quote:

Originally Posted by Eleatic Stranger

Another thing I have noticed is that rake is wrongly treated as a property of a player, i.e. it is recorded against the winner of the pot in HandsPlayers. But the rake should be treated as a property of the hand. For instance, if there is a rake of 15c and the pot is split two ways, the rake should be recorded once against the hand, not as (for instance) 7.5c paid by each of the two winners (which would be impossible, as the database does not allow for fractional cents).

You only pay rake when you win the hand so this does make sense.

Calculating for split pots and or rakeback is more difficult.

Quote

12-10-2008 , 06:43 AM

#781

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by sorrow

Winnings can only be positive.

In this case I think it should ideally be titled “pot size” or something of the sort; “winnings” is misleading. And I hold that this is, conceptually, a property of a hand, not a player in a hand. (This is just a quibble on my part, admittedly.)

Quote:

The profit graph and the new stats page in git show how to calculate profit correctly (i hope)

Where is the stats page? I can’t find any menu option that wasn’t there before. I can see the new queries in FpdbSQLQueries.py, but not how to access them.

At any rate, I have inferred that your expression for the total profit for a given player is equivalent to

select sum(winnings) - (select sum(amount) from HandsActions inner join HandsPlayers on handPlayerId = HandsPlayers.id where playerId = [ID]) from HandsPlayers where playerId = [ID];

That is, I think you are just subtracting from “winnings” (what I would call “pot size”) the total of the “amount” fields (viz. the amount contributed to the pot), belonging to the player in question, from the HandsActions table.

This looks correct, but isn’t. I have ascertained that it does not give the correct figure for my winnings. I think this is because it fails to take into account uncalled bets.

Be this as it may, it is of course possible that I have misunderstood what your code is trying to do. As I said, please let me know how one gets to the statistics page and I will have a look and report back.

Quote

12-10-2008 , 06:57 AM

#782

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Eleatic Stranger

I agree wholeheartedly that winnings intuitively means something different - I made the same mistake when trying to graph originally.

.... but when do sql/dba guys ever do anything intutively

[QUOTE=Eleatic Stranger;7553336]
Where is the stats page?
[QUOTE]
Viewers->Player Stats (tabluated view) - I think its across most trees now. Steffen did a major pull into the main repo today.

Only one of the new queries is active at the moment.

Quote:

Originally Posted by Eleatic Stranger

At any rate, I have inferred that your expression for the total profit for a given player is equivalent to

select sum(winnings) - (select sum(amount) from HandsActions inner join HandsPlayers on handPlayerId = HandsPlayers.id where playerId = [ID]) from HandsPlayers where playerId = [ID];

That is, I think you are just subtracting from “winnings” (what I would call “pot size”) the total of the “amount” fields (viz. the amount contributed to the pot), belonging to the player in question, from the HandsActions table.

This looks correct, but isn’t. I have ascertained that it does not give the correct figure for my winnings. I think this is because it fails to take into account uncalled bets.

My SQL sucks generally, but i'm pretty sure we are accounting for uncalled bets.

My profit graph has been pretty accurate as far as i can tell for some time.

Quote

12-10-2008 , 07:25 AM

#783

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by sorrow

Viewers->Player Stats (tabluated view) - I think its across most trees now. Steffen did a major pull into the main repo today.

In this case I haven’t got the latest version. This option is still marked “to do”. But git pull reports that my version is up to date. The repository’s URL is set to git://git.assembla.com/free_poker_tools.git. What’s wrong?

Quote

12-10-2008 , 07:40 AM

#784

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Git main (steffen) - git://git.assembla.com/fpdb.git
Git (eratosthenes) - git://git.assembla.com/free_poker_tools.git
Git (me) - git://git.assembla.com/fpdboz.git

I think Eratosthenes is prepping for a release and hasn't pushed for a few days.

FYI - doesn't work on postgres yet

Quote

12-10-2008 , 07:47 AM

#785

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Sorrow – Thanks for your help. I’m using MySQL, so it should work.

I’ve looked at the code and I see that uncalled bets are reversed; so the calculation ought to work. But I’m sure the number I’ve been getting is wrong.

I’ll let you know how I find the player statistics function.

Quote

12-10-2008 , 08:01 AM

#786

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

No luck, I’m afraid.

Code:

./fpdb.py:243: DeprecationWarning: use gtk.UIManager
  self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
Traceback (most recent call last):
  File "./fpdb.py", line 335, in tab_player_stats
    new_ps_thread=GuiPlayerStats.GuiPlayerStats(self.db, self.config, self.querydict)
  File "/home/matthew/ephemera/fpdb-git/pyfpdb/GuiPlayerStats.py", line 160, in __init__
    self.fillStatsFrame(self.stats_frame)
  File "/home/matthew/ephemera/fpdb-git/pyfpdb/GuiPlayerStats.py", line 49, in fillStatsFrame
    pid = result[0][0]
IndexError: tuple index out of range

The menu option appears now, but does nothing (except produce the above error messages).

Quote

12-10-2008 , 08:23 AM

#787

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Is your player name filled out in the config file?

Thats just trying to fetch your player name from the db (without error checking...)

I've just this minute pushed that checks your username exists before continuing with the query.

Quote

12-10-2008 , 08:24 AM

#788

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

In retrospect, I can see I was a bit too quick to find fault with the database design when I said:

Quote:

Originally Posted by Eleatic Stranger

I’ve looked into this briefly and discovered a problem with the design of the database. [Et cetera.]

It turns out that all the information was there, just not where I expected to find it.

Nonetheless the design still strikes me as doing certain things in more complicated a way than necessary. It seems it would be by far the simplest thing to have a single field that recorded each player’s net gain (or loss) for each hand; call it net_winnings. Then, using the standard statistical functions, the average amount won per hand becomes simply

avg(net_winnings)

and the variance

variance(net_winnings)

Thus there would be no need for confusing sums and differences over various separate tables.

Quote

12-10-2008 , 08:45 AM

#789

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by sorrow

I've just this minute pushed that checks your username exists before continuing with the query.

It works now; thanks!

The profit figure given is the same as the one I arrived at manually with the complicated SQL expression I gave. As regards whether the figure is accurate, I have realised I am not completely sure which sessions are in the database and which aren’t: I played a few sessions without using the HUD. There’s a simple solution. I’ll clear out my database and start again, and see what happens.

Quote

12-10-2008 , 11:48 AM

#790

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Eleatic Stranger

IThere’s a simple solution. I’ll clear out my database and start again, and see what happens.

Actually, you don't have to clear out your db, you can just point the bulk importer and HH dir and go. Duplicate hands will be skipped. This will be somewhat faster than doing a fresh import on a clean db.

Comment on the winnings discussion: I think that Steffen meant for "winnings" to the the net for that hand, so you could do the stats query _much_ faster. I am pretty sure that he said that in the mailing list some time in the deep, dimly remembered, past (= 3 months ago).

Quote

12-10-2008 , 11:50 AM

#791

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by sorrow

I pushed just a few minutes ago. I meant to push before I went to bed, but forgot (I was sleepy).

Quote

12-11-2008 , 08:29 AM

#792

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

A more careful inspection has revealed that the profit-and-loss numbers that Fpdb reports are, in fact, accurate. I withdraw my unfounded accusation to the contrary. I must have been finding it impossile to reconcile the figures because not all of the relevant hand histories that I thought had been transferred into the database had actually been transferred.

In the meantime, I have added two columns to the “Player Stats” display, profit per hand and variance. By taking the square root of the latter (i.e. standard deviation) a tool such as the following: http://www.poker-tools-online.com/riskofruin.html (link thanks to Xaiviax) can be used to calculate an appropriate bankroll. I think this should be added to Fpdb as well at some point – a very useful tool.

I’ll be happy to upload my code (assuming that there is interest) if somebody tells me how to have Git do it.

Quote

12-11-2008 , 10:02 AM

#793

LordV27

newbie

Join Date: Nov 2008 Posts: 34

Quote:

Originally Posted by xaiviax

OK, to be of some help, I have attempted to install this in Vista. I have a lot of experience with MySQL in a Lamp environment, and have been using this program in Linux. So with that said, it should be easy for me to get everything running in Vista. And .... it was.

To the developers: I used the current instructions and the new environment installer. Everything worked well for someone who knows their way around Vista, mysql, and this program. I noticed a few small potential issues for newbies, I'll get around to writing something up soon. The program works great (better than even in Linux, although much uglier)

To LordV27: It sounds like you have mysql set up properly. It also sounds like the program is set up correctly too. What seems the most likely issue first, is your password in the HUD_config.xml file is not the database password of your fpdb. Note that this password is the fpdb's password and not the root password you set for mysql. If you used the installer, this would be the 2nd set of passwords you entered. I would suggest you do the following:

From the start menu, run MySQL command line client
A cmd terminal (dos looking) window will pop up asking for password. This is the root password of mysql. When entered, you should get a message and the mysql> prompt.
Enter show databases;
and you should see a short list including mysql, test, information_schema, and fpdb.
If fpdb is in the list, Enter drop database fpdb;
Enter show databases; again to verify fpdb is no longer there.
Run the setup program again and remember the password entered for the fpdb database (again, this is different than the root password).

If this helps or doesn't help, post back here.

I tried the suggested method.. the list did not include fpdb and when I said to drop fpdb it clearly stated that the database did not exist.. I am still having the same problem as before clearly am at my wits end..

Quote

12-11-2008 , 11:12 AM

#794

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Eleatic Stranger

Thats good news.

Quote:

Originally Posted by Eleatic Stranger

In the meantime, I have added two columns to the “Player Stats” display, profit per hand and variance. By taking the square root of the latter (i.e. standard deviation) a tool such as the following: http://www.poker-tools-online.com/riskofruin.html (link thanks to Xaiviax) can be used to calculate an appropriate bankroll. I think this should be added to Fpdb as well at some point – a very useful tool.

I’ll be happy to upload my code (assuming that there is interest) if somebody tells me how to have Git do it.

I thought you were already "git pull"ing from our repositories?

If you did then "git diff" from anywhere in the tree will show you a unified diff output which you can redirect and email.

If you think you'll be making more contributions then setting up a public repository at assembla, github or one of the other free repository sites is probably best.

Quote

12-11-2008 , 12:09 PM

#795

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by LordV27

OK, the installer is not making an fpdb database for you. Later today I will look at that code and do some more testing on it.

You just need to create the fpdb database and set its permissions. So get back in to the mysql client like you did before. Then do:

CREATE DATABASE fpdb;
SHOW DATABASES;

my output looks like this:

Code:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| fpdb               | 
| fpdbTEST           | 
| fpdb_test          | 
| mythconverg        | 
| test               | 
| tester             | 
+--------------------+
8 rows in set (0.01 sec)

You will have fewer databases, but you should have one named fpdb.

Now set the password for fpdb with these 2 commands:
GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

OK, let's see if that worked. Now type this command:

SHOW GRANTS for fpdb@localhost;
Failure looks like this:

Code:

mysql> show grants for mythtv@'192.168.1.100';
ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on host '192.168.1.100'

and success looks something (but not exactly) like this:

Code:

show grants for mythtv@localhost;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for mythtv@localhost                                                                                     |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY PASSWORD '0476fc026afffe24' WITH GRANT OPTION | 
+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

If that all worked you should be ready to run fpdb.

Quote

12-11-2008 , 12:27 PM

#796

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Eleatic Stranger

A few years ago I worked at R&D organization where the big boss would be very unhappy when he was showed a graph that didn't have error bars on the data. This led to some of the young researchers being publicly throttled and humiliated. We all learned about that error bar thing.

OK, back on topic, how hard would it be to calculate a confidence interval for the BB/100 number? Related to that, how hard is it to calculate the probability that the true BB/100 is > 0 or >2 BB/100? Certainly the big boss would be considering a good throttling for us if we just present a BB/100 stat and no indication of how useful it is.

Related to that, the RoR calculations are very sensitive to the win rate (LDO), which needs tens of thousands of hands to be well estimated. fpdb will routinely be telling guys that they can play $100/200 NL with 3 buy ins based on a few hundred hands of running hot. So any bankroll information supplied by the program should be in some sort of pop up that has some caveats.

Quote

12-11-2008 , 12:39 PM

#797

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Eratosthenes

OK, back on topic, how hard would it be to calculate a confidence interval for the BB/100 number? Related to that, how hard is it to calculate the probability that the true BB/100 is > 0 or >2 BB/100?

Good question - probably one for the Poker Thoery or Probability forum.

Quote

12-11-2008 , 01:09 PM

#798

giftedmadness

old hand

Join Date: Feb 2008 Posts: 1,543

I went to this site's downloads page and it's a broken link. Is it still available?

Quote

12-11-2008 , 02:00 PM

#799

LottaNirvana

veteran

Join Date: Dec 2006 Posts: 2,146

Quote:

Originally Posted by giftedmadness

I went to this site's downloads page and it's a broken link. Is it still available?

It worked fine for me today.

Quote

12-11-2008 , 02:04 PM

#800

LottaNirvana

veteran

Join Date: Dec 2006 Posts: 2,146

I don't know if you've gone over this, but I dont have time to go through 52 pages of Thread replies....

When starting the Installation, there is a dialog box that says that 'this will reconfigure MYSQL" (or something like that...)

Will installing this software affect the operation of POKERTRACKER 3 in anyway?

Thank you...

Quote

Page 32 of 377

First

12 22 27 28 29 30 31 32 33 34 35 36 37 42 52 82 132 232

Last

Post Reply Subscribe

...

Page 32 of 377

First

12 22 27 28 29 30 31 32 33 34 35 36 37 42 52 82 132 232

Last