Very basic software request

[mmbt0ne]

I'm playing a decent bit of HORSE and HOSE lately on stars, and would like to keep track of a couple things. I don't want to use the 3 different PTs because I'd like to keep the data together, and I don't really need all of that information.

All I really want is something that will parse the HHs and keep a running total of the money I've made/lost at each of the 5 games. It doesn't even need to keep stuff in a database to be honest. I'd be happy if it would just spit out the overall numbers from a file and I could then put the numbers into an excel spreadsheet.

I have some programming experience, so even if you don't want to do this, if you could point me towards the best ways to accomplish this, I'd be willing to put in some time trying to figure it out.

Thanks.

[ben_]

Want to post a hand history with all 5 games?
I'm bored and it could be fun.

[SamIAm]

What happens if you have all the different PTs running? Can they read the hand-history together like that?

I think this might have an SQL solution, if you have databases collecting the individual games.
-Sam

[mmbt0ne]

[ QUOTE ]
What happens if you have all the different PTs running? Can they read the hand-history together like that?

I think this might have an SQL solution, if you have databases collecting the individual games.
-Sam

[/ QUOTE ]

PS actually makes 5 different HH files, and adds to each depending on the game type.



Here's an example from each game type:

Hold'em
PokerStars Game #5949907919: HORSE (Hold'em Limit, $1/$2) - 2006/08/17 - 11:26:33 (ET)
Table 'Gienah II' 8-max Seat #3 is the button
Seat 1: idareyouAA ($62.50 in chips)
Seat 2: c.a.r. ($14.70 in chips)
Seat 3: Kingsfield ($38.85 in chips)
Seat 4: GT0ne ($98.90 in chips)
Seat 6: Lucadk ($99.40 in chips)
Seat 8: hawkville ($63.85 in chips)
GT0ne: posts small blind $0.50
IndyJoe: is sitting out
IndyJoe leaves the table
Lucadk: posts big blind $1
Tuco: sits out
*** HOLE CARDS ***
Dealt to GT0ne [Qh 3c]
hawkville: raises $1 to $2
idareyouAA: folds
c.a.r.: calls $2
Kingsfield: folds
GT0ne: folds
Lucadk: folds
*** FLOP *** [Ks 7c Kh]
hawkville: checks
c.a.r.: bets $1
hawkville: calls $1
*** TURN *** [Ks 7c Kh] [8s]
hawkville: checks
c.a.r.: bets $2
hawkville: calls $2
*** RIVER *** [Ks 7c Kh 8s] [3h]
hawkville: checks
c.a.r.: checks
*** SHOW DOWN ***
hawkville: shows [9s As] (a pair of Kings)
c.a.r.: shows [Td 7d] (two pair, Kings and Sevens)
c.a.r. collected $11 from pot
*** SUMMARY ***
Total pot $11.50 | Rake $0.50
Board [Ks 7c Kh 8s 3h]
Seat 1: idareyouAA folded before Flop (didn't bet)
Seat 2: c.a.r. showed [Td 7d] and won ($11) with two pair, Kings and Sevens
Seat 3: Kingsfield (button) folded before Flop (didn't bet)
Seat 4: GT0ne (small blind) folded before Flop
Seat 6: Lucadk (big blind) folded before Flop
Seat 8: hawkville showed [9s As] and lost with a pair of Kings

O8
PokerStars Game #5949935325: HORSE (Omaha Hi/Lo Limit, $1/$2) - 2006/08/17 - 11:30:55 (ET)
Table 'Gienah II' 8-max Seat #2 is the button
Seat 1: idareyouAA ($61 in chips)
Seat 2: c.a.r. ($14.70 in chips)
Seat 3: Kingsfield ($46.60 in chips)
Seat 4: GT0ne ($92.40 in chips)
Seat 5: The Majestic ($46.25 in chips)
Seat 6: Lucadk ($103.15 in chips)
Seat 7: Tuco ($114 in chips)
Seat 8: hawkville ($54.35 in chips)
Kingsfield: posts small blind $0.50
GT0ne: posts big blind $1
*** HOLE CARDS ***
Dealt to GT0ne [7h 4d 6h 7s]
The Majestic: calls $1
Lucadk: folds
Tuco: folds
hawkville: calls $1
idareyouAA: folds
c.a.r.: folds
Kingsfield: folds
GT0ne: checks
*** FLOP *** [Jh Ah 2d]
GT0ne: checks
The Majestic: bets $1
hawkville: calls $1
GT0ne: folds
*** TURN *** [Jh Ah 2d] [8h]
The Majestic: bets $2
hawkville: calls $2
*** RIVER *** [Jh Ah 2d 8h] [Qc]
The Majestic: bets $2
hawkville: calls $2
*** SHOW DOWN ***
The Majestic: shows [Td 3c Qs Ad] (HI: two pair, Aces and Queens)
hawkville: mucks hand
The Majestic collected $13 from pot
No low hand qualified
*** SUMMARY ***
Total pot $13.50 | Rake $0.50
Board [Jh Ah 2d 8h Qc]
Seat 1: idareyouAA folded before Flop (didn't bet)
Seat 2: c.a.r. (button) folded before Flop (didn't bet)
Seat 3: Kingsfield (small blind) folded before Flop
Seat 4: GT0ne (big blind) folded on the Flop
Seat 5: The Majestic showed [Td 3c Qs Ad] and won ($13) with HI: two pair, Aces and Queens
Seat 6: Lucadk folded before Flop (didn't bet)
Seat 7: Tuco folded before Flop (didn't bet)
Seat 8: hawkville mucked [Jc 3d Qh 2s]

Razz
PokerStars Game #5950013442: HORSE (Razz Limit, $1/$2) - 2006/08/17 - 11:43:11 (ET)
Table 'Gienah II' 8-max
Seat 1: idareyouAA ($72.25 in chips)
Seat 2: c.a.r. ($48.45 in chips)
Seat 3: Kingsfield ($40.85 in chips)
Seat 4: GT0ne ($93.90 in chips)
Seat 5: The Majestic ($23.25 in chips)
Seat 6: Lucadk ($100.15 in chips)
Seat 7: Tuco ($121.95 in chips)
Seat 8: hawkville ($24.40 in chips)
GT0ne: posts the ante $0.10
The Majestic: posts the ante $0.10
Lucadk: posts the ante $0.10
Tuco: posts the ante $0.10
hawkville: posts the ante $0.10
idareyouAA: posts the ante $0.10
c.a.r.: posts the ante $0.10
Kingsfield: posts the ante $0.10
*** 3rd STREET ***
Dealt to idareyouAA [5c]
Dealt to c.a.r. [7s]
Dealt to Kingsfield [8d]
Dealt to GT0ne [3h 5s 4c]
Dealt to The Majestic [Qh]
Dealt to Lucadk [Ts]
Dealt to Tuco [Kc]
Dealt to hawkville [6d]
Tuco: brings-in low $0.50
hawkville: calls $0.50
idareyouAA: raises $0.50 to $1
c.a.r.: folds
Kingsfield: folds
GT0ne: calls $1
The Majestic: calls $1
Lucadk: folds
Tuco: folds
hawkville: calls $0.50
*** 4th STREET ***
Dealt to idareyouAA [5c] [Jh]
Dealt to GT0ne [3h 5s 4c] [9c]
Dealt to The Majestic [Qh] [Jd]
Dealt to hawkville [6d] [As]
hawkville: checks
idareyouAA: checks
GT0ne: bets $1
The Majestic: folds
The Majestic leaves the table
hawkville: calls $1
idareyouAA: calls $1
*** 5th STREET ***
Dealt to idareyouAA [5c Jh] [3c]
Dealt to GT0ne [3h 5s 4c 9c] [8c]
Dealt to hawkville [6d As] [Ad]
GT0ne: bets $2
hawkville: folds
idareyouAA: calls $2
*** 6th STREET ***
Dealt to idareyouAA [5c Jh 3c] [Qc]
Dealt to GT0ne [3h 5s 4c 9c 8c] [4d]
idareyouAA: checks
GT0ne: bets $2
idareyouAA: calls $2
*** RIVER ***
Dealt to GT0ne [3h 5s 4c 9c 8c 4d] [9s]
idareyouAA: checks
GT0ne: checks
*** SHOW DOWN ***
GT0ne: shows [3h 5s 4c 9c 8c 4d 9s] (Lo: 9,8,5,4,3)
idareyouAA: mucks hand
GT0ne collected $15.55 from pot
*** SUMMARY ***
Total pot $16.30 | Rake $0.75
Seat 1: idareyouAA mucked [4s 2h 5c Jh 3c Qc 5d]
Seat 2: c.a.r. folded on the 3rd Street (didn't bet)
Seat 3: Kingsfield folded on the 3rd Street (didn't bet)
Seat 4: GT0ne showed [3h 5s 4c 9c 8c 4d 9s] and won ($15.55) with Lo: 9,8,5,4,3
Seat 5: The Majestic folded on the 4th Street
Seat 6: Lucadk folded on the 3rd Street (didn't bet)
Seat 7: Tuco folded on the 3rd Street
Seat 8: hawkville folded on the 5th Street

Stud Hi/Lo
PokerStars Game #5949856123: HORSE (7 Card Stud Hi/Lo Limit, $1/$2) - 2006/08/17 - 11:18:13 (ET)
Table 'Gienah II' 8-max
Seat 1: idareyouAA ($63.90 in chips)
Seat 3: Kingsfield ($41.75 in chips)
Seat 4: GT0ne ($108.45 in chips)
Seat 5: IndyJoe ($10.20 in chips)
Seat 6: rtaet ($25.80 in chips)
Seat 7: Tuco ($121.30 in chips)
Seat 8: hawkville ($64.10 in chips)
rtaet: posts the ante $0.10
Tuco: posts the ante $0.10
hawkville: posts the ante $0.10
idareyouAA: posts the ante $0.10
Kingsfield: posts the ante $0.10
GT0ne: posts the ante $0.10
IndyJoe: posts the ante $0.10
*** 3rd STREET ***
Dealt to idareyouAA [Jc]
Dealt to Kingsfield [5h]
Dealt to GT0ne [3s 4s 2s]
Dealt to IndyJoe [Tc]
Dealt to rtaet [Jd]
Dealt to Tuco [Ad]
Dealt to hawkville [8s]
GT0ne: bets $1
IndyJoe: calls $1
rtaet: folds
rtaet is sitting out
Tuco: folds
hawkville: folds
rtaet leaves the table
idareyouAA: folds
Kingsfield: folds
*** 4th STREET ***
Dealt to GT0ne [3s 4s 2s] [7h]
Dealt to IndyJoe [Tc] [8c]
IndyJoe: checks
GT0ne: bets $1
IndyJoe: calls $1
*** 5th STREET ***
Dealt to GT0ne [3s 4s 2s 7h] [Th]
Dealt to IndyJoe [Tc 8c] [6s]
IndyJoe: checks
GT0ne: bets $2
IndyJoe: raises $2 to $4
GT0ne: calls $2
*** 6th STREET ***
Dealt to GT0ne [3s 4s 2s 7h Th] [9c]
Dealt to IndyJoe [Tc 8c 6s] [Qs]
c.a.r. has returned
IndyJoe: bets $2
GT0ne: calls $2
*** RIVER ***
Dealt to GT0ne [3s 4s 2s 7h Th 9c] [7s]
IndyJoe: bets $2
GT0ne: folds
IndyJoe collected $15.95 from pot
*** SUMMARY ***
Total pot $16.70 | Rake $0.75
Seat 1: idareyouAA folded on the 3rd Street (didn't bet)
Seat 3: Kingsfield folded on the 3rd Street (didn't bet)
Seat 4: GT0ne folded on the River
Seat 5: IndyJoe collected ($15.95)
Seat 6: rtaet folded on the 3rd Street (didn't bet)
Seat 7: Tuco folded on the 3rd Street (didn't bet)
Seat 8: hawkville folded on the 3rd Street (didn't bet)

Stud Hi
PokerStars Game #5949829090: HORSE (7 Card Stud Limit, $1/$2) - 2006/08/17 - 11:13:50 (ET)
Table 'Gienah II' 8-max
Seat 1: idareyouAA ($69.30 in chips)
Seat 3: Kingsfield ($44.15 in chips)
Seat 4: GT0ne ($97.20 in chips)
Seat 5: IndyJoe ($11.10 in chips)
Seat 6: rtaet ($31.50 in chips)
Seat 7: Tuco ($110 in chips)
Seat 8: hawkville ($74 in chips)
rtaet: posts the ante $0.10
Tuco: posts the ante $0.10
hawkville: posts the ante $0.10
idareyouAA: posts the ante $0.10
Kingsfield: posts the ante $0.10
GT0ne: posts the ante $0.10
IndyJoe: posts the ante $0.10
*** 3rd STREET ***
Dealt to idareyouAA [9d]
Dealt to Kingsfield [3d]
Dealt to GT0ne [8s 5s 6s]
Dealt to IndyJoe [7c]
Dealt to rtaet [Td]
Dealt to Tuco [Qs]
Dealt to hawkville [7s]
Kingsfield: brings-in low $0.50
GT0ne: calls $0.50
IndyJoe: folds
rtaet: raises $0.50 to $1
Tuco has timed out
Tuco: folds
Tuco is sitting out
hawkville: folds
idareyouAA: calls $1
Kingsfield: calls $0.50
GT0ne: calls $0.50
*** 4th STREET ***
Dealt to idareyouAA [9d] [2c]
Dealt to Kingsfield [3d] [2d]
Dealt to GT0ne [8s 5s 6s] [6c]
Dealt to rtaet [Td] [Ac]
Pair on board - a double bet is allowed
GT0ne: checks
Tuco has returned
rtaet: bets $1
idareyouAA: folds
Kingsfield: folds
GT0ne: calls $1
*** 5th STREET ***
Dealt to GT0ne [8s 5s 6s 6c] [6d]
Dealt to rtaet [Td Ac] [9c]
GT0ne: checks
rtaet: bets $2
GT0ne: raises $2 to $4
rtaet: folds
GT0ne collected $10.20 from pot
idareyouAA said, "looooool"
GT0ne: doesn't show hand
*** SUMMARY ***
Total pot $10.70 | Rake $0.50
Seat 1: idareyouAA folded on the 4th Street
Seat 3: Kingsfield folded on the 4th Street
Seat 4: GT0ne collected ($10.20)
Seat 5: IndyJoe folded on the 3rd Street (didn't bet)
Seat 6: rtaet folded on the 5th Street
Seat 7: Tuco folded on the 3rd Street (didn't bet)
Seat 8: hawkville folded on the 3rd Street (didn't bet)


Really I just want to be able to throw these in an excel sheet, track overall session wins/losses, and have a running total of number of hands/winnings/etc. The specific hands and statistics and whatnot don't matter to me at all.

[ben_]

Hi,
I played a session of this on stars last night for a laugh.
I'm going away for the weekend, but will try and put together a quick program to spit out win/lose per game for you when i get back on monday.

Cheers,
ben

[stigmata]

Personally I would like something that did this the other way round: E.g. parsed your PT databases and gave a nice pretty output of your HORSE results.

[mmbt0ne]

[ QUOTE ]
Personally I would like something that did this the other way round: E.g. parsed your PT databases and gave a nice pretty output of your HORSE results.

[/ QUOTE ]

This would be nice too as soon as PTS recognizes the razz hands at all, and can do the other hands without splitting sessions. It would make it easy to import the results into an excel database, not unlike the sng spreadsheet that's floating around.