+ Reply to Thread
Results 1 to 4 of 4

Excel Formula

  1. #1
    Registered User
    Join Date
    02-07-2008
    Posts
    2

    Excel Formula

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    Unless I'm missing something, isn't it simply:

    Please Login or Register  to view this content.
    where call and fold are the cell reference locations of those two values.

    Rgds
    Last edited by shg; 02-08-2008 at 07:38 PM. Reason: deleted spurious quote

  3. #3
    Registered User
    Join Date
    02-07-2008
    Posts
    2

    Thumbs up Seems to be working now



    Yes sir damn that was easy. I tired a few examples and it seems to be correct.

    Thanks for the help Sir.

    Have a great weekend.

    -Fish
    Last edited by shg; 02-08-2008 at 07:40 PM. Reason: deleted spurious quote

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Fish, hex, there's no need to quote whole posts in responding. It just occupies space.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1