PokerTracker

I'm messing around with the custom stats and want to create a stat for the sessions screen that shows gross winnings (total pot - hero contribution - rake when won the hand) and gross losses (hero contribution when did not win hand) for all the hands in a session (as currently defined/listed in program).

I can write the sql and run it externally but to make it show up for use in-game (main screen/hud) i'm not entirely sure how to do the where clause using the User interface for custom statisics...

if the entire row for each screen is run from one query i imagine i should use an if() or decode()-like function?

or is there a more simple way to aggregate this information?

After reviewing the db schema it doesnt look like you can differentiate between the hero contributed amount and the pot amount. is this correct?

The HUD is able to show winnings by player after the hand is over. does it do this but real-time reading the hand history or are there any aggregated fields for this available in the current schema?

I think you are looking for:
holdem_hand_player_detail.amt_bet_ttl