Looking up handrank on river

[bloodndef]

Can we lookup when a player has no pair OR less than top pair on the river?

Would we be using lookup_handrank? Is there a list of what the handranks are called?

Thanks!

[bloodndef]

Want to make a stat that says:

(cnt_r_bet OR cnt_r_raise) AND (has no pair OR less than top pair)

[bloodndef]

Found em, but not all of them.

flg_r_highcard=true

These would be false:

flg_r_2pair
flg_r_3oak
flg_r_straight
flg_r_flush
flg_r_fullhouse
flg_r_fouroak
flg_r_strflush


But what about

flg_r_1pair

Can we further define what this 1pair is? (In "simple filters" in the reports section this is done) Top, middle, overpr, etc.?

[kraada]

See this post.

Cliff notes: you want (flg_r_1pair and id_r_hand_strength < 3). But you'd probably find it interesting reading

[bloodndef]

Wow, thank you Kraada!!

[kraada]

That's what I'm here for

[bloodndef]

River bluff frequency stat to follow.

[kraada]

Excellent, I look forward to it!

[bloodndef]

Found a typo in the PokerTracker3_PostgreSQL_Database_Schema.pdf

On page 10, "flg_r_3oak" is supposed to read "flg_r_threeoak"



Here is my validated stat:


River Bluff Frequency

(cnt_r_bet_bluff / cnt_r_bet_known) * 100

cnt_r_bet_bluff

sum(if[((holdem_hand_player_combinations.flg_r_highcard) OR (holdem_hand_player_combinations.flg_r_1pair AND holdem_hand_player_combinations.id_r_hand_strength < 3) OR (holdem_hand_player_combinations.flg_r_1pair AND holdem_hand_player_combinations.id_r_hand_strength = 4) OR (holdem_hand_player_combinations.flg_r_1pair AND holdem_hand_player_combinations.id_r_hand_strength = 5) OR (holdem_hand_player_combinations.flg_r_2pair AND holdem_hand_player_combinations.id_r_hand_strength < 3) OR (holdem_hand_player_combinations.flg_r_2pair AND holdem_hand_player_combinations.id_r_hand_strength = 4) OR (holdem_hand_player_combinations.flg_r_2pair AND holdem_hand_player_combinations.id_r_hand_strength = 5) OR (holdem_hand_player_combinations.flg_r_threeoak AND holdem_hand_player_combinations.id_r_hand_strength = 0) OR (holdem_hand_player_combinations.flg_r_straight AND holdem_hand_player_combinations.id_r_hand_strength = 0) OR (holdem_hand_player_combinations.flg_r_flush AND holdem_hand_player_combinations.id_r_hand_strength = 0) OR (holdem_hand_player_combinations.flg_r_fullhouse AND holdem_hand_player_combinations.id_r_hand_strength = 0) OR (holdem_hand_player_combinations.flg_r_fouroak AND holdem_hand_player_combinations.id_r_hand_strength = 0) OR (holdem_hand_player_combinations.flg_r_strflush AND holdem_hand_player_combinations.id_r_hand_strength = 0)) AND (holdem_hand_player_statistics.flg_r_bet) AND NOT (holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand), 1, 0])

cnt_r_bet_known

sum(if[holdem_hand_player_statistics.flg_r_bet AND holdem_hand_player_statistics.id_holecard>0, 1, 0])

[kraada]

Nice. Have you tested this on any opponents (and, if you have, what sorts of numbers have you been seeing)?