+ Reply to Thread
Results 1 to 3 of 3

Changing default settings on a function

  1. #1
    Registered User
    Join Date
    03-24-2012
    Location
    vancouver
    MS-Off Ver
    Excel 2010
    Posts
    3

    Changing default settings on a function

    Hello,
    I am working with a unique function described below.

    SBKelly(Probability, Odds, Kelly Multiplier {default = 1**, Decimal Odds Flag {default = FALSE**): Calculates single bet Kelly stake given an expected win probability, paypout odds, and optional Kelly Multiplier. If the "Decimal Odds Flag" isn't set or is set to FALSE, then the function will use a "best guess" as to whether the odds specified are US or decimal-style (if absolute value < 100, it will assume decimal). Setting the flag to TRUE will cause the function to always assume decimal-style odds (this could be helpful when using decimal-style odds at very high payout levels).

    The bolded section is what I need to do. I just have no idea how to 'set the flag' to true.

  2. #2
    Registered User
    Join Date
    03-24-2012
    Location
    vancouver
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Changing default settings on a function

    sorry.. i figured it out, just had to write sbkelly(b4,b5,.6,True)

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Changing default settings on a function

    When you use this function in your worksheet, you could enter it like this:

    =SBKelly(0.7,0.9)

    (I have no idea if those numbers are "reasonable"), because the other two parameters both have default settings. This makes it equivalent to:

    =SBKelly(0.7,0.9,1,FALSE)

    So, if you don't want the default values then you have to specify them, i.e.:

    =SBKelly(0.7,0.9,1,TRUE)

    Hope this helps.

    Pete

+ 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