TRIGGER not "triggering"

[michaelm13]

My excel spreadsheet is not triggering my BACK bets I presume it is some basic error in my spreadsheet All was working earlier but has now ceased Help Please

Apolgies for originally posting in "Discussion"

[mak]

don't know how can anyone could help you if you can't tell us what is your problem.

[alrodopial]

My excel spreadsheet is not triggering my BACK bets I presume it is some basic error in my spreadsheet All was working earlier but has now ceased Help Please

Apolgies for originally posting in "Discussion"

I assume that the conditions for your bet to be triggered are not met.
Add code to record the conditions

[michaelm13]

I will try and be more specific. The conditions of the bet

IF(R$1<0.0002,"BACK","")

Where R$1 refers to time countdown and triggers at around 20 seconds before scheduled OFF time.

The trigger cell reads "BACK" and places bets referring to odds and stake columns correctly.
On further use of the sheet after downloading a future race the "BACK" is displayed at the correct time but does not activate the bet on the Betting Assistant site.

I am wondering if I need to clear some residue data from the used excel sheet.

I am trying again this afternoon and will update if necessary

[mak]

When you connect the BA to Excel "Enable Triggered Betting" in options must be ticked. Is it?

[MarkRussell]

I will try and be more specific. The conditions of the bet

IF(R$1<0.0002,"BACK","")

Where R$1 refers to time countdown and triggers at around 20 seconds before scheduled OFF time.

The trigger cell reads "BACK" and places bets referring to odds and stake columns correctly.
On further use of the sheet after downloading a future race the "BACK" is displayed at the correct time but does not activate the bet on the Betting Assistant site.

I am wondering if I need to clear some residue data from the used excel sheet.

I am trying again this afternoon and will update if necessary

There is a requirement that the Bet Reference column is blank which is to prevent the software going into a loop and placing bet after bet.
So as soon as bet is made the Bet Reference column is populated with the reference from Betfair.
You can blank the column by using the CLEAR trigger or just blank it manually.
There are options for clearing the bet ref column automatically when a new market is selected either manually or automatically.
You set these options when you initially start logging to Excel.

Regards,
Mark

[michaelm13]

Thanks yet again Mark I have now set the CLEAR bets on both auto and manual select markets Hope that does it for this afternoon.

[michaelm13]

Yes, worked perfectly THANK YOU