starting stack for tournament

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

starting stack for tournament

Postby WaitWaitW » Mon Sep 11, 2017 8:43 am

Hi !
I would like to know if it is possible to make a stat "starting stack" and use it. For example, for the "chips won / ev chips won graph", I would like to have it in staring stacks (some tournaments begins with 10k chips and blinds 10-20, some other are 20k chips and blinds 20-40... It actually is exactly the same but the "chips graph" will give 2x much more importance on the 20k stack)... a graph with chips/starting would give a more accurate result
WaitWaitW
 
Posts: 79
Joined: Fri Aug 03, 2012 4:21 am

Re: starting stack for tournament

Postby BillGatesIII » Mon Sep 11, 2017 5:06 pm

    This column will return hero's stack at the first hand of a tourney.

    Code: Select all
    select distinct first_value(thps.amt_before) over (partition by thps.id_tourney order by thps.date_played)
    from tourney_hand_player_statistics as thps
    join tourney_summary as ts on ts.id_tourney = thps.id_tourney
    where thps.flg_hero
    and ts.tourney_no = tourney_summary.tourney_no

    It can be used in a report if 'Tournament #' is also added.

    Tournament starting stack.png
    Tournament starting stack.png (4.95 KiB) Viewed 2951 times

    I don't understand the graph part of your question.
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm

    Re: starting stack for tournament

    Postby WaitWaitW » Mon Sep 11, 2017 6:49 pm

    I would like to have the equivalent of the graph "winnig in : Chips", but winning "x starting stacks"
    WaitWaitW
     
    Posts: 79
    Joined: Fri Aug 03, 2012 4:21 am

    Re: starting stack for tournament

    Postby BillGatesIII » Tue Sep 12, 2017 7:37 am

      So for example if the starting stack is 10k and you have won 25k chips, the value would be 2.5? And if you lose 10k, the value would be -1?
      BillGatesIII
       
      Posts: 740
      Joined: Fri Dec 16, 2011 6:50 pm

      Re: starting stack for tournament

      Postby WaitWaitW » Tue Sep 12, 2017 12:48 pm

      yes. with that type of graph, I look if in MTT if I'm serious in early game (good evbb/100) but gamble too much in late game (bad chipsEV); if I gambled with 100k at a 3k starting stack, it's horrible, if I gambled 100k at a 50k starting stack, it's less important. so in those cases a 33.3 stack ggamble or a 2 stack gamble would give a better accuracy :)
      WaitWaitW
       
      Posts: 79
      Joined: Fri Aug 03, 2012 4:21 am

      Re: starting stack for tournament

      Postby WaitWaitW » Sat Sep 16, 2017 5:14 am

      up !
      You think it's possible to make a graph like this BillGatesIII? Or you think it's useless? :?
      WaitWaitW
       
      Posts: 79
      Joined: Fri Aug 03, 2012 4:21 am

      Re: starting stack for tournament

      Postby BillGatesIII » Mon Sep 18, 2017 11:16 am

        I guess it should be possible, will take some time to think it over. In my opinion it is not very useful, you better look at how you play with your stack calculated in (adjusted) big blinds. But that doesn't mean it is useless :)
        BillGatesIII
         
        Posts: 740
        Joined: Fri Dec 16, 2011 6:50 pm

        Re: starting stack for tournament

        Postby BillGatesIII » Sat Sep 23, 2017 8:43 am

          I can't get this to work in a graph.
          BillGatesIII
           
          Posts: 740
          Joined: Fri Dec 16, 2011 6:50 pm

          Re: starting stack for tournament

          Postby WaitWaitW » Sat Sep 23, 2017 9:13 am

          hmm ok...
          Thanks very much for the help btw !
          WaitWaitW
           
          Posts: 79
          Joined: Fri Aug 03, 2012 4:21 am

          Re: starting stack for tournament

          Postby BillGatesIII » Sat Sep 23, 2017 12:08 pm

            No problem. I do have a Starting Stack Won stat for a Hand report if that has any use for you.

            Starting Stack (Won).png
            BillGatesIII
             
            Posts: 740
            Joined: Fri Dec 16, 2011 6:50 pm

            Next

            Return to Custom Stats, Reports and HUD Profiles

            Who is online

            Users browsing this forum: No registered users and 25 guests

            cron