Excel Triggers appear to not be working

[rhysw]

I have an excel sheet with some vba code and I managed to place a BACK bet with it but once it was matched I had a lay bet ready to offset it. My spreadsheet even said LAY-SP in the Q column but the action did not seem to be transmitted to betfair. Does anyone have any clue what might be going on here?

[Captain Sensible]

Have a look at the transaction log, that should have further details. Maybe the market was suspended or the SP bet below minimum stakes, hard to second guess tbh.

[tradeaj71]

The Bet Reference (Column T) has to be blank/empty at the time you try to place the second (or any) bet. Was this the case?

If not, you need to use the CLEAR trigger when a bet is matched or code another method of blanking the relevant cell in Column T.