AllinCalc for PT3 v0.96 (Updated 12/4)

[advis0r]

new version 0.96:
- ignore hands where we dont know every holecard
- updated postgresl jdbc driver

download:
http://depositfiles.com/files/24wixa5lb

current SQL:

Code: Select all

SELECT  summary.date_played,
        sites.site_abbrev AS site,
        limits.limit_name AS limit,
        hhh.id_hand,
        hero_d.holecard_1 AS hero_hc1,
        hero_d.holecard_2 AS hero_hc2,
        hero_d.amt_before AS hero_amt_before,
        hero_d.amt_bet_ttl AS hero_amt_bet_ttl,
        villain_d.holecard_1 AS villain_hc1,
        villain_d.holecard_2 AS villain_hc2,
        villain_d.amt_before AS villain_amt_before,
        villain_d.amt_bet_ttl AS villain_amt_bet_ttl,
        (CASE
            WHEN hero_s.enum_allin = 'N' THEN villain_s.enum_allin
            ELSE hero_s.enum_allin
        END) AS allin_street,
        history,
        card_1 AS flop1,
        card_2 AS flop2,
        card_3 AS flop3,
        card_4 AS turn,
        card_5 AS river,
        (amt_pot - amt_rake) AS potsize,
        hero_s.flg_won_hand AS hero_won,
        villain_s.flg_won_hand AS villain_won
 FROM   player p,
        holdem_hand_player_detail hero_d,
        holdem_hand_player_detail villain_d,
        holdem_hand_player_statistics hero_s,
        holdem_hand_player_statistics villain_s,
        holdem_hand_summary summary,
        holdem_limit limits,
        lookup_sites sites,
        holdem_hand_histories hhh
 WHERE  p.player_name = 'advis0r'
        AND hero_d.id_player = p.id_player
        AND hero_s.id_player = p.id_player
        AND villain_d.id_player != p.id_player
        AND villain_s.id_player != p.id_player
        AND summary.id_site != 0
        AND hhh.id_hand = hero_d.id_hand
        AND hhh.id_hand = hero_s.id_hand
        AND hhh.id_hand = villain_d.id_hand
        AND hhh.id_hand = villain_s.id_hand
        AND hhh.id_hand = summary.id_hand
        AND summary.id_limit = limits.id_limit
        AND summary.id_site = sites.id_site
        AND hero_s.flg_showdown = true
        AND villain_s.flg_showdown = true
        AND limits.flg_nlpl = true
        AND hero_d.holecard_1 != 0
        AND hero_d.holecard_2 != 0
        AND villain_d.holecard_1 != 0
        AND villain_d.holecard_2 != 0
        AND ((hero_d.amt_bet_p + hero_d.amt_bet_f + hero_d.amt_bet_t >= villain_d.amt_before)
             OR (villain_d.amt_bet_p + villain_d.amt_bet_f + villain_d.amt_bet_t >= hero_d.amt_before))
        AND ((SELECT COUNT(1)
              FROM   holdem_hand_player_statistics foo
              WHERE  foo.id_hand = hhh.id_hand
                     AND foo.flg_showdown) = 2)
        AND summary.date_played >= '2002-01-01'
ORDER BY summary.date_played

[kraada]

I just updated the first post for you, advis0r so that people will know there's a new version out

[advis0r]

thanks mate

[anyhero]

Awesome work, thanks for the app. For those looking for an EV calculator for SNGs, there's one called Juk's All In Luck. Search google for it, it uses ICM, so it gives an accurate model of your $EV.

Please more lines on the graph advis0r!

[advis0r]

Please more lines on the graph advis0r!

what lines do you want that make sense?
if i use expected money vs actual money won, you almost cant see the difference anymore

[alonalbert]

Please more lines on the graph advis0r!

what lines do you want that make sense?
if i use expected money vs actual money won, you almost cant see the difference anymore

I think that your expected & actual values do not take into account the total amount bet by hero. So the winning graph always goes up.

Say you were 80% EV in a $100 pot, your expected would be $100 and your actual would be $0 but in fact, you want to graph expected $50 and actual -$50 since you lost $50 on that hand. Assuming no rake.

This will make the expected & actual lines more reasonable compared to the difference.

[Ricardo]

80% EV in a $100 pot, your expected would be $100

?? don't mean to butt in but this doesn't add up to me ..for example an 80% win chance in $100 pot yields EV of $60.

[alonalbert]

80% EV in a $100 pot, your expected would be $100

?? don't mean to butt in but this doesn't add up to me ..for example an 80% win chance in $100 pot yields EV of $60.

Yeah sorry, my mistake, and it's $80, not $60. Here's the proper numbers:

So currently, AllinCalc would report for that hand if you lost:
Expected: $80 Actual: $0


When it should be reporting:
Expected: $30 Actual: -$50

This way, the graph goes down when you loose hands. The other way, it only goes up resulting in very large numbers that result in the different graph becoming very close to zero.

[anyhero]

Well, maybe a more informative graph would be one like this http://i238.photobucket.com/albums/ff31/kusimies/NL100_graph2.jpg

Thanks.

[advis0r]

sorry i dont get what you mean in your numbers example