Love the program. Still trying to figure out how to work everthing. From what I have read it appears I need to manually put in my tourney results to be able to graph profits. Is this correct? If so, in the description field do I need to link it to a specific tourney or how should I work this part? If you have already made a video on this just point me to which one to watch. I have watched the first two videos for SharpStats. Thanks.

Hey,
I have downloaded from the link in post no.72, have succesfully Tested the connection and have pointed the app to the correct folder to import hand histories.

When I click "Import Now", nothing happens except for "Current File" flashing up for a second beneath the Import Now button.

What am I doing wrong?

Thanks

The default Postgres password that PokerTracker 3 uses is 'dbpass' (without the quotes).

Kaz

You do have to input the results manually, since Cake gives zero indication of your place in the hand histories. You can put anything that you want in the description field--it doesn't link to the hand histories at all. Just use some sort of description that will help you remember what kind of tourney it was. Cake's HHs are so bad that they will actually combine SnGs into one file, unless that has changed in an update and I missed it, so linking results to files is pretty pointless.

I'm assuming that you are not in the US. There is currently a problem with importing on a computer that doesn't use $ as currency and/or uses the comma (,) as a decimal separator. I am currently working with my main beta-tester to get this issue resolved (he is from the UK and was having the exact same problem). I'm hoping to have it fixed and a new version released sometime this week.

-red

Nope, not in the US so that must be the problem. Is there any way I can work around this as a temporary measure before you release the fix? Maybe changing my windows settings or something?

Thanks very much

Red,

Just downloaded it and it worked like a champ, once I got through some unexpected configuration requirements.

One minor issue: I am a beginning beginner. So, I'm playing 4NL, and all the displays in the Statistics and reports show all the amounts correctly. But, for some reason, the Net Win and EV-Adjusted Win (which isn't defined in your stats help, btw) in the 'Hands' window is off by a factor of 100. For instance, if I have a hand with a net win of $0.04, the net win on in the "Hands" window is showing $4.00.

Thanks,

Kaz

I think that there might be, but I'm not sure where to go to adjust it. The updated version should be released today or tomorrow, though.

This was a known issue that I corrected with a patch that I released with the second introductory video. You can find it here:
http://www.megaupload.com/?d=ZO1ZOBIR
or
http://files.openomy.com/public/redl...PN-Update1.zip

I'd actually recommend waiting for the new update, though, because it also includes a fix to the duplicate hand detector along with a number of other improvements.

*edit* BTW, thanks for mentioning that neither of these stats are explained in the Stats description. I will add these for the next update.

-red

That is what I figured. Thanks for the sweet software. Maybe someday cake will learn the flaw to there ways.

Another minor issue... it doesn't seem to want to remember my folders I set up. Every time I start the program, I need to reset those. Yes, I'm clicking "save folder settings." Where are they saved to? Perhaps I can see what's going on.

Kaz

More significant issues:

First:

It appears that you have some left over code from earlier versions. In your original post, you said it would load in hand records from the current day. Since it does exactly that, I assume you changed it. However...

You also appear to move the files from the Cake directory to the working directory. This is fine. But, it does not move the files from the current day. The net result is that if I pull in files from the current day, those hand records are still in place in the original directory. If I play another session, or simply import a second time, those hand records from the current day will import a second time.

Second:

In attempting to solve the first problem, I went to reset and reinit the database and reread all the hand records. But I get errors if I've imported (or maybe just accessed the database). I need to shut down SharpStats and restart it. If I then immediate reset/reinit the database, all is fine.

Otherwise, I love it.

Kaz

The settings file is called user.config. It's in a different folder for everyone, so do a search for it. One of the sub-folders will be MTM Software\SSCPNb2.
I will take another look at the code to try and find out what might be causing this.

Yes, I changed this limitation when I added code that checks to see if any Cake client software is running

This was done on purpose because I'm not completely confident that the software wouldn't scramble hand history files if it tried to combine them. If I can ever get it stable enough, I might be changing this behavior. The duplicate hand check is supposed to prevent hands from importing twice, but their is a bug in the current release that is fixed for the next update.

I have the exact same problem and I'm not sure how to correct it. Something about the way that Npgsql handles connections between .NET and postgres. Since it is such a minor problem, it's not been a big priority. I will look into it again as soon as I get the other major bugs patched.

Thanks,
-red

Sounds good. Thanks. As for keeping the Postgres DB open, it might be that you need to do more than close the connection. You might need to actually destroy the connection object by setting the connection object to null.

I don't know your code of course, but I have that problem on a lot of .Net COM interrelationships.

As for the settings, I'm running Vista 64, and there might be a directory assumption being made that's bad. I'll look for that file, though.

Kaz

I found the user.config file, and it's in a strange directory:

AppData\Local\MTM_Software\SSCPNb2.exe_Url_2rm0b1v fpbjthslgbp03wa5eax3qur2o\0.1.3.0

And, yes.. the gobbly-good after SSCPNb2.exe is really part of it. Also, MTM_Software has an underscore, which you're not showing in your post. This may all be part of Vista's name mangling... I have no idea.

In any event, the contents of the user.config file appear to be correct. Certainly the stats to show are correct (and they are remembered across program instances.) The directories are not. Perhaps you don't like the format? Too many characters or something?

The XML for the directory section is:

(NOTE: I saw that the forum is 'helping' me by adding spaces into the directories. They are not there, except for "Hand Histories")

<SSCPNb2.Properties.Dir>
<setting name="Cake" serializeAs="String">
<value>C:\Users\name.machine\AppData\Local\DoylesR oom\Hand Histories\DumbPlayer</value>
</setting>
<setting name="SB" serializeAs="String">
<value />
</setting>
<setting name="POP" serializeAs="String">
<value />
</setting>
<setting name="RS" serializeAs="String">
<value />
</setting>
<setting name="Other" serializeAs="String">
<value />
</setting>
<setting name="Work" serializeAs="String">
<value>C:\Users\name.machine\AppData\Local\SharpSt ats</value>
</setting>
<setting name="Rake" serializeAs="String">
<value>-1</value>
</setting>
</SSCPNb2.Properties.Dir>

Found the bug. It's because you didn't choose a site name in the Rakeback Site combo box. I'll change it so that loading directory names isn't skipped when you haven't chosen a rakeback site (not sure why I did it that way in the first place).

-red

Wow.. I'm just a massive giant demo effect for you, aren't I?

Kaz

Another update with a lot of fixes and new features. You can download it here

List of fixes and added features:
--fixed the integer/real bug
--added mult-select to the Hands tables (allows marking more than one hand at a time)
--added the delete hand(s) option to the right-click menu of the Hands tables
--added big blinds per 100 hands stat
--fixed a bug where the post-flop stat 'saw next street' wasn't parsing correctly
--made the Current File textbox, import progress bar, and cancel imoprt button permanently visible in the Import group of the Configuration/Import page
--fixed an EV-Adjusted Win bug where the equity was always being calculated pre-flop
--a large number of improvements to the converter and parser to handle parsing on computers that don't use the $ as their currency symbol and/or use a comma as the decimal seperator
--added explanations of Net Win, EV-Adjusted Win, and BB/100 to the stats.txt file
--corrected a bug that gave a false Aggression Factor stat (I'm sure you'll be happy to see that you're not such pansies )
--fixed a bug that parsed saw_next_street incorrectly
--fixed a bug that falsely determined that hero was All In
--fixed the duplicate hands importing bug

As always, let me know if there are any questions, comments, or suggestions or if I have missed something that you've requested.

Thanks,
-red

*edit* In order to use the update, you will need to uninstall your current version and install this version

Downloaded and installed, and seems to be working great! I was the non US resident unable to import hands, but it's worked now. Thanks very much.

So, can you tell me how the rakeback calculator works?

And with the EV calculator, what methods are used to do the calculations?

EDIT: Am I right in thinking that the rakeback calculator works by you just entering your rakeback % and choosing the date range? I have tried doing this but get the error message;

Cheers

Basically, it just adds up the FPPs divided by the number of players for each hand, adds the vig, subtracts any MGR adjustments you may have and then multiplies the total by your rakeback percentage.

SharpStats uses the open-source Hand Evaluator to determine your hand equity at the point that the cards are flipped over. This equity percentage is then multiplied by the total pot (including side pots) after rake has been removed. I know that this method will give bad results in some situations (particularly side pots), but it is the best I could do given the time I've had allocated to the EV calculations. I plan to revisit this in the future.

You also need to have a rakeback site chosen on the import/configuration tab, but essentially that is correct. The error you are seeing is caused because PostgreSQL doesn't like to see future dates in any query. This is something that I've overlooked and will fix in the next version.

-red

So does it only take in to account all-in situations with more cards to come?


So for now it can only calculate my February RB when we're in March?

Thanks again

Yes. Your EV-Adjusted win will always equal your actual Net Win if you're all in on the river.

Sadly, yes. It won't be a difficult fix, so I should be able to create a patch relatively quickly.

-red

Hello,

I installed and tried to open the latest version.

The program says that I must close the Cake software. It isnt open, but the program keep telling me that and closes the tracker.

I reseted my computer and tried again, same error occuried.

PM sent.

I imported 300 k hands. All went wonderful. Just one question is there a way to import only one days hands. Like when I get done playing today, can I import just the hands I played that day. I tried but it wants to import everything all over again. Thanks again for a great program

There's no way to do it within SharpStats. However, you could move the hands you want imported into a separate folder and point SharpStats to that new folder.

BTW, it shouldn't be trying to re-import any hands. Is SharpStats not moving the files or do you have your import and working folders pointing to the same folder on your computer?

-red

That is a great idea. I will just make a new folder then just input that. Thanks again on a Great program (and yes the working & import were pointing to the same folder) Fixed that too