Cymatic Trader Community

why does my formula for stake not work in live mode - it works in training mode
command line is IF(AND(BB$25<10,BB$24<=BB$23,BB$32<BB$21,I8=SMALL(I$8:I$13,1)),"back",IF(AND(BB$25<10,BB$24<=BB$23,BB$32<BB$21,I8=SMALL(I$8:I$13,2)),"back",""))
stake line is IF(AND(I8=SMALL(I$8:I$13,1),BA8="back"),BB$34,IF(AND(I8=SMALL(I$8:I$13,2),BA8="back"),BB$35,""))

hopeful for correction or explanation if possible
thanks

Hi wbabc,

I'm guessing that you might have forgotten to round the stake sizes to whole currency units (for example, up to the next nearest pence).

Your formula for stake should be surrounded by the ROUND() function, with comma 2 just inside the closing bracket, for example:
=ROUND(IF(AND(I8=SMALL(I$8:I$13,1),BA8="back"),BB$34,IF(AND(I8=SMALL(I$8:I$13,2),BA8="back"),BB$35,"")),2)

Kind regards,

Gavin

Thanks Gavin for your prompt and spot on observation - rounding was the answer 10/10