Pages:
Actions
  • #1 by cc85 on 27 Oct 2017
  • Hi. please could  you tell me the formula that i need to put in the 'amount' box, so every bet that is placed will bet 10% of the available bank.

    Also i wanted to say you have an amazing product which i use every day and if you ever wanted me to do a testimonial i would be happy to do so and give 10/10 in every department.

    Thank you

    Carl
  • #2 by Tim (WellDoneSoft) on 27 Oct 2017
  • Hello Carl,

    The formula:
    10*0.01*IF(test_mode=1,test_funds,total_funds)

    where 10 is 10%

    Thank you :)
  • #3 by cc85 on 27 Oct 2017
  • Thank you.

    Also i have been trying to figure out how to bet 10% to the nearest round number. please can you tell me.

    So for example if you had 104.78, instead of betting 10.47, it would bet 10, as it is to the nearest round number.

    another example would be if you had 184.90. instead of 18.4 you would bet 20.


    Thank you for your help

    Carl
  • #4 by Oxa (WellDoneSoft) on 27 Oct 2017
  • Hello! Use the INTEGER function: INTEGER(18.4). Unfortunately, the program does not support the rounding function.
  • #5 by Jim Vincent on 28 Oct 2017
  • Here is a way:

    Add 0.50 to the number, then use INTEGER. This will round up or down to the nearest integer. 

    If you want to round to the nearest even integer, for example, divide first then multiply. For example, you want to get the nearest even number from 17.3, divide by 2 (you get 8.65) add 0.50 (you get 9.15) do INTEGER (you get 9.00) then multiply by 2 (you get 18.0, the desired result).

    In general to round to the nearest multiple of N of a number X do this:

         N * INTEGER ( (X / N) + 0.50)

    Using X = 17.3 and N = 10, you get 10 * INTEGER ( (17.3 / 10) + 0.50) = 10 * INTEGER ( 1.73 + 0.50 )
         = 10 * INTEGER ( 2.23 ) = 10 * 2 = 20

    The desired result.
  • #6 by pcal72 on 29 Oct 2017
  • Welldone Jim

    This is a good solution.

    Congrats 8)

    (I let here a image of your exemple in Market Feeder user variables)

    Image


    pcal72
Pages:
Actions