3Bet Preflop vs Hero

[Umut]

Hi, can i buy a few of those vs hero stats? If anyone already has made some, would be great if he can conntact me. Im really bad in it stuff ;(

[4StarGen]

ProPokerHUDS has made them and they are also cacheable. I suggest you to take a look at their site

[Umut]

got it, but sadly i cant use them in my hud as a stat. Just need like 3 stats. Fold to resteal, fold to 4bet after resteal and resteal. Can pay skrill or stars.

[sherrie524]

Can someone help me find out how often a particular villain attempts to steal a specific hero's blinds so that I can compare it to that villain's steal attempts vs the general population? I'm not very good at this. ty in advance

[4StarGen]

probably you only have to change this hero.flg_hero into id_player = the id of the player you actually want. I'm not at home so I cannot check but it should work. GL

[SirDehi]

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet and exists
  (select 1
   from cash_hand_player_statistics hero
   where hero.id_hand = cash_hand_player_statistics.id_hand
   and hero.flg_hero
   and hero.flg_p_first_raise), 1, 0])

I recently changed my username on a poker site. I have aliased my old username to my new one in PT4.
But now, this vs Hero stat actually corresponds to "vs Old Username + vs New userName".
But my opponents can't possibly know about the new name and link it to my old one.

How could I get the "vs Hero" stat to actually be "vs currentUserName"?

Cheers

[Flag_Hippo]

I don't know about editing that query but you can try this instead:

Code: Select all

sum(CASE WHEN cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'SirDehi' and chps.flg_p_first_raise) THEN 1 ELSE 0 END)

[Antohitch]

Hi, I was trying to make stat which shows how villain perceives me (like a mirror) and I heard it should be made in similar way as vshero stats. So vshero stats consist of two parts - 1st is defining villain's action and 2nd is subset where is defined hero's action. So in mirror stat it should be the opposite, 1st is defining action hero made and 2nd is subset of villain's action, right? But what field i should use in cause of defining subset with villain's action? (if it's convenient please use code below as an example). Thank you in advance.

(fold vs cbet vs hero and opportunity to fold vs cbet vs hero columns)

Code: Select all

sum(if[tourney_hand_player_statistics.cnt_players = 2
   and  tourney_hand_player_statistics.position = 8
   and tourney_hand_player_statistics.flg_f_cbet_def_opp
   and tourney_hand_player_statistics.enum_f_cbet_action='F'
   and exists
  (select 1
   from tourney_hand_player_statistics hero
   where hero.id_hand = tourney_hand_player_statistics.id_hand
   and hero.position = 9
   and tourney_hand_player_statistics.cnt_players = 2
   and hero.flg_hero
   and hero.flg_f_cbet_opp
   and hero.flg_f_cbet ), 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.cnt_players = 2
   and  tourney_hand_player_statistics.position = 8
   and tourney_hand_player_statistics.flg_f_cbet_def_opp
   and exists
  (select 1
   from tourney_hand_player_statistics hero
   where hero.id_hand = tourney_hand_player_statistics.id_hand
   and hero.position = 9
   and tourney_hand_player_statistics.cnt_players = 2
   and hero.flg_hero
   and hero.flg_f_cbet_opp
   and hero.flg_f_cbet ), 1, 0])

[Antohitch]

Come on guys, nobody knows?

[dave2085]

Hi guys,

I want to create a custom stat;

chipEV BBvSB(Hero)

Why is this not working?

gives me SQL Error;

Code: Select all

sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.position = 8,
tourney_hand_player_statistics.amt_expected_won and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_p_open_opp and hero.position = 9), 0])