Hello all Excel gurus. I've been trying to figure out how to do some equations in Excel for a few days but no success so far. So i found this forum maybe some of you can help me out
So I am a poker player and I am trying to do some calculations about EV(expected value). I am really just trying to calculate if a certain move has positive or negative EV.
I have one example for you.
So the formula is like this:
FOLD EQUITY Formula: EV = [EV(fold)] * x +[EV(call)] * (1-x)
EV(call)=-12.85
EV(fold)= 370
EV(total) = 370x-12.85(1-x)
EV(total) = 370x-12.85+12.85x
EV(total) = 382.85x-12.85
12.85 = 382.5x
x=12.85/382.85
X=3.4%
I can find out EV(call) and EV(fold) values thru other calculations and software. All i would like to do is to plug in the numbers into some excel cells and get the result.
notes: Ev(total)= 0 just so it does not bring any confusion.
I would be Extremly glad if somebody could help me out with this.
I attach my excel file
Cheers
Fish
Bookmarks