how to get to statistics a betting limit

[jarvan]

Hello,
need advice on how the statistics define terms for the betting limit.

This is me on the resolution / fixed limit holdem 6max 0.10 - 0.20 USD / fixed limit holdem 6max 0.25 - 0.50 USD /...../ on Pokerstars

What field do I have to use it and how to define the appropriate limit

Thanks

[4StarGen]

Open pgAdmin, then do a simple SQL query

Code: Select all

SELECT * FROM cash_limit

You will get a table with all the info you require, after you see the whole table you can decide which column you would like to use

[jarvan]

Thanks for your reply.

No, no, my point is, learn how to work in custom HUD stats with game limits. Add to some of my stats / HUD / condition of a limit game (eg number of hands played in the limit / fixed limit holdem 6max from 0.10 to 0.20 USD /).

[kraada]

See this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. The latter was written for PT3 but the techniques all apply to PT4, the interface is just slightly different. You can also test the big blind size with cash_limit.amt_bb

[WhiteRider]

Just to make sure you're aware; you can configure the Hud to show stats for the current cash game limit only by enabling the 'Stats from current cash stake only' option in Hud > Edit Hud Options > General Settings.

[jarvan]

Problem solved.
Thanks for your time.

Spoiler: show

Code: Select all

AVG FL stakes played

( handplayed_FL04*0.04 + handplayed_FL10*0.1 + handplayed_FL100 + handplayed_FL1000*10 + handplayed_FL100000*100 + handplayed_FL20*0.2 + handplayed_FL200*2 + handplayed_FL2000*20 + handplayed_FL3000*30 +
handplayed_FL400*4 + handplayed_FL50*0.5 + handplayed_FL600*6 + handplayed_FL6000*60 ) / ( handplayed_FL04 + handplayed_FL10 + handplayed_FL100 + handplayed_FL1000 + handplayed_FL100000 + handplayed_FL20 + handplayed_FL200 + handplayed_FL2000 + handplayed_FL3000 + handplayed_FL400 + handplayed_FL50 + handplayed_FL600 + handplayed_FL6000 )
.....
sum( if[ cash_limit.limit_name LIKE '$0.25/$0.50 (6 max)' and cash_hand_player_statistics.id_hand > 0, 1, 0 ])
.
.
.