won durign last x hands/minutes

[pt4pt4pt4]

My mistake for the previous thread Kraada.

I was using MTTs in my examples and that PT4 stat is only good for STTs.

[Sattva]

To get the amount won in the last (up to) 10 hands you'd need to use the "live stats" mechanism.
Go to Configure > Statistics and have a look at how stats like "Live Win 1" and "Live Winner 1" are built - you would need to compare the live winner name with the player's name in order to determine when to include the pot in their winnings.
If you decide you want to go that way and you can't work out how to build it please post back and we'll take a look at it.

I've done it but is it possible to make a stat that would show how much an oponent lost in the last 10 hands ?

[4StarGen]

It is def possibile, propokerHUDs, made similar stats in their HU HUD, where they basically show stats of Villain only for that day.

[PropokerHUDs]

To get the amount won in the last (up to) 10 hands you'd need to use the "live stats" mechanism.
Go to Configure > Statistics and have a look at how stats like "Live Win 1" and "Live Winner 1" are built - you would need to compare the live winner name with the player's name in order to determine when to include the pot in their winnings.
If you decide you want to go that way and you can't work out how to build it please post back and we'll take a look at it.

I've done it but is it possible to make a stat that would show how much an oponent lost in the last 10 hands ?

It is definitely possible. If there is interest, we will look at making it available.

[Sattva]

It is definitely possible. If there is interest, we will look at making it available.

it would be great)

[dave2085]

Hi
did anybody make it work?

I am actually searching for a stat like; "All-In Equity Adjusted"

Code: Select all

sum(tourney_hand_player_statistics.amt_expected_won)

which includes only last ~14days or last ~50 hands. This stat should work in a HUD.

I tried to include something like this;

Code: Select all

tourney_hand_summary.date_played > (now() - interval '14 days')

But this gives me SQL error.