PokerAce Heads Up Display - Version 0.27 Released

[PokerAce]

This is the SQL to run to get the variables needed to calculate Aggression Frequency:

<font class="small">Code:</font><hr /><pre>
SELECT
sum(gp.fbet + gp.fraise) as flop_aggr,
sum(gp.fbet + gp.fraise + gp.fcall + gp.ffold) as flop_aggr_opp,
sum(gp.tbet + gp.traise) as turn_aggr,
sum(gp.tbet + gp.traise + gp.tcall + gp.tfold) as turn_aggr_opp,
sum(gp.rbet + gp.rraise) as river_aggr,
sum(gp.rbet + gp.rraise + gp.rcall + gp.rfold) as river_aggr_opp
FROM game_players gp WHERE gp.player_id= (SELECT (case when (alias_id = 0) then player_id else alias_id end)
FROM players
WHERE screen_name='YOUR_NAME_HERE'
AND main_site_id=(SELECT site_id FROM poker_sites WHERE site_abbrev='PTY'))
</pre><hr />

Obviously, replace YOUR_NAME_HERE with your poker id.

To execute the SQL, open pgAdmin III, select the database you want to run the SQL for and click the icon that says SQL on it. Paste the above SQL into the area and press the Execute Query button. It will give you the 6 fields you need to calculate the final results.

To calculate aggr freq:

flop_aggr / flop_aggr_opp
turn_aggr / turn_aggr_opp
river_aggr / river_aggr_opp