Custom AFq stats, similar to hand2note

[Rikimoro]

Hi,
i am trying to create custom AFq stats, similar to hand2note.
H2N Flop AFq formula is this: '(Cases(Bet Flop) + Cases(Raise Flop)) / Cases(Call Flop)'.
So, i simply changed default pokertracker Flop AFq to '((cnt_f_bet + cnt_f_raise) / cnt_f_call)', but numbers are differing.
Can you please help me with this?

[Flag_Hippo]

You have specifically referenced 'AFq' in this thread but your formulas are for 'AF' so I am a bit confused. If you are actually looking at 'AFq' statistics then they will not give the same results as they have different definitions in each program.

[Rikimoro]

Yeah, it seems i picked a formula for AF, instead of AFq.
The correct one is 'Cases(Flop Raise or Bet)/Cases(Flop Any Action) * 100', where it is said 'Cases(Flop Any Action) means the number of hands in which the player saw the flop'.
Can you please help me to convert it to pokertracker's expression?

[Flag_Hippo]

where it is said 'Cases(Flop Any Action) means the number of hands in which the player saw the flop'.

That wouldn't be "the number of hands in which the player saw the flop". It would be the total number of actions the player took on the flop.

Can you please help me to convert it to pokertracker's expression?

PokerTracker 4 has a built-in statistic called 'Flop AFq' - this does not include checks in the calculation. If you want checks included then there is an 'AFq including Checks' custom statistic package available in the Download Warehouse.

[Rikimoro]

Yeah, i already downloaded AFq including Checks, unfortunately, numbers don't match..
This one: '((cnt_f_bet + cnt_f_raise) / (cnt_f_check + cnt_f_call + cnt_f_fold + cnt_f_bet + cnt_f_raise)) * 100'
For example, H2N3 has AFq for a player on streets 30/35/28, PTR4 - 24/30/24

[Flag_Hippo]

I am not aware of an issue with that in PokerTracker 4. For example here is a small sample of hands for a player:

flop_actions.PNG

(17.62 KiB) Downloaded 6247 times

Flop AFq (including checks) on that sample would be:

(6 / 16) * 100 = 37.5%

Here are the results in PokerTracker 4 and Hand2Note for that sample of hands:

afq.PNG

(19.7 KiB) Downloaded 6197 times

[Rikimoro]

Thanks for the example! It seems that H2N formula doesn't use addition of actions, but takes just any action.
In your example, we take just any one aggressive action on flop (bet or raise - 4 times) and amount of times a player saw flop (12 times) = (4/12)*100 == 33%.
So, the PTR expression would be like '((counting any bet or raise on flop from the player)/cnt_f_saw)*100', right?

[Rikimoro]

+we need to exclude all-ins on previous streets, so its only streets, where player had opportunity to make an action.

[Flag_Hippo]

That would require new custom columns:

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_bet or cash_hand_player_statistics.cnt_f_raise > 0, 1, 0])

Code: Select all

sum(if[lookup_actions_f.action LIKE '_%', 1, 0])

[Rikimoro]

Everything works great! Thanks for the help!