Bet Angel placing double bets (error)

[jonesk]

Hey.

I use the bet angel spreadsheet for placing bets. My problem is that often the bet angel client places two similar bets of the same amount when I only want to place one.

- Example I want to place a bet with the command "back" £10 with odds 2.00.

Bet Angel sometimes places only 1 back bet. But sometimes it reads it twice and places:

-£10 x 2.00
-£10 x 2.00

Is there a way to adress this in excel? Maybe with other commands in addition to "back" to restrict the client from trying to place 2 bets?

[Vexxejr]

Bump, also experiencing this problem.

[Wyndon]

You could try having a condition that v10+ab10=0 before triggering. That should ensure that there are no existing matched or unmatched BACK bets.

[MemphisFlash]

or you could place "" within your if statement so that it creates the empty cell,
i.e =IF(M9<1.5,IF(AG10>=3,IF(AG12=AG10-3, "BACK",""),""),"")

if you look at my tennis trading blog you will see where this code is adopted,
so in short if statement is true "BACK", if statement is false then ""