Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Poker Software Poker-related software official support, e.g., poker trackers, solvers, equity calculators.

Closed Thread
 
Thread Tools Display Modes
Old 11-19-2008, 04:29 PM   #5576
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

The prompt should be played=#
if it's played-# that means you forgot a semicolon; put in a semicolon and hit enter.

Then type this exactly:
SELECT history from holdem_hand_histories;

and hit enter. It should spit everything out properly and all output should be redirected to the file you specified.
Kraada is offline  
Old 11-19-2008, 05:02 PM   #5577
§437 Nr. 3
veteran
 
§437 Nr. 3's Avatar
 
Join Date: Jan 2008
Location: Schland
Posts: 2,098
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

ok this is what it gave me for different values

^
played=# SELECT history from holdem_hand_histories;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=# SELECT history from holdem_hand_histories WHERE id_hand > 10;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=# SELECT history from holdem_hand_histories WHERE id_hand > 50;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=#
§437 Nr. 3 is offline  
Old 11-19-2008, 06:27 PM   #5578
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Try for some larger values? See if you can get it from id_hand > 1000 or > 10000.

How big is your database, roughly?
Kraada is offline  
Old 11-19-2008, 06:44 PM   #5579
§437 Nr. 3
veteran
 
§437 Nr. 3's Avatar
 
Join Date: Jan 2008
Location: Schland
Posts: 2,098
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

my database is prob like 1.5mil

ill try bigger values later
§437 Nr. 3 is offline  
Old 11-19-2008, 07:05 PM   #5580
§437 Nr. 3
veteran
 
§437 Nr. 3's Avatar
 
Join Date: Jan 2008
Location: Schland
Posts: 2,098
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

just checked its only 1 mil

will try bigger values later.

if u dont come up with another way and it doesnt work, i might just have to reimport some hands i saved somewhere and hope that is all (which it wont be)

should i reinstall postgresql in that case or will creating a new database be fine?

i could also just remove and not delete my database and start a new one right, since all my hands "seem" to be in there for emergency cases
§437 Nr. 3 is offline  
Old 11-19-2008, 07:09 PM   #5581
§437 Nr. 3
veteran
 
§437 Nr. 3's Avatar
 
Join Date: Jan 2008
Location: Schland
Posts: 2,098
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

sry, just double checked, coz i had filters on

its actually 5.5 million, alot of obvserved ones tho, im only intersted in played hands if that helps anything
§437 Nr. 3 is offline  
Old 11-20-2008, 10:05 AM   #5582
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

In order to try exporting just played hands, run this query:

SELECT history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = "Your Screenname";

It may also not work, I'm not sure how deep the corruption goes. Again, you can also add "Where holdem_hand_histories.id_hand > X" for some numbers x and try to just get some. I'm starting to doubt this will actually work but it's worth one more try (maybe the parts of the database that are corrupted are from the other players, after all).

Good luck
Kraada is offline  
Old 11-22-2008, 01:30 PM   #5583
starchyy
adept
 
starchyy's Avatar
 
Join Date: Jan 2007
Posts: 1,168
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

In the cash hud configuration menu, which one of the options stands for btn and co 3bet pf?
starchyy is offline  
Old 11-22-2008, 02:09 PM   #5584
WhiteRider
Pooh-Bah
 
WhiteRider's Avatar
 
Join Date: May 2008
Location: UK
Posts: 5,337
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Positional stats aren't included by default yet, so you will need to use Custom Stats.
There are a few of these available for download from the Repository although I don't remember seeing 3 bet positional stats yet.
It would be pretty straightforward to build your own, though.
Have a look at how one of the positional stats is made, as well as the 3-bet stats, and have a go.
Custom Statistics and Reports FAQ.
If you get stuck, please ask. (I'd suggest starting a thread in the PokerTracker 3 Forum)
WhiteRider is offline  
Old 11-23-2008, 01:12 PM   #5585
starchyy
adept
 
starchyy's Avatar
 
Join Date: Jan 2007
Posts: 1,168
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by WhiteRider View Post
Positional stats aren't included by default yet, so you will need to use Custom Stats.
There are a few of these available for download from the Repository although I don't remember seeing 3 bet positional stats yet.
It would be pretty straightforward to build your own, though.
Have a look at how one of the positional stats is made, as well as the 3-bet stats, and have a go.
Custom Statistics and Reports FAQ.
If you get stuck, please ask. (I'd suggest starting a thread in the PokerTracker 3 Forum)
Thanks
starchyy is offline  
Old 11-24-2008, 02:46 PM   #5586
johnnytothec
adept
 
johnnytothec's Avatar
 
Join Date: Mar 2008
Location: Colorado
Posts: 707
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

A few basic PT3 Qs:

On Stars, when I click "sit here" to rotate the view of the seat that I am in, the HUD stats do not move with me and are on the wrong player. Is there a way around this?

My HUD stats are based only upon the session I am playing, but I want it to be based upon my entire history with that player, how can I change that?

Is there a way to auto-import STT and MTT? I have been maually entering the results so far.

Thanks.
johnnytothec is offline  
Old 11-24-2008, 04:25 PM   #5587
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by johnnytothec View Post
A few basic PT3 Qs:

On Stars, when I click "sit here" to rotate the view of the seat that I am in, the HUD stats do not move with me and are on the wrong player. Is there a way around this?

My HUD stats are based only upon the session I am playing, but I want it to be based upon my entire history with that player, how can I change that?

Is there a way to auto-import STT and MTT? I have been maually entering the results so far.

Thanks.
The Hand History doesn't say where you move to when you use "Sit Here" so PT3 cannot recognize your new seat location. You need to use the Preferred Seating on PokerStars in order for PT3 to recognize it. Once you set up Preferred Seating PT3 should automatically detect where you are and rotate the stats accordingly.

Your HUD stats will always be session only and this is by design; your session stats show you how the other players around the table perceive you and this information is very useful since there's no way to know for sure how much data your opponents have for you.

Imports by e-mail for tournament summaries will be available in the next Beta, which should be out by the end of the day tomorrow.
Kraada is offline  
Old 11-24-2008, 04:45 PM   #5588
johnnytothec
adept
 
johnnytothec's Avatar
 
Join Date: Mar 2008
Location: Colorado
Posts: 707
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Thanks. Very good info.
johnnytothec is offline  
Old 11-24-2008, 07:06 PM   #5589
craig1120
veteran
 
Join Date: Oct 2005
Posts: 2,220
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 18 (60 day trial) - 30-Sept-2008

Quote:
Originally Posted by craig1120 View Post
I am a HEM user and am unfamiliar with PT3 but I am getting frustrated because HEM has not upgraded the vs player feature.

I am looking for the ability to filter situations to see how certain players are playing against me specifically. I want the ability to filter for example a situation where I am on the button he is in the BB and see how often he is 3 betting my opens. Or if I raise preflop he flats, I want to be able to select fold to flop cbet = true and see the number of times he folds to my flop cbet. Etc.

Does PT3 have this ability and if not are you guys planning on adding this in the future and if so when? Thanks.
Any update on this?
craig1120 is offline  
Old 11-24-2008, 07:15 PM   #5590
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

There are currently quite a few filters, and you can do most of what you want right now.

You want position is exactly 0 on the general tab for times you're on the button.

You can then go to the Actions tab and add Chance to Steal, Raised for times when it's folded to you and you raise.

Then you can add Face 3 bet on the Facing tab. Then you'll see hands where you faced a 3bet when opening from the button.

Or you can add "Call 3bet" on the Facing tab's flop section and then you can look at all hands where you stole from the button got 3 bet and flat called.

From there you can add whatever you'd like to reports and see what you'd like to see.

And more filters should be available in the next Beta release, due out sometime tomorrow.
Kraada is offline  
Old 11-24-2008, 07:34 PM   #5591
craig1120
veteran
 
Join Date: Oct 2005
Posts: 2,220
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

It sounds like I would have to go through all the hands in that situation and look for the villain I want and count right? There isn't the ability to select a player, select filters, then have a number come up?
craig1120 is offline  
Old 11-25-2008, 10:27 AM   #5592
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

If you're looking for a number on a specific villian, you should create a custom stat for it.

You didn't give a very specific situation, so here's how you'd create "Fold to cbet in 3 bet pot when having stolen the blinds"

Create two columns in Holdem Cash Player Statistics:

(1) Call the first one something like "cnt_f_cbet_def_fold_when_stealing_and_3bet":

sum(if[ flg_steal_att and enum_p_3bet_action = 'C' and enum_f_cbet_action = 'F'])

(2) Call the second one something like "cnt_f_cbet_def_when_stealing_and_3bet":

sum(if[ flg_steal_att and enum_p_3bet_action = 'C' and flg_f_cbet_def_opp ])

Then go to the statistics tab, create a new stat, call it how you please ("Fold to cbet percentage in 3bet blind stealing pot"? This name is going to get long).

Define it as:
100 * cnt_f_cbet_def_fold_when_stealing_and_3bet / cnt_f_cbet_def_when_stealing_and_3bet

Make sure on the format tab you give it a width (40 or 50 should be fine) and a title (FCB3BWS?).

You can then add that stat to any report that can access the Holdem Cash Player Statistics information and use that data on your HUD.

Now, it won't be based on times they've done that to you but rather times they've done that with all opponents.

Still, that should get you what you're looking for. And, similarly, you can create other stats in the same vein.
Kraada is offline  
Old 11-25-2008, 10:27 AM   #5593
74Flyers75
banned
 
Join Date: Aug 2008
Posts: 505
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Sorry in advance for what probably are newb questions. I just purchased PT3 for use with FullTiltPoker. I read the documentation but didn't see anything that addressed this.

1. Should I download the Beta20 release (11/4/08) or the Build 3 release (9/29/08)? I would think the Build 3 release since it would not be as buggy, but what do I know?

2. Do I need to make an adjustment in the FTP software on how many days I keep my hand history? Does the PT software keep all my history since the first day, regardless how long I save my hand history in FTP?
74Flyers75 is offline  
Old 11-25-2008, 10:45 AM   #5594
craig1120
veteran
 
Join Date: Oct 2005
Posts: 2,220
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by Kraada View Post

Now, it won't be based on times they've done that to you but rather times they've done that with all opponents.
This is what I was asking about.
craig1120 is offline  
Old 11-25-2008, 11:25 AM   #5595
zoltan
Carpal \'Tunnel
 
zoltan's Avatar
 
Join Date: Jul 2007
Location: Off my lawn you little punk!
Posts: 21,444
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

When importing older hands into PT3, does PT3 recognize duplicate hands as duplicates or unique? i.e., are hands double counted, and therefore I need to manually remove the duplicates?
zoltan is offline  
Old 11-25-2008, 11:38 AM   #5596
WhiteRider
Pooh-Bah
 
WhiteRider's Avatar
 
Join Date: May 2008
Location: UK
Posts: 5,337
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by 74Flyers75 View Post
Sorry in advance for what probably are newb questions. I just purchased PT3 for use with FullTiltPoker. I read the documentation but didn't see anything that addressed this.

1. Should I download the Beta20 release (11/4/08) or the Build 3 release (9/29/08)? I would think the Build 3 release since it would not be as buggy, but what do I know?
There are enough fixes and improvements in Build 20 to make that the preferred version.
You can check out the version history post and make your own decision if you like: http://www.pokertracker.com/forums/v...hp?f=15&t=6548

Quote:
2. Do I need to make an adjustment in the FTP software on how many days I keep my hand history? Does the PT software keep all my history since the first day, regardless how long I save my hand history in FTP?
No, as long as the files are written that's fine. PT3 will read them as they are updated, and when you stop auto import it will move the files to another folder as a backup (and so it doesn't have to read them again next time).
If you leave the "Store Hand History Text" option enabled then the hand history text will also be stored in the database.

Quote:
Originally Posted by zoltan View Post
When importing older hands into PT3, does PT3 recognize duplicate hands as duplicates or unique? i.e., are hands double counted, and therefore I need to manually remove the duplicates?
If the hand is already in your database then it will be identified as a duplicate and NOT imported again (so you don't need to do anything).
WhiteRider is offline  
Old 11-25-2008, 12:45 PM   #5597
PokerAce
See our Commercial Software thread
 
PokerAce's Avatar
 
Join Date: Jan 2005
Posts: 4,309
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Beta 21 Released

Added:
  • New Site: Boss Media
  • Tourney: Enter Results window allows you to select and edit/auto multiple tournaments at once
  • Tourney: Report: Tournaments - By Time
  • Import from Email
  • New Filters
  • Option to use images to represent cards in reports
  • OnGame tournament support
Fixed:
  • Report: Tournaments/Winnings tab using the "Amount Won" value instead of the "Net Won" value for the row coloring
  • Auto Rate: "Rules" tab shows icons properly (broke in previous release)
  • Import: OnGame import problem with steal attempts
  • Import: After preflop raise, flag for cbet opportunity being set

PT3 now supports a new site: Boss Media. This is full support: Cash, Tournament and Hud on both. It has not been thoroughly tested yet, so there may be some statistical bugs, so please compare your PT3 results with what PT2 shows (if you use PT2).

Tournament support has been improved. There is now a "Tournament - By Time" report, which allows you to see your true hourly win rate. Also, tournament result entry has been improved. You can highlight multiple tournaments and edit them all at once. You can also use the Auto Fill to automatically fill the results for multiple tournaments at one time. To further improve tournament result entry, PT3 can import summaries from your POP3 email account. Simply configure PT3 using the link on the Manual Import tab and then click the Import from Email button. It will bring up a window that lets you select which emails you would like PT3 to import from.

New filters have been added to PT3. You can now filter for all-ins, as well as board texture, cards on the board, various pot sizes, and more. These filters were a late addition and thus have not been tested much. Please report any inconsistencies you notice.

OnGame tournament support has been added. This was also a late addition and has had very little testing. Please let us know of any problems you experience.

We hope to add more site support by the end of the year. Thanks to those of you who have submitted hands to us, but we still need more. We need hands from the following sites:
  • Absolute
  • B2B
  • Betfair
  • Bodog
  • Cryptologic
  • Microgaming Network
  • Pacific Poker
  • Tain Network
  • Tribeca
  • Ultimate Bet
  • World Poker Exchange
We need hand histories in all formats and both cash and tournament hands. For sites that use database files or single xml files or whatever, we need those as well as any datamining formats and PT2 exported formats. The more hand histories we get, the easier and faster it will be for us to get support added for the site. The sites above are not listed in the order we will be adding them. We have been going by http://pokerscout.com and adding the sites by size. We may continue to do this or we may skip around now that the unsupported sites are pretty similar in size. To submit your hand histories, please follow this link.
PokerAce is offline  
Old 11-25-2008, 01:51 PM   #5598
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by craig1120 View Post
This is what I was asking about.
Unfortunately I don't think it's possible to make any "Against Me Only" stats in PT3 at this time.
Kraada is offline  
Old 11-25-2008, 02:17 PM   #5599
§437 Nr. 3
veteran
 
§437 Nr. 3's Avatar
 
Join Date: Jan 2008
Location: Schland
Posts: 2,098
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

Quote:
Originally Posted by §437 Nr. 3 View Post
should i reinstall postgresql in that case or will creating a new database be fine?

i could also just remove and not delete my database and start a new one right, since all my hands "seem" to be in there for emergency cases
pls say something about this

another question:

if i do this


SELECT history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = "Your Screenname";


will my usual screenname that has aliasses attached to it in pt3 be enough or can i do "screenname1, screenname2"?
§437 Nr. 3 is offline  
Old 11-25-2008, 05:34 PM   #5600
Kraada
See our Commercial Software thread
 
Join Date: May 2005
Location: New York
Posts: 6,489
Re: New Software: PokerTracker 3 - 3.00.3 / Beta 20 (60 day trial) - 05-Nov-2008

So long as you don't initialize a new database cluster on top of the old database location, your data will not be harmed; reinstalling PostgreSQL will only nuke your database if you initialize a new database cluster on top of the old one.

I believe the alias function actually adds your data together at a low enough level that using just your master screenname would get all hands from all aliased screen names as well.
Kraada is offline  

Closed Thread
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 08:55 PM.


Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright © 2008-2020, Two Plus Two Interactive