Dutching in excel

[GhostDog]

Hi
Anybody know why my dutching excel doesnt work.
Normal with fire a bet in excel works good, but now i have a dutching excel for the first 3 horses and it auto calculates the stakes but when to fire, it bet reference goes pending and then 0 and no bet is made ??? Dont understand it.
Alle help is needed.

[Mitch]

Normally when you place a single bet, is it a whole number and for the dutching there is a decimal?

I know there has been issues before with the decimal seperator Excel uses and what Betfair expects.

[GhostDog]

I have tryed with backing all the selections with 0.1 stake and it works, and with the calculatet dutch stake im using the round with 2 decimals and i wont work ???
Im living in denmark and we normall use , as a separator, but changed the settings to uk with . as separator in excel, so its really driving me crazy.

[Mitch]

Can you post examples of the formula, or vba if you use it?

It does seem very odd that it works in singles and not in multiples.

If you copy then "paste values" of your odds and stakes in non-formatted cells what do you get?

[GhostDog]

is it possible to get your email, i dont use vba for it, so i could try to send the excel spreadsheets. I made 2, 1 with dutching the first 3 horses and another with levelbetting, and with same result ????

[GhostDog]

Think i know what the problem is now, it dont seems to work to bet with small stakes anymore like 0.5 etc

[Mitch]

Glad you've figured it out