Report vs Villains

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Report vs Villains

Postby Bill_Balas » Sun Oct 08, 2017 10:02 am

Hi,

would you please code, if possible, a hands Reports filter where Villains have VPIP < 30 & Stack >= 2/3 full buy-in?

Thanks
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby potamito » Sun Oct 08, 2017 10:36 am

Bill_Balas wrote: Stack >= 2/3 full buy-in?

What you mean by this?
potamito
 
Posts: 802
Joined: Wed Apr 21, 2010 4:20 pm

Re: Report vs Villains

Postby Bill_Balas » Sun Oct 08, 2017 2:18 pm

A Stack of at least 2/3 of the stakes buy-in (usually 100 BBs).

Thanks
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby Bill_Balas » Sun Oct 08, 2017 2:19 pm

---So at least 63 BBs.
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby WhiteRider » Mon Oct 09, 2017 4:09 am

Do you mean all villains, or one villain in the hand meets that criteria?
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Report vs Villains

Postby Bill_Balas » Mon Oct 09, 2017 4:22 am

I mean all. I'll then select Villain's name in the "Player:" box.

Thanks
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby Bill_Balas » Mon Oct 09, 2017 4:27 am

Hero's name in the "player:" box, I mean. Just happens I'm targeting Villain vs Villain hands.

Thanks
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby WhiteRider » Tue Oct 10, 2017 4:36 am

I've been experimenting with this, but unfortunately it's beyond my query skills at the moment - hopefully one of our PostgreSQL experts will be able to help you.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Report vs Villains

Postby Bill_Balas » Tue Oct 10, 2017 7:36 am

Thanks for your effort anyway WhiteRider!
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: Report vs Villains

Postby potamito » Tue Oct 10, 2017 9:13 am

It takes a while to populate but it works for me...

Code: Select all
cash_hand_player_statistics.id_hand in (SELECT thps.id_hand from cash_hand_player_statistics thps, cash_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player HAVING ((((sum(tc.cnt_vpip) / (sum(tc.cnt_hands) - sum(tc.cnt_walks)))) BETWEEN 0.15 and 0.25))) and #Chips in BBs#>= 63
potamito
 
Posts: 802
Joined: Wed Apr 21, 2010 4:20 pm

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 23 guests

cron