Could you share the PQL query with which you succeeded? Maybe it was a random success, maybe you indeed got how to do it in PQL. Read the help files at propokertools.com.
Lordhonse made a lot of mistakes in the quoted post, what hit my eyes immediately was the 'asdf' range for Hero that means not 'four arbitrary cards' but 'the ace of spades, a diamond, a non-ace and an arbitrary fourth card'.
If I understand correctly that you meant to count the EV of a call preflop - evaluate flop line with 30.06% equity needed to call, then your above query should look like that:
select avg(
case
when HvREquity(hero,flop)>0.3006
then 42.75*HvREquity(hero,flop)-18.4
else -5.55
end
) as EVCALL
from game='omahahi',
syntax='generic',
hero='QQ33$ds',
villain='AA'
My major amendments:
1. HvREquity(hero,flop)>0.3006 - Hero's
average equity vs
Villain's whole range on the flop (Villain's hole cards, turn and river cards are generated randomly
many times, for every picked combination of Hero's hand and flop) - should be used instead of minEquity(hero,flop,0.3006) - the function that tells if Hero's hand has equity >0.3006 vs a
certain Villain's hand which is randomly picked
once for every evaluation of the body (i.e. all what's inside the avg() parentheses).
2. HvREquity(hero,flop) should be used instead of riverEquity(hero) - Hero's river equity vs a
certain Villain's hand on a
certain flop, turn and river, all picked
once for every evaluation of the body.
E.g. let's imagine that you tell the PQL interpreter to execute the query from your post.
At the first iteration it picks Q
Q
3
3
for Hero, A
A
8
2
for Villain and deals a full board J
5
2
-8
-7
. Then it finds out that minEquity(hero,flop,0.3006)=0 because the flushdraw is dominated and Hero's flop equity vs the certain Villain's hand is 14.15% (vs the whole AA range it's 44.61%), so 'when-then-else' is wrongly evaluated as -5.55.
At the second iteration it picks Q
Q
3
3
for Hero, A
A
K
K
for Villain, deals the full board A
K
4
-Q
-Q
, finds out that riverEquity(hero)=1 (Hero won) and posts it in the BBV thread because Hero was almost toast on the flop (HvREquity(hero,flop)=0.0022).