SharpStats Personal Tracker for Cake, Merge, Stars, and FTP
09-23-2008
, 03:57 PM
Before I go into the main announcement, I would like to say one thing: This is not PT for Cake. The program is completely incapable of tracking any statistics for any player besides "hero". As an extra precaution, it will not import "same-day" hands, so there will be no way for a useful HUD to be used with this program.
This is only a tool for tracking personal statistics.
With that out of the way, I would like to introduce CPST.
As you can see from the SS, you will eventually be able to view your stats by several different groupings. Currently, only by Blind Level for cash games and by M-Zone for tourneys is available, but the others should be implemented soon.
Requirements:
-Microsoft .NET Framework 2.0 or above
-Microsoft SQLServer 2005 Available for free here
To install, simply Download and run.
Initial Setup:
Go into Configuration-->Initial Setup
Choose your Source and Destination directories (CPST does not change any of the files, so your HHs are safe)
Input the SQLServer info
Click "Test Connection" to verify that all of your database information is correct
Click "Create Databases" to set up the Cake db in SQLServer
Exit out of the configuration screen and click the "Import Hands" button to start importing your hand histories
Importing hands will take a little while (my 45k-hand test batch took around 1 minute to import). After the program has imported all available files, a screen with the number of hands processed will come up.
After that, just adjust the time range at the bottom of the screen then click on the tab you wish to view (NOTE--you might need to move out and then back into a tab for the stats to update). You can sort by any column and even re-order the columns as you see fit.
If you click on a Blind Level (or M-Zone under the M-Zone tab) a list of Hand Histories will come up in the top-right table. If you double-click a Hand Number, the full hand history will pop-up.
Future plans:
Finish tab views
Add a report generator
Please post any comments, suggestions or bug reports here. Please keep in mind that I do not own PT, HeM, or any other tracking software so comments like "do it more like <insert tracker here>" will be ignored.
That's it. I look forward to hearing any suggestions you guys may have.
-red
This is only a tool for tracking personal statistics.
With that out of the way, I would like to introduce CPST.
As you can see from the SS, you will eventually be able to view your stats by several different groupings. Currently, only by Blind Level for cash games and by M-Zone for tourneys is available, but the others should be implemented soon.
Requirements:
-Microsoft .NET Framework 2.0 or above
-Microsoft SQLServer 2005 Available for free here
To install, simply Download and run.
Initial Setup:
Go into Configuration-->Initial Setup
Choose your Source and Destination directories (CPST does not change any of the files, so your HHs are safe)
Input the SQLServer info
Click "Test Connection" to verify that all of your database information is correct
Click "Create Databases" to set up the Cake db in SQLServer
Exit out of the configuration screen and click the "Import Hands" button to start importing your hand histories
Importing hands will take a little while (my 45k-hand test batch took around 1 minute to import). After the program has imported all available files, a screen with the number of hands processed will come up.
After that, just adjust the time range at the bottom of the screen then click on the tab you wish to view (NOTE--you might need to move out and then back into a tab for the stats to update). You can sort by any column and even re-order the columns as you see fit.
If you click on a Blind Level (or M-Zone under the M-Zone tab) a list of Hand Histories will come up in the top-right table. If you double-click a Hand Number, the full hand history will pop-up.
Future plans:
Finish tab views
Add a report generator
Please post any comments, suggestions or bug reports here. Please keep in mind that I do not own PT, HeM, or any other tracking software so comments like "do it more like <insert tracker here>" will be ignored.
That's it. I look forward to hearing any suggestions you guys may have.
-red
Last edited by jukofyork; 07-21-2009 at 07:40 PM.
Reason: Changed title at OP's request.
09-26-2008
, 08:39 AM
Well this is getting quite the overwhelming response
Not sure if this is the problem, but I am currently working on a PostgreSQL version of the program. I just need to get a few more tables up and running in the UI and it will be caught up with the SQLServer version.
BTW, is there anything else that you guys would like to see?
-red
Not sure if this is the problem, but I am currently working on a PostgreSQL version of the program. I just need to get a few more tables up and running in the UI and it will be caught up with the SQLServer version.
BTW, is there anything else that you guys would like to see?
-red
10-16-2008
, 02:43 PM
Well, you asked for it and here it is. CPST PostgreSQL version is now available here.
All tabs are now complete and I've greatly decreased the search time. Unfortunately, import times have increased by quite a bit. It now takes my dual-core 1.8GHz laptop about 12 minutes to import 48K hands.
Here are a few screenshots:
Main Screen:
Database Setup:
Directory Setup:
Updates in this version:
--Works with PostgreSQL only. The database should not interfere with your HM or PT database.
--All tabs complete
--Some stats were changed so they more-closely correlate with PT's definition (i.e. WTSD is now [# of hands that you took to showdown]/[# of hands where you saw the flop] instead of [# of hands that you took to showdown]/[total # of hands])
--Customizable queries. All of the queries are located in the .que files which you can open with Notepad and edit.
--6-max and full ring stats have been separated. I don't have any HHs from heads-up tables to use for testing so they are currently mixed with the full ring stats. If anyone can supply a few HU HHs, I can probably get the HU stats separated as well. Scrubbed HHs would work fine.
Installation:
Just unzip and run.
Setup:
Go to Configuration-->Database.
Input your password (change the server, port, and UID fields if necessary)
Click "Test Connection" to verify that the information is correct.
Click "Initialize Database" to build the database and its tables.
Save and Exit
Go to Configuration-->Folders.
Use the controls to set the HH and Work directories
Save and Exit
Go to File-->Import Now
Once the import process is complete, you can change the date filters and view your stats any way you want.
Notes:
The file where your database password is stored is not encrypted. If you are concerned about security, delete the CPSTdb.ini file after each use. You'll have to enter your database settings each time if you do this. I am working to find a way to encrypt this file for future versions.
There are backup copies of the queries in the backup folder in case you have an editting experience go bad. I recommend not changing these backup copies--copy them into the main folder and then edit them from there.
That's it. I would really appreciate any feedback you guys can give me. In particular, I need to hear from anyone that is having problems with the import process.
Thanks and enjoy,
-red
All tabs are now complete and I've greatly decreased the search time. Unfortunately, import times have increased by quite a bit. It now takes my dual-core 1.8GHz laptop about 12 minutes to import 48K hands.
Here are a few screenshots:
Main Screen:
Database Setup:
Directory Setup:
Updates in this version:
--Works with PostgreSQL only. The database should not interfere with your HM or PT database.
--All tabs complete
--Some stats were changed so they more-closely correlate with PT's definition (i.e. WTSD is now [# of hands that you took to showdown]/[# of hands where you saw the flop] instead of [# of hands that you took to showdown]/[total # of hands])
--Customizable queries. All of the queries are located in the .que files which you can open with Notepad and edit.
--6-max and full ring stats have been separated. I don't have any HHs from heads-up tables to use for testing so they are currently mixed with the full ring stats. If anyone can supply a few HU HHs, I can probably get the HU stats separated as well. Scrubbed HHs would work fine.
Installation:
Just unzip and run.
Setup:
Go to Configuration-->Database.
Input your password (change the server, port, and UID fields if necessary)
Click "Test Connection" to verify that the information is correct.
Click "Initialize Database" to build the database and its tables.
Save and Exit
Go to Configuration-->Folders.
Use the controls to set the HH and Work directories
Save and Exit
Go to File-->Import Now
Once the import process is complete, you can change the date filters and view your stats any way you want.
Notes:
The file where your database password is stored is not encrypted. If you are concerned about security, delete the CPSTdb.ini file after each use. You'll have to enter your database settings each time if you do this. I am working to find a way to encrypt this file for future versions.
There are backup copies of the queries in the backup folder in case you have an editting experience go bad. I recommend not changing these backup copies--copy them into the main folder and then edit them from there.
That's it. I would really appreciate any feedback you guys can give me. In particular, I need to hear from anyone that is having problems with the import process.
Thanks and enjoy,
-red
11-03-2008
, 03:30 PM
Version 0.3 of the PostgreSQL version is now available here
Updates for this version include:
Unfortunately, the AI stat bugfix and the added AI stat requires a reset and re-import. Judging by the lack of feedback, I'm assuming that this won't affect many people, though.
This will probably be the last update for a while. I have to get back to working on my game a little bit.
Let me know if there are any questions/comments/suggestions/problems/etc.
-red
Updates for this version include:
- Bug fix for Omaha Hi/Lo Files
- Bug fix for a currently unused AI stat
- New AI stat created
- Database settings .ini file is now encrypted
- Error Log viewer
- Pre-Flop All-In Generator -- this creates a file that includes all of the hands that you've shoved pf or you've called a pf shove and you've seen the flop. I hope to use this tool for an All In EV calculator in the future.
- A few internal programming improvements.
Unfortunately, the AI stat bugfix and the added AI stat requires a reset and re-import. Judging by the lack of feedback, I'm assuming that this won't affect many people, though.
This will probably be the last update for a while. I have to get back to working on my game a little bit.
Let me know if there are any questions/comments/suggestions/problems/etc.
-red
11-08-2008
, 01:47 PM
11-08-2008
, 02:16 PM
Speaking of which, there is a new version (0.4) available here.
Updates:
- Ante Bug Fix
- Improved error-checking
- Added some small visual improvements
- Removed the same-day import restriction
- Added a check to make sure that a Cake's software is not running. CPST will refuse to load or it will shut itself down if it detects that the poker client is running
- Added Tournament Profit Tracker (see below)
Tournament Profit Tracker is a simple program to record your tournament and SnG wins/losses.
Just submit the tourney details and it automatically keeps track of your profit and ROI. Since it is part of CPST, you won't be able to input new tournies while playing. However, if there is any interest, I can create a separate data-entry-only program pretty quickly. The TPT database is separate from the main CPST, so you won't need to worry about losing your tourney data if the main CPST database needs to be reset.
I have also started testing on Vista and I've found that you might need to give the software admin rights to get it to work correctly. Sorry that I didn't catch this before, but most of my testing has been on Win2K.
Also, another problem that might occur is a crash when refreshing the Hold'Em BB tables. This has only come up when the total profit has netted out to zero (it's a rounding issue with PostgreSQL). Quick fix is to replace the text in the BBGen.que file with the following
Code:
--Query for general cash game stats
--{0} = filter start date
--{1} = filter end date
--{2} = filter game type (H for holdem, O for Omaha)
(SELECT hand_bb::text::money::text AS "Blind Level",
"type" AS "6M or FR",
count(hand_id) as "# of Hands",
sum(net_win::numeric(9,2))::text::money::text as "Net Win/Loss",
to_char((((sum(net_win)/(hand_bb*2))/(count(hand_id)::real))*100),'9990D99') as "PTBB/100"
FROM hand_master
WHERE hand_date>='{0}' AND hand_date<='{1}' AND game='{2}'
GROUP BY hand_bb, "type"
ORDER BY hand_bb, "type")
UNION
(SELECT 'TOTAL', ' ', count(hand_id), sum(net_win::numeric(9,2))::text::money::text, ' '
FROM hand_master
WHERE hand_date>='{0}' AND hand_date<='{1}' AND game='{2}')
Thanks,
-red
11-14-2008
, 10:48 AM
Version 6 (final alpha) is available here.
New Additions:
Here's a quick screenshot of the Profit Graph:
This is the last feature that I really wanted to implement. Therefore, I will not be adding any new features unless they are specifically requested (or I happen to stumble upon something while I'm using it).
As always, let me know if anyone has any questions, comments, suggestions, or complaints.
-red
New Additions:
- Separate program for entering tournament information into Tournament Profit Tracker
- Net Profit Graph
Here's a quick screenshot of the Profit Graph:
This is the last feature that I really wanted to implement. Therefore, I will not be adding any new features unless they are specifically requested (or I happen to stumble upon something while I'm using it).
As always, let me know if anyone has any questions, comments, suggestions, or complaints.
-red
11-26-2008
, 09:54 AM
Looks like it's not finding Npgsql, so you'll need to run PostgreSQL's Stack Builder. Go to Start-->All Programs-->PostgreSQL 8.x-->Application Stack Builder. On the first screen, choose your database server from the drop-down list. The next screen should look like this:
Click the check box next to Npgsql, click "Next", and follow the instructions.
Let me know if this doesn't fix the problem.
-red
Click the check box next to Npgsql, click "Next", and follow the instructions.
Let me know if this doesn't fix the problem.
-red