please help

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

Hello Carl,

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

where 10 is 10%

Thank you

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

Hello! Use the INTEGER function: INTEGER(18.4). Unfortunately, the program does not support the rounding function.

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.

Welldone Jim

This is a good solution.

Congrats 

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

Image


pcal72