Can I back then lay the same horse using Excel trigger

[tamrood2000]

Hi

New to the application but not to excel.

I have set a macro (using worksheet_calculcate event) to set the trigger to Back -IP , that works OK - bet is matched at the odds and stake I request.

I am then putting CLEAR in trigger cell of same horse, adjusting odds and Stake and then using a macro to set Trigger to Lay -IP ( to green up) but nothing happens.

Is it possible to do this or can you only bet once on a horse per race?

Steve

[Captain Sensible]

As long as the et reference field is empty you should be able tp lace another bet whether it's a back or lay. Only thing that may be playing up is if the market is currently in play the trigger part IP may result in the bet being rejected for invalid bet persistance.

Were the bets not being placed in play or before the off ?

[tamrood2000]

Hi

The market hadn't gone In Play ( The macro checks this and will send LAY instead if it is).

I see that some people were reporting slow running yesterday so perhaps that was what was causing the issue.

Written a macro to clear Bet ref field.

Will try again today - lets see how it goes.

Thank you for the suggestion.

Steve

[tamrood2000]

Thank you - that sorted out the problem.

Spreadsheet is now working great.

Steve