Creating new stat?

[redhot0007]

I want to create stat that shows RFI buy posision and stack size so i need to create two new columns for that.
Formula (Number of hands the player raised first in pre flop. Position and stack Depth / Number of hands player was dealt cards. Position and stack Depth)*100

So i tried to create first colum for example RFI EP 9-11BBs deep

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND
lookup_positions.flg_ep AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])

something is wrong with it because when i try to validate it's not working i works without the position but when i added messed something up ....

How many position are there in FR is it ep, mp, cut, but, sb ,bb ?

Thanks

[WhiteRider]

You do not need to specify the position in your stat - you can add the normal stat and use the Hud "Position" Property to specify the position.
Click the grey monitor icon in the bottom corner of the Profile Editor to watch the video tutorial for more information.

There is also a tournament stack filter option in Hud > Edit Hud Options > General Settings, so you may find that you don't need a custom stat at all. Again, check out the video tutorial on that window.

[redhot0007]

You do not need to specify the position in your stat - you can add the normal stat and use the Hud "Position" Property to specify the position.
Click the grey monitor icon in the bottom corner of the Profile Editor to watch the video tutorial for more information.

There is also a tournament stack filter option in Hud > Edit Hud Options > General Settings, so you may find that you don't need a custom stat at all. Again, check out the video tutorial on that window.

Yes i can use normal stat and show sat buy position but i can't filter it buy stack size or can i.So i need to create custom stat.

Thanks

[kraada]

The tournament stack filter does work even with a by position option enabled - take a look at that video and that will explain things.

[redhot0007]

The tournament stack filter does work even with a by position option enabled - take a look at that video and that will explain things.

Still no good i there is no filter that suites for me like 8-12bbs 12-20 bbs so can you please take a look at my first post and tell me what i am doing wrong.

Thanks

[kraada]

We have 5-10BB and 11-20BBs will those ranges work for you?

[redhot0007]

We have 5-10BB and 11-20BBs will those ranges work for you?

No these filters would be no help i bought PT4 exactly for that i could make these custom stats. I am playing for a living and i would like to learn how to great these stats they can bee very powerful tool. So can you please help me to figure this out...

Thanks

[redhot0007]

I got the columns working but the stat seems to be off so i guess something is wrong with the columns..

Here is the column RFI 9-11bbs SB
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND
(tourney_hand_player_statistics.flg_p_open_opp) AND
lookup_positions.flg_sb AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])

And Hands Played 9-11bbs SB

sum(if[tourney_hand_player_statistics.id_hand > 0 AND
lookup_positions.flg_sb AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])


Thanks

[kraada]

Those look right - what's wrong about the data you see using the stat?

[WhiteRider]

FWIW I'd suggest removing the position check from your columns and use the Hud Position property instead - that will save you a significant amount of work as you'd only need to build one stat per stack size rather than 6.