Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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 (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
by 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
by 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
by 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
by 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
by 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
by 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
by 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
by 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.
-
BillGatesIII
-
- Posts: 740
- Joined: Fri Dec 16, 2011 6:50 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 25 guests