PokerTracker

How do I create a stat that is based off the last 100 hands played?

That feature is not available at this time. There are plans to add it, but unfortunately I cannot say when it will be available.

Well... is there a way I can create this feature? I think there would at least be a way to filter based off time the past 15 minutes?

I'm not aware of any way to create a custom stat in this fashion either. Your looking for hands in the last X minutes is interesting, though, I'll try a few things when I get a chance to see if I can make any headway there. But as far as I'm aware, you can't do either of those things at the moment.

Any success? Is there a way to access the system time?

I haven't had a chance to check; I've been working on an updated version of the Advanced Hud Howto. The good news is though that the stats and HUD are almost done, so once I do some testing and write it up it'll be ready for releasing.

And then I'll have more time to look into this for you. But don't worry, I haven't forgotten.

Any success? I'm a heads up player and good opponents change gears alot... it's very important for my game to have some sort of way of only viewing the recent hands so that I can detect that they have tightened/loosened up.

Nothing at the moment, sorry.

I've been trying make a conditional statement to test if a hand has occured in the last 15 minutes... However, I am unable to construct a valid SQL statement. I've just been playing around with holdem_hand_player_statistics.date_played and holdem_table_session_summary.date_end. I really have no idea how to use them in "If then" statements. I've tried the following and it is not valid.
sum(if[holdem_table_session_summary.date_end - holdem_hand_player_statistics.date_played) > 15, 1, 0])

How do I use timestamps in expressions? What kind of operators can be used on them?

In theory, I think the functions listed here. But I'm not sure how exactly the SQL statements are wrapped so I'm not sure if they'll all work quite right. You might need to create new variables in order to get the job done.