I'm not much help here as the same thing happened to me the last time that I uninstalled/reinstalled PostgreSQL. You might try searching around the PostgreSQL website at www.postrgresql.org.

Thank you for the bug report. Due to the entirely different way that it handles this, SharpStats does not suffer from this bug.

-red

redlotus,

First thank you for creating and supporting this product, seems like it will be quite useful. I am having an issue though:

ERROR: 42846: cannot cast type bit to text.

This occurs when I hit refresh on the Holdem tab. I get similar casting errors hitting refresh on other tabs as well.

Thanks,
Wes

What version of PostgreSQL are you running?

8.2

upload please Cake Personal Stats Tracker full version on another server

Could you try the upgrade to 8.3.5? You can find it here. To be completely honest, the error you're getting is caused by PostgreSQL and there's no away around it that I know of.

I'll see if I can find another file-share.

-red

Upload please! On the server can not boot from Russian IP. The program will be of interest to the whole Russian community!

Try this. If this new share doesn't work, PM me your email address and I'll send it to you.

-red

2 questions please.

A I downloaded and unzipped the file now how do I install it on my pc

B I get this error message : Working directory does not exist , when I try and import files.


Thanks

You don't. You run CPST directly from the folder that you unzipped it to.

Make sure that the text box next to the "Working" button has a valid directory in it. If not, click the Working button and browse to the folder where you would like to have CPST move the hand history files.

-red

Thanks that worked

Hey all,
Just wanted to give everyone a quick update on how SharpStats is coming along. I think that I've finally wrapped up all of the big errors that occurred during the early phases of development. In fact, out of my latest test run of ~30,000 hands, SharpStats only choked on 27 of them. Of these, 6 were broken hand histories, 3 were forced all-ins during HU play, 3 were caused by "sitters" (players sitting out during a tourney) in the blinds, and the last 15 were EV calculations with side pots (a problem that even PT and HeM are subject to).

The biggest reason that SharpStats has less than a 1% error rate, and a big reason for the delay, is that I've implemented an internal HH converter that cleans up hand histories as much as possible. This clean-up includes separating villains that share the same first four letters in their screen names. It also attempts to fill seats with players that are sitting out in tourneys. Here's a quick example of a HH that hasn't been converted:
And here is what it looks like converted:
Unfortunately, I can't find an example with duplicate villain names at the moment, but I will try to post one when I get a little more time.

I apologize for the wait, but I think that you will agree that it was worth it.

Thanks,
-red

Looks like I'm having problems emailing the program, so here's one more effort to make this available. If you had problems with my last two file-shares, give this a try. This is my personal breifcase, so please only use it if you've had problems with the other two. If anyone else has some free online file storage space and are willing to mirror CPST, I would appreciate it.

Thanks,
-red

Note to the two people who've asked me to email them CPST: for some reason, gmail bounced my emails to you. The only error message in the mess of text that makes any sense is that gmail doesn't like the attachment. Please try this new link and let me know if it works.

And here's the megaupload link:
http://www.megaupload.com/?d=96O1R7FE

www.mediafire.com is good for sharing too, really fast and does allow many download managers!

Hi,

I'm interested by the program but could you please backup your claim?

You wrote:


the last 15 were EV calculations with side pots (a problem that even PT and HeM are subject to)

Do you have an exact HH (not a Cake one, a PStars one will do) to provide showing HM and PT having problems with EV calculations in deals involving side pots?

Also the way you worded it, you may it sound like HM and PT would choke on importing deals where EV calcs for side-pots is needed.

In any case, could you clarify your statement and/or give an example of where PT and HM have a problem?

Ok, I'll give. I was going by what several other posters have written. Take a look in any of the "Online Poker is Rigged" threads where EV graphs are brought up and there's inevitably someone bringing this up.

I suppose my choice of words was a little harsh. AFAIK, neither PT nor HeM will generate an error if the EV calculations have a possibility of being off. SharpStats, OTOH, checks for a couple of specific situations. If it finds either of these, it marks the hand with an error bit so that the EV can be calculated manually. Here are the two situations:
Hero's net win for the hand is positive, but it is less than the EV-Adjusted net win. The two situations that cause this are 1. spots where you get it in with an equity advantage, but you end up splitting the pot (eg your AA vs villain's AK and the board comes up 2345x) 2. Pots with one or more side pots.
Hero's net win for the hand is negative, but it is not as negative as the EV-Adjusted net win. If I remember my math correctly, this can only happen when there are side pots.

I will see if I have any HHs where the EV calc is off. The big problem is, though, that I only have a couple hundred cash game hands and I'm not running a version of HeM that includes EV calcs with tournament hands.

-red

Hi again,

thanks for the answer, here's more infos and questions

I made a test with a crafted hand. I'll do more testing and I'll report.

Bringing what up? That PT and HEM EV calcs are wrong in particular cases? (any link appreciated for I'd like hand history/ies showing this [bad] behavior of PT/HEM).

But what makes you think these two cases are problematic for HM/PT? For deals going to showdown, where all the holecards are known, it's possible to compute the expected value of every pot (main pot and side-pots) for all the players.

There's a tiny bias --and this is another topic-- when a player is all-in at some pre-river street and another player folds at a later street (there's a discussion entitled "EV in a side pot, folders, all cards known" on 2+2 on that subject), but the EV calculations should never be way off.

I crafted a hand with three people all-in preflop where the hero makes a net win, but less than what is expected.

AA vs AK vs J2. All players have $0.10, total main (and only) pot: $0.30.

AA's pot equity is 76% (as verified in PokerStove). This is the number that HM gives too (what HM calls the "avg allin EV%").

So hero should be making $0.22 on average, for a net win of $0.12.

However hero splitted with the AK hand and made only $0.15, for a net win of $0.05.

So hero is "running bad" by approx 7 cents (7.8 cents actually).

These are exactly the numbers reported by HEM, which shows your net win as $0.05 and the "$EV adjusted" as $0.13 ($0.05 + $0.078, which gives $0.1278, approximated by HM to $0.13).

That crafted hand history shows a case where the net win is positive, but less than the EV-adjusted net win and HM has no problem with it. I really don't see why this case would be problematic.

I think that crafted case is exactly the "situation 1" you described. And HM has no problem extracting the correct EV infos in this case.

I've got a lot of gripes and complains about PT and HM, but this is not one of them.

Now I haven't tested with sidepots. I'll agree with you that showing a value "average all-in ev%" is meaningless in a multi-way deal with sidepots (is it pot1 ev% + pot2 ev% average? is it ev1+ev2 average? If pot one has $10 and pot two $350, I'm pretty sure this info is completely misleading). "average all-in ev%" makes sense in PokerStove, for PokerStove has no concepts of side-pots. But HM loves to display misleading information (I won't start about all the stats calculated by taking into account actions due to a player disconnecting).

As a sidenote PokerStove is kinda misleading too: it gives an info that it calls "pot equity" when 99% of multi-way all-ins involve multiple pots. PokerStove's "pot equity %" is actually "mainpot equity %".

Anyway, it's not because HM allows you to display that misleading information when there are multiple pots that it's actually computing the "EV diff" or "$EV adjusted" wrong in multi-way pots involving side-pots.

I'm not saying it's right: I haven't tested yet.

But I have tested your first situation and HM has no problem with it.

Here's a fake PokerStars hand I crafted to test your "situation 1". Three players all in preflop, they all have the same stack. No rake for it's less than $1 pot.


If you find a hand where HM is way off, you can post it.

I'll try to craft a case with sidepots and prove HM wrong

I'll report my findings

This one I already answered and apparently is OK for HM.

OK you were apparently right for this second case. Actually it looks even worse than this: you don't even need special cases. All the multi-ways/different stack sizes (and hence multi-pots) all-ins EV calculations seems to be plainly wrong in HM. And this is one more gripe for me to add to HM. The "EV" infos HM gives, say, when three players are all-in preflop with different stack sizes are actually apparently completely bogus.

My apologies for not making myself clearer, but I didn't mean to imply that HeM or PT had a problem with this scenario. I was just mentioning the fact that SharpStats will flag this hand. In fact, this situation is one of the reasons I have a "Information Correct As Is" button in the database editor.

This is exactly what is brought up every time someone posts an EV graph to try and prove that online poker is rigged.

I actually can't blame the programmers of HeM or PT. It would take a good chunk of programming to get it working correctly and all for just a little gain. However, I've always felt that there should be some easy way for the user to change this kind of information if he or she wishes to take the time.

-red

I am happy to announce that the successor to Cake Personal Statistics Tracker, SharpStats CPN is now available for download.
http://www.megaupload.com/?d=ZJPF9R5A
http://files.openomy.com/public/redlotus/SSCPNb3.zip

Here's a quick list of the improvements that have been implemented:
--Right-click any stats table to bring up a list of stats that can be displayed. No more switching back to the configuration page to change which stats you want to see. Using this feature will be the subject of my next video, which I hope to have posted soon.
--Separation of Omaha High and Omaha Hi/Lo
--Greatly increased accuracy. As I've mentioned in a previous post, SSCPN uses an internal hand converter that improves the parsing of hand information
--Rewards tracking - This includes a monthly gold chip estimator, rakeback calculator, and bonus tracker.
--Database editor - Allows you to change any hand histories that SharpStats has determined may be incorrect or any hand histories that you have marked. Also allows you to correct any tournament results information that you may have entered incorrectly.
--Hand History Exporter - Create a file with all of the hand histories that you have marked for review
--Introductory video - This is just a quick video that will help to get you up and running quickly. I will be making several other videos that cover different aspects of SharpStats and posting them as they are completed.

That's it. Hope everyone enjoys the program. Please post any questions, comments, or suggestions. I would still consider the program to be in beta, so there may be bugs. If you find anything that doesn't look right, let me know and I'll get fixed ASAP.

Thanks,
-red

Note to programmers: the internal hand-convertor and parser are available for use with your program. If you would be interested in using either/both for your program, contact me via PM so we can discuss how you can use it and possible licensing terms.

I have a quick update and a new video for everyone.
http://www.megaupload.com/?d=ZO1ZOBIR
http://files.openomy.com/public/redl...PN-Update1.zip
The new video goes over how to change which stats are displayed.

The update fixes the Net Win and EV-Adjusted Win columns in the 'Hands' table. I made a last-minute decision to store all real numbers as integers in the database and missed the queries for these two columns when I was updating everything. To apply the patch, just unzip the files to your SharpStats program directory and overwrite the existing files.

-red

I downloaded SSCNb3.zip - which I think is the latest version.

I can't seemt to get configured. I have your default settings for Server ID, Port ID and User ID. I have no idea what to put for Password. I never set up a password for PostGres - either had it as a default on my computer or it came with Poker Tracker.

I tried to Test Configuration leaving password blank and by using the admin password for my computer - neither worked. Any suggestions.

Also, if I click Import Now I get "Working Directory does not Exist". This is likely because I don't have a PostGres password. Any help you can give leading me to a solution would be appreciated.

The new SharpStat is not able to recognize duplicate hands. It will imports the same hand twice.

*The old CPST has the same problem too.

Thanks

"Working directory does not exist" only comes up when you don't have the 'Folders' area filled in. You must have at least the Working Directory and one skin directory pointing to a valid directory to get SharpStats to start importing.
As for your password, I spent some time searching for an answer, but I couldn't come up with anything. At some point you had to have entered a password for PostgreSQL to work correctly.

Thank you for reporting this. I will get it fixed ASAP.

-red