Help with custom stat? Player stack / Avg stack

[MTTcrusher]

Hi all, I want to make a custom statistic that shows the opponents stack size divided by the overall tournament average stack, but I am not familiar with SQL. Would appreciate any help, thanks!

[Flag_Hippo]

PokerTracker 4 gets its information from the hand history files for the table you are playing at. The number of players left and the total number of chips in play at any given time in a multi-table tournament isn't known to PokerTracker 4 so the overall tournament average stack cannot be calculated.

[MTTcrusher]

PokerTracker 4 gets its information from the hand history files for the table you are playing at. The number of players left and the total number of chips in play at any given time in a multi-table tournament isn't known to PokerTracker 4 so the overall tournament average stack cannot be calculated.

Ok, how about (opponent stack / average stack of all the players at my table)?

Thanks!

[Flag_Hippo]

The players stack is in live_amt_stack and this can display the table average stack when used in a table averages HUD Group but I don't know of a method to combine that with the individual player data.