Cymatic Trader Community

[Mweyawa]

Hi Gavin,
My Excel equations for a dutching system aren't working, and I can't see why. They work perfectly when I tested them in Training Mode, but when I go into Live Mode I get the error message "FAILURE" in the Status column, and "INVALID_BET_SIZE" in the Report column.
The parameters for the dutching system are very simple: (1) back favourite and second favourite only. (2) the favourite odds must be 3.00 odds or more. I have attached the Excel spreadsheet, and in case it's easier for you, these are the cell locations and equations:

BC1 stake (manual entry)
BC2 Total odds =I8+I9
BC3 Favourite percent of stake =I8/BC2
BC4 2nd Favourite Percent of Stake =I9/BC2
BC8 Stake for Favorite =IF(I8>2.98,BC1*BC4)
Stake for Second Favourite =IF(I8>2.98,BC1*BC3)

Please let me know if you need anything else. All the best, David
.

[Gavin]

Hi David,

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 formulae should be surrounded by the ROUND() function.

Kind regards,

Gavin

[Mweyawa]

Genius, Gavin! It took me a while to work out what to do with ROUND (I'm really poor on these things), but it's working fine now. Thank you very much - I really appreciate it. All the best, David

[Gavin]

Hi David,

You're very welcome. I'm really glad to hear that my comment was helpful.

Happy trading,

Gavin