Betting Volume

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny

Betting Volume

Postby js2002 » Thu Oct 16, 2014 10:35 am

Hi,

I tried to make the HEM2 stat "Betting Volume" which is defined like this:
betting volume
Quoted from the article:
It’s measuring the total size of my opponents bets against me versus what I expect from the number of hands we played together.

The ratio looks like this:
(Total_amount won+ ABS(Tot_amountlost))/(times_beat+times_been_beat)
For example:
You play 100 hands where you win or lose money. In 50 hands you win total of $1000, and in the other 50 hands you lose total of $1000, finishing at $0.

Betting volume would show you:
( $1000 (Tot Amt Won) + $1000 (Absolute value of amount lost)) / (50+50 (winning hands + losing hands))=
($1000 + $1000) / (50+50) = $2000/100 = $20


So I made:
sum(if[TRUE, cash_hand_summary.amt_pot, 0]) and devided tru cnt_hands. Do u think this i correct?
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Betting Volume

Postby kraada » Thu Oct 16, 2014 11:04 am

That does assume you're in every pot which would be fine for heads up but for multiway play would probably give you numbers you don't want.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Betting Volume

Postby js2002 » Thu Oct 16, 2014 11:36 am

args thought that
hand# > 0 or what is the correct filter then?
went postflop wont be good
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Betting Volume

Postby js2002 » Thu Oct 16, 2014 11:43 am

I switched it to sum amount pots when vpip / cnt_vpip but thats not 100% correct.

It misses the spots were in BB and freeplayed

and thsi also sums pots when we fold flop
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Betting Volume

Postby js2002 » Thu Oct 16, 2014 12:10 pm

Rethought it:

Betting Volume
js2002_amt_pot / cnt_hands
numerator:
sum(if[TRUE, cash_hand_player_statistics.amt_bet_ttl, 0])

Betting Volume in BB
js2002_amt_pot_in_bb / cnt_hands
numerator:
sum(if[TRUE, (cash_hand_player_statistics.amt_bet_ttl/cash_limit.amt_bb), 0])

Gets me valuee between 1.7-2.3 bigblinds as semi-TAG
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Betting Volume

Postby kraada » Thu Oct 16, 2014 2:27 pm

You can do:
sum(if[TRUE, cash_hand_player_statistics.amt_bet_ttl, 0])
as
sum(cash_hand_player_statistics.amt_bet_ttl)

which is a bit cleaner.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Betting Volume

Postby js2002 » Thu Oct 16, 2014 2:53 pm

I switched to /vpip again because /ttl doesnt count bets that did not get called.
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Betting Volume

Postby js2002 » Fri Oct 17, 2014 8:23 am

now after advice from fozzy (tu)
its the sum of all bet_ttl / hands where ttl > 0

I have values from 5bb to 2bb in my DB.
js2002
 
Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron
highfalutin